P_CMMDTYFINTRANSACTIONHEADER

CDS View
24 Fields 2 CDS Views

P_CMMDTYFINTRANSACTIONHEADER is a CDS View in S/4HANA. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CmmdtyFinancialTransaction view inner COMPOSITE
P_CmmdtyFinTransactFlowUnion view inner COMPOSITE

Fields (24)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FinancialTransaction FinancialTransaction 2
_CompanyCode _CompanyCode 1
_Counterparty _Counterparty 1
_ProductType _ProductType 1
CmmdtyHdgSpecificationID CmmdtyHdgSpecificationID 1
CmmdtyHdgSpecQuotaOrderID CmmdtyHdgSpecQuotaOrderID 1
Counterparty Counterparty 1
CreatedByUser CreatedByUser 1
FinancialInstrProductCategory FinancialInstrProductCategory 1
FinancialInstrTransactionType FinancialInstrTransactionType 1
FinancialInstrumentProductType FinancialInstrumentProductType 1
FinancialInstrumentStatus FinancialInstrumentStatus 2
FinancialTransactionHedgeBook FinancialTransactionHedgeBook 1
FinancialTransactionPortfolio FinancialTransactionPortfolio 1
FinInstrTransactionCategory FinInstrTransactionCategory 1
FinInstrumentLastChangedTime FinInstrumentLastChangedTime 1
FinTransCreationDate FinTransCreationDate 1
FinTransCreationTime FinTransCreationTime 1
FinTransHedgingClassification FinTransHedgingClassification 2
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
TermEndDate TermEndDate 1
TermStartDate FinTransTermRiskStartDate,TermStartDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CMMDTYFINTRANSACTIONHEADER (
    COMPANYCODE,
    FINANCIALTRANSACTION,
    _COMPANYCODE,
    _COUNTERPARTY,
    _PRODUCTTYPE,
    CMMDTYHDGSPECIFICATIONID,
    CMMDTYHDGSPECQUOTAORDERID,
    COUNTERPARTY,
    CREATEDBYUSER,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALINSTRUMENTSTATUS,
    FINANCIALTRANSACTIONHEDGEBOOK,
    FINANCIALTRANSACTIONPORTFOLIO,
    FININSTRTRANSACTIONCATEGORY,
    FININSTRUMENTLASTCHANGEDTIME,
    FINTRANSCREATIONDATE,
    FINTRANSCREATIONTIME,
    FINTRANSHEDGINGCLASSIFICATION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    TERMENDDATE,
    TERMSTARTDATE,
    PRIMARY KEY (COMPANYCODE, FINANCIALTRANSACTION)
);

Learn More