SAP ABAP Table CMS_STR_ANL_CS_RE_DETAILS (Real estate details for collateral sheet), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `CMS_STR_ANL_CS_RE_DETAILS` {Real estate details for collateral sheet}

Home

                title {label: "SAP ABAP table CMS_STR_ANL_CS_RE_DETAILS {Real estate details for collateral sheet}", size: "20"}

# Entities

[CMS_STR_ANL_CS_RE_DETAILS] {bgcolor: "tomato"}
+OBJECT_TYPE {label: "CHAR (6)"}
+OBJECT_CURR {label: "CUKY (5)"}
+MACRO_LOC_TYPE {label: "CHAR (6)"}
+MICRO_LOC_TYPE {label: "CHAR (6)"}
+TRAN_CONN_TYPE {label: "CHAR (6)"}
+ENVIRON_STATUS {label: "CHAR (6)"}
+TITLE {label: "CHAR (4)"}
+CITY_CODE {label: "CHAR (12)"}
+CITYP_CODE {label: "CHAR (8)"}
+CITYH_CODE {label: "CHAR (12)"}
+REGIOGROUP {label: "CHAR (8)"}
+DONT_USE_P {label: "CHAR (4)"}
+CITY_CODE2 {label: "CHAR (12)"}
+PO_BOX_REG {label: "CHAR (3)"}
+PO_BOX_CTY {label: "CHAR (3)"}
+TRANSPZONE {label: "CHAR (10)"}
+DONT_USE_S {label: "CHAR (4)"}
+STREETCODE {label: "CHAR (12)"}
+STREETABBR {label: "CHAR (2)"}
COUNTRY {label: "CHAR (3)"}
+LANGU {label: "LANG (1)"}
REGION {label: "CHAR (3)"}
+ADDRORIGIN {label: "CHAR (4)"}
+TIME_ZONE {label: "CHAR (6)"}
+LANGU_CREA {label: "LANG (1)"}
+DELI_SERV_TYPE {label: "CHAR (4)"}
+COUNTY_CODE {label: "CHAR (8)"}
+TOWNSHIP_CODE {label: "CHAR (8)"}
+DEFLT_COMM {label: "CHAR (3)"}

[ADDRC_DELI_SERV] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*DELI_SERV_TYPE {label: "CHAR (4)"}

[ADRCITY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*CITY_CODE {label: "CHAR (12)"}

[ADRCITYPRT] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+CITY_CODE {label: "CHAR (12)"}
*CITYP_CODE {label: "CHAR (8)"}

[ADRCOUNTY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+REGION {label: "CHAR (3)"}
*COUNTY_CODE {label: "CHAR (8)"}

[ADRREGGRP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*REGIOGROUP {label: "CHAR (8)"}

[ADRSTREET] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*STRT_CODE {label: "CHAR (12)"}

[ADRSTRTYPE] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*STRTYPEAB {label: "CHAR (2)"}

[ADRTOWNSHIP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+REGION {label: "CHAR (3)"}
*+COUNTY_CODE {label: "CHAR (8)"}
*TOWNSHIP_CODE {label: "CHAR (8)"}

[T002] {bgcolor: "#d0e0d0"}
*SPRAS {label: "LANG (1)"}

[T005] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LAND1 {label: "CHAR (3)"}

[T005S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*BLAND {label: "CHAR (3)"}

[TCMS_ATT_ID_TY] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+INDICATOR_ID {label: "CHAR (6)"}
*INDICATOR_TYPE {label: "CHAR (6)"}

[TCMS_RE_TYP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*OBJECT_TYPE {label: "CHAR (6)"}

[TCURC] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*WAERS {label: "CUKY (5)"}

[TSAC] {bgcolor: "#d0e0d0"}
*COMM_TYPE {label: "CHAR (3)"}

[TSAD12] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*UNDELIVER {label: "CHAR (4)"}

[TSAD3] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TITLE {label: "CHAR (4)"}

[TSAD6] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ORIGIN {label: "CHAR (4)"}

[TTZZ] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TZONE {label: "CHAR (6)"}

[TZONE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*ZONE1 {label: "CHAR (10)"}

# Relationships

CMS_STR_ANL_CS_RE_DETAILS ?--* TSAD6 {label: "CMS_STR_ANL_CS_RE_DETAILS-ADDRORIGIN = TSAD6-ORIGIN"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRCITY {label: "CMS_STR_ANL_CS_RE_DETAILS-CITYH_CODE = ADRCITY-CITY_CODE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRCITYPRT {label: "CMS_STR_ANL_CS_RE_DETAILS-CITYP_CODE = ADRCITYPRT-CITYP_CODE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRCITY {label: "CMS_STR_ANL_CS_RE_DETAILS-CITY_CODE = ADRCITY-CITY_CODE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRCITY {label: "CMS_STR_ANL_CS_RE_DETAILS-CITY_CODE2 = ADRCITY-CITY_CODE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRCOUNTY {label: "CMS_STR_ANL_CS_RE_DETAILS-COUNTY_CODE = ADRCOUNTY-COUNTY_CODE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* TSAC {label: "CMS_STR_ANL_CS_RE_DETAILS-DEFLT_COMM = TSAC-COMM_TYPE"}
CMS_STR_ANL_CS_RE_DETAILS 1--* ADDRC_DELI_SERV {label: "CMS_STR_ANL_CS_RE_DETAILS-DELI_SERV_TYPE = ADDRC_DELI_SERV-DELI_SERV_TYPE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* TSAD12 {label: "CMS_STR_ANL_CS_RE_DETAILS-DONT_USE_P = TSAD12-UNDELIVER"}
CMS_STR_ANL_CS_RE_DETAILS ?--* TSAD12 {label: "CMS_STR_ANL_CS_RE_DETAILS-DONT_USE_S = TSAD12-UNDELIVER"}
CMS_STR_ANL_CS_RE_DETAILS 1--* TCMS_ATT_ID_TY {label: "CMS_STR_ANL_CS_RE_DETAILS-ENVIRON_STATUS = TCMS_ATT_ID_TY-INDICATOR_TYPE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* T002 {label: "CMS_STR_ANL_CS_RE_DETAILS-LANGU = T002-SPRAS"}
CMS_STR_ANL_CS_RE_DETAILS ?--* T002 {label: "CMS_STR_ANL_CS_RE_DETAILS-LANGU_CREA = T002-SPRAS"}
CMS_STR_ANL_CS_RE_DETAILS 1--* TCMS_ATT_ID_TY {label: "CMS_STR_ANL_CS_RE_DETAILS-MACRO_LOC_TYPE = TCMS_ATT_ID_TY-INDICATOR_TYPE"}
CMS_STR_ANL_CS_RE_DETAILS 1--* TCMS_ATT_ID_TY {label: "CMS_STR_ANL_CS_RE_DETAILS-MICRO_LOC_TYPE = TCMS_ATT_ID_TY-INDICATOR_TYPE"}
CMS_STR_ANL_CS_RE_DETAILS 1--* TCURC {label: "CMS_STR_ANL_CS_RE_DETAILS-OBJECT_CURR = TCURC-WAERS"}
CMS_STR_ANL_CS_RE_DETAILS ?--* T005 {label: "CMS_STR_ANL_CS_RE_DETAILS-PO_BOX_CTY = T005-LAND1"}
CMS_STR_ANL_CS_RE_DETAILS ?--* T005S {label: "CMS_STR_ANL_CS_RE_DETAILS-PO_BOX_REG = T005S-BLAND"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRREGGRP {label: "CMS_STR_ANL_CS_RE_DETAILS-REGIOGROUP = ADRREGGRP-REGIOGROUP"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRSTRTYPE {label: "CMS_STR_ANL_CS_RE_DETAILS-STREETABBR = ADRSTRTYPE-STRTYPEAB"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRSTREET {label: "CMS_STR_ANL_CS_RE_DETAILS-STREETCODE = ADRSTREET-STRT_CODE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* TTZZ {label: "CMS_STR_ANL_CS_RE_DETAILS-TIME_ZONE = TTZZ-TZONE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* TSAD3 {label: "CMS_STR_ANL_CS_RE_DETAILS-TITLE = TSAD3-TITLE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* ADRTOWNSHIP {label: "CMS_STR_ANL_CS_RE_DETAILS-TOWNSHIP_CODE = ADRTOWNSHIP-TOWNSHIP_CODE"}
CMS_STR_ANL_CS_RE_DETAILS ?--* TZONE {label: "CMS_STR_ANL_CS_RE_DETAILS-TRANSPZONE = TZONE-ZONE1"}
CMS_STR_ANL_CS_RE_DETAILS 1--* TCMS_ATT_ID_TY {label: "CMS_STR_ANL_CS_RE_DETAILS-TRAN_CONN_TYPE = TCMS_ATT_ID_TY-INDICATOR_TYPE"}

E-R Diagram for table CMS_STR_ANL_CS_RE_DETAILS (Real estate details for collateral sheet)

Foreign Key tables (20)

ADDRC_DELI_SERV {Address Service Types}
ADRCITY {Postal cities}
ADRCITYPRT {Postal districts}
ADRCOUNTY {County codes}
ADRREGGRP {Regional structure grouping}
ADRSTREET {Streets}
ADRSTRTYPE {Street type}
ADRTOWNSHIP {Township codes}
T002 {Language Keys (Component BC-I18)}
T005 {Countries}
T005S {Taxes: Region (Province) Key}
TCMS_ATT_ID_TY { Attribute Indicator type}
TCMS_RE_TYP {Customizing table for real estate types}
TCURC {Currency Codes}
TSAC {Communication Methods (Business Address Services)}
TSAD12 {Reasons for Non-Delivery (Business Address Services)}
TSAD3 {Forms of Address (Key) (Business Address Services)}
TSAD6 {Source Address or Personal Data (Business Address Services)}
TTZZ {Time zones}
TZONE {Customers: Regional zones}

SAP ABAP Table CMS_STR_ANL_CS_RE_DETAILS {Real estate details for collateral sheet}

Foreign Key tables (20)

SAP ABAP Table `CMS_STR_ANL_CS_RE_DETAILS` {Real estate details for collateral sheet}