SAP Table MCVBPAB
Reference Structure from MCVBPA for Function Module
MCVBPAB (Reference Structure from MCVBPA for Function Module) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MCVBPAB to other SAP tables.
MCVBPAB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SUPKZ | Statistics update indicator (post in/post out) | SUPKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
| VBELN | Sales and Distribution Document Number | VBELN | VBUK | CHAR | 10 | 0 | ||||||||||||||||||
| POSNR | Item number of the SD document | POSNR | VBUP | NUMC | 6 | 0 | ||||||||||||||||||
| PARVW | Partner Function | PARVW | TPAR | CHAR | 2 | 0 | ||||||||||||||||||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||||||||||||||||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||||||||||||||
| PARNR | Number of contact person | PARNR | NUMC | 10 | 0 | |||||||||||||||||||
| ADRNR | Address | ADRNR | CHAR | 10 | 0 | |||||||||||||||||||
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||||||||||||||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||||||||||||
| ADRDA | Address indicator | ADRDA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| HITYP | Customer hierarchy type | HITYP_KH | THIT | CHAR | 1 | 0 | ||||||||||||||||||
| PRFRE | Relevant for price determination ID | PRFRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| BOKRE | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| HISTUNR | Level number within hierarchy | HISTUNR | NUMC | 2 | 0 | |||||||||||||||||||
| KNREF | Customer description of partner (plant, storage location) | KNREF | CHAR | 30 | 0 | |||||||||||||||||||
| LZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | 0 | |||||||||||||||||||
| HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 | 0 | |||||||||||||||||||
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | 0 | |||||||||||||||||||
| PARVW_FF | Indicator 'further partners in this function' (VBPA2) | PARTNER_FF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| ADRNP | Person number | AD_PERSNUM | ADRP | CHAR | 10 | 0 | ||||||||||||||||||
| KALE | Maintain appointments in calendar | KALE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| OIPBL | Business location identifier (IS-Oil MRN) | OIF_PBLNRP | OIFSPBL | CHAR | 10 | 0 | ||||||||||||||||||
| DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 | |||||||||||||||||||
MCVBPAB foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MCVBPAB | ADRNP | MCVBPAB | MANDT | ADRP | Persons (Business Address Services) | CLIENT |
| MCVBPAB | ADRNP | MCVBPAB | ADRNP | ADRP | Persons (Business Address Services) | PERSNUMBER |
| MCVBPAB | ADRNP | * | ADRP | Persons (Business Address Services) | DATE_FROM | |
| MCVBPAB | ADRNP | * | ADRP | Persons (Business Address Services) | NATION | |
| MCVBPAB | HITYP | MCVBPAB | MANDT | THIT | Customer Hierarchy Types | MANDT |
| MCVBPAB | HITYP | MCVBPAB | HITYP | THIT | Customer Hierarchy Types | HITYP |
| MCVBPAB | KUNNR | MCVBPAB | MANDT | KNA1 | General Data in Customer Master | MANDT |
| MCVBPAB | KUNNR | MCVBPAB | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| MCVBPAB | LAND1 | MCVBPAB | MANDT | T005 | Countries | MANDT |
| MCVBPAB | LAND1 | MCVBPAB | LAND1 | T005 | Countries | LAND1 |
| MCVBPAB | LIFNR | MCVBPAB | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| MCVBPAB | LIFNR | MCVBPAB | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| MCVBPAB | MANDT | MCVBPAB | MANDT | T000 | Clients | MANDT |
| MCVBPAB | OIPBL | MCVBPAB | MANDT | OIFSPBL | Physical Location - Master Data | MANDT |
| MCVBPAB | OIPBL | MCVBPAB | OIPBL | OIFSPBL | Physical Location - Master Data | PBLNR |
| MCVBPAB | PARVW | MCVBPAB | MANDT | TPAR | Business Partner: Functions | MANDT |
| MCVBPAB | PARVW | MCVBPAB | PARVW | TPAR | Business Partner: Functions | PARVW |
| MCVBPAB | POSNR | MCVBPAB | VBELN | VBUP | Sales Document: Item Status | VBELN |
| MCVBPAB | POSNR | MCVBPAB | POSNR | VBUP | Sales Document: Item Status | POSNR |
| MCVBPAB | POSNR | MCVBPAB | MANDT | VBUP | Sales Document: Item Status | MANDT |
| MCVBPAB | VBELN | MCVBPAB | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| MCVBPAB | VBELN | MCVBPAB | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
