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

SAP ABAP Table `/SPE/V_CRM_CP` {Generated Table for View}

Home

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

# Entities

[_SPE_V_CRM_CP] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*BERID {label: "CHAR (10)"}
*BERTX {label: "CHAR (40)"}
*+WERZG {label: "CHAR (4)"}
*+ORTZG {label: "CHAR (4)"}
*ADDRNUMBER {label: "CHAR (10)"}
*NAME1 {label: "CHAR (40)"}
*NAME2 {label: "CHAR (40)"}
*NAME3 {label: "CHAR (40)"}
*NAME4 {label: "CHAR (40)"}
*NAME_CO {label: "CHAR (40)"}
*CITY1 {label: "CHAR (40)"}
*CITY2 {label: "CHAR (40)"}
*POST_CODE1 {label: "CHAR (10)"}
*POST_CODE2 {label: "CHAR (10)"}
*POST_CODE3 {label: "CHAR (10)"}
*PO_BOX {label: "CHAR (10)"}
*PO_BOX_LOC {label: "CHAR (40)"}
*POSTALAREA {label: "CHAR (15)"}
*STREET {label: "CHAR (60)"}
*+STREETCODE {label: "CHAR (12)"}
*+STREETABBR {label: "CHAR (2)"}
*HOUSE_NUM1 {label: "CHAR (10)"}
*HOUSE_NUM3 {label: "CHAR (10)"}
*LOCATION {label: "CHAR (40)"}
*BUILDING {label: "CHAR (20)"}
*FLOOR {label: "CHAR (10)"}
*ROOMNUMBER {label: "CHAR (10)"}
*+COUNTRY {label: "CHAR (3)"}
*+LANGU {label: "LANG (1)"}
*+REGION {label: "CHAR (3)"}
*TEL_NUMBER {label: "CHAR (30)"}
*TEL_EXTENS {label: "CHAR (10)"}
*FAX_NUMBER {label: "CHAR (30)"}
*TAXJURCODE {label: "CHAR (15)"}

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

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

[T001L] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+WERKS {label: "CHAR (4)"}
*LGORT {label: "CHAR (4)"}

[T001W] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*WERKS {label: "CHAR (4)"}

[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

_SPE_V_CRM_CP 1--* T005 {label: "/SPE/V_CRM_CP-COUNTRY = T005-LAND1"}
_SPE_V_CRM_CP ?--* T002 {label: "/SPE/V_CRM_CP-LANGU = T002-SPRAS"}
_SPE_V_CRM_CP 1--* T000 {label: "/SPE/V_CRM_CP-MANDT = T000-MANDT"}
_SPE_V_CRM_CP ?--* T001L {label: "/SPE/V_CRM_CP-ORTZG = T001L-LGORT"}
_SPE_V_CRM_CP ?--* T005S {label: "/SPE/V_CRM_CP-REGION = T005S-BLAND"}
_SPE_V_CRM_CP ?--* ADRSTRTYPE {label: "/SPE/V_CRM_CP-STREETABBR = ADRSTRTYPE-STRTYPEAB"}
_SPE_V_CRM_CP ?--* ADRSTREET {label: "/SPE/V_CRM_CP-STREETCODE = ADRSTREET-STRT_CODE"}
_SPE_V_CRM_CP 1--* T001W {label: "/SPE/V_CRM_CP-WERZG = T001W-WERKS"}

E-R Diagram for table /SPE/V_CRM_CP (Generated Table for View)

Foreign Key tables (8)

ADRSTREET {Streets}
ADRSTRTYPE {Street type}
T000 {Clients}
T001L {Storage Locations}
T001W {Plants/Branches}
T002 {Language Keys (Component BC-I18)}
T005 {Countries}
T005S {Taxes: Region (Province) Key}

SAP ABAP Table /SPE/V_CRM_CP {Generated Table for View}

Foreign Key tables (8)

SAP ABAP Table `/SPE/V_CRM_CP` {Generated Table for View}