1. Home
  2. Resources
  3. SAP Tables
  4. RJYCIC_ADR - IS-M: CIC, BP Search, Address Data

SAP Table RJYCIC_ADR

IS-M: CIC, BP Search, Address Data

RJYCIC_ADR (IS-M: CIC, BP Search, Address Data) 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 RJYCIC_ADR to other SAP tables.

Source: RJYCIC_ADR (IS-M: CIC, BP Search, Address Data)

RJYCIC_ADR table fields

Field Data element Checktable Datatype Length Decimals
GPNR IS-M: Business Partner Key GPNR JGTGPNR CHAR 10 0
ADRNR IS-M: Address Number JADRNR CHAR 10 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
ANI_TELNR Telephone number for determining caller AD_TELNRCL CHAR 30 0
ANI_LAND Country for telephone/fax number AD_COMCTRY CHAR 3 0
STRAS Street Name STRAS_ISP CHAR 35 0
PREDIRECTIONAL Directional for Street Name DIRECTIONAL TJS41 CHAR 10 0
POSTDIRECTIONAL Directional for Street Name DIRECTIONAL TJS41 CHAR 10 0
HAUSN IS-M: House Number HSNMR1 CHAR 10 0
HSNMR2 IS-M: House Number Affix HSNMR2 CHAR 8 0
HOUSE_NO House Number AD_HSNM1 CHAR 10 0
PSTLZ IS-M: Postal Code PLZ_ISP CHAR 10 0
ORT01 IS-M: City ORT01_ISP CHAR 35 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
LAND1 Country Key LAND1 T005 CHAR 3 0
XGPLOE IS-M: Deletion Flag for General Business Partner JXLV_GP CHAR 1 0
X Yes
NULL No
XGPLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
J_SOC_SECU Social Insurance Number J_SOC_SECU CHAR 20 0
HH_REF IS-M: Business Partner Number of Household GPNR_HH BUT000 CHAR 10 0

RJYCIC_ADR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RJYCIC_ADR ANRED SYST MANDT TJG43 IS-M: Form-of-Address Key MANDT
RJYCIC_ADR ANRED RJYCIC_ADR ANRED TJG43 IS-M: Form-of-Address Key JANRED
RJYCIC_ADR GPNR SYST MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
RJYCIC_ADR GPNR RJYCIC_ADR GPNR JGTGPNR IS-M: Central Business Partner Table GPNR
RJYCIC_ADR HH_REF SYST MANDT BUT000 BP: General data I CLIENT
RJYCIC_ADR HH_REF RJYCIC_ADR HH_REF BUT000 BP: General data I PARTNER
RJYCIC_ADR LAND1 SYST MANDT T005 Countries MANDT
RJYCIC_ADR LAND1 RJYCIC_ADR LAND1 T005 Countries LAND1
RJYCIC_ADR POSTDIRECTIONAL RJYCIC_ADR LAND1 TJS41 IS-M: Direction Data for Street Names LAND1
RJYCIC_ADR POSTDIRECTIONAL RJYCIC_ADR POSTDIRECTIONAL TJS41 IS-M: Direction Data for Street Names DIRECTIONAL
RJYCIC_ADR PREDIRECTIONAL RJYCIC_ADR LAND1 TJS41 IS-M: Direction Data for Street Names LAND1
RJYCIC_ADR PREDIRECTIONAL RJYCIC_ADR PREDIRECTIONAL TJS41 IS-M: Direction Data for Street Names DIRECTIONAL