P_CONTSUBITEM

CDS View

CONSUMPTION VIEW for wbhd

P_CONTSUBITEM is a CDS View in S/4HANA. CONSUMPTION VIEW for wbhd. It contains 17 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ACMContractSubItemDet view from BASIC Trading Contrct Sub item details
I_ACMTrdgContrBusForMntnContr view from BASIC Trading Contract Business Details for Maintain Contract App
I_ContSubItem view from BASIC CONSUMPTION VIEW for wbhd

Fields (17)

KeyField CDS FieldsUsed in Views
KEY TKONN TradingContractNumber 1
BSTKD ACMCustomerReference 1
EKGRP PurchasingGroup 1
EKORG PurchasingOrganization 1
ELIFN PurchaseOrderSupplier 1
IHREZ ACMYourReference 1
INCO1_MM ACMPurgIncotermsPart1 1
INCO1_SD ACMSlsIncotermsPart1 1
INCO2_L_MM TrdgContrPurgIncotermsLoc1Text 1
INCO2_L_SD TrdgContrSlsIncotermsLoc1Text 1
INCO3_L_SD TrdgContrSlsIncotermsLoc2Text 1
INCOV_MM TrdgContrPurgIncotermsVersion 1
INCOV_SD TrdgContrSalesIncotermsVersion 1
KNUMV_MM PricingDocument 1
WAERS_PURCH TradingContractCurrency 1
ZTERM PaymentTerms 1
ZTERM_SALES TrdgContrSalesPaymentTerms 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.

-- CONSUMPTION VIEW for wbhd
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CONTSUBITEM (
    TKONN,
    BSTKD,
    EKGRP,
    EKORG,
    ELIFN,
    IHREZ,
    INCO1_MM,
    INCO1_SD,
    INCO2_L_MM,
    INCO2_L_SD,
    INCO3_L_SD,
    INCOV_MM,
    INCOV_SD,
    KNUMV_MM,
    WAERS_PURCH,
    ZTERM,
    ZTERM_SALES,
    PRIMARY KEY (TKONN)
);