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

SAP ABAP Table `FTI_LDB_TR_DEAL_MAIN` {Treasury: Transaction Reporting, Main Data (-> LDB)}

Home

                title {label: "SAP ABAP table FTI_LDB_TR_DEAL_MAIN {Treasury: Transaction Reporting, Main Data (-> LDB)}", size: "20"}

# Entities

[FTI_LDB_TR_DEAL_MAIN] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+COMPANYCODE {label: "CHAR (4)"}
+REFERENCE_TYPE {label: "CHAR (3)"}
+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)"}
+ABWTYP {label: "CHAR (5)"}
+TRADER {label: "CHAR (12)"}
+COUNTERPARTY {label: "CHAR (10)"}
+ISTYPE {label: "CHAR (4)"}
+IND_SECTOR {label: "CHAR (10)"}
+CNTRY_COMP {label: "CHAR (3)"}
+LEGAL_ENTY {label: "CHAR (2)"}
+LEGAL_ORG {label: "CHAR (2)"}
+NATION {label: "CHAR (3)"}
+STATE {label: "CHAR (3)"}
+GROUP_ID {label: "CHAR (4)"}
+GROUP_D {label: "CHAR (4)"}
+STAFF_GRP {label: "CHAR (4)"}
+RATING {label: "CHAR (3)"}
+SOL_INS {label: "CHAR (4)"}
+GUARANTOR {label: "CHAR (10)"}
+VALUATION_CLASS {label: "NUMC (4)"}
+REVERSAL_REASON {label: "CHAR (2)"}
+CURRENCY {label: "CUKY (5)"}
+CURRENCY_RCV {label: "CUKY (5)"}
+CURRENCY_PAY {label: "CUKY (5)"}
+LEAD_CURRENCY {label: "CUKY (5)"}
+FOLL_CURRENCY {label: "CUKY (5)"}
+SECURITY_ACCOUNT {label: "CHAR (10)"}
+CALC_CCY {label: "CUKY (5)"}

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

[AT05] {bgcolor: "#d0e0d0"}
*+SANLF {label: "NUMC (3)"}
*+SFGTYP {label: "NUMC (3)"}
*ABWTYP {label: "CHAR (5)"}

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

[ATR1] {bgcolor: "#d0e0d0"}
*REFTYP {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)"}

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

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

[TB019] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*LEGAL_ENTY {label: "CHAR (2)"}

[TB032] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*LEGAL_ORG {label: "CHAR (2)"}

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

[TB038A] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+ISTYPE {label: "CHAR (4)"}
*IND_SECTOR {label: "CHAR (10)"}

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

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

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

[TP07] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*SOL_INS {label: "CHAR (4)"}

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

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

[TZST] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*SSTOGRD {label: "CHAR (2)"}

# Relationships

FTI_LDB_TR_DEAL_MAIN *--* AT05 {label: "FTI_LDB_TR_DEAL_MAIN-ABWTYP = AT05-ABWTYP"}
FTI_LDB_TR_DEAL_MAIN *--* AT02 {label: "FTI_LDB_TR_DEAL_MAIN-ACTIVITY_CAT = AT02-SFGZUSTT"}
FTI_LDB_TR_DEAL_MAIN *--* TCURC {label: "FTI_LDB_TR_DEAL_MAIN-CALC_CCY = TCURC-WAERS"}
FTI_LDB_TR_DEAL_MAIN *--* T005 {label: "FTI_LDB_TR_DEAL_MAIN-CNTRY_COMP = T005-LAND1"}
FTI_LDB_TR_DEAL_MAIN *--* T001 {label: "FTI_LDB_TR_DEAL_MAIN-COMPANYCODE = T001-BUKRS"}
FTI_LDB_TR_DEAL_MAIN *--* BUT000 {label: "FTI_LDB_TR_DEAL_MAIN-COUNTERPARTY = BUT000-PARTNER"}
FTI_LDB_TR_DEAL_MAIN *--* TCURC {label: "FTI_LDB_TR_DEAL_MAIN-CURRENCY = TCURC-WAERS"}
FTI_LDB_TR_DEAL_MAIN *--* TCURC {label: "FTI_LDB_TR_DEAL_MAIN-CURRENCY_PAY = TCURC-WAERS"}
FTI_LDB_TR_DEAL_MAIN *--* TCURC {label: "FTI_LDB_TR_DEAL_MAIN-CURRENCY_RCV = TCURC-WAERS"}
FTI_LDB_TR_DEAL_MAIN *--* TCURC {label: "FTI_LDB_TR_DEAL_MAIN-FOLL_CURRENCY = TCURC-WAERS"}
FTI_LDB_TR_DEAL_MAIN *--* TP13 {label: "FTI_LDB_TR_DEAL_MAIN-GROUP_D = TP13-GROUP_D"}
FTI_LDB_TR_DEAL_MAIN *--* TB001 {label: "FTI_LDB_TR_DEAL_MAIN-GROUP_ID = TB001-BU_GROUP"}
FTI_LDB_TR_DEAL_MAIN *--* BUT000 {label: "FTI_LDB_TR_DEAL_MAIN-GUARANTOR = BUT000-PARTNER"}
FTI_LDB_TR_DEAL_MAIN *--* TB038A {label: "FTI_LDB_TR_DEAL_MAIN-IND_SECTOR = TB038A-IND_SECTOR"}
FTI_LDB_TR_DEAL_MAIN *--* TB038 {label: "FTI_LDB_TR_DEAL_MAIN-ISTYPE = TB038-ISTYPE"}
FTI_LDB_TR_DEAL_MAIN *--* TCURC {label: "FTI_LDB_TR_DEAL_MAIN-LEAD_CURRENCY = TCURC-WAERS"}
FTI_LDB_TR_DEAL_MAIN *--* TB019 {label: "FTI_LDB_TR_DEAL_MAIN-LEGAL_ENTY = TB019-LEGAL_ENTY"}
FTI_LDB_TR_DEAL_MAIN *--* TB032 {label: "FTI_LDB_TR_DEAL_MAIN-LEGAL_ORG = TB032-LEGAL_ORG"}
FTI_LDB_TR_DEAL_MAIN *--* T000 {label: "FTI_LDB_TR_DEAL_MAIN-MANDT = T000-MANDT"}
FTI_LDB_TR_DEAL_MAIN *--* T005 {label: "FTI_LDB_TR_DEAL_MAIN-NATION = T005-LAND1"}
FTI_LDB_TR_DEAL_MAIN *--* TZAF {label: "FTI_LDB_TR_DEAL_MAIN-PRODUCT_CAT = TZAF-SANLF"}
FTI_LDB_TR_DEAL_MAIN *--* TZPA {label: "FTI_LDB_TR_DEAL_MAIN-PRODUCT_TYPE = TZPA-GSART"}
FTI_LDB_TR_DEAL_MAIN *--* TP06 {label: "FTI_LDB_TR_DEAL_MAIN-RATING = TP06-RATING"}
FTI_LDB_TR_DEAL_MAIN *--* ATR1 {label: "FTI_LDB_TR_DEAL_MAIN-REFERENCE_TYPE = ATR1-REFTYP"}
FTI_LDB_TR_DEAL_MAIN *--* TZST {label: "FTI_LDB_TR_DEAL_MAIN-REVERSAL_REASON = TZST-SSTOGRD"}
FTI_LDB_TR_DEAL_MAIN *--* TWD01 {label: "FTI_LDB_TR_DEAL_MAIN-SECURITY_ACCOUNT = TWD01-RLDEPO"}
FTI_LDB_TR_DEAL_MAIN *--* TP07 {label: "FTI_LDB_TR_DEAL_MAIN-SOL_INS = TP07-SOL_INS"}
FTI_LDB_TR_DEAL_MAIN *--* TP05 {label: "FTI_LDB_TR_DEAL_MAIN-STAFF_GRP = TP05-STAFF_GRP"}
FTI_LDB_TR_DEAL_MAIN *--* T005 {label: "FTI_LDB_TR_DEAL_MAIN-STATE = T005-LAND1"}
FTI_LDB_TR_DEAL_MAIN *--* TZDEA {label: "FTI_LDB_TR_DEAL_MAIN-TRADER = TZDEA-RDEALER"}
FTI_LDB_TR_DEAL_MAIN *--* AT01 {label: "FTI_LDB_TR_DEAL_MAIN-TRANSACTION_CAT = AT01-SFGTYP"}
FTI_LDB_TR_DEAL_MAIN *--* AT10 {label: "FTI_LDB_TR_DEAL_MAIN-TRANSACTION_TYPE = AT10-SFHAART"}
FTI_LDB_TR_DEAL_MAIN *--* TRGC_COM_VALCL {label: "FTI_LDB_TR_DEAL_MAIN-VALUATION_CLASS = TRGC_COM_VALCL-COM_VAL_CLASS"}

E-R Diagram for table FTI_LDB_TR_DEAL_MAIN (Treasury: Transaction Reporting, Main Data (-> LDB))

Foreign Key tables (25)

AT01 {Transaction Category}
AT02 {Transaction Activity Category}
AT05 {Processing Categories}
AT10 {Transaction type}
ATR1 {Check table for reference categories}
BUT000 {BP: General data I}
T000 {Clients}
T001 {Company Codes}
T005 {Countries}
TB001 {BP groupings}
TB019 {BP legal forms}
TB032 {BP Legal Entity}
TB038 {BP Industry Key Systems}
TB038A {BP Industry Key}
TCURC {Currency Codes}
TP05 {Business partner: Employee group}
TP06 {Business Partner: Rating}
TP07 {Business Partner: Credit Rating Institute}
TP13 {Business Partner: Partner Grouping (Target Group)}
TRGC_COM_VALCL {General valuation class}
TWD01 {Treasury: Securities Account Master Data}
TZAF {Product categories}
TZDEA {Trader register}
TZPA {Financial Assets Management Product Types}
TZST {Reasons for reversal}

SAP ABAP Table FTI_LDB_TR_DEAL_MAIN {Treasury: Transaction Reporting, Main Data (-> LDB)}

Foreign Key tables (25)

SAP ABAP Table `FTI_LDB_TR_DEAL_MAIN` {Treasury: Transaction Reporting, Main Data (-> LDB)}