P_ACMTRDGCONTRHDRDETSMNTNCONTR

CDS View
27 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ACMTradingContractOvw view from COMPOSITE

Fields (27)

KeyField CDS FieldsUsed in Views
KEY tkonn TradingContractNumber 1
ACMCustomerReference ACMCustomerReference 1
ACMRelevantContractStatus ACMRelevantContractStatus 1
ACMYourReference ACMYourReference 1
aedat TradingContractChangedOnDate 1
aenam TradingContractChangedBy 1
AlternatePaymentTerm AlternatePaymentTerm 1
bezei TrdgContrApplStsName 1
btbsta ContractStatus 1
budat DocumentDate 1
erdat TradingContrCreatedOnDate 1
ernam TradingContractCreatedBy 1
erzeit timezne 1
IncotermsClassificationName IncotermsClassificationName 1
IncotermsLocation1 IncotermsLocation1 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
Side Side 1
spart Division 1
tctyp TradingContractType 1
tctyp_descr TradingContractTypeName 1
tkonn_ex TradingContractExternalID 1
tksachb PersonResponsible 1
TrdgContrPurgIncotermsLoc1Text TrdgContrPurgIncotermsLoc1Text 1
TrdgContrSlsIncotermsLoc1Text TrdgContrSlsIncotermsLoc1Text 1
vkorg SalesOrganization 1
vtweg DistributionChannel 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_ACMTRDGCONTRHDRDETSMNTNCONTR (
    TKONN,
    ACMCUSTOMERREFERENCE,
    ACMRELEVANTCONTRACTSTATUS,
    ACMYOURREFERENCE,
    AEDAT,
    AENAM,
    ALTERNATEPAYMENTTERM,
    BEZEI,
    BTBSTA,
    BUDAT,
    ERDAT,
    ERNAM,
    ERZEIT,
    INCOTERMSCLASSIFICATIONNAME,
    INCOTERMSLOCATION1,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SIDE,
    SPART,
    TCTYP,
    TCTYP_DESCR,
    TKONN_EX,
    TKSACHB,
    TRDGCONTRPURGINCOTERMSLOC1TEXT,
    TRDGCONTRSLSINCOTERMSLOC1TEXT,
    VKORG,
    VTWEG,
    PRIMARY KEY (TKONN)
);

Learn More