SAP ABAP Table OIFPBL (Index to point at Business Location)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIF (Package) MRN Marketing Retail Networks
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIF (Package) MRN Marketing Retail Networks
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIFPBL | Table Relationship Diagram |
Short Description | Index to point at Business Location |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | PBLNR | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | OIFSPBL | |
3 | KUNDE | KUNDE_D | KUNDE | CHAR | 10 | 0 | Partner number (KUNNR, LIFNR, or PERNR) | ||
4 | PARVW | PARVW | PARVW | CHAR | 2 | 0 | Partner Role | TPAR | |
5 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
6 | TRVOG | TRVOG | TRVOG | CHAR | 1 | 0 | Transaction group | ||
7 | AUDAT | AUDAT | DATUM | DATS | 8 | 0 | Document Date (Date Received/Sent) | ||
8 | DATAB | DATAB_VI | DATUM | DATS | 8 | 0 | Quotation or contract valid from | ||
9 | DATBI | DATBI_VI | DATUM | DATS | 8 | 0 | Quotation or contract valid to | ||
10 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
11 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
12 | AUART | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | TVAK | |
13 | KUNNR | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
14 | ERNAM | OIF_ERNAM | USNAM | CHAR | 12 | 0 | User who Created Record | ||
15 | VBELN | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | VBUK | |
16 | POSNR | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | VBUP |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIFPBL | AUART | TVAK | AUART | KEY | 1 | CN |
2 | OIFPBL | KUNNR | KNA1 | KUNNR | KEY | 1 | CN |
3 | OIFPBL | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | OIFPBL | PARVW | TPAR | PARVW | 1 | CN | |
5 | OIFPBL | PBLNR | OIFSPBL | PBLNR | KEY | 1 | CN |
6 | OIFPBL | POSNR | VBUP | POSNR | KEY | 1 | CN |
7 | OIFPBL | SPART | TSPA | SPART | KEY | 1 | CN |
8 | OIFPBL | VBELN | VBUK | VBELN | KEY | 1 | CN |
9 | OIFPBL | VKORG | TVKO | VKORG | KEY | 1 | CN |
10 | OIFPBL | VTWEG | TVTW | VTWEG | KEY | 1 | CN |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in |