P_TRADINGCONTRACTBUSINESSDETS

CDS View

P_TRADINGCONTRACTBUSINESSDETS is a CDS View in S/4HANA. It contains 14 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ACMApplicationOverview view left_outer TRANSACTIONAL Interface Layer for ACM Application Overview
P_ACMTradingContractDetails view inner COMPOSITE
P_ACMTradingContractOverview view inner COMPOSITE
P_TradingContractOverview view inner COMPOSITE
P_TrdgContrPricingOverview view inner COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
ACMCustomerReference ACMCustomerReference 4
ACMReferencePO ACMReferencePO 1
ACMSupplyingPlant ACMSupplyingPlant 2
ACMYourReference ACMYourReference 4
DocumentSide Side 3
eknam eknam,PurchasingGroupDescr 4
ekotx ekotx,PurchasingOrgDescr 4
IncotermsClassificationName IncotermsClassificationName 4
PurchasingGroup PurchasingGroup 5
PurchasingOrganization PurchasingOrganization 5
TradingContractItem TradingContractItem 1
TradingContractNumber TradingContractNumber 1
TrdgContrPurgIncotermsLoc1Text TrdgContrPurgIncotermsLoc1Text 3
TrdgContrSlsIncotermsLoc1Text TrdgContrSlsIncotermsLoc1Text 3

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_TRADINGCONTRACTBUSINESSDETS (
    ACMCUSTOMERREFERENCE,
    ACMREFERENCEPO,
    ACMSUPPLYINGPLANT,
    ACMYOURREFERENCE,
    DOCUMENTSIDE,
    EKNAM,
    EKOTX,
    INCOTERMSCLASSIFICATIONNAME,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    TRADINGCONTRACTITEM,
    TRADINGCONTRACTNUMBER,
    TRDGCONTRPURGINCOTERMSLOC1TEXT,
    TRDGCONTRSLSINCOTERMSLOC1TEXT
);