SAP Table RJS_ABLOUT

IS-M/SD: Structure for Displaying Loading/Unloading Points

RJS_ABLOUT (IS-M/SD: Structure for Displaying Loading/Unloading Points) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RJS_ABLOUT to other SAP tables.

RJS_ABLOUT table fields

Field Data element Checktable Datatype Length Decimals
BEABLART Type of Unloading Point BEABLART CHAR 2 0
MANDT Client MANDT T000 CLNT 3 0
ADRNR IS-M: Address Number JADRNR CHAR 10 0
UVADR_ST IS-M: Coding Status of Address UVADR_AD CHAR 1 0
0 coded in full
1 coded in part
2 not coded
3 does not exist
4 technical change to postal data
UVADR_PF IS-M: Coding Status of Address UVADR_AD CHAR 1 0
0 coded in full
1 coded in part
2 not coded
3 does not exist
4 technical change to postal data
UVADR_GK IS-M: Coding Status of Address UVADR_AD CHAR 1 0
0 coded in full
1 coded in part
2 not coded
3 does not exist
4 technical change to postal data
HERK IS-M: Use of Address HERK CHAR 1 0
1 Business Partner
2 IS-M/SD Order
3 Loading/Unloading Pt
4 Voucher Shipping
5 Divert Address
6 Shipping Order
7 Household
A Media Order
B Media Contact Person
C Media Order (One-Time)
XADRLOE IS-M: Deletion Flag for Address XLOES CHAR 1 0
X Yes
NULL No
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
ANRED Form of Address Key JANRED TJG43 CHAR 2 0
NAME1 IS-M: Business Partner Name NAME1_ISP CHAR 35 0
NAME2 IS-M: First Name of Business Partner NAME2_ISP CHAR 35 0
NAME3 IS-M: Further Name Field for Business Partner NAME3_ISP CHAR 35 0
NAME4 IS-M: Further Name Field for Business Partner NAME4_ISP CHAR 35 0
TITEL IS-M: Title TITEL_ISP T535N CHAR 15 0
NAMZU IS-M: Name Affix NAMZU_ISP T535N CHAR 15 0
VORSW IS-M: Name Prefix VORSW_ISP T535N CHAR 15 0
PSTLZ IS-M: Postal Code PLZ_ISP CHAR 10 0
PSTLZ_ADDON IS-M: Extension to 5-Character ZIP Code PSTLZ_ADDON CHAR 4 0
ORT01 IS-M: City ORT01_ISP CHAR 35 0
ORT02 IS-M: City District ORT02_ISP CHAR 35 0
PSTL2 IS-M: Postal Code for PO Box PLZPF CHAR 10 0
PSTL2_ADDON IS-M: Extension to 5-Character ZIP Code (PO Box) PSTL2_ADDON CHAR 4 0
PSTL3 IS-M: Company Postal Code PSTL3 CHAR 10 0
PSTL3_ADDON IS-M: Extension to 5-Character ZIP Code (Company) PSTL3_ADDON CHAR 4 0
PFACH IS-M: Post Office Box PFACH_ISP CHAR 10 0
ORTPF IS-M: City for PO Box ORTPF CHAR 35 0
STRAS Street Name STRAS_ISP CHAR 35 0
HAUSN IS-M: House Number HSNMR1 CHAR 10 0
HSNMR2 IS-M: House Number Affix HSNMR2 CHAR 8 0
ADRZUS2 Classification Using a Further Address Affix ADRZUS2 CHAR 6 0
STOCK Floor STOCK CHAR 6 0
LAND1 Country Key LAND1 T005 CHAR 3 0
PREDIRECTIONAL Directional for Street Name DIRECTIONAL TJS41 CHAR 10 0
POSTDIRECTIONAL Directional for Street Name DIRECTIONAL TJS41 CHAR 10 0
ADDRSECABBREV IS-M: Secondary Address Text ADDRSECABBREV TJS43 CHAR 4 0
ADDRSECNUMBER IS-M: Secondary Address Number ADDRSECNUMBER CHAR 8 0
STREET2 IS-M: Second street line STREET2_ISM CHAR 35 0
ALIASNAME IS-M: Alias Text (Street Name + Suffix) ALIASNAME CHAR 50 0
ALIASPREDIRECTN Directional for Street Name DIRECTIONAL CHAR 10 0
ALIASPOSTDIRECTN Directional for Street Name DIRECTIONAL CHAR 10 0
ALIASDELADDRLOW IS-M: Primary House Number (Lower Limit) ADDRPRIMLOW CHAR 10 0
ALIASDELADDRHIGH IS-M: Primary House Number (Upper Limit) ADDRPRIMHIGH CHAR 10 0
ALIASDELODDEVEN IS-M: Indicator - Even/Odd/All ODDEVENCODE CHAR 1 0
0 All
1 Odd
2 Even
SUCHFELDALIAS Search field for accessing postal structures w/o matchcode SUCHFELD CHAR 40 0
POSTEINORT IS-M: City Number (Unique) JALORT JSTORTPRO CHAR 8 0
ERSTADR IS-M: Address Proposal for Alternatives ERSTADR CHAR 1 0
1 Address with City/Street
2 PO Box Address
3 Major Customer Postal Code
POSTEINSTR IS-M: Street Number STRASSENNR JSTSTRPRO CHAR 10 0
PEINORTPF IS-M: Postal Unit of City for PO Box ALORT2 JSTORTPRO CHAR 8 0
LOCCO City Coordinates LOCCO CHAR 10 0
NIELS Nielsen ID NIELS TNLS CHAR 2 0
COUNC County Code COUNC T005E CHAR 3 0
CITYC City Code CITYC T005G CHAR 4 0
RPMKR Regional Market RPMKR CHAR 5 0
SORTL Sort field SORTL CHAR 10 0
SORT2 IS-M: Sort Field 2 (for Internal Use) SORTL2 CHAR 20 0
SORT3 IS-M: Sort field 3 (internal) SORTL3 CHAR 30 0
BU_SORT1 Search term 1 for business partner BU_SORT1 CHAR 20 0
SPRAS Language Key SPRAS T002 LANG 1 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
TELFP IS-M: Home Phone Number TELFP CHAR 16 0
TELFD IS-M: Telephone Number at Work TELFD CHAR 16 0
TELW1 IS-M: Additional Telephone Number TELWT CHAR 16 0
TELW2 IS-M: Additional Telephone Number TELWT CHAR 16 0
TELW3 IS-M: Additional Telephone Number TELWT CHAR 16 0
TELW4 IS-M: Mobile Phone Number TELWF CHAR 20 0
TELW5 IS-M: Mobile Phone Number TELWF CHAR 20 0
TELFX Fax Number TELFX CHAR 31 0
TELF1 IS-M: Additional Fax Number TELFT CHAR 16 0
TELF2 IS-M: Additional Fax Number TELFT CHAR 16 0
TELF3 IS-M: Additional Fax Number TELFT CHAR 16 0
TELTX Teletex number TELTX CHAR 30 0
TELX1 Telex number TELX1 CHAR 30 0
TELBX Telebox number TELBX CHAR 15 0
DATLT Data communication line no. DATLT CHAR 14 0
STDKO Default communications service STDKO_D CHAR 1 0
GPHERK IS-M: Business Partner Origin GPHERK TJG41 CHAR 2 0
GP_REF IS-M: Business Partner Key GPNR JGTGPNR CHAR 10 0
VBELN_REF IS-M/SD: Publishing Sales Order AVNR JKAK CHAR 10 0
POSNR_REF Sales Order Item APNR JKAP NUMC 6 0
JPARVW_REF IS-M: Business Partner Role JPARVW TJG39 CHAR 2 0
BEABLS_REF IS-M: Unloading Point BEABLST JRTBEABST CHAR 10 0
TELFP_COD IS-M: Home Phone Number TELFP CHAR 16 0
TELFD_COD IS-M: Telephone Number at Work TELFD CHAR 16 0
NAME1_MACO IS-M: Business Partner Name (Upper Case for Matchcode) NAME1_ISPM CHAR 35 0
NAME2_MACO IS-M: Bus.Partner's First Name (Upper Case for Matchcode) NAME2_ISPM CHAR 35 0
STRAS_MACO IS-M: Street Name STRAS_ISPM CHAR 35 0
ORT01_MACO IS-M/SD: City Name (Upper Case for Matchcode) ORT01_ISPM CHAR 35 0
ISPTELVWP IS-M: Area Code (Home) ISPTELVWP CHAR 10 0
ISPTELP IS-M: Telephone Number ISPTELP CHAR 20 0
ISPTELVWD IS-M: Area Code - Work ISPTELVWD CHAR 10 0
ISPTELD IS-M: Telephone Number ISPTELD CHAR 20 0
ISPHANDY IS-M: Mobile Phone Number ISPHANDY CHAR 30 0
ISPEMAIL IS-M: E-Mail Address ISPEMAIL CHAR 50 0
ISPADRBSND IS-M/SD: Note for Home Delivery to Ship-to Party ISPADRBSND CHAR 50 0
TECHNUMZUG IS-M: Technical Relocation Due to Postal Data Change TECHNUMZUG CHAR 1 0
X Yes
NULL No
XNOMESS IS-M: Indicator - Do Not Perform Output Determination XNOMESS CHAR 1 0
X Yes
NULL No
ALIASLFDNR IS-M: Sequence Number for Alias Table (Key) ALIASLFDNR JSTALIAS NUMC 10 0
XNOCARPERMESS IS-M: No Change of Carrier When Address Changes XNOCARPERMESS CHAR 1 0
X Yes
NULL No
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
ANI_TELNRP Telephone number for determining caller AD_TELNRCL CHAR 30 0
ANI_TELNRD Telephone number for determining caller AD_TELNRCL CHAR 30 0
ANI_ISPHANDY Telephone number for determining caller AD_TELNRCL CHAR 30 0
HH_REF IS-M: Business Partner Number of Household GPNR_HH JGTHH CHAR 10 0
HH_EXCLUDE IS-M: Indicator: Exclude Household Assignment HH_EXCLUDE CHAR 1 0
X Yes
NULL No
PRIVACY_STATUS IS-M: Status of Address As Regards Data Protection ADDRESS_PRIVACY_STATUS CHAR 1 0
NULL No Response from Customer
Y Consent from Customer
N Refusal from Customer
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
PERSNUMBER Person number AD_PERSNUM CHAR 10 0

RJS_ABLOUT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RJS_ABLOUT ADDRSECABBREV RJS_ABLOUT ADDRSECABBREV TJS43 IS-M: Abbreviations for Secondary Address Texts ADDRSECABBREV
RJS_ABLOUT ADDRSECABBREV RJS_ABLOUT LAND1 TJS43 IS-M: Abbreviations for Secondary Address Texts LAND1
RJS_ABLOUT ALIASLFDNR RJS_ABLOUT ALIASLFDNR JSTALIAS IS-M: Alias Table for Streets ALIASLFDNR
RJS_ABLOUT ANRED RJS_ABLOUT MANDT TJG43 IS-M: Form-of-Address Key MANDT
RJS_ABLOUT ANRED RJS_ABLOUT ANRED TJG43 IS-M: Form-of-Address Key JANRED
RJS_ABLOUT BEABLS_REF RJS_ABLOUT MANDT JRTBEABST IS-M/SD: Unloading Point MANDT
RJS_ABLOUT BEABLS_REF RJS_ABLOUT BEABLS_REF JRTBEABST IS-M/SD: Unloading Point BEABLST
RJS_ABLOUT CITYC RJS_ABLOUT LAND1 T005G City LAND1
RJS_ABLOUT CITYC RJS_ABLOUT REGIO T005G City REGIO
RJS_ABLOUT CITYC RJS_ABLOUT CITYC T005G City CITYC
RJS_ABLOUT CITYC RJS_ABLOUT MANDT T005G City MANDT
RJS_ABLOUT COUNC RJS_ABLOUT MANDT T005E County MANDT
RJS_ABLOUT COUNC RJS_ABLOUT LAND1 T005E County LAND1
RJS_ABLOUT COUNC RJS_ABLOUT REGIO T005E County REGIO
RJS_ABLOUT COUNC RJS_ABLOUT COUNC T005E County COUNC
RJS_ABLOUT GPHERK RJS_ABLOUT MANDT TJG41 IS-M/SD: Business Partner Origin MANDT
RJS_ABLOUT GPHERK RJS_ABLOUT GPHERK TJG41 IS-M/SD: Business Partner Origin GPHERK
RJS_ABLOUT GP_REF RJS_ABLOUT GP_REF JGTGPNR IS-M: Central Business Partner Table GPNR
RJS_ABLOUT GP_REF RJS_ABLOUT MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
RJS_ABLOUT HH_REF RJS_ABLOUT MANDT JGTHH IS-M: Household Business Partner CLIENT
RJS_ABLOUT HH_REF RJS_ABLOUT HH_REF JGTHH IS-M: Household Business Partner PARTNER
RJS_ABLOUT JPARVW_REF RJS_ABLOUT JPARVW_REF TJG39 IS-M/SD: Business Partner Roles JPARVW
RJS_ABLOUT JPARVW_REF RJS_ABLOUT MANDT TJG39 IS-M/SD: Business Partner Roles MANDT
RJS_ABLOUT LAND1 RJS_ABLOUT LAND1 T005 Countries LAND1
RJS_ABLOUT LAND1 RJS_ABLOUT MANDT T005 Countries MANDT
RJS_ABLOUT MANDT RJS_ABLOUT MANDT T000 Clients MANDT
RJS_ABLOUT NAMZU RJS_ABLOUT MANDT T535N Name affixes MANDT
RJS_ABLOUT NAMZU 'Z' T535N Name affixes ART
RJS_ABLOUT NAMZU RJS_ABLOUT NAMZU T535N Name affixes TITEL
RJS_ABLOUT NIELS RJS_ABLOUT MANDT TNLS Nielsen ID MANDT
RJS_ABLOUT NIELS RJS_ABLOUT NIELS TNLS Nielsen ID NIELS
RJS_ABLOUT PEINORTPF RJS_ABLOUT LAND1 JSTORTPRO IS-M/SD: City File (Post) LAND1
RJS_ABLOUT PEINORTPF RJS_ABLOUT PEINORTPF JSTORTPRO IS-M/SD: City File (Post) ALORT
RJS_ABLOUT POSNR_REF RJS_ABLOUT MANDT JKAP Sales Order - Item Data MANDT
RJS_ABLOUT POSNR_REF RJS_ABLOUT VBELN_REF JKAP Sales Order - Item Data VBELN
RJS_ABLOUT POSNR_REF RJS_ABLOUT POSNR_REF JKAP Sales Order - Item Data POSNR
RJS_ABLOUT POSTDIRECTIONAL RJS_ABLOUT LAND1 TJS41 IS-M: Direction Data for Street Names LAND1
RJS_ABLOUT POSTDIRECTIONAL RJS_ABLOUT POSTDIRECTIONAL TJS41 IS-M: Direction Data for Street Names DIRECTIONAL
RJS_ABLOUT POSTEINORT RJS_ABLOUT LAND1 JSTORTPRO IS-M/SD: City File (Post) LAND1
RJS_ABLOUT POSTEINORT RJS_ABLOUT POSTEINORT JSTORTPRO IS-M/SD: City File (Post) ALORT
RJS_ABLOUT POSTEINSTR RJS_ABLOUT POSTEINORT JSTSTRPRO IS-M/SD: Street File (Post) ALORT
RJS_ABLOUT POSTEINSTR RJS_ABLOUT POSTEINSTR JSTSTRPRO IS-M/SD: Street File (Post) STRASSENNR
RJS_ABLOUT POSTEINSTR RJS_ABLOUT LAND1 JSTSTRPRO IS-M/SD: Street File (Post) LAND1
RJS_ABLOUT PREDIRECTIONAL RJS_ABLOUT LAND1 TJS41 IS-M: Direction Data for Street Names LAND1
RJS_ABLOUT PREDIRECTIONAL RJS_ABLOUT PREDIRECTIONAL TJS41 IS-M: Direction Data for Street Names DIRECTIONAL
RJS_ABLOUT REGIO RJS_ABLOUT REGIO T005S Taxes: Region (Province) Key BLAND
RJS_ABLOUT REGIO RJS_ABLOUT MANDT T005S Taxes: Region (Province) Key MANDT
RJS_ABLOUT REGIO RJS_ABLOUT LAND1 T005S Taxes: Region (Province) Key LAND1
RJS_ABLOUT SPRAS RJS_ABLOUT SPRAS T002 Language Keys (Component BC-I18) SPRAS
RJS_ABLOUT TITEL RJS_ABLOUT STDKO T535N Name affixes ART
RJS_ABLOUT TITEL RJS_ABLOUT TITEL T535N Name affixes TITEL
RJS_ABLOUT TITEL RJS_ABLOUT MANDT T535N Name affixes MANDT
RJS_ABLOUT TXJCD RJS_ABLOUT MANDT TTXJ Check Table for Tax Jurisdiction MANDT
RJS_ABLOUT TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
RJS_ABLOUT TXJCD RJS_ABLOUT TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
RJS_ABLOUT VBELN_REF RJS_ABLOUT MANDT JKAK Sales Order Header Data MANDT
RJS_ABLOUT VBELN_REF RJS_ABLOUT VBELN_REF JKAK Sales Order Header Data VBELN
RJS_ABLOUT VORSW RJS_ABLOUT MANDT T535N Name affixes MANDT
RJS_ABLOUT VORSW 'V' T535N Name affixes ART
RJS_ABLOUT VORSW RJS_ABLOUT VORSW T535N Name affixes TITEL