P_PRICINGDOCUMENTHEADERELEMENT

CDS View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PrcgDocumentHeaderElementTP view_entity from TRANSACTIONAL Pricing Document Header Element - TP

Fields (34)

KeyField CDS FieldsUsed in Views
KEY HostObjectNodeID HostObjectNodeID 1
KEY HostObjNodeSAPObjectNodeType HostObjNodeSAPObjectNodeType 1
KEY PricingDocument PricingDocument 1
KEY PricingProcedureCounter PricingProcedureCounter 1
KEY PricingProcedureStep PricingProcedureStep 1
_ConditionApplication _ConditionApplication 1
_ConditionCalculationType _ConditionCalculationType 1
_ConditionClass _ConditionClass 1
_ConditionCurrency _ConditionCurrency 1
_ConditionInactiveReason _ConditionInactiveReason 1
_ConditionOrigin _ConditionOrigin 1
_ConditionQuantityUnit _ConditionQuantityUnit 1
_ConditionRateRatioUnit _ConditionRateRatioUnit 1
_Currency _TransactionCurrency 1
_PricingConditionType _PricingConditionType 1
ConditionAmount ConditionAmount 1
ConditionApplication ConditionApplication 1
ConditionBaseAmount ConditionBaseAmount 1
ConditionBaseQuantity ConditionBaseQuantity 1
ConditionCalculationType ConditionCalculationType 1
ConditionClass ConditionClass 1
ConditionCurrency ConditionCurrency 1
ConditionInactiveReason ConditionInactiveReason 1
ConditionIsForStatistics ConditionIsForStatistics 1
ConditionIsManuallyChanged ConditionIsManuallyChanged 1
ConditionOrigin ConditionOrigin 1
ConditionQuantity ConditionQuantity 1
ConditionQuantityUnit ConditionQuantityUnit 1
ConditionRateAmount ConditionRateAmount 1
ConditionRateRatio ConditionRateRatio 1
ConditionRateRatioUnit ConditionRateRatioUnit 1
ConditionType ConditionType 1
PriceConditionDeterminationDte PriceConditionDeterminationDte 1
TransactionCurrency TransactionCurrency 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_PRICINGDOCUMENTHEADERELEMENT (
    HOSTOBJECTNODEID,
    HOSTOBJNODESAPOBJECTNODETYPE,
    PRICINGDOCUMENT,
    PRICINGPROCEDURECOUNTER,
    PRICINGPROCEDURESTEP,
    _CONDITIONAPPLICATION,
    _CONDITIONCALCULATIONTYPE,
    _CONDITIONCLASS,
    _CONDITIONCURRENCY,
    _CONDITIONINACTIVEREASON,
    _CONDITIONORIGIN,
    _CONDITIONQUANTITYUNIT,
    _CONDITIONRATERATIOUNIT,
    _CURRENCY,
    _PRICINGCONDITIONTYPE,
    CONDITIONAMOUNT,
    CONDITIONAPPLICATION,
    CONDITIONBASEAMOUNT,
    CONDITIONBASEQUANTITY,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCLASS,
    CONDITIONCURRENCY,
    CONDITIONINACTIVEREASON,
    CONDITIONISFORSTATISTICS,
    CONDITIONISMANUALLYCHANGED,
    CONDITIONORIGIN,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEAMOUNT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONTYPE,
    PRICECONDITIONDETERMINATIONDTE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (HOSTOBJECTNODEID, HOSTOBJNODESAPOBJECTNODETYPE, PRICINGDOCUMENT, PRICINGPROCEDURECOUNTER, PRICINGPROCEDURESTEP)
);