SAP ABAP Table REXCJPF1792_S1TL (Form 179-2 Section 1 Table Line)
Hierarchy
☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ GLO_REFX_JP (Package) Localization Flexible Real Estate Japan
Basic Data
Table Category INTTAB    Structure 
Structure REXCJPF1792_S1TL   Table Relationship Diagram
Short Description Form 179-2 Section 1 Table Line    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 INTRENO RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
2 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
3 XRO REXCJPXRO CHAR30 CHAR 30   0   Rental Object  
4 XMETXT REBDXRO RECAXLDESCRIPTION CHAR 60   0   Rental Object Name  
5 N01_KORENT REXCJPXKORENT CHAR20 CHAR 20   0   Kind of Rent  
6 N02_RENTSTAT REXCJPXRENTSTATUS CHAR20 CHAR 20   0   Rent Status  
7 .INCLUDE       0   0   Tenant's Address  
8 CLIENT MANDT MANDT CLNT 3   0   Client T000
9 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
10 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses TSADV
11 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
12 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
13 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
14 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
15 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
16 NAME_TEXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
17 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
18 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
19 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
20 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
21 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
22 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
23 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
24 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
25 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
26 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
27 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
28 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
29 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
30 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
31 STREET AD_STREET TEXT60 CHAR 60   0   Street  
32 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
33 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
34 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
35 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
36 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
37 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
38 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
39 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
40 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
41 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
42 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
43 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
44 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
45 XREGION BEZEI20 TEXT20 CHAR 20   0   Description  
46 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
47 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
48 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
49 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
50 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
51 N04_TENOFFNAME REXCJPTENANTOFFN TEXT40 CHAR 40   0   Office Name of the Tenant  
52 N05_TENALTNAME REXCJPTENANTALTN TEXT40 CHAR 40   0   Alternative Name of the Tenant  
53 N06_TENNAME REXCJPTENANTNAM TEXT40 CHAR 40   0   Name of the Tenant  
54 N07_FAEXCL REXCJPTENFAEXCL CHAR20 CHAR 20   0   Exlusive Floor Area of the Tenant  
55 N08_FACOMM REXCJPTENFACOMM CHAR20 CHAR 20   0   Common Floor Area of the Tenant  
56 N09_FALENT REXCJPTENFALENT CHAR20 CHAR 20   0   Floor Area of the Tenant  
57 .INCLUDE       0   0   Rental Status Change Date  
58 .INCLUDE       0   0   Wareki date  
59 JAPCALERA REXCJPJAPCALERA CHAR20 CHAR 20   0   Wareki Date Era  
60 JAPCALYEAR REXCJPJAPCALYEAR CHAR3 CHAR 3   0   Wareki Date Year  
61 JAPCALMONTH REXCJPJAPCALMON CHAR2 CHAR 2   0   Wareki Date Month  
62 JAPCALDAY REXCJPJAPCALDAY CHAR2 CHAR 2   0   Wareki Date Day  
63 N11_FLOOR REXCJPBDFLOOR CHAR200 CHAR 200   0   Occupied Floor(s) by the Tenant  
64 N12_TENPHONE REXCJPTENANTTEL CHAR30 CHAR 30   0   Phone Number of the Tenant  
65 N13_TENPHONEXT REXCJPTENANTEXT CHAR10 CHAR 10   0   Phone Extension of the Tenant  
66 MEASUREUNIT REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
67 RENTSTDATE DATS DATS DATS 8   0   Field of type DATS  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 REXCJPF1792_S1TL CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
2 REXCJPF1792_S1TL CITY_CODE ADRCITY CITY_CODE REF C CN
3 REXCJPF1792_S1TL CITY_CODE2 ADRCITY CITY_CODE REF C CN
4 REXCJPF1792_S1TL CLIENT T000 MANDT KEY 1 CN
5 REXCJPF1792_S1TL COUNTRY T005 LAND1 REF 1 CN
6 REXCJPF1792_S1TL LANGU T002 SPRAS REF C CN
7 REXCJPF1792_S1TL NATION TSADV NATION KEY 1 CN
8 REXCJPF1792_S1TL PO_BOX_CTY T005 LAND1 REF C CN
9 REXCJPF1792_S1TL PO_BOX_REG T005S BLAND REF C CN
10 REXCJPF1792_S1TL REGION T005S BLAND REF C CN
11 REXCJPF1792_S1TL STREETCODE ADRSTREET STRT_CODE REF C CN
12 REXCJPF1792_S1TL TIME_ZONE TTZZ TZONE REF C CN
13 REXCJPF1792_S1TL TITLE TSAD3 TITLE REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 700