ESO_S_ERP_VBRP SAP (ERP Billing Item attributes for Enterprise Search) Structure details
Description: ERP Billing Item attributes for Enterprise Search
Related tables to ESO_S_ERP_VBRP
Access table ESO_S_ERP_VBRP
Structure field list including key, data, relationships and ABAP select examples
ESO_S_ERP_VBRP 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 "ERP Billing Item attributes for Enterprise Search" 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_ESO_S_ERP_VBRP TYPE ESO_S_ERP_VBRP.
The ESO_S_ERP_VBRP table consists of various fields, each holding specific information or linking keys about ERP Billing Item attributes for Enterprise Search data available in SAP. These include POSNR (Billing item), FKIMG (Actual Invoiced Quantity), VRKME (Sales unit), MEINS (Base Unit of Measure).. 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 (character-type or numeric)
SAP ESO_S_ERP_VBRP 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 |
VBELN | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
POSNR | Billing item | POSNR_VF | NUMC | 6 | Assigned to domain | POSNR | |||
FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VOLUM | Volume | VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
NETWR | Net value of the billing item in document currency | NETWR_FP | CURR | 15(2) | WERTV8 | ||||
VBELV | Originating document | VBELV | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
POSNV | Originating item | POSNV | NUMC | 6 | Assigned to domain | POSNR | |||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | Assigned to domain | POSNR | |||
AUBEL | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
AUPOS | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
PMATN | Pricing Reference Material | PMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
PSTYV | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV | |||
PRODH | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | Assigned to domain | VSTEL | VST | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ALAND | Departure country (country from which the goods are sent) | ALAND | CHAR | 3 | Assigned to domain | LAND1 | VAL | ||
WKREG | Region in which plant is located | WKREG | CHAR | 3 | Assigned to domain | REGIO | |||
WKCOU | County in which plant is located | WKCOU | CHAR | 3 | CHAR3 | ||||
WKCTY | City in which plant is located | WKCTY | CHAR | 4 | CHAR4 | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | Assigned to domain | KVGR1 | |||
KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | Assigned to domain | KVGR2 | |||
KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | Assigned to domain | KVGR3 | |||
KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | Assigned to domain | KVGR4 | |||
KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | Assigned to domain | KVGR5 | |||
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 | |||
MATWA | Material entered | MATWA | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | Assigned to domain | ABRVW | |||
SERNR | BOM explosion number | SERNR | CHAR | 8 | Assigned to domain | SERNR | |||
BZIRK_AUFT | Sales district of sales order | BZIRK_AUFT | CHAR | 6 | Assigned to domain | BZIRK | |||
LLAND_AUFT | Country of destination of sales order | LLAND_AUFT | CHAR | 3 | Assigned to domain | LAND1 | VLL | ||
REGIO_AUFT | Region of sales order | REGIO_AUFT | CHAR | 3 | Assigned to domain | REGIO | |||
VKORG_AUFT | Sales organization of sales order | VKORG_AUFT | CHAR | 4 | Assigned to domain | VKORG | VKO | ||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | Assigned to domain | FPLNR | |||
AKTNR | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
KNUMA_PI | Promotion | KNUMA_PI | CHAR | 10 | Assigned to domain | ALPHA | KNUMA | VPI | VMBO |
KNUMA_AG | Sales deal | KNUMA_AG | CHAR | 10 | Assigned to domain | ALPHA | KNUMA | VK1 | VMBO |
AUGRU_AUFT | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | Assigned to domain | AUGRU | |||
UPMAT | Pricing reference material of main item | UPMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
J_1AREGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
J_1ATXREL | Tax relevant classification | J_1ATXREL_ | CHAR | 10 | Assigned to domain | J_1ATXREL | |||
J_1BCFOP | CFOP Code and Extension | J_1BCFOP | CHAR | 10 | Assigned to domain | CFOBR | J_1BCFOP | ||
J_1BTAXLW1 | Tax law: ICMS | J_1BTAXLW1 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW1 | ||
J_1BTAXLW2 | Tax law: IPI | J_1BTAXLW2 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW2 | ||
WKTNR | Value contract no. | WKTNR | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
RPLNR | Payment card plan number of sales document | RPLNR_AU | CHAR | 10 | Assigned to domain | FPLNR | |||
WGRU1 | Material group hierarchy 1 | WGRU_HIE1 | CHAR | 18 | KLASSE | ||||
WGRU2 | Material group hierarchy 2 | WGRU_HIE2 | CHAR | 18 | KLASSE | ||||
VKAUS | Usage Indicator | ABRVW | CHAR | 3 | Assigned to domain | ABRVW | |||
J_1AINDXP | Inflation Index | J_1AINDXP | CHAR | 5 | Assigned to domain | J_1AINDXP | |||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
DELCO | Agreed delivery time | DELCO | CHAR | 3 | DELCO | ||||
WMINR | Product catalog number | WMINR | CHAR | 10 | Assigned to domain | WMINR | WMI | WPC1 | |
VGBEL_EX | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
VGTYP_EX | Category of an external transaction or element | VGTYP_EX | CHAR | 3 | VORG_TYP | ||||
J_1BTAXLW3 | ISS Tax Law | J_1BTAXLW3 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW3 | ||
J_1BTAXLW4 | COFINS Tax Law | J_1BTAXLW4 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW4 | ||
J_1BTAXLW5 | PIS Tax Law | J_1BTAXLW5 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW5 | ||
MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 10 | ALPHA | MSR_PROCESS_ID | |||
MSR_REFUND_CODE | Returns Refund Code | MSR_RETURNS_REFUND_CODE | CHAR | 3 | MSR_RETURNS_REFUND_CODE | ||||
MSR_RET_REASON | Return Reason | MSR_RETURNS_REASON | CHAR | 3 | Assigned to domain | MSR_RETURNS_REASON |
Key field | Non-key field |
How do I retrieve data from SAP structure ESO_S_ERP_VBRP using ABAP code?
As ESO_S_ERP_VBRP 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 ESO_S_ERP_VBRP as there is no data to select.How to access SAP table ESO_S_ERP_VBRP
Within an ECC or HANA version of SAP you can also view further information about ESO_S_ERP_VBRP 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