SAP ABAP Table BAPIVBRP_CMS (CMS BAPI structure for Billing Item data from R/3)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-CHM-POS (Application Component) Point of Sale
⤷ CMS_BAPI_STR (Package) CMS Package for Common BAPI Structures
⤷ CRM-CHM-POS (Application Component) Point of Sale
⤷ CMS_BAPI_STR (Package) CMS Package for Common BAPI Structures
Basic Data
Table Category | INTTAB | Structure |
Structure | BAPIVBRP_CMS | Table Relationship Diagram |
Short Description | CMS BAPI structure for Billing Item data from R/3 |
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 | OPERATION | MSGFN | MSGFN | CHAR | 3 | 0 | Function | ||
2 | BILL_DOC | VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | ||
3 | BILL_ITEM_NO | NUMC | 6 | 0 | |||||
4 | HG_LV_ITEM | UEPOS | POSNR | NUMC | 6 | 0 | Higher-level item in bill of material structures | ||
5 | INV_QTY | FKIMG | MENG13 | QUAN | 13 | 3 | Actual billed quantity | ||
6 | SALES_UNIT | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
7 | ISO_SALES_UNIT | ISO_ZIEME | ISOCD_UNIT | CHAR | 3 | 0 | Target quantity unit of measure in ISO code | * | |
8 | SALES_QTY_NUM | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
9 | SALES_QTY_DENOM | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
10 | BASE_UOM | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
11 | T_UNIT_ISO | ISO_ZIEME | ISOCD_UNIT | CHAR | 3 | 0 | Target quantity unit of measure in ISO code | * | |
12 | SCALE_QTY_BASE_UOM | SMENG | MENG13 | QUAN | 13 | 3 | Scale quantity in base unit of measure | ||
13 | INV_QTY_SU | FKLMG | MENG13 | QUAN | 13 | 3 | Billing quantity in stockkeeping unit | ||
14 | REQ_QUAN_MAT_MAN_ST_UN | LMENG | MENG13 | QUAN | 13 | 3 | Required quantity for mat.management in stockkeeping units | ||
15 | NET_WEIGHT | NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
16 | GROSS_WT | BRGEW_15 | MENG15 | QUAN | 15 | 3 | Gross weight | ||
17 | UNIT_OF_WT | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
18 | ISO_WT_UNIT | ISO_ZIEME | ISOCD_UNIT | CHAR | 3 | 0 | Target quantity unit of measure in ISO code | * | |
19 | VOLUME | VOLUM_15 | MENG15 | QUAN | 15 | 3 | Volume | ||
20 | VOLUMEUNIT | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
21 | ISO_VOL_UNIT | ISO_ZIEME | ISOCD_UNIT | CHAR | 3 | 0 | Target quantity unit of measure in ISO code | * | |
22 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
23 | PRICE_DATE | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
24 | SERVICE_DATE | FBUDA | DATUM | DATS | 8 | 0 | Date When Services Rendered | ||
25 | EXCHG_RATE | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
26 | NET_VAL | CURR | 15 | 2 | |||||
27 | ORGION_DOC | VBELV | VBELN | CHAR | 10 | 0 | Originating document | ||
28 | ORGION_DOC_ITEM | POSNV | POSNR | NUMC | 6 | 0 | Originating item | ||
29 | REF_DOC | VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | ||
30 | REF_DOC_IT | VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | ||
31 | REF_DOC_CA | VBTYP_V | VBTYP | CHAR | 1 | 0 | Document category of preceding SD document | ||
32 | DOC_NUMBER | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | ||
33 | ITM_NUMBER | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | ||
34 | FLAG_SALES_DOC_REF | CHAR | 1 | 0 | |||||
35 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | ||
36 | SHORT_TEXT | ARKTX | TEXT40 | CHAR | 40 | 0 | Short text for sales order item | ||
37 | PR_REF_MAT | PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | ||
38 | BATCH | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | ||
39 | MATL_GROUP | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
40 | ITEM_CATEG | PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | ||
41 | ITEM_TYPE | POSAR | POSAR | CHAR | 1 | 0 | Item type | ||
42 | PROD_HIER | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | ||
43 | SHIP_POINT | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | ||
44 | REPLACE_PT | ATPKZ | ATPKZ | CHAR | 1 | 0 | Replacement part | ||
45 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | ||
46 | ITEM_NUM_PART_SEG | NUMC | 6 | 0 | |||||
47 | PLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
48 | DEPCOUNTRY | ALAND | LAND1 | CHAR | 3 | 0 | Departure country (country from which the goods are sent) | * | |
49 | ISO_DEP_COUNTRY | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
50 | WKREG | WKREG | REGIO | CHAR | 3 | 0 | Region in which plant is located | * | |
51 | WKCOU | WKCOU | CHAR3 | CHAR | 3 | 0 | County in which plant is located | ||
52 | WKCTY | WKCTY | CHAR4 | CHAR | 4 | 0 | City in which plant is located | ||
53 | TAXM1 | TAXM1 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
54 | TAXM2 | TAXM2 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
55 | TAXM3 | TAXM3 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
56 | TAXM4 | CHAR | 1 | 0 | |||||
57 | TAXM5 | CHAR | 1 | 0 | |||||
58 | TAXM6 | CHAR | 1 | 0 | |||||
59 | TAXM7 | CHAR | 1 | 0 | |||||
60 | TAXM8 | CHAR | 1 | 0 | |||||
61 | TAXM9 | CHAR | 1 | 0 | |||||
62 | STAT_VAL | KOWRR | KOWRR | CHAR | 1 | 0 | Statistical values | ||
63 | FLAG_CARRY_PRICE | PRSFD | PRSFD | CHAR | 1 | 0 | Carry out pricing | ||
64 | CASH_DISC | SKTOF | XFELD | CHAR | 1 | 0 | Cash discount indicator | ||
65 | ELG_AMT_CASH_DISC | CURR | 13 | 2 | |||||
66 | MAT_PR_GRP | KONDM | KONDM | CHAR | 2 | 0 | Material Pricing Group | ||
67 | ACCT_ASSGT | KTGRM | KTGRM | CHAR | 2 | 0 | Account assignment group for this material | * | |
68 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
69 | REBATE_GRP | BONUS | BONUS | CHAR | 2 | 0 | Volume rebate group | * | |
70 | COMM_GROUP | PROVG | PROVG | CHAR | 2 | 0 | Commission group | * | |
71 | EUR_ART_NR | EANNR | CHAR13 | CHAR | 13 | 0 | European Article Number (EAN) - obsolete!!!!! | ||
72 | SALES_GRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
73 | SALES_OFF | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
74 | DIV_ORD_HEADER | CHAR | 2 | 0 | |||||
75 | FLAG_RETURN_ITEM | CHAR | 1 | 0 | |||||
76 | CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
77 | CR_ON | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
78 | REC_TIME | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
79 | VAL_TYPE | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | ||
80 | STGE_LOC | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | ||
81 | UPDATE_GRP | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
82 | COST_DOC_CURR | CURR | 13 | 2 | |||||
83 | SUB_TOT_1_PP_COND | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
84 | SUB_TOT_2_PP_COND | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
85 | SUB_TOT_3_PP_COND | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
86 | SUB_TOT_4_PP_COND | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
87 | SUB_TOT_5_PP_COND | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
88 | SUB_TOT_6_PP_COND | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
89 | EXCH_RATE_STAT_CREATE | DEC | 9 | 5 | |||||
90 | FLAG_INCOMP_PRICE | CHAR | 1 | 0 | |||||
91 | FLAG_INCOMP_GEN | CHAR | 1 | 0 | |||||
92 | EAN_UPC | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
93 | PROFIT_CTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | ||
94 | CUST_GRP1 | KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | * | |
95 | CUST_GRP2 | KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | * | |
96 | CUST_GRP3 | KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | * | |
97 | CUST_GRP4 | KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | * | |
98 | CUST_GRP5 | KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | * | |
99 | PRC_GROUP1 | MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | ||
100 | PRC_GROUP2 | MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | ||
101 | PRC_GROUP3 | MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | ||
102 | PRC_GROUP4 | MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | ||
103 | PRC_GROUP5 | MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | ||
104 | MAT_ENTRD | MATWA | MATNR | CHAR | 18 | 0 | Material entered | ||
105 | BONBA | BONBA | WERTV7 | CURR | 13 | 2 | Rebate basis 1 | ||
106 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
107 | PROFIT_SEGM_NO | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
108 | WBS_ELEM | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
109 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
110 | TAXJURCODE | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
111 | ITEM_CR_PRICE | CURR | 11 | 2 | |||||
112 | ITEM_ID_ACTV_REL_CR | CMPNT | XFELD | CHAR | 1 | 0 | ID: Item with active credit function / relevant for credit | ||
113 | CONFIGURATION | CUOBJ_VA | CUOBJ | NUMC | 18 | 0 | Configuration | ||
114 | INT_OBJ_BATCH_CLASS | CUOBJ_CH | CUOBJ | NUMC | 18 | 0 | Internal object number of the batch classification | ||
115 | COND_UPDAT | KOUPD | XFELD | CHAR | 1 | 0 | Condition update | ||
116 | HIGH_ITEM_BATCH_SPLIT | UECHA | POSNR | NUMC | 6 | 0 | Higher-Level Item of Batch Split Item | ||
117 | IND_BTCH | XCHAR | XFELD | CHAR | 1 | 0 | Batch management indicator (internal) | ||
118 | DLVSCHEDUSE_01 | ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | * | |
119 | BOMEXPL_NO | SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | * | |
120 | SALES_DIST_SO | CHAR | 6 | 0 | |||||
121 | CUST_GRP_SO | CHAR | 2 | 0 | |||||
122 | PRICE_GRP_SO | CHAR | 2 | 0 | |||||
123 | COUNT_DEST_SO | CHAR | 3 | 0 | |||||
124 | ISO_SO_COUN_DEST | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
125 | STAT_MAP_PRICE_CHNG | MPROK | MPROK | CHAR | 1 | 0 | Status manual price change | ||
126 | PRICE_LIST_TYPE_SO | CHAR | 2 | 0 | |||||
127 | REGION_SO | CHAR | 3 | 0 | |||||
128 | SALE_ORG_SO | VKORG_AUFT | VKORG | CHAR | 4 | 0 | Sales organization of sales order | * | |
129 | DIS_CHANNEL_SO | CHAR | 2 | 0 | |||||
130 | START_DATE_ACC_SET_PER | DATS | 8 | 0 | |||||
131 | ID_MAT_SEL_ACTIVE | PROSA | PROSA | CHAR | 1 | 0 | ID for material selection - active | ||
132 | ID_HIGH_LEV_ITM_USG | UEPVW | UEPVW | CHAR | 1 | 0 | ID for higher-level item usage | ||
133 | SD_DOC_CAT | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
134 | STAT_DATE | STADAT | DATUM | DATS | 8 | 0 | Statistics date | ||
135 | BILL_PLAN | FPLNR | FPLNR | CHAR | 10 | 0 | Billing plan number / invoicing plan number | * | |
136 | BILL_PLAN_ITEM | FPLTR | FPLTR | NUMC | 6 | 0 | Item for billing plan/invoice plan/payment cards | * | |
137 | ACTION | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | ||
138 | PROMOTION | KNUMA_PI | KNUMA | CHAR | 10 | 0 | Promotion | * | |
139 | SALES_DEAL | KNUMA_AG | KNUMA | CHAR | 10 | 0 | Sales deal | * | |
140 | IND_PREF_IMP_EXP | PREFE | PREFE | CHAR | 1 | 0 | Preference indicator in export/import | ||
141 | TAX_AMT_DOC_CURR | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
142 | ORD_REASON | AUGRU | AUGRU | CHAR | 3 | 0 | Order reason (reason for the business transaction) | * | |
143 | RULE_BILL_INV | FAREG | FAREG | CHAR | 1 | 0 | Rule in billing plan/invoice plan | ||
144 | PRIC_REF_MAT_MAIN_ITEM | UPMAT | MATNR | CHAR | 18 | 0 | Pricing reference material of main item | ||
145 | MAT_PRC_GRP_MAN_ITEM | UKONM | KONDM | CHAR | 2 | 0 | Material pricing group of main item | ||
146 | ITEM_CR_PRICE_FLT | CMPRE_FLT | FLTP | FLTP | 16 | 16 | Item credit price | ||
147 | FORM_PAY_GUAR | ABSFORM_CM | ABSFORM_CM | CHAR | 2 | 0 | Form of payment guarantee | ||
148 | FACTOR_GUAR | ABGES_CM | FLTP | FLTP | 16 | 16 | Guaranteed (factor between 0 and 1) | ||
149 | REASON_ZERO_VAT | J_1ARFZVAT | J_1ARFZVAT | CHAR | 1 | 0 | Reason for zero VAT | * | |
150 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
151 | ACT_CODE_GROSS_EMP_TAX | J_1AGICD_D | J_1AGICD2 | CHAR | 2 | 0 | Activity Code for Gross Income Tax | * | |
152 | DIST_TYP_EMP_TAX | J_1ADTYP_D | J_1ADTYP | CHAR | 2 | 0 | Distribution Type for Employment Tax | * | |
153 | TAX_REL_CLASS | J_1ATXREL_ | J_1ATXREL | CHAR | 10 | 0 | Tax relevant classification | * | |
154 | CFOP_CODE_EXTN | CHAR | 10 | 0 | |||||
155 | ICMS_TAX_LAW | J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | * | |
156 | IPI_TAX_LAW | J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | * | |
157 | SD_TAX_CODE | J_1BTXSDC_ | J_1BTXSDC | CHAR | 2 | 0 | SD tax code | * | |
158 | GROSS_VAL_BILL_ITEM | CURR | 15 | 2 | |||||
159 | WKTNR | WKTNR | VBELN | CHAR | 10 | 0 | Value contract no. | ||
160 | WKTPS | WKTPS | POSNR | NUMC | 6 | 0 | Value contract item | ||
161 | PAY_CARD_PLAN_NO_SD | CHAR | 10 | 0 | |||||
162 | TRANS_DATE | WWERT_D | DATUM | DATS | 8 | 0 | Translation date | ||
163 | MAT_GRP_HIER1 | WGRU_HIE1 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 1 | ||
164 | MAT_GRP_HIER2 | WGRU_HIE2 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 2 | ||
165 | CUST_COND_GRP1 | KDKG1 | KDKGR | CHAR | 2 | 0 | Customer condition group 1 | * | |
166 | CUST_COND_GRP2 | KDKG2 | KDKGR | CHAR | 2 | 0 | Customer condition group 2 | * | |
167 | CUST_COND_GRP3 | KDKG3 | KDKGR | CHAR | 2 | 0 | Customer condition group 3 | * | |
168 | CUST_COND_GRP4 | KDKG4 | KDKGR | CHAR | 2 | 0 | Customer condition group 4 | * | |
169 | CUST_COND_GRP5 | KDKG5 | KDKGR | CHAR | 2 | 0 | Customer condition group 5 | * | |
170 | DLVSCHEDUSE_02 | ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | * | |
171 | INFLATION_INDEX | J_1AINDXP | J_1AINDXP | CHAR | 5 | 0 | Inflation Index | * | |
172 | INDEX_BASE_DATE | J_1AIDATES | J_1AUDATEP | DATS | 8 | 0 | Indexing base date | ||
173 | FLG_LEAD_UNIT | KZFME | KZFME | CHAR | 1 | 0 | ID: Leading unit of measure for completing a transaction | ||
174 | TAX_CODE | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
175 | CONTRACT_TYPE | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
176 | CONTRACT_NUM | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
177 | ITEM_TEXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
178 | AGREED_DEL_TIME | DELCO | DELCO | CHAR | 3 | 0 | Agreed delivery time | ||
179 | CALC_MOTIVE | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | * | |
180 | REVENUE_TYPE | CHAR | 1 | 0 | |||||
181 | EXCH_RATE_LET_CR | AKKUR | KURRF | DEC | 9 | 5 | Exchange rate for letter-of-credit procg in foreign trade | ||
182 | PRODCAT | WMINR | WMINR | CHAR | 10 | 0 | Product catalog number | * | |
183 | REF_DOC_EX | VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | ||
184 | REF_DOC_IT_EX | VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | ||
185 | LOG_SYSTEM | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
186 | ACT_ELEM_CAT_EX | CHAR | 3 | 0 | |||||
187 | SD_DOC_TYP | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | * | |
188 | SD_ITM_CAT | PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 400 |