_RAANALYTICSSSPRICETEST

24 Fields

_RAANALYTICSSSPRICETEST is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY AccountingPrinciple AccountingPrinciple 8
KEY CalendarQuarter CalendarQuarter 3
KEY CalendarYear CalendarYear 3
KEY CompanyCode CompanyCode 8
KEY PerformanceObligation PerformanceObligation 5
KEY PerformanceObligationClass PerformanceObligationClass 8
KEY RevenueAccountingContract RevenueAccountingContract 5
KEY SalesDocumentCurrency SalesDocumentCurrency 8
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy 4
ContractualUnitPrcInSlsDocCrcy ContractualUnitPrcInSlsDocCrcy 3
NumberOfCompliantPerfOblgnVal NumberOfCompliantPerfOblgnVal 1
NumberOfPerformanceObligations NumberOfPerformanceObligations 1
PerfOblgnContractualQtyUnit PerfOblgnContractualQtyUnit 4
PerfOblgnContractualQuantity PerfOblgnContractualQuantity 4
PerfOblgnEffectiveQuantity PerfOblgnEffectiveQuantity 3
PerfOblgnEffectiveQuantityUnit PerfOblgnEffectiveQuantityUnit 4
PerfOblgnFulfillmentType PerfOblgnFulfillmentType 4
RAFinCmplncIntervalScopeValue RAFinCmplncIntervalScopeValue 3
RAFinCmplncIntervalScpAmtHigh RAFinCmplncIntervalScpAmtHigh 1
RAFinCmplncIntervalScpAmtLow RAFinCmplncIntervalScpAmtLow 1
RAPerfOblgnInceptionDate RAPerfOblgnInceptionDate 4
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy 4
StandardPrice StandardPrice 6
UnitSSPriceInSalesDocCrcy UnitSSPriceInSalesDocCrcy 3

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 _RAANALYTICSSSPRICETEST (
    ACCOUNTINGPRINCIPLE,
    CALENDARQUARTER,
    CALENDARYEAR,
    COMPANYCODE,
    PERFORMANCEOBLIGATION,
    PERFORMANCEOBLIGATIONCLASS,
    REVENUEACCOUNTINGCONTRACT,
    SALESDOCUMENTCURRENCY,
    CONTRACTUALPRCINSLSDOCCRCY,
    CONTRACTUALUNITPRCINSLSDOCCRCY,
    NUMBEROFCOMPLIANTPERFOBLGNVAL,
    NUMBEROFPERFORMANCEOBLIGATIONS,
    PERFOBLGNCONTRACTUALQTYUNIT,
    PERFOBLGNCONTRACTUALQUANTITY,
    PERFOBLGNEFFECTIVEQUANTITY,
    PERFOBLGNEFFECTIVEQUANTITYUNIT,
    PERFOBLGNFULFILLMENTTYPE,
    RAFINCMPLNCINTERVALSCOPEVALUE,
    RAFINCMPLNCINTERVALSCPAMTHIGH,
    RAFINCMPLNCINTERVALSCPAMTLOW,
    RAPERFOBLGNINCEPTIONDATE,
    SSPRICEINSALESDOCCRCY,
    STANDARDPRICE,
    UNITSSPRICEINSALESDOCCRCY,
    PRIMARY KEY (ACCOUNTINGPRINCIPLE, CALENDARQUARTER, CALENDARYEAR, COMPANYCODE, PERFORMANCEOBLIGATION, PERFORMANCEOBLIGATIONCLASS, REVENUEACCOUNTINGCONTRACT, SALESDOCUMENTCURRENCY)
);

Learn More