/SAPSLL/API6800_ADDR_R3_S SAP (SLL: API Comm. Structure: Customs Document: Addresses) Structure details

Dictionary Type: Structure
Description: SLL: API Comm. Structure: Customs Document: Addresses




ABAP Code to SELECT data from /SAPSLL/API6800_ADDR_R3_S
Related tables to /SAPSLL/API6800_ADDR_R3_S
Access table /SAPSLL/API6800_ADDR_R3_S




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

/SAPSLL/API6800_ADDR_R3_S is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SLL: API Comm. Structure: Customs Document: Addresses" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_/SAPSLL/API6800_ADDR_R3_S TYPE /SAPSLL/API6800_ADDR_R3_S.

The /SAPSLL/API6800_ADDR_R3_S table consists of various fields, each holding specific information or linking keys about SLL: API Comm. Structure: Customs Document: Addresses data available in SAP. These include FORMOFADDR (Form of address text), NAME (Name 1), NAME_2 (Name 2), NAME_3 (Name 3).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP /SAPSLL/API6800_ADDR_R3_S structure 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
ADDR_NOAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
FORMOFADDRForm of address text AD_TITLE_TCHAR20TEXT20
NAMEName 1 AD_NAME1CHAR40TEXT40
NAME_2Name 2 AD_NAME2CHAR40TEXT40
NAME_3Name 3 AD_NAME3CHAR40TEXT40
NAME_4Name 4 AD_NAME4CHAR40TEXT40
C_O_NAMEc/o name AD_NAME_COCHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
DISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
CITY_NOCity code for city/street file AD_CITYNUMCHAR12Assigned to domainALPHACITY_CODE
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
POSTL_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POSTL_COD3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_CITPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
DELIV_DIS(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
STREETStreet AD_STR_OLDCHAR40TEXT40
STREET_NOStreet Number for City/Street File AD_STRNUMCHAR12Assigned to domainALPHASTRT_CODE
STR_ABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2Assigned to domainSTRTYPEAB
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGText (10 Characters) TEXT10CHAR10TEXT10
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
TIME_ZONEAddress time zone AD_TZONECHAR6Assigned to domainTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADR_NOTESAddress notes AD_REMARK1CHAR50TEXT50
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3Assigned to domainAD_COMM
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
STREET_LNGStreet AD_STREETCHAR60TEXT60CLSTRTNAME
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
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
HOUSE_NO2House number supplement AD_HSNM2CHAR10TEXT10
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
TITLEText (30 Characters) TEXT30CHAR30TEXT30
COUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
LANGU_ISO2-Character SAP Language Code LAISOCHAR2LAISO
BUILD_LONGText (20 Characters) TEXT20CHAR20TEXT20
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
HOME_CITYText, 40 Characters Long TEXT40CHAR40TEXT40
HOMECITYNOCharacter Field of Length 12 CHAR12CHAR12CHAR12
PCODE1_EXTCharacter Field Length = 10 CHAR10CHAR10CHAR10
PCODE2_EXTCharacter Field Length = 10 CHAR10CHAR10CHAR10
PCODE3_EXTCharacter Field Length = 10 CHAR10CHAR10CHAR10
PO_W_O_NOFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3Assigned to domainREGIO
POBOX_CTRYPO box country AD_POBXCTYCHAR3Assigned to domainLAND1
PO_CTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
HOMEPAGEText (length 132) TEXT132CHAR132TEXT132
DONT_USE_SNot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
DONT_USE_PNot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
HOUSE_NO3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
LANGU_CRAddress record creation original language AD_LANGUCRLANG1Assigned to domainISOLASPRAS
LANGUCRISO2-Character SAP Language Code LAISOCHAR2LAISO

Key field Non-key field



How do I retrieve data from SAP structure /SAPSLL/API6800_ADDR_R3_S using ABAP code?

As /SAPSLL/API6800_ADDR_R3_S is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SAPSLL/API6800_ADDR_R3_S as there is no data to select.

How to access SAP table /SAPSLL/API6800_ADDR_R3_S

Within an ECC or HANA version of SAP you can also view further information about /SAPSLL/API6800_ADDR_R3_S 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!