TDS_ITEM_COM SAP (Lean Order - Item Data) Structure details
Description: Lean Order - Item Data
Structure field list including key, data, relationships and ABAP select examples
TDS_ITEM_COM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Lean Order - Item Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_TDS_ITEM_COM TYPE TDS_ITEM_COM.
The TDS_ITEM_COM table consists of various fields, each holding specific information or linking keys about Lean Order - Item Data data available in SAP. These include HANDLE (GUID in 'CHAR' Format in Uppercase), POSNR (Sales Document Item), UEPOS (Higher-level item in bill of material structures), MABNR (Material Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP TDS_ITEM_COM structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
HANDLE | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
UEPOS | Higher-level item in bill of material structures | UEPOS | NUMC | 6 | Assigned to domain | POSNR | |||
MABNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | IDNEX | ||||
PSTYV | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV | |||
KWMENG | Cumulative Order Quantity in Sales Units | KWMENG | QUAN | 15(3) | MENG15 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
ZMENG | Target quantity in sales units | DZMENG | QUAN | 13(3) | MENG13 | ||||
ZIEME | Target quantity UoM | DZIEME | UNIT | 3 | T006 | CUNIT | MEINS | ||
UMZIZ | Factor for converting sales units to base units (target qty) | UMZIZ | DEC | 5 | UMBSZ | ||||
UMZIN | Factor for converting sales units to base units (target qty) | UMZIN | DEC | 5 | UMBSN | ||||
ETDAT | Schedule line date | ETDAT | CHAR | 10 | ETDAT | ||||
PRGBZ | External date type | PRGBZ | CHAR | 1 | Assigned to domain | PRGBZ | |||
FIXMG | Delivery date and quantity fixed | FIXMG | CHAR | 1 | XFELD | ||||
WERKS | Plant (Own or External) | WERKS_EXT | CHAR | 4 | Assigned to domain | WERKS | WRK | SH_T001W_EXTS | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | Assigned to domain | VSTEL | VST | ||
ROUTE | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
POSEX | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | ALPHA | POSEX | |||
FAKSP | Billing block for item | FAKSP_AP | CHAR | 2 | Assigned to domain | FAKSP | |||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
KURSK_INT | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
KURSK_EXT | Exchange Rate for Pricing (External Format) | 0 | |||||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
ABGRU | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
LPRIO | Delivery Priority | LPRIO | NUMC | 2 | Assigned to domain | LPRIO | |||
BRGEW | Gross Weight of the Item | BRGEW_AP | QUAN | 15(3) | MENG15 | ||||
NTGEW | Net Weight of the Item | NTGEW_AP | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
VOLUM | Volume of the item | VOLUM_AP | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
AWAHR | Order probability of the item | AWAHR | NUMC | 3 | AWAHR | ||||
GRPOS | Item for which this item is an alternative | GRPOS | NUMC | 6 | GRPOS | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | Assigned to domain | ZLSCH | |||
KZTLF | Partial delivery at item level | KZTLF | CHAR | 1 | KZTLF | ||||
ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | ANTLF | ||||
GRKOR | Delivery group (items are delivered together) | GRKOR | NUMC | 3 | GRKOR | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
DELCO | Agreed delivery time | DELCO | CHAR | 3 | DELCO | ||||
SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
PLTYP | Price list type | PLTYP | CHAR | 2 | Assigned to domain | PLTYP | VPL | ||
KONDA | Price group (customer) | KONDA | CHAR | 2 | Assigned to domain | KONDA | VKA | ||
BZIRK | Sales district | BZIRK | CHAR | 6 | Assigned to domain | BZIRK | BZI | ||
KDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
KONDM | Material Pricing Group | KONDM | CHAR | 2 | Assigned to domain | KONDM | VKM | ||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | Assigned to domain | BSARK | |||
VSART | Shipping type | VSARTTR | CHAR | 2 | T173 | VERSART | |||
ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
EMPST | Receiving point | EMPST | CHAR | 25 | TEXT25 | ||||
MVGR1 | Material group 1 | MVGR1 | CHAR | 3 | Assigned to domain | MVGR1 | |||
MVGR2 | Material group 2 | MVGR2 | CHAR | 3 | Assigned to domain | MVGR2 | |||
MVGR3 | Material group 3 | MVGR3 | CHAR | 3 | Assigned to domain | MVGR3 | |||
MVGR4 | Material group 4 | MVGR4 | CHAR | 3 | Assigned to domain | MVGR4 | |||
MVGR5 | Material group 5 | MVGR5 | CHAR | 3 | Assigned to domain | MVGR5 | |||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | Assigned to domain | KDKGR | |||
VBELN_REF | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
POSNR_REF | Item number of the reference item | VGPOS | NUMC | 6 | Assigned to domain | POSNR | |||
EDATU | Schedule line date | EDATU | DATS | 8 | DATUM | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
PRODH | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
ZWERT_INT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR | 13(2) | WERT7 | ||||
ZWERT_EXT | Target Value for Outline Agreement in Document Currency | DZWERT_EXT | CHAR | 16 | CHAR16 | ||||
WAKTION | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
SKOPF | Assortment module | W_SORTK | CHAR | 18 | Assigned to domain | ALPHA | WSORTK | WBS | |
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PCTRF | Profit Center for Billing | PCTRF | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRCT | |
ABGRS | Results Analysis Key | ABGR_SCHL | CHAR | 6 | Assigned to domain | ABGR_SCHL | ACS | ||
KALSM_K | Costing Sheet | AUFKALSM | CHAR | 6 | Assigned to domain | KALSM | |||
ZSCHL_K | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
POSGUID | ATP: Encryption of DELNR and DELPS | POSGUID | CHAR | 22 | SYSUUID_22 | ||||
IUID_RELEVANT | IUID Relevant for Customer | IUID_RELEVANT_CUST | CHAR | 1 | UID_RELEVANT | ||||
AWERT | Value of value contract already released | ABRUFWERT | CURR | 17(2) | ABRUFWERT | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
PAY_TYPE | SEPA: Transaction Type | SEPA_PAY_TYPE | CHAR | 1 | SEPA_PAY_TYPE | ||||
SEPON | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
.INCLU--AP | 0 | ||||||||
PEROP_BEG | Period of Performance Start Date | FM_PEROP_SD_LOW | DATS | 8 | DATUM | ||||
PEROP_END | Period of Performance End Date | FM_PEROP_SD_HIGH | DATS | 8 | DATUM | ||||
.INCLU-_I | 0 | ||||||||
HANDLE_I | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
POSNR_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
UEPOS_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MABNR_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ARKTX_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KDMAT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PSTYV_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KWMENG_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VRKME_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
UMVKN_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
UMVKZ_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ZMENG_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ZIEME_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
UMZIZ_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
UMZIN_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ETDAT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PRGBZ_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
FIXMG_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
WERKS_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
LGORT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VSTEL_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ROUTE_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
POSEX_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
FAKSP_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
BSTKD_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
BSTDK_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ZTERM_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PRSDT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KURSK_INT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KURSK_EXT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
FKDAT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INCO1_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INCO2_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ABGRU_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
LPRIO_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
BRGEW_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
NTGEW_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
GEWEI_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VOLUM_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VOLEH_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SPART_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
WAERK_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
AUFNR_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PS_PSP_PNR_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
AWAHR_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
GRPOS_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ZLSCH_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KZTLF_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ANTLF_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
GRKOR_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
CHARG_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
DELCO_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SELKZ_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PLTYP_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KONDA_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
BZIRK_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KDGRP_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KONDM_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
BSARK_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VSART_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ABLAD_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
EMPST_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MVGR1_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MVGR2_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MVGR3_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MVGR4_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MVGR5_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KDKG1_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KDKG2_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KDKG3_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KDKG4_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KDKG5_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VBELN_REF_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
POSNR_REF_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
EDATU_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VALDT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VALTG_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
UEBTO_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
UNTTO_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
UEBTK_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PRODH_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MATKL_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ZWERT_INT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ZWERT_EXT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
WAKTION_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SKOPF_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
BWTAR_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
EAN11_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
GSBER_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PRCTR_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PCTRF_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ABGRS_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KALSM_K_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ZSCHL_K_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
POSGUID_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
IUID_RELEVANT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
AWERT_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MNDID_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PAY_TYPE_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SEPON_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
PEROP_BEG_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PEROP_END_I | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
.INCLU-_R | 0 | ||||||||
HANDLE_R | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
MATWA_R_R | Material entered | MATWA | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
KBMENG_R_R | Cumulative confirmed quantity in sales unit | KBMENG | QUAN | 15(3) | MENG15 | ||||
LSMNG_R_R | Cumulative required delivery qty (all dlv-relev.sched.lines) | LSMENG | QUAN | 15(3) | MENG15 | ||||
VSMNG_R_R | Delivered quantity in sales units | VSMNG | QUAN | 13(3) | MENG13 | ||||
VRKME_R_R | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SPART_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
PSTYV_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
WERKS_T_R | Description | BEZEI30 | CHAR | 30 | TEXT30 | ||||
LGORT_T_R | Description of Storage Location | LGOBE | CHAR | 16 | TEXT16 | ||||
VSTEL_T_R | Description | BEZEI30 | CHAR | 30 | TEXT30 | ||||
ROUTE_T_R | Description of Route | ROUTBEZ | CHAR | 40 | TEXT40 | ||||
FAKSP_T_R | Description | BEZEI_FAKSP | CHAR | 20 | TEXT20 | ||||
ZTERM_T_R | Description of terms of payment | DZTERM_BEZ | CHAR | 30 | TEXT30 | ||||
ZLSCH_T_R | Name of Payment Method in Language of the Country | TEXT1_042Z | CHAR | 30 | TEXT30 | ||||
KZTLF_T_R | Description | BEZEI30 | CHAR | 30 | TEXT30 | ||||
MWSBP_R_R | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
KSTBS_R_R | Condition scale quantity | KSTBM | QUAN | 15(3) | MENG15 | ||||
WAVWR_R_R | Cost in document currency | WAVWR | CURR | 13(2) | WERTV7 | ||||
CMPRE_R_R | Item credit price | CMPRE | CURR | 11(2) | WERTV6 | ||||
NETWR_R_R | Net value of the order item in document currency | NETWR_AP | CURR | 15(2) | WERTV8 | ||||
WAERK_R_R | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
NETPR_R_R | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
KPEIN_R_R | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KMEIN_R_R | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ERNAM_R_R | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT_R_R | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
KZWI1_R_R | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2_R_R | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3_R_R | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4_R_R | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5_R_R | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6_R_R | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
PLTYP_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
KONDA_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
BZIRK_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
KDGRP_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
KONDM_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
BSARK_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
VSART_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
VGBEL_R_R | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
VGPOS_R_R | Item number of the reference item | VGPOS | NUMC | 6 | Assigned to domain | POSNR | |||
POSAR_R_R | Item type | POSAR | CHAR | 1 | POSAR | ||||
UEPVW_R_R | ID for higher-level item usage | UEPVW | CHAR | 1 | UEPVW | ||||
PROSA_R_R | ID for material determination | PROSA | CHAR | 1 | PROSA | ||||
POSAR_T_R | Short Text for Fixed Values | VAL_TEXT | CHAR | 60 | DDTEXT | ||||
EDATU_LAST_R | Schedule line date | EDATU | DATS | 8 | DATUM | ||||
MBDAT_LAST_R | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
BMENG_LAST_R | Confirmed Quantity | BMENG | QUAN | 13(3) | MENG13 | ||||
WAKTION_T_R | Promotion description | AKTBEZ | CHAR | 40 | TEXT40 | ||||
MEINS_R | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KATPMN_R | Cumulative ATP quantity (available to promise) | KATPMN | QUAN | 15(3) | MENGV15 | ||||
LPRIO_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
ABGRU_T_R | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
MATKL_T_R | Material Group Description | WGBEZ | CHAR | 20 | TEXT20 | ||||
GSBER_T_R | Business area description | GTEXT | CHAR | 30 | TEXT30 | ||||
PS_PSP_PNR_T_R | PS: Short description (1st text line) | PS_POST1 | CHAR | 40 | TEXT40 | ||||
AUFNR_T_R | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
PRCTR_T_R | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
PCTRF_T_R | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
ABGRS_T_R | Character Field for Text Table | KKATEXT | CHAR | 40 | KKATEXT | ||||
KALSM_K_T_R | Description | VTXTM | CHAR | 30 | TEXT30 | ||||
ZSCHL_K_T_R | Description | BEZEI30 | CHAR | 30 | TEXT30 | ||||
VBELV_R_R | Originating document | VBELV | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
POSNV_R_R | Originating item | POSNV | NUMC | 6 | Assigned to domain | POSNR | |||
CUOBJ_R_R | Configuration | CUOBJ_VA | NUMC | 18 | CUOBJ | ||||
ETERL_R_R | Schedule lines allowed | ETERL | CHAR | 1 | XFELD | ||||
SUGRD_R_R | Reason for material substitution | SUGRD | CHAR | 4 | Assigned to domain | SUGRD | VDG | ||
SUGRD_T_R | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
PRSFD_R_R | Carry out pricing | PRSFD | CHAR | 1 | PRSFD | ||||
MATNR_INT_R_R | Unedited Material Number | TDV_MATNR_UNEDITED | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
PMATN_R_R | Pricing Reference Material | PMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
VRKME_INT_R_R | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SPOSN_R_R | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
SHKZG_R_R | Returns Item | SHKZG_VA | CHAR | 1 | XFELD | ||||
STMAN_R_R | Indicates processing status | STMAN | CHAR | 1 | STMAN | ||||
STDPD_R_R | Configurable material | STDPD | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
OBJNR_R_R | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
SKOPF_T_R | Description for assortment module | W_SORTX | CHAR | 40 | TEXT40U | ||||
PRODH_T_R | Product Hierarchy (Description) | TDV_PRODH_DESCR | CHAR | 40 | TEXT40 | ||||
ENDBP_R_R | Total amount of item | ENDBP | CURR | 15(2) | WERTV8 | ||||
KOWRR_R_R | Statistical values | KOWRR | CHAR | 1 | KOWRR |
Key field | Non-key field |
How do I retrieve data from SAP structure TDS_ITEM_COM using ABAP code?
As TDS_ITEM_COM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TDS_ITEM_COM as there is no data to select.How to access SAP table TDS_ITEM_COM
Within an ECC or HANA version of SAP you can also view further information about TDS_ITEM_COM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects