BBP_TMP_ZA_ASP SAP (Temporary: Request 'Bidder', Contact Addresses) Table details

Dictionary Type: Table
Description: Temporary: Request 'Bidder', Contact Addresses




ABAP Code to SELECT data from BBP_TMP_ZA_ASP
Related tables to BBP_TMP_ZA_ASP
Access table BBP_TMP_ZA_ASP




Table field list including key, data, relationships and ABAP select examples

BBP_TMP_ZA_ASP is a standard SAP Table which is used to store Temporary: Request 'Bidder', Contact Addresses data and is available within R/3 SAP systems depending on the version and release level.

The BBP_TMP_ZA_ASP table consists of various fields, each holding specific information or linking keys about Temporary: Request 'Bidder', Contact Addresses data available in SAP. These include GUID (UUID in character form), ASP_ITEM_GUID (UUID in X form (binary)), STANDARDADDRESS (Indicator: Address is standard address), C_O_NAME (c/o name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP BBP_TMP_ZA_ASP table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
ASP_ITEM_GUIDUUID in X form (binary) SYSUUID_XRAW16SYSUUID
STANDARDADDRESSIndicator: Address is standard address BU_XDFADRCHAR1XFELD
C_O_NAMEc/o name AD_NAME_COCHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
DISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8ADRREGGRPREGIOGROUP
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
POSTL_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POSTL_COD3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_W_O_NOFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_CITPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3T005SREGIO
POBOX_CTRYPO box country AD_POBXCTYCHAR3T005LAND1
PO_CTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STR_ABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2ADRSTRTYPESTRTYPEAB
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
HOUSE_NO2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NO3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
COUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
TIME_ZONEAddress time zone AD_TZONECHAR6TTZZTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
LANGUISO2-Character SAP Language Code LAISOCHAR2LAISO
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3Assigned to domainAD_COMM
EXTADDRESSNUMBERAddress number in external system BU_ADEXTCHAR20BU_ADEXT
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4Assigned to domainAD_NO_USE
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4Assigned to domainAD_NO_USE
MOVE_DATEDate of Move BU_MOVEDATDATS8DATUM
MOVE_ADDRESSNumber of Move Target Address for Address Moves BU_MOVE_ADDRCHAR10Assigned to domainALPHAAD_ADDRNUMADR
VALIDFROMDATEValidity Date (Valid From) BU_DATFROMDATS8DATUM
VALIDTODATEValidity Date (Valid To) BU_DATTODATS8DATUM
MOVE_ADDR_GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
CITY_NOCity code for city/street file AD_CITYNUMCHAR12Assigned to domainALPHACITY_CODE
DISTRCT_NODistrict code for City and Street file AD_CITYPNMCHAR8Assigned to domainALPHACITYP_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
PBOXCIT_NOCity PO box code (City file) AD_CIT2NUMCHAR12Assigned to domainALPHACITY_CODE
STREET_NOStreet Number for City/Street File AD_STRNUMCHAR12Assigned to domainALPHASTRT_CODE
HOMECITYNODifferent city for city/street file AD_CITYHNMCHAR12Assigned to domainALPHACITY_CODE
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
COUNTY_NOCounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
TOWNSHIP_NOTownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
FUNCTIONNAMEFunction name of partner BU_FNCTNCHAR40TEXT40
FUNCTIONFunction of partner BU_PAFKTCHAR4TB912BU_PAFKT
DEPARTMENTNAMEDepartment at business partner BU_DPRTMNTCHAR40TEXT40
DEPARTMENTDepartment BU_ABTNRCHAR4TB910BU_ABTNR
AUTHORITYPartner's Authority BU_PAAUTHCHAR1TB914BU_PAAUTH
VIPVIP Partner BU_PAVIPCHAR1TB916BU_PAVIP
COMMENTSNotes for Partner BU_PAREMCHAR40TEXT40
TEL1_NUMBRFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL1_EXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
INHOUSE_MLInt. mail postal code AD_IH_MAILCHAR10TEXT10
ASP_BUILDINGBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
ASP_FLOORFloor in building AD_FLOORCHAR10TEXT10
ASP_ROOMRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10

Key field Non-key field



How do I retrieve data from SAP table BBP_TMP_ZA_ASP using ABAP code

The following ABAP code Example will allow you to do a basic selection on BBP_TMP_ZA_ASP to SELECT all data from the table
DATA: WA_BBP_TMP_ZA_ASP TYPE BBP_TMP_ZA_ASP.

SELECT SINGLE *
FROM BBP_TMP_ZA_ASP
INTO CORRESPONDING FIELDS OF WA_BBP_TMP_ZA_ASP
WHERE...

How to access SAP table BBP_TMP_ZA_ASP

Within an ECC or HANA version of SAP you can also view further information about BBP_TMP_ZA_ASP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!