_EXTDEAL

13 Fields

_EXTDEAL is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CmmdtyHedgeConstellationDeal CmmdtyHedgeConstellationDeal,FinTransactionDealIdentifier 3
KEY FinTransactionCompanyCode CompanyCode,FinTransactionCompanyCode 3
CmmdtyHdgCnstltnExpsrVersion CmmdtyHdgCnstltnExpsrVersion 3
CmmdtyHdgCnstltnIntCompanyCode CmmdtyHdgCnstltnIntCompanyCode 1
CmmdtyHdgCnstltnIntDealNumber CmmdtyHdgCnstltnIntDealNumber 1
CmmdtyHdgConstellationExposure CmmdtyHdgConstellationExposure 4
CmmdtyHedgeCnstltnRecordType CmmdtyHedgeCnstltnRecordType 3
CmmdtyHedgeConstellationUUID CmmdtyHedgeConstellationUUID 1
CompanyCode CompanyCode 1
FinancialInstrTransactionType FinancialInstrTransactionType 2
FinTransactionProductCategory FinTransactionProductCategory 2
FinTransactionProductType FinTransactionProductType 2
FinTransOnBehalfOfCompany FinTransOnBehalfOfCompany 2

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 _EXTDEAL (
    CMMDTYHEDGECONSTELLATIONDEAL,
    FINTRANSACTIONCOMPANYCODE,
    CMMDTYHDGCNSTLTNEXPSRVERSION,
    CMMDTYHDGCNSTLTNINTCOMPANYCODE,
    CMMDTYHDGCNSTLTNINTDEALNUMBER,
    CMMDTYHDGCONSTELLATIONEXPOSURE,
    CMMDTYHEDGECNSTLTNRECORDTYPE,
    CMMDTYHEDGECONSTELLATIONUUID,
    COMPANYCODE,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINTRANSACTIONPRODUCTCATEGORY,
    FINTRANSACTIONPRODUCTTYPE,
    FINTRANSONBEHALFOFCOMPANY,
    PRIMARY KEY (CMMDTYHEDGECONSTELLATIONDEAL, FINTRANSACTIONCOMPANYCODE)
);

Learn More