SAP ABAP Table CRMV_ADDR_STREET (Generated Table for View), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `CRMV_ADDR_STREET` {Generated Table for View}

Home

                title {label: "SAP ABAP table CRMV_ADDR_STREET {Generated Table for View}", size: "20"}

# Entities

[CRMV_ADDR_STREET] {bgcolor: "tomato"}
*+CLIENT {label: "CLNT (3)"}
*+LANGU {label: "LANG (1)"}
*+COUNTRY {label: "CHAR (3)"}
*STRT_CODE {label: "CHAR (12)"}
*+CITY_CODE {label: "CHAR (12)"}
*+STRTYPEAB {label: "CHAR (2)"}
*MC_STREET {label: "CHAR (25)"}
*STREET {label: "CHAR (60)"}
*+REGION {label: "CHAR (3)"}
*CITY_NAME {label: "CHAR (40)"}
*MC_CITY {label: "CHAR (25)"}
*CITY_EXT {label: "CHAR (30)"}
*HOUSENUM_H {label: "NUMC (10)"}
*HSN_SUPP_H {label: "CHAR (4)"}
*HOUSENUM_L {label: "NUMC (10)"}
*HSN_SUPP_L {label: "CHAR (4)"}
*+POST_CODE {label: "CHAR (10)"}

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

[ADRPSTCODE] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*POST_CODE {label: "CHAR (10)"}

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

[T000] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}

[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)"}

# Relationships

CRMV_ADDR_STREET 1--* ADRCITY {label: "CRMV_ADDR_STREET-CITY_CODE = ADRCITY-CITY_CODE"}
CRMV_ADDR_STREET 1--* T000 {label: "CRMV_ADDR_STREET-CLIENT = T000-MANDT"}
CRMV_ADDR_STREET 1--* T005 {label: "CRMV_ADDR_STREET-COUNTRY = T005-LAND1"}
CRMV_ADDR_STREET 1--* T002 {label: "CRMV_ADDR_STREET-LANGU = T002-SPRAS"}
CRMV_ADDR_STREET ?--* ADRPSTCODE {label: "CRMV_ADDR_STREET-POST_CODE = ADRPSTCODE-POST_CODE"}
CRMV_ADDR_STREET *--* T005S {label: "CRMV_ADDR_STREET-REGION = T005S-BLAND"}
CRMV_ADDR_STREET 1--* ADRSTRTYPE {label: "CRMV_ADDR_STREET-STRTYPEAB = ADRSTRTYPE-STRTYPEAB"}

E-R Diagram for table CRMV_ADDR_STREET (Generated Table for View)

Foreign Key tables (7)

ADRCITY {Postal cities}
ADRPSTCODE {Postal codes}
ADRSTRTYPE {Street type}
T000 {Clients}
T002 {Language Keys (Component BC-I18)}
T005 {Countries}
T005S {Taxes: Region (Province) Key}

SAP ABAP Table CRMV_ADDR_STREET {Generated Table for View}

Foreign Key tables (7)

SAP ABAP Table `CRMV_ADDR_STREET` {Generated Table for View}