SAP ABAP View /SAPSLL/V_PNTBPA (Customs Business Partner + Number in Feeder System)
Hierarchy
☛
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
⤷ SLL (Application Component) Global Trade Services
⤷ /SAPSLL/CORE_PARTNER (Package) Legal & Logistics Services: Basic Functions - Partners
⤷ SLL (Application Component) Global Trade Services
⤷ /SAPSLL/CORE_PARTNER (Package) Legal & Logistics Services: Basic Functions - Partners
Basic Data
View Type | D | Database View |
Database View | /SAPSLL/V_PNTBPA | |
Short Description | Customs Business Partner + Number in Feeder System | |
Root table | /SAPSLL/PNTBP | Legal and Logistics Services: Mapping of Business Partners |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | /SAPSLL/PNTBP | /SAPSLL/PNTBP | ||
2 | BUT000 |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | BUT000 | CLIENT | JL | EQ | 0 | 0 | ||||
2 | /SAPSLL/PNTBP | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | BUT000 | PARTNER | JL | EQ | 0 | 0 | ||||
4 | /SAPSLL/PNTBP | PARTNER | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | /SAPSLL/PNTBP | MANDT | MANDT | Client | |||
2 | GRVSY | /SAPSLL/PNTBP | GRVSY | /SAPSLL/GRVSY | Logical System Group | |||
3 | BPTYP | /SAPSLL/PNTBP | BPTYP | /SAPSLL/BPTYP | Business Partner Category in Feeder System | |||
4 | BPVSY | /SAPSLL/PNTBP | BPVSY | /SAPSLL/BPVSY | External Business Partner Number | |||
5 | CLIENT | BUT000 | CLIENT | MANDT | Client | |||
6 | PARTNER | BUT000 | PARTNER | BU_PARTNER | Business Partner Number | |||
7 | GUID_PRTN | /SAPSLL/PNTBP | GUID_PRTN | /SAPSLL/PRTN_GUID_16 | Primary Key of Business Partner | |||
8 | DATAB | /SAPSLL/PNTBP | DATAB | /SAPSLL/RPTST | Definitive Date (Valid-From Time) | |||
9 | DATBI | /SAPSLL/PNTBP | DATBI | /SAPSLL/RPTET | Definitive Date (Valid-To Date) | |||
10 | TYPE | BUT000 | TYPE | BU_TYPE | Business partner category | |||
11 | BPKIND | BUT000 | BPKIND | BU_BPKIND | Business Partner Type | |||
12 | BU_GROUP | BUT000 | BU_GROUP | BU_GROUP | Business Partner Grouping | |||
13 | BPEXT | BUT000 | BPEXT | BU_BPEXT | Business Partner Number in External System | |||
14 | BU_SORT1 | BUT000 | BU_SORT1 | BU_SORT1 | Search term 1 for business partner | |||
15 | BU_SORT2 | BUT000 | BU_SORT2 | BU_SORT2 | Search term 2 for business partner | |||
16 | NAME_ORG1 | BUT000 | NAME_ORG1 | BU_NAMEOR1 | Name 1 of organization | |||
17 | NAME_ORG2 | BUT000 | NAME_ORG2 | BU_NAMEOR2 | Name 2 of organization | |||
18 | NAME_ORG3 | BUT000 | NAME_ORG3 | BU_NAMEOR3 | Name 3 of organization | |||
19 | NAME_ORG4 | BUT000 | NAME_ORG4 | BU_NAMEOR4 | Name 4 of organization | |||
20 | NAME_LAST | BUT000 | NAME_LAST | BU_NAMEP_L | Last name of business partner (person) | |||
21 | NAME_FIRST | BUT000 | NAME_FIRST | BU_NAMEP_F | First name of business partner (person) | |||
22 | NAME_LST2 | BUT000 | NAME_LST2 | BU_NAMEPL2 | Other Last Name of a Person | |||
23 | NAME_LAST2 | BUT000 | NAME_LAST2 | BU_BIRTHNM | Name at birth of business partner | |||
24 | NAME_GRP1 | BUT000 | NAME_GRP1 | BU_NAMEGR1 | Name 1 (group) | |||
25 | NAME_GRP2 | BUT000 | NAME_GRP2 | BU_NAMEGR2 | Name 2 (group) | |||
26 | MC_NAME1 | BUT000 | MC_NAME1 | BU_MCNAME1 | Search Help Field 1 (Name 1/Last Name) | |||
27 | MC_NAME2 | BUT000 | MC_NAME2 | BU_MCNAME2 | Search Help Field 2 (Name 2/First Name) | |||
28 | PARTNER_GUID | BUT000 | PARTNER_GUID | BU_PARTNER_GUID | Business Partner GUID | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in | 700 |