SAP ABAP Table /SAPSLL/V_BLBP (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /SAPSLL/V_BLBP   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 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number BUT000
3 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
4 ERNAM /SAPSLL/ERNAM XUBNAME CHAR 12   0   Name of User Who Created the Object USR02
5 CRTSP /SAPSLL/CRTSP /SAPSLL/TMELS DEC 15   0   Date and Time When Object Was Added  
6 AENAM /SAPSLL/AENAM XUBNAME CHAR 12   0   Name of User Who Changed the Object USR02
7 CHTSP /SAPSLL/CHTSP /SAPSLL/TMELS DEC 15   0   Date and Time When Object Was Changed  
8 ADRNR /SAPSLL/ADRNR AD_ADDRNUM CHAR 10   0   Address Number of Entry in Address File ADRC
9 LGREG /SAPSLL/LGREG /SAPSLL/LGREG CHAR 5   0   Legal Regulation /SAPSLL/T606G
10 DATBI /SAPSLL/RPTET /SAPSLL/TSTMP DEC 15   0   Definitive Date (Valid-To Date)  
11 DATAB /SAPSLL/RPTST /SAPSLL/TSTMP DEC 15   0   Definitive Date (Valid-From Time)  
12 PIDEX /SAPSLL/PIDEX /SAPSLL/OBJEX CHAR 40   0   External Identification of Customs Business Partner  
13 SPL_CHK_DATE /SAPSLL/SPLCT /SAPSLL/TSTMP DEC 15   0   Date of Sanctioned Party List Screening  
14 SPL_CHK_POSITIVE /SAPSLL/SPLCO XFELD CHAR 1   0   Indicator: Address Appears in Sanction List  
15 SPLPN /SAPSLL/SPLPN /SAPSLL/SPLPN CHAR 1   0   Flagged on Positive/Negative List  
16 SPLIB /SAPSLL/SPLIB /SAPSLL/SPLIB CHAR 2   0   Indicator for "Indirectly Locked"  
17 GUID_ADRCON /SAPSLL/GUID_16 SYSUUID RAW 16   0   Primary Key as GUID in 'RAW' Format  
18 MCUSE /SAPSLL/MCUSE /SAPSLL/MCUSE CHAR 1   0   Military / Civilian Usage Indicator  
19 BPCCB /SAPSLL/BPCCB XFELD CHAR 1   0   Indicator for Chemical/Biological Warfare  
20 BPCNT /SAPSLL/BPCNT XFELD CHAR 1   0   Nuclear Nonproliferation Indicator  
21 BPCMT /SAPSLL/BPCMT XFELD CHAR 1   0   Indicator for Missile Technology  
22 BPCNS /SAPSLL/BPCNS XFELD CHAR 1   0   Indicator for National Security  
23 BPCDR /SAPSLL/BPCDR XFELD CHAR 1   0   Indicator for Drug Products  
24 CRECO /SAPSLL/CRECO /SAPSLL/CRECO CHAR 2   0   Method of Entry  
25 MOBJT /SAPSLL/MOBJT /SAPSLL/MOBJT CHAR 1   0   Type of Main Object  
26 GUID_MOBJ /SAPSLL/MOBJ_GUID_16 SYSUUID RAW 16   0   Primary Key of Main Object  
27 POBJT /SAPSLL/POBJT /SAPSLL/POBJT CHAR 2   0   Type of Preceding Object  
28 GUID_POBJ /SAPSLL/POBJ_GUID_16 SYSUUID RAW 16   0   Primary Key of Preceding Object  
29 PARTNER_GUID BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
30 CRUSR BU_CRUSR USNAM CHAR 12   0   User who created the object  
31 CRDAT BU_CRDAT DATUM DATS 8   0   Date on which the object was created  
32 CHUSR BU_CHUSR USNAM CHAR 12   0   Last user to change object  
33 CHDAT BU_CHDAT DATUM DATS 8   0   Date when object was last changed  
34 XDFADR BU_XDFADR XFELD CHAR 1   0   Indicator: Address is standard address  
35 ADEXT BU_ADEXT BU_ADEXT CHAR 20   0   Address number in external system  
36 GUID SYSUUID_C SYSUUID_C CHAR 32   0   UUID in character form  
37 ADDRESS_GUID BU_ADDRESS_GUID SYSUUID RAW 16   0   GUID of a Business Partner Address  
38 GRVSY /SAPSLL/GRVSY /SAPSLL/GRVSY CHAR 10   0   Logical System Group /SAPSLL/TCOGVS
39 BPTYP /SAPSLL/BPTYP /SAPSLL/BPTYP CHAR 2   0   Business Partner Category in Feeder System  
40 BPVSY /SAPSLL/BPVSY /SAPSLL/OBJEX CHAR 40   0   External Business Partner Number  
41 GUID_PRTN /SAPSLL/PRTN_GUID_16 SYSUUID RAW 16   0   Primary Key of Business Partner  
42 GUID_BPVSY /SAPSLL/GUID_16 SYSUUID RAW 16   0   Primary Key as GUID in 'RAW' Format  
43 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses TSADV
44 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
45 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
46 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
47 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
48 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
49 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
50 NAME_TEXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
51 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
52 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
53 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
54 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
55 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
56 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
57 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
58 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
59 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
60 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
61 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
62 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
63 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
64 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
65 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
66 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
67 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
68 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
69 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
70 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
71 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
72 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
73 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
74 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
75 STREET AD_STREET TEXT60 CHAR 60   0   Street  
76 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
77 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
78 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
79 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
80 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
81 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
82 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
83 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
84 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
85 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
86 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
87 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
88 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
89 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
90 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
91 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
92 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services) TSAD7
93 FLAGGROUPS AD_FLGGP XFELD CHAR 1   0   Flag: There are more address group assignments  
94 PERS_ADDR AD_PRSADDR XFELD CHAR 1   0   Flag: This is a personal address  
95 SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
96 SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
97 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
98 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) TSAC
99 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
100 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
101 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
102 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
103 FLAGCOMM2 AD_FLGCM02 XFELD CHAR 1   0   Flag: Telephone number(s) maintained  
104 FLAGCOMM3 AD_FLGCM03 XFELD CHAR 1   0   Flag: Fax number(s) maintained  
105 FLAGCOMM4 AD_FLGCM04 XFELD CHAR 1   0   Flag: Teletex number(s) maintained  
106 FLAGCOMM5 AD_FLGCM05 XFELD CHAR 1   0   Flag: Telex number(s) maintained  
107 FLAGCOMM6 AD_FLGCM06 XFELD CHAR 1   0   Indicator: E-Mail Address(es) Maintained  
108 FLAGCOMM7 AD_FLGCM07 XFELD CHAR 1   0   Flag: RML (remote mail) addresse(s) maintained  
109 FLAGCOMM8 AD_FLGCM08 XFELD CHAR 1   0   Flag: X.400 addresse(s) maintained  
110 FLAGCOMM9 AD_FLGCM09 XFELD CHAR 1   0   Flag: RFC destination(s) maintained  
111 FLAGCOMM10 AD_FLGCM10 XFELD CHAR 1   0   Flag: Printer maintained  
112 FLAGCOMM11 AD_FLGCM11 XFELD CHAR 1   0   Flag: SSF maintained  
113 FLAGCOMM12 AD_FLGCM12 XFELD CHAR 1   0   Flag: URI/FTP address maintained  
114 FLAGCOMM13 AD_FLGCM13 XFELD CHAR 1   0   Flag: Pager address maintained  
115 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
116 MC_NAME1 AD_MC_NAME CHAR25 CHAR 25   0   Name (field NAME1) in upper case for matchcode  
117 MC_CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
118 MC_STREET AD_MC_STRT CHAR25 CHAR 25   0   Street name in upper case for search help  
119 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
120 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
121 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
122 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
123 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
124 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language  
125 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPSLL/V_BLBP ADDRNUMBER ADRC ADDRNUMBER KEY 1 C
2 /SAPSLL/V_BLBP ADDRORIGIN TSAD6 ORIGIN REF C CN
3 /SAPSLL/V_BLBP ADDR_GROUP TSAD7 ADDR_GROUP REF C CN
4 /SAPSLL/V_BLBP ADRNR ADRC ADDRNUMBER KEY 1 CN
5 /SAPSLL/V_BLBP AENAM USR02 BNAME KEY 1 CN
6 /SAPSLL/V_BLBP CITYH_CODE ADRCITY CITY_CODE REF C CN
7 /SAPSLL/V_BLBP CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
8 /SAPSLL/V_BLBP CITY_CODE ADRCITY CITY_CODE REF C CN
9 /SAPSLL/V_BLBP CITY_CODE2 ADRCITY CITY_CODE REF C CN
10 /SAPSLL/V_BLBP COUNTRY T005 LAND1 REF 1 CN
11 /SAPSLL/V_BLBP DEFLT_COMM TSAC COMM_TYPE REF C CN
12 /SAPSLL/V_BLBP DONT_USE_P TSAD12 UNDELIVER REF C CN
13 /SAPSLL/V_BLBP DONT_USE_S TSAD12 UNDELIVER REF C CN
14 /SAPSLL/V_BLBP ERNAM USR02 BNAME KEY 1 CN
15 /SAPSLL/V_BLBP LANGU T002 SPRAS REF C CN
16 /SAPSLL/V_BLBP LGREG /SAPSLL/T606G MANDT KEY 1 CN
17 /SAPSLL/V_BLBP MANDT T000 MANDT KEY 1 CN
18 /SAPSLL/V_BLBP NATION TSADV NATION KEY 1 CN
19 /SAPSLL/V_BLBP PARTNER BUT000 PARTNER KEY 1 CN
20 /SAPSLL/V_BLBP PO_BOX_CTY T005 LAND1 REF C CN
21 /SAPSLL/V_BLBP PO_BOX_REG T005S BLAND REF C CN
22 /SAPSLL/V_BLBP REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
23 /SAPSLL/V_BLBP REGION T005S BLAND REF C CN
24 /SAPSLL/V_BLBP STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
25 /SAPSLL/V_BLBP STREETCODE ADRSTREET STRT_CODE REF C CN
26 /SAPSLL/V_BLBP TIME_ZONE TTZZ TZONE REF C CN
27 /SAPSLL/V_BLBP TITLE TSAD3 TITLE REF C CN
28 /SAPSLL/V_BLBP TRANSPZONE TZONE ZONE1 REF C CN
History
Last changed by/on DDIC  20141106 
SAP Release Created in