SAP Table TDS_ITEM_COM

Lean Order - Item Data

TDS_ITEM_COM (Lean Order - Item Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TDS_ITEM_COM to other SAP tables.

TDS_ITEM_COM table fields

Field Data element Checktable Datatype Length Decimals
HANDLE GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
POSNR Sales Document Item POSNR_VA NUMC 6 0
UEPOS Higher-level item in bill of material structures UEPOS NUMC 6 0
MABNR Material Number MATNR CHAR 18 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
KDMAT Material Number Used by Customer MATNR_KU CHAR 35 0
PSTYV Sales document item category PSTYV CHAR 4 0
KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
VRKME Sales unit VRKME UNIT 3 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
ZMENG Target quantity in sales units DZMENG QUAN 13 3
ZIEME Target quantity UoM DZIEME T006 UNIT 3 0
UMZIZ Factor for converting sales units to base units (target qty) UMZIZ DEC 5 0
UMZIN Factor for converting sales units to base units (target qty) UMZIN DEC 5 0
ETDAT Schedule line date ETDAT CHAR 10 0
PRGBZ External date type PRGBZ CHAR 1 0
FIXMG Delivery date and quantity fixed FIXMG CHAR 1 0
X Yes
NULL No
WERKS Plant (Own or External) WERKS_EXT CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
ROUTE Route ROUTE CHAR 6 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
FAKSP Billing block for item FAKSP_AP CHAR 2 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
BSTDK Customer purchase order date BSTDK DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
KURSK_INT Exchange Rate for Price Determination KURSK DEC 9 5
KURSK_EXT CHAR 12 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
LPRIO Delivery Priority LPRIO NUMC 2 0
BRGEW Gross Weight of the Item BRGEW_AP QUAN 15 3
NTGEW Net Weight of the Item NTGEW_AP QUAN 15 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume of the item VOLUM_AP QUAN 15 3
VOLEH Volume unit VOLEH T006 UNIT 3 0
SPART Division SPART CHAR 2 0
WAERK SD Document Currency WAERK TCURC CUKY 5 0
AUFNR Order Number AUFNR CHAR 12 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
GRPOS Item for which this item is an alternative GRPOS NUMC 6 0
ZLSCH Payment Method SCHZW_BSEG CHAR 1 0
KZTLF Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
GRKOR Delivery group (items are delivered together) GRKOR NUMC 3 0
CHARG Batch Number CHARG_D CHAR 10 0
DELCO Agreed delivery time DELCO CHAR 3 0
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
PLTYP Price list type PLTYP CHAR 2 0
KONDA Price group (customer) KONDA CHAR 2 0
BZIRK Sales district BZIRK CHAR 6 0
KDGRP Customer group KDGRP CHAR 2 0
KONDM Material Pricing Group KONDM CHAR 2 0
BSARK Customer purchase order type BSARK CHAR 4 0
VSART Shipping type VSARTTR T173 CHAR 2 0
ABLAD Unloading Point ABLAD CHAR 25 0
EMPST Receiving point EMPST CHAR 25 0
MVGR1 Material group 1 MVGR1 CHAR 3 0
MVGR2 Material group 2 MVGR2 CHAR 3 0
MVGR3 Material group 3 MVGR3 CHAR 3 0
MVGR4 Material group 4 MVGR4 CHAR 3 0
MVGR5 Material group 5 MVGR5 CHAR 3 0
KDKG1 Customer condition group 1 KDKG1 CHAR 2 0
KDKG2 Customer condition group 2 KDKG2 CHAR 2 0
KDKG3 Customer condition group 3 KDKG3 CHAR 2 0
KDKG4 Customer condition group 4 KDKG4 CHAR 2 0
KDKG5 Customer condition group 5 KDKG5 CHAR 2 0
VBELN_REF Document number of the reference document VGBEL CHAR 10 0
POSNR_REF Item number of the reference item VGPOS NUMC 6 0
EDATU Schedule line date EDATU DATS 8 0
VALDT Fixed value date VALDT DATS 8 0
VALTG Additional value days VALTG NUMC 2 0
UEBTO Overdelivery Tolerance Limit UEBTO DEC 3 1
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3 1
UEBTK Indicator: Unlimited Overdelivery Allowed UEBTK CHAR 1 0
X Yes
NULL No
PRODH Product hierarchy PRODH_D CHAR 18 0
MATKL Material Group MATKL CHAR 9 0
ZWERT_INT Target Value for Outline Agreement in Document Currency DZWERT CURR 13 2
ZWERT_EXT Target Value for Outline Agreement in Document Currency DZWERT_EXT CHAR 16 0
WAKTION Promotion WAKTION CHAR 10 0
SKOPF Assortment module W_SORTK CHAR 18 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
GSBER Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
PCTRF Profit Center for Billing PCTRF CHAR 10 0
ABGRS Results Analysis Key ABGR_SCHL CHAR 6 0
KALSM_K Costing Sheet AUFKALSM CHAR 6 0
ZSCHL_K Overhead key AUFZSCHL CHAR 6 0
POSGUID ATP: Encryption of DELNR and DELPS POSGUID CHAR 22 0
IUID_RELEVANT IUID Relevant for Customer IUID_RELEVANT_CUST CHAR 1 0
X Relevant
NULL Not Relevant
AWERT Value of value contract already released ABRUFWERT CURR 17 2
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1 0
1 One-Time Mandate
N Recurring Use Mandate
SEPON SEPA-Relevance SD_SEPA_FLAG CHAR 1 0
NULL No SEPA Relevance
0 SEPA Relevance - No Mandate Assigned
1 SEPA Relevance - Mandate Assigned
PEROP_BEG Period of Performance Start Date FM_PEROP_SD_LOW DATS 8 0
PEROP_END Period of Performance End Date FM_PEROP_SD_HIGH DATS 8 0
OIINEX Code for internal or external excise duty rate determination OIH_INEX CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OIH_LICIN Excise tax internal license number OIH_LICIN CHAR 10 0
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
OIH_LICTP License type OIH_LICTP CHAR 4 0
OIH_PFLIC IS-OIL partner function for tax exemption license OIH_PFLIC CHAR 2 0
OIC_TIME Time for time-pricing OIC_TIME TIMS 6 0
OIA_SBMAT Base product number OIA_SBMAT CHAR 18 0
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT CHAR 2 0
OID_BYPASS IS-Oil plant determination indicator: x=yes blank=no OID_BYPASS CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
VKTRA_TXT Text Field of Length 60 TEXT60 CHAR 60 0
HANDLE_I GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
POSNR_I Single-Character Indicator CHAR1 CHAR 1 0
UEPOS_I Single-Character Indicator CHAR1 CHAR 1 0
MABNR_I Single-Character Indicator CHAR1 CHAR 1 0
ARKTX_I Single-Character Indicator CHAR1 CHAR 1 0
KDMAT_I Single-Character Indicator CHAR1 CHAR 1 0
PSTYV_I Single-Character Indicator CHAR1 CHAR 1 0
KWMENG_I Single-Character Indicator CHAR1 CHAR 1 0
VRKME_I Single-Character Indicator CHAR1 CHAR 1 0
UMVKN_I Single-Character Indicator CHAR1 CHAR 1 0
UMVKZ_I Single-Character Indicator CHAR1 CHAR 1 0
ZMENG_I Single-Character Indicator CHAR1 CHAR 1 0
ZIEME_I Single-Character Indicator CHAR1 CHAR 1 0
UMZIZ_I Single-Character Indicator CHAR1 CHAR 1 0
UMZIN_I Single-Character Indicator CHAR1 CHAR 1 0
ETDAT_I Single-Character Indicator CHAR1 CHAR 1 0
PRGBZ_I Single-Character Indicator CHAR1 CHAR 1 0
FIXMG_I Single-Character Indicator CHAR1 CHAR 1 0
WERKS_I Single-Character Indicator CHAR1 CHAR 1 0
LGORT_I Single-Character Indicator CHAR1 CHAR 1 0
VSTEL_I Single-Character Indicator CHAR1 CHAR 1 0
ROUTE_I Single-Character Indicator CHAR1 CHAR 1 0
POSEX_I Single-Character Indicator CHAR1 CHAR 1 0
FAKSP_I Single-Character Indicator CHAR1 CHAR 1 0
BSTKD_I Single-Character Indicator CHAR1 CHAR 1 0
BSTDK_I Single-Character Indicator CHAR1 CHAR 1 0
ZTERM_I Single-Character Indicator CHAR1 CHAR 1 0
PRSDT_I Single-Character Indicator CHAR1 CHAR 1 0
KURSK_INT_I Single-Character Indicator CHAR1 CHAR 1 0
KURSK_EXT_I Single-Character Indicator CHAR1 CHAR 1 0
FKDAT_I Single-Character Indicator CHAR1 CHAR 1 0
INCO1_I Single-Character Indicator CHAR1 CHAR 1 0
INCO2_I Single-Character Indicator CHAR1 CHAR 1 0
ABGRU_I Single-Character Indicator CHAR1 CHAR 1 0
LPRIO_I Single-Character Indicator CHAR1 CHAR 1 0
BRGEW_I Single-Character Indicator CHAR1 CHAR 1 0
NTGEW_I Single-Character Indicator CHAR1 CHAR 1 0
GEWEI_I Single-Character Indicator CHAR1 CHAR 1 0
VOLUM_I Single-Character Indicator CHAR1 CHAR 1 0
VOLEH_I Single-Character Indicator CHAR1 CHAR 1 0
SPART_I Single-Character Indicator CHAR1 CHAR 1 0
WAERK_I Single-Character Indicator CHAR1 CHAR 1 0
AUFNR_I Single-Character Indicator CHAR1 CHAR 1 0
PS_PSP_PNR_I Single-Character Indicator CHAR1 CHAR 1 0
AWAHR_I Single-Character Indicator CHAR1 CHAR 1 0
GRPOS_I Single-Character Indicator CHAR1 CHAR 1 0
ZLSCH_I Single-Character Indicator CHAR1 CHAR 1 0
KZTLF_I Single-Character Indicator CHAR1 CHAR 1 0
ANTLF_I Single-Character Indicator CHAR1 CHAR 1 0
GRKOR_I Single-Character Indicator CHAR1 CHAR 1 0
CHARG_I Single-Character Indicator CHAR1 CHAR 1 0
DELCO_I Single-Character Indicator CHAR1 CHAR 1 0
SELKZ_I Single-Character Indicator CHAR1 CHAR 1 0
PLTYP_I Single-Character Indicator CHAR1 CHAR 1 0
KONDA_I Single-Character Indicator CHAR1 CHAR 1 0
BZIRK_I Single-Character Indicator CHAR1 CHAR 1 0
KDGRP_I Single-Character Indicator CHAR1 CHAR 1 0
KONDM_I Single-Character Indicator CHAR1 CHAR 1 0
BSARK_I Single-Character Indicator CHAR1 CHAR 1 0
VSART_I Single-Character Indicator CHAR1 CHAR 1 0
ABLAD_I Single-Character Indicator CHAR1 CHAR 1 0
EMPST_I Single-Character Indicator CHAR1 CHAR 1 0
MVGR1_I Single-Character Indicator CHAR1 CHAR 1 0
MVGR2_I Single-Character Indicator CHAR1 CHAR 1 0
MVGR3_I Single-Character Indicator CHAR1 CHAR 1 0
MVGR4_I Single-Character Indicator CHAR1 CHAR 1 0
MVGR5_I Single-Character Indicator CHAR1 CHAR 1 0
KDKG1_I Single-Character Indicator CHAR1 CHAR 1 0
KDKG2_I Single-Character Indicator CHAR1 CHAR 1 0
KDKG3_I Single-Character Indicator CHAR1 CHAR 1 0
KDKG4_I Single-Character Indicator CHAR1 CHAR 1 0
KDKG5_I Single-Character Indicator CHAR1 CHAR 1 0
VBELN_REF_I Single-Character Indicator CHAR1 CHAR 1 0
POSNR_REF_I Single-Character Indicator CHAR1 CHAR 1 0
EDATU_I Single-Character Indicator CHAR1 CHAR 1 0
VALDT_I Single-Character Indicator CHAR1 CHAR 1 0
VALTG_I Single-Character Indicator CHAR1 CHAR 1 0
UEBTO_I Single-Character Indicator CHAR1 CHAR 1 0
UNTTO_I Single-Character Indicator CHAR1 CHAR 1 0
UEBTK_I Single-Character Indicator CHAR1 CHAR 1 0
PRODH_I Single-Character Indicator CHAR1 CHAR 1 0
MATKL_I Single-Character Indicator CHAR1 CHAR 1 0
ZWERT_INT_I Single-Character Indicator CHAR1 CHAR 1 0
ZWERT_EXT_I Single-Character Indicator CHAR1 CHAR 1 0
WAKTION_I Single-Character Indicator CHAR1 CHAR 1 0
SKOPF_I Single-Character Indicator CHAR1 CHAR 1 0
BWTAR_I Single-Character Indicator CHAR1 CHAR 1 0
EAN11_I Single-Character Indicator CHAR1 CHAR 1 0
GSBER_I Single-Character Indicator CHAR1 CHAR 1 0
PRCTR_I Single-Character Indicator CHAR1 CHAR 1 0
PCTRF_I Single-Character Indicator CHAR1 CHAR 1 0
ABGRS_I Single-Character Indicator CHAR1 CHAR 1 0
KALSM_K_I Single-Character Indicator CHAR1 CHAR 1 0
ZSCHL_K_I Single-Character Indicator CHAR1 CHAR 1 0
POSGUID_I Single-Character Indicator CHAR1 CHAR 1 0
IUID_RELEVANT_I Single-Character Indicator CHAR1 CHAR 1 0
AWERT_I Single-Character Indicator CHAR1 CHAR 1 0
MNDID_I Single-Character Indicator CHAR1 CHAR 1 0
PAY_TYPE_I Single-Character Indicator CHAR1 CHAR 1 0
SEPON_I Single-Character Indicator CHAR1 CHAR 1 0
PEROP_BEG_I Single-Character Indicator CHAR1 CHAR 1 0
PEROP_END_I Single-Character Indicator CHAR1 CHAR 1 0
OIINEX_I Single-Character Indicator CHAR1 CHAR 1 0
OIHANTYP_I Single-Character Indicator CHAR1 CHAR 1 0
OIH_LICIN_I Single-Character Indicator CHAR1 CHAR 1 0
OICERTF1_I Single-Character Indicator CHAR1 CHAR 1 0
OIH_LICTP_I Single-Character Indicator CHAR1 CHAR 1 0
OIH_PFLIC_I Single-Character Indicator CHAR1 CHAR 1 0
OIC_TIME_I Single-Character Indicator CHAR1 CHAR 1 0
OIA_SBMAT_I Single-Character Indicator CHAR1 CHAR 1 0
OID_EXTBOL_I Single-Character Indicator CHAR1 CHAR 1 0
OIC_MOT_I Single-Character Indicator CHAR1 CHAR 1 0
OID_BYPASS_I Single-Character Indicator CHAR1 CHAR 1 0
VKTRA_TXT_I Single-Character Indicator CHAR1 CHAR 1 0
HANDLE_R GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
MATWA_R_R Material entered MATWA CHAR 18 0
KBMENG_R_R Cumulative confirmed quantity in sales unit KBMENG QUAN 15 3
LSMNG_R_R Cumulative required delivery qty (all dlv-relev.sched.lines) LSMENG QUAN 15 3
VSMNG_R_R Delivered quantity in sales units VSMNG QUAN 13 3
VRKME_R_R Sales unit VRKME UNIT 3 0
SPART_T_R Description BEZEI20 CHAR 20 0
PSTYV_T_R Description BEZEI20 CHAR 20 0
WERKS_T_R Description BEZEI30 CHAR 30 0
LGORT_T_R Description of Storage Location LGOBE CHAR 16 0
VSTEL_T_R Description BEZEI30 CHAR 30 0
ROUTE_T_R Description of Route ROUTBEZ CHAR 40 0
FAKSP_T_R Description BEZEI_FAKSP CHAR 20 0
ZTERM_T_R Description of terms of payment DZTERM_BEZ CHAR 30 0
ZLSCH_T_R Name of Payment Method in Language of the Country TEXT1_042Z CHAR 30 0
KZTLF_T_R Description BEZEI30 CHAR 30 0
MWSBP_R_R Tax amount in document currency MWSBP CURR 13 2
KSTBS_R_R Condition scale quantity KSTBM QUAN 15 3
WAVWR_R_R Cost in document currency WAVWR CURR 13 2
CMPRE_R_R Item credit price CMPRE CURR 11 2
NETWR_R_R Net value of the order item in document currency NETWR_AP CURR 15 2
WAERK_R_R SD Document Currency WAERK CUKY 5 0
NETPR_R_R Net price NETPR CURR 11 2
KPEIN_R_R Condition pricing unit KPEIN DEC 5 0
KMEIN_R_R Condition unit KMEIN UNIT 3 0
ERNAM_R_R Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT_R_R Date on Which Record Was Created ERDAT DATS 8 0
KZWI1_R_R Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2_R_R Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3_R_R Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4_R_R Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5_R_R Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6_R_R Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
PLTYP_T_R Description BEZEI20 CHAR 20 0
KONDA_T_R Description BEZEI20 CHAR 20 0
BZIRK_T_R Description BEZEI20 CHAR 20 0
KDGRP_T_R Description BEZEI20 CHAR 20 0
KONDM_T_R Description BEZEI20 CHAR 20 0
BSARK_T_R Description BEZEI20 CHAR 20 0
VSART_T_R Description BEZEI20 CHAR 20 0
VGBEL_R_R Document number of the reference document VGBEL CHAR 10 0
VGPOS_R_R Item number of the reference item VGPOS NUMC 6 0
POSAR_R_R Item type POSAR CHAR 1 0
NULL Standard Item
A Value Item
B Text item
C Packing item (will be generated)
D Material not relevant
E Packaging Item (External)
UEPVW_R_R ID for higher-level item usage UEPVW CHAR 1 0
A Product selection
B Free goods (inclusive bonus)
C Free goods (on-top bonus)
D Repairs
E ** unused **
F Cross selling
G Complete goods (purchase order)
H Automotive (subitem)
I CRM Repairs
K Kit Component
R Replacement Kit Component
PROSA_R_R ID for material determination PROSA CHAR 1 0
NULL No product selection
A Replaced item
B Replacement item
POSAR_T_R Short Text for Fixed Values VAL_TEXT CHAR 60 0
EDATU_LAST_R Schedule line date EDATU DATS 8 0
MBDAT_LAST_R Material Staging/Availability Date MBDAT DATS 8 0
BMENG_LAST_R Confirmed Quantity BMENG QUAN 13 3
WAKTION_T_R Promotion description AKTBEZ CHAR 40 0
MEINS_R Base Unit of Measure MEINS UNIT 3 0
KATPMN_R Cumulative ATP quantity (available to promise) KATPMN QUAN 15 3
LPRIO_T_R Description BEZEI20 CHAR 20 0
ABGRU_T_R Description BEZEI40 CHAR 40 0
MATKL_T_R Material Group Description WGBEZ CHAR 20 0
GSBER_T_R Business area description GTEXT CHAR 30 0
PS_PSP_PNR_T_R PS: Short description (1st text line) PS_POST1 CHAR 40 0
AUFNR_T_R Description AUFTEXT CHAR 40 0
PRCTR_T_R General Name KTEXT CHAR 20 0
PCTRF_T_R General Name KTEXT CHAR 20 0
ABGRS_T_R Character Field for Text Table KKATEXT CHAR 40 0
KALSM_K_T_R Description VTXTM CHAR 30 0
ZSCHL_K_T_R Description BEZEI30 CHAR 30 0
VBELV_R_R Originating document VBELV CHAR 10 0
POSNV_R_R Originating item POSNV NUMC 6 0
CUOBJ_R_R Configuration CUOBJ_VA NUMC 18 0
ETERL_R_R Schedule lines allowed ETERL CHAR 1 0
X Yes
NULL No
SUGRD_R_R Reason for material substitution SUGRD CHAR 4 0
SUGRD_T_R Description BEZEI20 CHAR 20 0
PRSFD_R_R Carry out pricing PRSFD CHAR 1 0
NULL No pricing
X Pricing standard
A Pricing for empties
B Pricing for free goods (100% discount)
MATNR_INT_R_R Unedited Material Number TDV_MATNR_UNEDITED CHAR 18 0
PMATN_R_R Pricing Reference Material PMATN CHAR 18 0
VRKME_INT_R_R Sales unit VRKME UNIT 3 0
SPOSN_R_R BOM Item Number SPOSN CHAR 4 0
SHKZG_R_R Returns Item SHKZG_VA CHAR 1 0
X Yes
NULL No
STMAN_R_R Indicates processing status STMAN CHAR 1 0
NULL No change
1 Manually changed
STDPD_R_R Configurable material STDPD CHAR 18 0
OBJNR_R_R Object number J_OBJNR CHAR 22 0
SKOPF_T_R Description for assortment module W_SORTX CHAR 40 0
PRODH_T_R Product Hierarchy (Description) TDV_PRODH_DESCR CHAR 40 0
ENDBP_R_R Total amount of item ENDBP CURR 15 2
KOWRR_R_R Statistical values KOWRR CHAR 1 0
NULL System will copy item to header totals
X No cumulation - Values cannot be used statistically
Y No cumulation - Values can be used statistically
LICTT_R License type text OIH_LICTT CHAR 30 0
DATAB_R Valid-From Date DATAB DATS 8 0
DATBI_R Valid To Date DATBI DATS 8 0

TDS_ITEM_COM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TDS_ITEM_COM GEWEI SYST MANDT T006 Units of Measurement MANDT
TDS_ITEM_COM GEWEI TDS_ITEM_COM GEWEI T006 Units of Measurement MSEHI
TDS_ITEM_COM INCO1 SYST MANDT TINC Customers: Incoterms MANDT
TDS_ITEM_COM INCO1 TDS_ITEM_COM INCO1 TINC Customers: Incoterms INCO1
TDS_ITEM_COM VOLEH SYST MANDT T006 Units of Measurement MANDT
TDS_ITEM_COM VOLEH TDS_ITEM_COM VOLEH T006 Units of Measurement MSEHI
TDS_ITEM_COM VSART SYST MANDT T173 Routes: Mode of Transport for Each Shipping Type MANDT
TDS_ITEM_COM VSART TDS_ITEM_COM VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
TDS_ITEM_COM WAERK SYST MANDT TCURC Currency Codes MANDT
TDS_ITEM_COM WAERK TDS_ITEM_COM WAERK TCURC Currency Codes WAERS
TDS_ITEM_COM ZIEME SYST MANDT T006 Units of Measurement MANDT
TDS_ITEM_COM ZIEME TDS_ITEM_COM ZIEME T006 Units of Measurement MSEHI