LG_PRDCOST

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Maliyet Periyodu Kapatma Kaydı Log. Ref. Cost Period Closing Record Logical Reference
PRDENDDATE Longint 4 4 Periyot kapanış tarihi Period Closing Date
PRDENDTIME Longint 4 8 Periyot kapanış tarihi Period Closing Time
PRDCOSTTYPE Integer 2 12 Maliyet Türü Cost Type
ITEMREF Longint 4 14 Malzeme Kartı Referansı Item Card Reference
LINENR Integer 2 18 Satır Numarası Line Number
INVENCOSTTYPE Integer 2 20 Kaynak Tipi Resource Type
INVENCOSTGRPNR Integer 2 22 Ambar maliyet grubu Warehouse Cost Group
INVENCOSTWSREF Longint 4 24 İş İstasyonu Ref. Workstation Reference
STTRANSREF Longint 4 28 Malzeme Hareketi Ref. Item Transaction Reference
TOTAMNT Double 8 32 Toplam miktar Total Quantity
TOTVAL Double 8 40 Toplam değer Total Value
TOTCURR Double 8 48 RD değeri Reporting Currency Value
TOTDIFFVAL Double 8 56 Fiyat farkı miktarı Price Difference Amount
TOTDIFFCURR Double 8 64 RD fiyat farkı tutarı Reporting Currency Price Difference Amount
MAINUNITREF Longint 4 72 Ana Birim Ref. Main Unit Reference
TOTATAXVAL Double 8 76 Ek Vergi Toplamı Additional Tax Total
TOTATAXCURR Double 8 84 Ek Vergi Toplamı (Raporlama Dövizi) Additional Tax Total (Reporting Currency)
TOTINF Double 8 92 Toplam enflasyon değeri Total Inflation Value
TOTDIFFINF Double 8 100 Toplam fiyat farkı endeks değeri Total Price Difference Index Value

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
2 3 840   ITEMREF L_ITEMS LOGICALREF one-to-one  
2 3 840   INVENCOSTWSREF L_WORKSTAT LOGICALREF one-to-one  
2 3 840   STTRANSREF L_STLINE LOGICALREF one-to-one  
2 3 840   MAINUNITREF L_UNITSETL LOGICALREF one-to-one  

Indexler

Level Product ID Index Name Attributes Segment No Segment Field Sense
2 3 Index1 Unique + Not Null 1 LOGICALREF Ascending
2 3 Index2 Duplicate + Not Null 1 PRDENDDATE Ascending
2 3 Index2 Duplicate + Not Null 2 PRDCOSTTYPE Ascending
2 3 Index2 Duplicate + Not Null 3 ITEMREF Ascending
2 3 Index2 Duplicate + Not Null 4 INVENCOSTTYPE Ascending
2 3 Index2 Duplicate + Not Null 5 INVENCOSTGRPNR Ascending
2 3 Index2 Duplicate + Not Null 6 INVENCOSTWSREF Ascending
2 3 Index3 Duplicate + Not Null 1 PRDENDDATE Ascending
2 3 Index3 Duplicate + Not Null 2 PRDCOSTTYPE Ascending
2 3 Index3 Duplicate + Not Null 3 ITEMREF Ascending
2 3 Index3 Duplicate + Not Null 4 INVENCOSTTYPE Ascending
2 3 Index3 Duplicate + Not Null 5 INVENCOSTGRPNR Ascending
2 3 Index3 Duplicate + Not Null 6 INVENCOSTWSREF Ascending
2 3 Index3 Duplicate + Not Null 7 STTRANSREF Ascending

>