SAP BBP_TMP_ZA_ORG Temporary: Request 'Bidder', Company Address Table data and field list

BBP_TMP_ZA_ORG is a standard SAP Table which is used to store Temporary: Request 'Bidder', Company Address data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The BBP_TMP_ZA_ORG table consists of various fields, each holding specific information or linking keys about Temporary: Request 'Bidder', Company Address data available in SAP. These include GUID (UUID in character form), ADR_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. .

BBP_TMP_ZA_ORG table Technical Details:

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_ORG table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BBP_TMP_ZA_ORG table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
GUID	UUID in character form	SYSUUID_C	CHAR	32			SYSUUID_C
ADR_ITEM_GUID	UUID in X form (binary)	SYSUUID_X	RAW	16			SYSUUID
STANDARDADDRESS	Indicator: Address is standard address	BU_XDFADR	CHAR	1			XFELD
C_O_NAME	c/o name	AD_NAME_CO	CHAR	40			TEXT40
CITY	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
DISTRICT	District	AD_CITY2	CHAR	40			TEXT40		CITY_PART
REGIOGROUP	Regional structure grouping	REGIOGROUP	CHAR	8	ADRREGGRP		REGIOGROUP
POSTL_COD1	City postal code	AD_PSTCD1	CHAR	10			CHAR10
POSTL_COD2	PO Box Postal Code	AD_PSTCD2	CHAR	10			CHAR10
POSTL_COD3	Company Postal Code (for Large Customers)	AD_PSTCD3	CHAR	10			CHAR10
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code	AD_PST1XT	CHAR	10			CHAR10
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension	AD_PST2XT	CHAR	10			CHAR10
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension	AD_PST3XT	CHAR	10			CHAR10
PO_BOX	PO Box	AD_POBX	CHAR	10			CHAR10
PO_W_O_NO	Flag: PO Box Without Number	AD_POBXNUM	CHAR	1			XFELD
PO_BOX_CIT	PO Box city	AD_POBXLOC	CHAR	40			TEXT40		CITY_NAME
PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	AD_POBXREG	CHAR	3	T005S		REGIO
POBOX_CTRY	PO box country	AD_POBXCTY	CHAR	3	T005		LAND1
PO_CTRYISO	Country ISO code	INTCA	CHAR	2			INTCA		F4_INTCA
STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
STR_ABBR	(Not Supported) Abbreviation of Street Name	AD_STRABBR	CHAR	2	ADRSTRTYPE		STRTYPEAB
HOUSE_NO	House Number	AD_HSNM1	CHAR	10			TEXT10
HOUSE_NO2	House number supplement	AD_HSNM2	CHAR	10			TEXT10
HOUSE_NO3	(Not supported) House Number Range	AD_HSNM3	CHAR	10			TEXT10
STR_SUPPL1	Street 2	AD_STRSPP1	CHAR	40			TEXT40
STR_SUPPL2	Street 3	AD_STRSPP2	CHAR	40			TEXT40
STR_SUPPL3	Street 4	AD_STRSPP3	CHAR	40			TEXT40
LOCATION	Street 5	AD_LCTN	CHAR	40			TEXT40
BUILDING	Building (Number or Code)	AD_BLDNG	CHAR	20			TEXT20
FLOOR	Floor in building	AD_FLOOR	CHAR	10			TEXT10
ROOM_NO	Room or Appartment Number	AD_ROOMNUM	CHAR	10			TEXT10
COUNTRY	Country Key	LAND1	CHAR	3	T005		LAND1	LND
COUNTRYISO	Country ISO code	INTCA	CHAR	2			INTCA		F4_INTCA
REGION	STATE (State, Province, County)	REGIO	CHAR	3	T005S		REGIO
TIME_ZONE	Address time zone	AD_TZONE	CHAR	6	TTZZ		TZNZONE
TAXJURCODE	Tax Jurisdiction	AD_TXJCD	CHAR	15			AD_TXJCD	TXJ
HOME_CITY	City (different from postal city)	AD_CITY3	CHAR	40			TEXT40
TRANSPZONE	Transportation zone to or from which the goods are delivered	LZONE	CHAR	10	Assigned to domain		ZONE
LANGU	Language Key	SPRAS	LANG	1	Assigned to domain	ISOLA	SPRAS	SPR	H_T002
LANGUISO	2-Character SAP Language Code	LAISO	CHAR	2			LAISO
COMM_TYPE	Communication Method (Key) (Business Address Services)	AD_COMM	CHAR	3	Assigned to domain		AD_COMM
EXTADDRESSNUMBER	Address number in external system	BU_ADEXT	CHAR	20			BU_ADEXT
DONT_USE_P	PO Box Address Undeliverable Flag	AD_NO_USEP	CHAR	4	Assigned to domain		AD_NO_USE
DONT_USE_S	Street Address Undeliverable Flag	AD_NO_USES	CHAR	4	Assigned to domain		AD_NO_USE
MOVE_DATE	Date of Move	BU_MOVEDAT	DATS	8			DATUM
MOVE_ADDRESS	Number of Move Target Address for Address Moves	BU_MOVE_ADDR	CHAR	10	Assigned to domain	ALPHA	AD_ADDRNUM	ADR
VALIDFROMDATE	Validity Date (Valid From)	BU_DATFROM	DATS	8			DATUM
VALIDTODATE	Validity Date (Valid To)	BU_DATTO	DATS	8			DATUM
MOVE_ADDR_GUID	UUID in character form	SYSUUID_C	CHAR	32			SYSUUID_C
CITY_NO	City code for city/street file	AD_CITYNUM	CHAR	12	Assigned to domain	ALPHA	CITY_CODE
DISTRCT_NO	District code for City and Street file	AD_CITYPNM	CHAR	8	Assigned to domain	ALPHA	CITYP_CODE
CHCKSTATUS	City file test status	AD_CHECKST	CHAR	1			AD_CHECKST
PBOXCIT_NO	City PO box code (City file)	AD_CIT2NUM	CHAR	12	Assigned to domain	ALPHA	CITY_CODE
STREET_NO	Street Number for City/Street File	AD_STRNUM	CHAR	12	Assigned to domain	ALPHA	STRT_CODE
HOMECITYNO	Different city for city/street file	AD_CITYHNM	CHAR	12	Assigned to domain	ALPHA	CITY_CODE
PO_BOX_LOBBY	PO Box Lobby	AD_PO_BOX_LBY	CHAR	40			TEXT40
DELI_SERV_TYPE	Type of Delivery Service	AD_DELIVERY_SERVICE_TYPE	CHAR	4			AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER	Number of Delivery Service	AD_DELIVERY_SERVICE_NUMBER	CHAR	10			CHAR10
COUNTY	County	AD_COUNTY	CHAR	40			TEXT40		CLTCNTYNAME
COUNTY_NO	County code for county	AD_CNTYNUM	CHAR	8	Assigned to domain	ALPHA	CNTY_CODE
TOWNSHIP	Township	AD_TOWNSHIP	CHAR	40			TEXT40		CLTWSHPNAME
TOWNSHIP_NO	Township code for Township	AD_TWSHPNUM	CHAR	8	Assigned to domain	ALPHA	TWSHP_CODE
TEL_NUMBER	First telephone no.: dialling code+number	AD_TLNMBR1	CHAR	30			CHAR30
FAX_NUMBER	First fax no.: dialling code+number	AD_FXNMBR1	CHAR	30			CHAR30
SMTP_ADDR	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
TEL_EXTENSION	First Telephone No.: Extension	AD_TLXTNS1	CHAR	10			CHAR10
FAX_EXTENSION	First fax no.: extension	AD_FXXTNS1	CHAR	10			CHAR10

Key field

Non-key field

< BBP_TMP_ZA_ASP - Temporary: Request 'Bidder', Contact Addresses BBP_TMP_ZD_ASP - Temporary: Request 'Bidder', Contact Person Data >

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

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

SELECT SINGLE *
FROM BBP_TMP_ZA_ORG
INTO CORRESPONDING FIELDS OF WA_BBP_TMP_ZA_ORG
WHERE...

How to access SAP table BBP_TMP_ZA_ORG

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

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