SAP ABAP Table CRMST_ACTIVITYH_BTIL (Bus. Trans. IL Attribute Structure for ACTIVITYH Extension), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `CRMST_ACTIVITYH_BTIL` {Bus. Trans. IL Attribute Structure for ACTIVITYH Extension}

Home

                title {label: "SAP ABAP table CRMST_ACTIVITYH_BTIL {Bus. Trans. IL Attribute Structure for ACTIVITYH Extension}", size: "20"}

# Entities

[CRMST_ACTIVITYH_BTIL] {bgcolor: "tomato"}
+CATEGORY {label: "CHAR (3)"}
+PRIORITY {label: "NUMC (1)"}
+OBJECTIVE {label: "CHAR (3)"}
+ADDR_NO {label: "CHAR (10)"}
+CITY_NO {label: "CHAR (12)"}
+STREET_NO {label: "CHAR (12)"}
+STR_ABBR {label: "CHAR (2)"}
+COUNTRY {label: "CHAR (3)"}
+LANGU {label: "LANG (1)"}
+REGION {label: "CHAR (3)"}
+TIME_ZONE {label: "CHAR (6)"}
+COMM_TYPE {label: "CHAR (3)"}
+DISTRCT_NO {label: "CHAR (8)"}
+PBOXCIT_NO {label: "CHAR (12)"}
+TRANSPZONE {label: "CHAR (10)"}
+REGIOGROUP {label: "CHAR (8)"}
+DONT_USE_S {label: "CHAR (4)"}
+DONT_USE_P {label: "CHAR (4)"}

[ADRC] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ADDRNUMBER {label: "CHAR (10)"}
*DATE_FROM {label: "DATS (8)"}
*+NATION {label: "CHAR (1)"}

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

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

[CRMC_ACT_CATEGOR] {bgcolor: "#d0e0d0"}
*CLIENT {label: "CLNT (3)"}
*CATEGORY {label: "CHAR (3)"}

[CRMC_ACT_OBJ] {bgcolor: "#d0e0d0"}
*CLIENT {label: "CLNT (3)"}
*OBJECTIVE {label: "CHAR (3)"}

[SCPRIO] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*PRIORITY {label: "NUMC (1)"}

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

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

[TSAD12] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*UNDELIVER {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

CRMST_ACTIVITYH_BTIL *--* ADRC {label: "CRMST_ACTIVITYH_BTIL-ADDR_NO = ADRC-ADDRNUMBER"}
CRMST_ACTIVITYH_BTIL *--* CRMC_ACT_CATEGOR {label: "CRMST_ACTIVITYH_BTIL-CATEGORY = CRMC_ACT_CATEGOR-CATEGORY"}
CRMST_ACTIVITYH_BTIL *--* ADRCITY {label: "CRMST_ACTIVITYH_BTIL-CITY_NO = ADRCITY-CITY_CODE"}
CRMST_ACTIVITYH_BTIL *--* TSAC {label: "CRMST_ACTIVITYH_BTIL-COMM_TYPE = TSAC-COMM_TYPE"}
CRMST_ACTIVITYH_BTIL *--* T005 {label: "CRMST_ACTIVITYH_BTIL-COUNTRY = T005-LAND1"}
CRMST_ACTIVITYH_BTIL *--* ADRCITYPRT {label: "CRMST_ACTIVITYH_BTIL-DISTRCT_NO = ADRCITYPRT-CITYP_CODE"}
CRMST_ACTIVITYH_BTIL ?--* TSAD12 {label: "CRMST_ACTIVITYH_BTIL-DONT_USE_P = TSAD12-UNDELIVER"}
CRMST_ACTIVITYH_BTIL ?--* TSAD12 {label: "CRMST_ACTIVITYH_BTIL-DONT_USE_S = TSAD12-UNDELIVER"}
CRMST_ACTIVITYH_BTIL *--* T002 {label: "CRMST_ACTIVITYH_BTIL-LANGU = T002-SPRAS"}
CRMST_ACTIVITYH_BTIL *--* CRMC_ACT_OBJ {label: "CRMST_ACTIVITYH_BTIL-OBJECTIVE = CRMC_ACT_OBJ-OBJECTIVE"}
CRMST_ACTIVITYH_BTIL *--* ADRCITY {label: "CRMST_ACTIVITYH_BTIL-PBOXCIT_NO = ADRCITY-CITY_CODE"}
CRMST_ACTIVITYH_BTIL *--* SCPRIO {label: "CRMST_ACTIVITYH_BTIL-PRIORITY = SCPRIO-PRIORITY"}
CRMST_ACTIVITYH_BTIL ?--* ADRREGGRP {label: "CRMST_ACTIVITYH_BTIL-REGIOGROUP = ADRREGGRP-REGIOGROUP"}
CRMST_ACTIVITYH_BTIL *--* T005S {label: "CRMST_ACTIVITYH_BTIL-REGION = T005S-BLAND"}
CRMST_ACTIVITYH_BTIL *--* ADRSTREET {label: "CRMST_ACTIVITYH_BTIL-STREET_NO = ADRSTREET-STRT_CODE"}
CRMST_ACTIVITYH_BTIL *--* ADRSTRTYPE {label: "CRMST_ACTIVITYH_BTIL-STR_ABBR = ADRSTRTYPE-STRTYPEAB"}
CRMST_ACTIVITYH_BTIL *--* TTZZ {label: "CRMST_ACTIVITYH_BTIL-TIME_ZONE = TTZZ-TZONE"}
CRMST_ACTIVITYH_BTIL *--* TZONE {label: "CRMST_ACTIVITYH_BTIL-TRANSPZONE = TZONE-ZONE1"}

E-R Diagram for table CRMST_ACTIVITYH_BTIL (Bus. Trans. IL Attribute Structure for ACTIVITYH Extension)

Foreign Key tables (16)

ADRC {Addresses (Business Address Services)}
ADRCITY {Postal cities}
ADRCITYPRT {Postal districts}
ADRREGGRP {Regional structure grouping}
ADRSTREET {Streets}
ADRSTRTYPE {Street type}
CRMC_ACT_CATEGOR {Activity Category}
CRMC_ACT_OBJ {Activity: Goal}
SCPRIO {Priorities}
T002 {Language Keys (Component BC-I18)}
T005 {Countries}
T005S {Taxes: Region (Province) Key}
TSAC {Communication Methods (Business Address Services)}
TSAD12 {Reasons for Non-Delivery (Business Address Services)}
TTZZ {Time zones}
TZONE {Customers: Regional zones}

SAP ABAP Table CRMST_ACTIVITYH_BTIL {Bus. Trans. IL Attribute Structure for ACTIVITYH Extension}

Foreign Key tables (16)

SAP ABAP Table `CRMST_ACTIVITYH_BTIL` {Bus. Trans. IL Attribute Structure for ACTIVITYH Extension}