SAP ABAP Table BAPICMS_VBRP (CMS BAPI structure for Billing Item data from R/3)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷
SD (Application Component) Sales and Distribution
⤷
CRM_CMS_BILL_CAP_RI (Package) Rel Ind CMS plugin package to capture billing data
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | BAPICMS_VBRP |
|
| 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 | |
MSGFN | MSGFN | CHAR | 3 | 0 | Function | ||
| 2 | |
VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | * | |
| 3 | |
POSNR_VF | POSNR | NUMC | 6 | 0 | Billing item | * | |
| 4 | |
UEPOS | POSNR | NUMC | 6 | 0 | Higher-level item in bill of material structures | * | |
| 5 | |
FKIMG | MENG13 | QUAN | 13 | 3 | Actual billed quantity | ||
| 6 | |
VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
| 7 | |
ISO_ZIEME | ISOCD_UNIT | CHAR | 3 | 0 | Target quantity unit of measure in ISO code | * | |
| 8 | |
UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
| 9 | |
UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
| 10 | |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
| 11 | |
ISO_ZIEME | ISOCD_UNIT | CHAR | 3 | 0 | Target quantity unit of measure in ISO code | * | |
| 12 | |
SMENG | MENG13 | QUAN | 13 | 3 | Scale quantity in base unit of measure | ||
| 13 | |
FKLMG | MENG13 | QUAN | 13 | 3 | Billing quantity in stockkeeping unit | ||
| 14 | |
LMENG | MENG13 | QUAN | 13 | 3 | Required quantity for mat.management in stockkeeping units | ||
| 15 | |
NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
| 16 | |
BRGEW_15 | MENG15 | QUAN | 15 | 3 | Gross weight | ||
| 17 | |
GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
| 18 | |
ISO_ZIEME | ISOCD_UNIT | CHAR | 3 | 0 | Target quantity unit of measure in ISO code | * | |
| 19 | |
VOLUM_15 | MENG15 | QUAN | 15 | 3 | Volume | ||
| 20 | |
VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
| 21 | |
ISO_ZIEME | ISOCD_UNIT | CHAR | 3 | 0 | Target quantity unit of measure in ISO code | * | |
| 22 | |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
| 23 | |
PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
| 24 | |
FBUDA | DATUM | DATS | 8 | 0 | Date When Services Rendered | ||
| 25 | |
KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
| 26 | |
NETWR_FP | WERTV8 | CURR | 15 | 2 | Net value of the billing item in document currency | ||
| 27 | |
VBELV | VBELN | CHAR | 10 | 0 | Originating document | * | |
| 28 | |
POSNV | POSNR | NUMC | 6 | 0 | Originating item | * | |
| 29 | |
VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | * | |
| 30 | |
VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | * | |
| 31 | |
VBTYP_V | VBTYP | CHAR | 1 | 0 | Document category of preceding SD document | ||
| 32 | |
VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
| 33 | |
POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
| 34 | |
AUREF | XFELD | CHAR | 1 | 0 | Sales document was created from reference | ||
| 35 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
| 36 | |
ARKTX | TEXT40 | CHAR | 40 | 0 | Short text for sales order item | ||
| 37 | |
PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | * | |
| 38 | |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
| 39 | |
MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
| 40 | |
PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | * | |
| 41 | |
POSAR | POSAR | CHAR | 1 | 0 | Item type | ||
| 42 | |
PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | * | |
| 43 | |
VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | * | |
| 44 | |
ATPKZ | ATPKZ | CHAR | 1 | 0 | Replacement part | ||
| 45 | |
SPART | SPART | CHAR | 2 | 0 | Division | * | |
| 46 | |
POSPA | POSNR | NUMC | 6 | 0 | Item number in the partner segment | * | |
| 47 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
| 48 | |
ALAND | LAND1 | CHAR | 3 | 0 | Departure country (country from which the goods are sent) | * | |
| 49 | |
INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
| 50 | |
WKREG | REGIO | CHAR | 3 | 0 | Region in which plant is located | * | |
| 51 | |
WKCOU | CHAR3 | CHAR | 3 | 0 | County in which plant is located | ||
| 52 | |
WKCTY | CHAR4 | CHAR | 4 | 0 | City in which plant is located | ||
| 53 | |
TAXM1 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
| 54 | |
TAXM2 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
| 55 | |
TAXM3 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
| 56 | |
TAXM4 | TAXKM | CHAR | 1 | 0 | Tax Classification 4 Material | * | |
| 57 | |
TAXM5 | TAXKM | CHAR | 1 | 0 | Tax classification 5 for material | * | |
| 58 | |
TAXM6 | TAXKM | CHAR | 1 | 0 | Tax classification 6 for material | * | |
| 59 | |
TAXM7 | TAXKM | CHAR | 1 | 0 | Tax classification 7 for material | * | |
| 60 | |
TAXM8 | TAXKM | CHAR | 1 | 0 | Tax Classification 8 Material | * | |
| 61 | |
TAXM9 | TAXKM | CHAR | 1 | 0 | Tax Classification 9 Material | * | |
| 62 | |
KOWRR | KOWRR | CHAR | 1 | 0 | Statistical values | ||
| 63 | |
PRSFD | PRSFD | CHAR | 1 | 0 | Carry out pricing | ||
| 64 | |
SKTOF | XFELD | CHAR | 1 | 0 | Cash discount indicator | ||
| 65 | |
SKFBP | WERTV7 | CURR | 13 | 2 | Amount eligible for cash discount in document currency | ||
| 66 | |
KONDM | KONDM | CHAR | 2 | 0 | Material Pricing Group | * | |
| 67 | |
KTGRM | KTGRM | CHAR | 2 | 0 | Account assignment group for this material | * | |
| 68 | |
KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
| 69 | |
BONUS | BONUS | CHAR | 2 | 0 | Volume rebate group | * | |
| 70 | |
PROVG | PROVG | CHAR | 2 | 0 | Commission group | * | |
| 71 | |
EANNR | CHAR13 | CHAR | 13 | 0 | European Article Number (EAN) - obsolete!!!!! | ||
| 72 | |
VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
| 73 | |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
| 74 | |
SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | * | |
| 75 | |
SHKZG_VF | SHKZG_VF | CHAR | 1 | 0 | Returns item | ||
| 76 | |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 77 | |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
| 78 | |
ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
| 79 | |
BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
| 80 | |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
| 81 | |
STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
| 82 | |
WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
| 83 | |
KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
| 84 | |
KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
| 85 | |
KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
| 86 | |
KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
| 87 | |
KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
| 88 | |
KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
| 89 | |
STCUR_AP | KURRF | DEC | 9 | 5 | Exchange rate for statistics (Exch.rate at time of creation) | ||
| 90 | |
UVPRS | XFELD | CHAR | 1 | 0 | Incomplete with respect to pricing | ||
| 91 | |
UVALL | XFELD | CHAR | 1 | 0 | Generally incomplete | ||
| 92 | |
EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
| 93 | |
PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
| 94 | |
KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | * | |
| 95 | |
KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | * | |
| 96 | |
KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | * | |
| 97 | |
KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | * | |
| 98 | |
KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | * | |
| 99 | |
MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | * | |
| 100 | |
MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | * | |
| 101 | |
MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | * | |
| 102 | |
MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | * | |
| 103 | |
MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | * | |
| 104 | |
MATWA | MATNR | CHAR | 18 | 0 | Material entered | * | |
| 105 | |
BONBA | WERTV7 | CURR | 13 | 2 | Rebate basis 1 | ||
| 106 | |
KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
| 107 | |
RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
| 108 | |
PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
| 109 | |
AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
| 110 | |
TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
| 111 | |
CMPRE | WERTV6 | CURR | 11 | 2 | Item credit price | ||
| 112 | |
CMPNT | XFELD | CHAR | 1 | 0 | ID: Item with active credit function / relevant for credit | ||
| 113 | |
CUOBJ_VA | CUOBJ | NUMC | 18 | 0 | Configuration | ||
| 114 | |
CUOBJ_CH | CUOBJ | NUMC | 18 | 0 | Internal object number of the batch classification | ||
| 115 | |
KOUPD | XFELD | CHAR | 1 | 0 | Condition update | ||
| 116 | |
UECHA | POSNR | NUMC | 6 | 0 | Higher-Level Item of Batch Split Item | * | |
| 117 | |
XCHAR | XFELD | CHAR | 1 | 0 | Batch management indicator (internal) | ||
| 118 | |
ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | * | |
| 119 | |
SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | * | |
| 120 | |
BZIRK_AUFT | BZIRK | CHAR | 6 | 0 | Sales district of sales order | * | |
| 121 | |
KDGRP_AUFT | KDGRP | CHAR | 2 | 0 | Customer group of sales order | * | |
| 122 | |
KONDA_AUFT | KONDA | CHAR | 2 | 0 | Price group of sales order | * | |
| 123 | |
LLAND_AUFT | LAND1 | CHAR | 3 | 0 | Country of destination of sales order | * | |
| 124 | |
INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
| 125 | |
MPROK | MPROK | CHAR | 1 | 0 | Status manual price change | ||
| 126 | |
PLTYP_AUFT | PLTYP | CHAR | 2 | 0 | Price list type of sales order | * | |
| 127 | |
REGIO_AUFT | REGIO | CHAR | 3 | 0 | Region of sales order | * | |
| 128 | |
VKORG_AUFT | VKORG | CHAR | 4 | 0 | Sales organization of sales order | * | |
| 129 | |
VTWEG_AUFT | VTWEG | CHAR | 2 | 0 | Distribution channel of sales order | * | |
| 130 | |
ABRBG | DATUM | DATS | 8 | 0 | Start of accounting settlement period | ||
| 131 | |
PROSA | PROSA | CHAR | 1 | 0 | ID for material selection - active | ||
| 132 | |
UEPVW | UEPVW | CHAR | 1 | 0 | ID for higher-level item usage | ||
| 133 | |
VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
| 134 | |
STADAT | DATUM | DATS | 8 | 0 | Statistics date | ||
| 135 | |
FPLNR | FPLNR | CHAR | 10 | 0 | Billing plan number / invoicing plan number | * | |
| 136 | |
FPLTR | FPLTR | NUMC | 6 | 0 | Item for billing plan/invoice plan/payment cards | * | |
| 137 | |
WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | * | |
| 138 | |
KNUMA_PI | KNUMA | CHAR | 10 | 0 | Promotion | * | |
| 139 | |
KNUMA_AG | KNUMA | CHAR | 10 | 0 | Sales deal | * | |
| 140 | |
PREFE | PREFE | CHAR | 1 | 0 | Preference indicator in export/import | ||
| 141 | |
MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
| 142 | |
AUGRU | AUGRU | CHAR | 3 | 0 | Order reason (reason for the business transaction) | * | |
| 143 | |
FAREG | FAREG | CHAR | 1 | 0 | Rule in billing plan/invoice plan | ||
| 144 | |
UPMAT | MATNR | CHAR | 18 | 0 | Pricing reference material of main item | * | |
| 145 | |
UKONM | KONDM | CHAR | 2 | 0 | Material pricing group of main item | * | |
| 146 | |
CMPRE_FLT | FLTP | FLTP | 16 | 16 | Item credit price | ||
| 147 | |
ABSFORM_CM | ABSFORM_CM | CHAR | 2 | 0 | Form of payment guarantee | ||
| 148 | |
ABGES_CM | FLTP | FLTP | 16 | 16 | Guaranteed (factor between 0 and 1) | ||
| 149 | |
J_1ARFZVAT | J_1ARFZVAT | CHAR | 1 | 0 | Reason for zero VAT | * | |
| 150 | |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
| 151 | |
J_1AGICD_D | J_1AGICD2 | CHAR | 2 | 0 | Activity Code for Gross Income Tax | * | |
| 152 | |
J_1ADTYP_D | J_1ADTYP | CHAR | 2 | 0 | Distribution Type for Employment Tax | * | |
| 153 | |
J_1ATXREL_ | J_1ATXREL | CHAR | 10 | 0 | Tax relevant classification | * | |
| 154 | |
CHAR | 10 | 0 | |||||
| 155 | |
J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | * | |
| 156 | |
J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | * | |
| 157 | |
J_1BTXSDC_ | J_1BTXSDC | CHAR | 2 | 0 | SD tax code | * | |
| 158 | |
BRTWR_FP | WERTV8 | CURR | 15 | 2 | Gross value of the billing item in document currency | ||
| 159 | |
WKTNR | VBELN | CHAR | 10 | 0 | Value contract no. | * | |
| 160 | |
WKTPS | POSNR | NUMC | 6 | 0 | Value contract item | * | |
| 161 | |
RPLNR_AU | FPLNR | CHAR | 10 | 0 | Payment card plan number of sales document | * | |
| 162 | |
WWERT_D | DATUM | DATS | 8 | 0 | Translation date | ||
| 163 | |
WGRU_HIE1 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 1 | ||
| 164 | |
WGRU_HIE2 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 2 | ||
| 165 | |
KDKG1 | KDKGR | CHAR | 2 | 0 | Customer condition group 1 | * | |
| 166 | |
KDKG2 | KDKGR | CHAR | 2 | 0 | Customer condition group 2 | * | |
| 167 | |
KDKG3 | KDKGR | CHAR | 2 | 0 | Customer condition group 3 | * | |
| 168 | |
KDKG4 | KDKGR | CHAR | 2 | 0 | Customer condition group 4 | * | |
| 169 | |
KDKG5 | KDKGR | CHAR | 2 | 0 | Customer condition group 5 | * | |
| 170 | |
ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | * | |
| 171 | |
J_1AINDXP | J_1AINDXP | CHAR | 5 | 0 | Inflation Index | * | |
| 172 | |
J_1AIDATES | J_1AUDATEP | DATS | 8 | 0 | Indexing base date | ||
| 173 | |
KZFME | KZFME | CHAR | 1 | 0 | ID: Leading unit of measure for completing a transaction | ||
| 174 | |
MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
| 175 | |
RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
| 176 | |
RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
| 177 | |
SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
| 178 | |
DELCO | DELCO | CHAR | 3 | 0 | Agreed delivery time | ||
| 179 | |
BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | * | |
| 180 | |
CHAR | 1 | 0 | |||||
| 181 | |
AKKUR | KURRF | DEC | 9 | 5 | Exchange rate for letter-of-credit procg in foreign trade | ||
| 182 | |
WMINR | WMINR | CHAR | 10 | 0 | Product catalog number | * | |
| 183 | |
VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | * | |
| 184 | |
VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | * | |
| 185 | |
LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
| 186 | |
CHAR | 3 | 0 | |||||
| 187 | |
AUART | AUART | CHAR | 4 | 0 | Sales Document Type | * | |
| 188 | |
PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | * |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |