P_TRADINGCONTRACTHEADER

CDS View
28 Fields 4 CDS Views

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

CDS Views using this table (4)

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

Fields (28)

KeyField CDS FieldsUsed in Views
KEY tkonn TradingContractNumber 4
ACMSignedStatus ACMSignedStatus 1
ACMTrdgContrIsStatusClosed ACMTrdgContrIsStatusClosed 1
aedat TradingContractChangedOnDate 2
aenam TradingContractChangedBy 4
bezei TrdgContrApplStsName 4
btbsta ContractStatus 4
budat DocumentDate 1
ChangedBy TradingContractChangedByName 4
company_code CompanyCode 2
CreatedBy TradingContractCreatedByName 4
DistributionChannelDescr DistributionChannelDescr 4
erdat DocumentDate,TradingContrCreatedOnDate 4
ernam TradingContractCreatedBy 4
orig_resp_trader_id orig_resp_trader_id 2
PersonResponsible PersonResponsibleName 4
resp_trader_id resp_trader_id 2
SalesDivisionDescr SalesDivisionDescr 4
SalesOrgDescr SalesOrgDescr 4
spart Division 4
tctyp TradingContractType 4
tctyp_descr TradingContractTypeName 4
tkonn_ex TradingContractExternalID 4
tksachb PersonResponsible 4
TradingContractCreditSales TradingContractCreditSales 1
TradingContractTradeOffice TradingContractTradeOffice 1
vkorg SalesOrganization 4
vtweg DistributionChannel 4

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