SAP ABAP Table /SAPSLL/V_PNTBPA (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | /SAPSLL/V_PNTBPA | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | GRVSY | /SAPSLL/GRVSY | /SAPSLL/GRVSY | CHAR | 10 | 0 | Logical System Group | /SAPSLL/TCOGVS | |
3 | BPTYP | /SAPSLL/BPTYP | /SAPSLL/BPTYP | CHAR | 2 | 0 | Business Partner Category in Feeder System | ||
4 | BPVSY | /SAPSLL/BPVSY | /SAPSLL/OBJEX | CHAR | 40 | 0 | External Business Partner Number | ||
5 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
6 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | ||
7 | GUID_PRTN | /SAPSLL/PRTN_GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key of Business Partner | ||
8 | DATAB | /SAPSLL/RPTST | /SAPSLL/TSTMP | DEC | 15 | 0 | Definitive Date (Valid-From Time) | ||
9 | DATBI | /SAPSLL/RPTET | /SAPSLL/TSTMP | DEC | 15 | 0 | Definitive Date (Valid-To Date) | ||
10 | TYPE | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
11 | BPKIND | BU_BPKIND | BU_KIND | CHAR | 4 | 0 | Business Partner Type | TB004 | |
12 | BU_GROUP | BU_GROUP | BU_GROUP | CHAR | 4 | 0 | Business Partner Grouping | TB001 | |
13 | BPEXT | BU_BPEXT | CHAR20 | CHAR | 20 | 0 | Business Partner Number in External System | ||
14 | BU_SORT1 | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
15 | BU_SORT2 | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
16 | NAME_ORG1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
17 | NAME_ORG2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
18 | NAME_ORG3 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
19 | NAME_ORG4 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
20 | NAME_LAST | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
21 | NAME_FIRST | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
22 | NAME_LST2 | BU_NAMEPL2 | BU_NAME | CHAR | 40 | 0 | Other Last Name of a Person | ||
23 | NAME_LAST2 | BU_BIRTHNM | BU_NAME | CHAR | 40 | 0 | Name at birth of business partner | ||
24 | NAME_GRP1 | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
25 | NAME_GRP2 | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
26 | MC_NAME1 | BU_MCNAME1 | CHAR35 | CHAR | 35 | 0 | Search Help Field 1 (Name 1/Last Name) | ||
27 | MC_NAME2 | BU_MCNAME2 | CHAR35 | CHAR | 35 | 0 | Search Help Field 2 (Name 2/First Name) | ||
28 | PARTNER_GUID | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /SAPSLL/V_PNTBPA | BPKIND | TB004 | BPKIND | KEY | 1 | CN |
2 | /SAPSLL/V_PNTBPA | BU_GROUP | TB001 | BU_GROUP | REF | 1 | CN |
3 | /SAPSLL/V_PNTBPA | CLIENT | T000 | MANDT | KEY | 1 | CN |
4 | /SAPSLL/V_PNTBPA | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | DDIC | 20141106 |
SAP Release Created in |