SAP ABAP Table CRMST_L2_ITEM_COMV (Lean Order - RFC - Item Data (Values))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-ERP (Application Component) BSP for ERP Sales Order
⤷ CRM_ERP_IL (Package) ERP Sales Order: GENIL Implementation
⤷ CRM-BTX-ERP (Application Component) BSP for ERP Sales Order
⤷ CRM_ERP_IL (Package) ERP Sales Order: GENIL Implementation
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMST_L2_ITEM_COMV | Table Relationship Diagram |
Short Description | Lean Order - RFC - Item Data (Values) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | HANDLE | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
2 | POSNR | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | ||
3 | UEPOS | UEPOS | POSNR | NUMC | 6 | 0 | Higher-level item in bill of material structures | ||
4 | MABNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | ||
5 | ARKTX | ARKTX | TEXT40 | CHAR | 40 | 0 | Short text for sales order item | ||
6 | KDMAT | MATNR_KU | CRM_R3_VEND_MAT | CHAR | 35 | 0 | Customer Material Number | ||
7 | PSTYV | PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | ||
8 | KWMENG | KWMENG | MENG15 | QUAN | 15 | 3 | Cumulative order quantity in sales units | ||
9 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
10 | UMVKN | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
11 | UMVKZ | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
12 | ZMENG | DZMENG | MENG13 | QUAN | 13 | 3 | Target quantity in sales units | ||
13 | ZIEME | DZIEME | MEINS | UNIT | 3 | 0 | Target quantity UoM | T006 | |
14 | UMZIZ | UMZIZ | UMBSZ | DEC | 5 | 0 | Factor for converting sales units to base units (target qty) | ||
15 | UMZIN | UMZIN | UMBSN | DEC | 5 | 0 | Factor for converting sales units to base units (target qty) | ||
16 | ETDAT | ETDAT_ERP | ETDAT | CHAR | 10 | 0 | Schedule line date | ||
17 | PRGBZ | PRGBZ_ERP | PRGBZ | CHAR | 1 | 0 | External date type | * | |
18 | FIXMG | FIXMG | XFELD | CHAR | 1 | 0 | Delivery date and quantity fixed | ||
19 | WERKS | DWERK_ERP | WERKS | CHAR | 4 | 0 | Delivering Plant (Own or External) | * | |
20 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | ||
21 | VSTEL | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | ||
22 | ROUTE | ROUTE | ROUTE | CHAR | 6 | 0 | Route | ||
23 | POSEX | POSEX | POSEX | CHAR | 6 | 0 | Item Number of the Underlying Purchase Order | ||
24 | FAKSP | FAKSP_AP | FAKSP | CHAR | 2 | 0 | Billing block for item | * | |
25 | BSTKD | BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
26 | BSTDK | BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
27 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
28 | PRSDT | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
29 | KURSK_INT | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
30 | KURSK_EXT | CHAR | 12 | 0 | |||||
31 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
32 | INCO1 | INCO1 | CRM_INCOTERMS1 | CHAR | 3 | 0 | Incoterms (part 1) | CRMC_INCOTERM | |
33 | INCO2 | INCO2 | CRM_INCOTERMS2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
34 | ABGRU | ABGRU_VA | ABGRU_VA | CHAR | 2 | 0 | Reason for rejection of quotations and sales orders | * | |
35 | LPRIO | LPRIO | LPRIO | NUMC | 2 | 0 | Delivery priority | ||
36 | BRGEW | BRGEW_AP | MENG15 | QUAN | 15 | 3 | Gross weight of item | ||
37 | NTGEW | NTGEW_AP | MENG15 | QUAN | 15 | 3 | Net weight of item | ||
38 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | T006 | |
39 | VOLUM | VOLUM_AP | MENG15 | QUAN | 15 | 3 | Volume of the item | ||
40 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | T006 | |
41 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | ||
42 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
43 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
44 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
45 | AWAHR | AWAHR | AWAHR | NUMC | 3 | 0 | Order probability of the item | ||
46 | GRPOS | GRPOS | GRPOS | NUMC | 6 | 0 | Item for which this item is an alternative | ||
47 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | * | |
48 | KZTLF | KZTLF | KZTLF | CHAR | 1 | 0 | Partial delivery at item level | ||
49 | ANTLF | ANTLF | ANTLF | DEC | 1 | 0 | Maximum number of partial deliveries allowed per item | ||
50 | GRKOR | GRKOR | GRKOR | NUMC | 3 | 0 | Delivery group (items are delivered together) | ||
51 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | ||
52 | DELCO | DELCO | DELCO | CHAR | 3 | 0 | Agreed delivery time | ||
53 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | ||
54 | KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | ||
55 | BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
56 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | ||
57 | KONDM | KONDM | KONDM | CHAR | 2 | 0 | Material Pricing Group | ||
58 | BSARK | BSARK | BSARK | CHAR | 4 | 0 | Customer Order Type | ||
59 | VSART | VSARTTR | VERSART | CHAR | 2 | 0 | Shipping type | * | |
60 | ABLAD | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
61 | EMPST | EMPST | TEXT25 | CHAR | 25 | 0 | Receiving point | ||
62 | MVGR1 | MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | ||
63 | MVGR2 | MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | ||
64 | MVGR3 | MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | ||
65 | MVGR4 | MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | ||
66 | MVGR5 | MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | ||
67 | KDKG1 | KDKG1 | KDKGR | CHAR | 2 | 0 | Customer condition group 1 | * | |
68 | KDKG2 | KDKG2 | KDKGR | CHAR | 2 | 0 | Customer condition group 2 | * | |
69 | KDKG3 | KDKG3 | KDKGR | CHAR | 2 | 0 | Customer condition group 3 | * | |
70 | KDKG4 | KDKG4 | KDKGR | CHAR | 2 | 0 | Customer condition group 4 | * | |
71 | KDKG5 | KDKG5 | KDKGR | CHAR | 2 | 0 | Customer condition group 5 | * | |
72 | VBELN_REF | VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | ||
73 | POSNR_REF | VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | ||
74 | EDATU | EDATU | DATUM | DATS | 8 | 0 | Schedule line date | ||
75 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
76 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
77 | UEBTO | CRMT_UEBTO_ERPIL | PRZ21 | DEC | 3 | 1 | Overdelivery Tolerance Limit | ||
78 | UNTTO | CRMT_UNTTO_ERPIL | PRZ21 | DEC | 3 | 1 | Underdelivery Tolerance Limit | ||
79 | UEBTK | UEBTK | XFELD | CHAR | 1 | 0 | Indicator: Unlimited Overdelivery Allowed | ||
80 | PRODH | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | ||
81 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
82 | ZWERT_INT | DZWERT | WERT7 | CURR | 13 | 2 | Target value for outline agreement in document currency | ||
83 | ZWERT_EXT | CHAR16 | CHAR16 | CHAR | 16 | 0 | Field of length 16 | ||
84 | WAKTION | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | ||
85 | SKOPF | W_SORTK | WSORTK | CHAR | 18 | 0 | Assortment Module | ||
86 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | ||
87 | EAN11 | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
88 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
89 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | ||
90 | PCTRF | CRMT_PCTRF_ERPIL | PRCTR | CHAR | 10 | 0 | Profit Center for Billing | ||
91 | ABGRS | ABGR_SCHL | ABGR_SCHL | CHAR | 6 | 0 | Results Analysis Key | ||
92 | KALSM_K | AUFKALSM | KALSM | CHAR | 6 | 0 | Costing Sheet | * | |
93 | ZSCHL_K | AUFZSCHL | CHAR6 | CHAR | 6 | 0 | Overhead key | ||
94 | POSGUID | POSGUID | SYSUUID_22 | CHAR | 22 | 0 | ATP: Encryption of DELNR and DELPS | ||
95 | IUID_RELEVANT | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
96 | AWERT | CRMT_ERP_AWERT | CRM_ERP_AWERT | CURR | 17 | 2 | Value of the Value Contract Already Released | ||
97 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
98 | PAY_TYPE | SEPA_PAY_TYPE | SEPA_PAY_TYPE | CHAR | 1 | 0 | SEPA: Payment Type | ||
99 | SEPON | CRMT_SEPA_ON | CRM_SEPA_ON | CHAR | 1 | 0 | Indicator for SEPA-Relevant Transactions |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMST_L2_ITEM_COMV | GEWEI | T006 | MSEHI | REF | C | CN |
2 | CRMST_L2_ITEM_COMV | INCO1 | CRMC_INCOTERM | INCOTERMS1 | REF | C | CN |
3 | CRMST_L2_ITEM_COMV | VOLEH | T006 | MSEHI | REF | C | CN |
4 | CRMST_L2_ITEM_COMV | WAERK | TCURC | WAERS | REF | C | CN |
5 | CRMST_L2_ITEM_COMV | ZIEME | T006 | MSEHI | REF | C | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |