P_RAANLYTSUNITPRICEBYITEM

CDS View
16 Fields 2 CDS Views

P_RAANLYTSUNITPRICEBYITEM is a CDS View in S/4HANA. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RAAnlytsQtyByUnitSSPrice view_entity from COMPOSITE
P_RAAnlytsSSPriceTestDistance view_entity from COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
KEY PerfOblgnContractualQtyUnit PerfOblgnContractualQtyUnit 2
KEY PerfOblgnEffectiveQuantityUnit PerfOblgnEffectiveQuantityUnit 2
KEY PerformanceObligation PerformanceObligation 1
KEY PerformanceObligationClass PerformanceObligationClass 2
KEY SalesDocumentCurrency SalesDocumentCurrency 2
KEY UnitSSPriceInSalesDocCrcy UnitSSPriceInSalesDocCrcy 2
AccountingPrinciple AccountingPrinciple 1
CompanyCode CompanyCode 1
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy 1
ContractualUnitPrcInSlsDocCrcy ContractualUnitPrcInSlsDocCrcy 1
PerfOblgnContractualQuantity PerfOblgnContractualQuantity 1
PerfOblgnEffectiveQuantity PerfOblgnEffectiveQuantity 1
PerfOblgnFulfillmentType PerfOblgnFulfillmentType 1
RAPerfOblgnInceptionDate RAPerfOblgnInceptionDate 1
RevenueAccountingContract RevenueAccountingContract 1
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy 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_RAANLYTSUNITPRICEBYITEM (
    PERFOBLGNCONTRACTUALQTYUNIT,
    PERFOBLGNEFFECTIVEQUANTITYUNIT,
    PERFORMANCEOBLIGATION,
    PERFORMANCEOBLIGATIONCLASS,
    SALESDOCUMENTCURRENCY,
    UNITSSPRICEINSALESDOCCRCY,
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    CONTRACTUALPRCINSLSDOCCRCY,
    CONTRACTUALUNITPRCINSLSDOCCRCY,
    PERFOBLGNCONTRACTUALQUANTITY,
    PERFOBLGNEFFECTIVEQUANTITY,
    PERFOBLGNFULFILLMENTTYPE,
    RAPERFOBLGNINCEPTIONDATE,
    REVENUEACCOUNTINGCONTRACT,
    SSPRICEINSALESDOCCRCY,
    PRIMARY KEY (PERFOBLGNCONTRACTUALQTYUNIT, PERFOBLGNEFFECTIVEQUANTITYUNIT, PERFORMANCEOBLIGATION, PERFORMANCEOBLIGATIONCLASS, SALESDOCUMENTCURRENCY, UNITSSPRICEINSALESDOCCRCY)
);

Learn More