P_PRCGCNDNRECORDHEADER

CDS View

P_PRCGCNDNRECORDHEADER is a CDS View in S/4HANA. It contains 14 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_PricingConditionRecord view from BASIC Condition Record for Pricing
P_PurgPrcgCndnRecdSuplmnt view from BASIC
P_PurgPrcgConditionRecord view from BASIC
P_SlsPrcgCndnRecdSuplmnt view from BASIC
P_SlsPrcgConditionRecord view from BASIC
P_SrcgProjQtnItmCndnAmount view_entity from BASIC
P_SrcgProjQtnItmCndnAmtSimple view_entity from BASIC

Fields (14)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 6
ConditionApplication ConditionApplication 5
ConditionResponsibility ConditionResponsibility 1
ConditionSearchTermValue ConditionSearchTermValue 1
ConditionTable ConditionTable 6
ConditionValidityEndDate ConditionValidityEndDate 5
ConditionValidityStartDate ConditionValidityStartDate 5
CreatedByUser CreatedByUser 5
CreationDate CreationDate 5
LastChangeDateTime LastChangeDateTime 1
LicenseGrantDate LicenseGrantDate 1
PrevApprovedConditionRecord PrevApprovedConditionRecord 2
PriceApprovalRequest SalesPriceApprovalRequest 2
TaxExemptionLicense TaxExemptionLicense 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_PRCGCNDNRECORDHEADER (
    CONDITIONRECORD,
    CONDITIONAPPLICATION,
    CONDITIONRESPONSIBILITY,
    CONDITIONSEARCHTERMVALUE,
    CONDITIONTABLE,
    CONDITIONVALIDITYENDDATE,
    CONDITIONVALIDITYSTARTDATE,
    CREATEDBYUSER,
    CREATIONDATE,
    LASTCHANGEDATETIME,
    LICENSEGRANTDATE,
    PREVAPPROVEDCONDITIONRECORD,
    PRICEAPPROVALREQUEST,
    TAXEXEMPTIONLICENSE,
    PRIMARY KEY (CONDITIONRECORD)
);