P_ACMTRADINGCONTRACTHEADER

CDS View
31 Fields 1 CDS Views

P_ACMTRADINGCONTRACTHEADER is a CDS View in S/4HANA. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ACMTradingContractOverview view from COMPOSITE

Fields (31)

KeyField CDS FieldsUsed in Views
KEY TradingContractNumber TradingContractNumber 1
ACMSignedStatus ACMSignedStatus 1
ACMTargetTrdgContrType ACMTargetTrdgContrType 1
ACMTargetTrdgContrTypeName ACMTargetTrdgContrTypeName 1
ACMTrdgContrQuotesValidDate ACMTrdgContrQuotesValidDate 1
bezei TrdgContrApplStsName 1
ChangedBy TradingContractChangedByName 1
CompanyCode CompanyCode 1
ContractStatus ContractStatus 1
CreatedBy TradingContractCreatedByName 1
DistributionChannel DistributionChannel 1
DistributionChannelDescr DistributionChannelDescr 1
Division Division 1
DocumentDate DocumentDate 1
orig_resp_trader_id orig_resp_trader_id 1
PersonResponsible PersonResponsible 1
PersonResponsibleName PersonResponsibleName 1
resp_trader_id resp_trader_id 1
SalesDivisionDescr SalesDivisionDescr 1
SalesOrganization SalesOrganization 1
SalesOrgDescr SalesOrgDescr 1
Side Side 1
tctyp_descr TradingContractTypeName 1
TradingContractChangedBy TradingContractChangedBy 1
TradingContractChangedOnDate TradingContractChangedOnDate 1
TradingContractCreatedBy TradingContractCreatedBy 1
TradingContractCreditSales TradingContractCreditSales 1
TradingContractExternalID TradingContractExternalID 1
TradingContractTradeOffice TradingContractTradeOffice 1
TradingContractType TradingContractType 1
TradingContrCreatedOnDate TradingContrCreatedOnDate 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_ACMTRADINGCONTRACTHEADER (
    TRADINGCONTRACTNUMBER,
    ACMSIGNEDSTATUS,
    ACMTARGETTRDGCONTRTYPE,
    ACMTARGETTRDGCONTRTYPENAME,
    ACMTRDGCONTRQUOTESVALIDDATE,
    BEZEI,
    CHANGEDBY,
    COMPANYCODE,
    CONTRACTSTATUS,
    CREATEDBY,
    DISTRIBUTIONCHANNEL,
    DISTRIBUTIONCHANNELDESCR,
    DIVISION,
    DOCUMENTDATE,
    ORIG_RESP_TRADER_ID,
    PERSONRESPONSIBLE,
    PERSONRESPONSIBLENAME,
    RESP_TRADER_ID,
    SALESDIVISIONDESCR,
    SALESORGANIZATION,
    SALESORGDESCR,
    SIDE,
    TCTYP_DESCR,
    TRADINGCONTRACTCHANGEDBY,
    TRADINGCONTRACTCHANGEDONDATE,
    TRADINGCONTRACTCREATEDBY,
    TRADINGCONTRACTCREDITSALES,
    TRADINGCONTRACTEXTERNALID,
    TRADINGCONTRACTTRADEOFFICE,
    TRADINGCONTRACTTYPE,
    TRADINGCONTRCREATEDONDATE,
    PRIMARY KEY (TRADINGCONTRACTNUMBER)
);

Learn More