P_TRADINGCONTRACTHEADER

CDS View
28 Fields 3 CDS Views

P_TRADINGCONTRACTHEADER is a CDS View in S/4HANA. It contains 28 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_ACMTradingContractDetails view from COMPOSITE
P_TradingContractOverview view from COMPOSITE
P_TrdgContrPricingOverview view inner COMPOSITE

Fields (28)

KeyField CDS FieldsUsed in Views
KEY tkonn TradingContractNumber 3
ACMSignedStatus ACMSignedStatus 1
ACMTrdgContrIsStatusClosed ACMTrdgContrIsStatusClosed 1
aedat TradingContractChangedOnDate 2
aenam TradingContractChangedBy 3
bezei TrdgContrApplStsName 3
btbsta ContractStatus 3
budat DocumentDate 1
ChangedBy TradingContractChangedByName 3
company_code CompanyCode 1
CreatedBy TradingContractCreatedByName 3
DistributionChannelDescr DistributionChannelDescr 3
erdat DocumentDate,TradingContrCreatedOnDate 3
ernam TradingContractCreatedBy 3
orig_resp_trader_id orig_resp_trader_id 2
PersonResponsible PersonResponsibleName 3
resp_trader_id resp_trader_id 2
SalesDivisionDescr SalesDivisionDescr 3
SalesOrgDescr SalesOrgDescr 3
spart Division 3
tctyp TradingContractType 3
tctyp_descr TradingContractTypeName 3
tkonn_ex TradingContractExternalID 3
tksachb PersonResponsible 3
TradingContractCreditSales TradingContractCreditSales 1
TradingContractTradeOffice TradingContractTradeOffice 1
vkorg SalesOrganization 3
vtweg DistributionChannel 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_TRADINGCONTRACTHEADER (
    TKONN,
    ACMSIGNEDSTATUS,
    ACMTRDGCONTRISSTATUSCLOSED,
    AEDAT,
    AENAM,
    BEZEI,
    BTBSTA,
    BUDAT,
    CHANGEDBY,
    COMPANY_CODE,
    CREATEDBY,
    DISTRIBUTIONCHANNELDESCR,
    ERDAT,
    ERNAM,
    ORIG_RESP_TRADER_ID,
    PERSONRESPONSIBLE,
    RESP_TRADER_ID,
    SALESDIVISIONDESCR,
    SALESORGDESCR,
    SPART,
    TCTYP,
    TCTYP_DESCR,
    TKONN_EX,
    TKSACHB,
    TRADINGCONTRACTCREDITSALES,
    TRADINGCONTRACTTRADEOFFICE,
    VKORG,
    VTWEG,
    PRIMARY KEY (TKONN)
);

Learn More