SAP ABAP Table FTI_LDB_TR_SEC_DEAL_1 (Treasury: Transaction Reporting, Securities Main Data), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `FTI_LDB_TR_SEC_DEAL_1` {Treasury: Transaction Reporting, Securities Main Data}

Home

                title {label: "SAP ABAP table FTI_LDB_TR_SEC_DEAL_1 {Treasury: Transaction Reporting, Securities Main Data}", size: "20"}

# Entities

[FTI_LDB_TR_SEC_DEAL_1] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+COMPANYCODE {label: "CHAR (4)"}
+PRODUCT_CAT {label: "NUMC (3)"}
+PRODUCT_TYPE {label: "CHAR (3)"}
+TRANSACTION_CAT {label: "NUMC (3)"}
+ACTIVITY_CAT {label: "NUMC (2)"}
+TRANSACTION_TYPE {label: "CHAR (3)"}
+TRADER {label: "CHAR (12)"}
+COUNTERPARTY {label: "CHAR (10)"}
+GUARANTOR {label: "CHAR (10)"}
+VALUATION_CLASS {label: "NUMC (4)"}
+CURRENCY {label: "CUKY (5)"}
+SECURITY_ACCOUNT {label: "CHAR (10)"}

[AT01] {bgcolor: "#d0e0d0"}
*+SANLFOR {label: "NUMC (3)"}
*SFGTYP {label: "NUMC (3)"}

[AT02] {bgcolor: "#d0e0d0"}
*+SANLFOR {label: "NUMC (3)"}
*+SFGTYP {label: "NUMC (3)"}
*SFGZUSTT {label: "NUMC (2)"}

[AT10] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+SGSART {label: "CHAR (3)"}
*SFHAART {label: "CHAR (3)"}

[BUT000] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*PARTNER {label: "CHAR (10)"}

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

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

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

[TRGC_COM_VALCL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*COM_VAL_CLASS {label: "NUMC (4)"}

[TWD01] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*RLDEPO {label: "CHAR (10)"}

[TZAF] {bgcolor: "#d0e0d0"}
*SANLF {label: "NUMC (3)"}

[TZDEA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*RDEALER {label: "CHAR (12)"}

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

# Relationships

FTI_LDB_TR_SEC_DEAL_1 *--* AT02 {label: "FTI_LDB_TR_SEC_DEAL_1-ACTIVITY_CAT = AT02-SFGZUSTT"}
FTI_LDB_TR_SEC_DEAL_1 *--* T001 {label: "FTI_LDB_TR_SEC_DEAL_1-COMPANYCODE = T001-BUKRS"}
FTI_LDB_TR_SEC_DEAL_1 *--* BUT000 {label: "FTI_LDB_TR_SEC_DEAL_1-COUNTERPARTY = BUT000-PARTNER"}
FTI_LDB_TR_SEC_DEAL_1 *--* TCURC {label: "FTI_LDB_TR_SEC_DEAL_1-CURRENCY = TCURC-WAERS"}
FTI_LDB_TR_SEC_DEAL_1 *--* BUT000 {label: "FTI_LDB_TR_SEC_DEAL_1-GUARANTOR = BUT000-PARTNER"}
FTI_LDB_TR_SEC_DEAL_1 *--* T000 {label: "FTI_LDB_TR_SEC_DEAL_1-MANDT = T000-MANDT"}
FTI_LDB_TR_SEC_DEAL_1 *--* TZAF {label: "FTI_LDB_TR_SEC_DEAL_1-PRODUCT_CAT = TZAF-SANLF"}
FTI_LDB_TR_SEC_DEAL_1 *--* TZPA {label: "FTI_LDB_TR_SEC_DEAL_1-PRODUCT_TYPE = TZPA-GSART"}
FTI_LDB_TR_SEC_DEAL_1 *--* TWD01 {label: "FTI_LDB_TR_SEC_DEAL_1-SECURITY_ACCOUNT = TWD01-RLDEPO"}
FTI_LDB_TR_SEC_DEAL_1 *--* TZDEA {label: "FTI_LDB_TR_SEC_DEAL_1-TRADER = TZDEA-RDEALER"}
FTI_LDB_TR_SEC_DEAL_1 *--* AT01 {label: "FTI_LDB_TR_SEC_DEAL_1-TRANSACTION_CAT = AT01-SFGTYP"}
FTI_LDB_TR_SEC_DEAL_1 *--* AT10 {label: "FTI_LDB_TR_SEC_DEAL_1-TRANSACTION_TYPE = AT10-SFHAART"}
FTI_LDB_TR_SEC_DEAL_1 *--* TRGC_COM_VALCL {label: "FTI_LDB_TR_SEC_DEAL_1-VALUATION_CLASS = TRGC_COM_VALCL-COM_VAL_CLASS"}

E-R Diagram for table FTI_LDB_TR_SEC_DEAL_1 (Treasury: Transaction Reporting, Securities Main Data)

Foreign Key tables (12)

AT01 {Transaction Category}
AT02 {Transaction Activity Category}
AT10 {Transaction type}
BUT000 {BP: General data I}
T000 {Clients}
T001 {Company Codes}
TCURC {Currency Codes}
TRGC_COM_VALCL {General valuation class}
TWD01 {Treasury: Securities Account Master Data}
TZAF {Product categories}
TZDEA {Trader register}
TZPA {Financial Assets Management Product Types}

SAP ABAP Table FTI_LDB_TR_SEC_DEAL_1 {Treasury: Transaction Reporting, Securities Main Data}

Foreign Key tables (12)

SAP ABAP Table `FTI_LDB_TR_SEC_DEAL_1` {Treasury: Transaction Reporting, Securities Main Data}