CR

CR is an SAP database table in S/4HANA. It contains 8 fields.

Fields (8)

KeyField CDS FieldsUsed in Views
KEY bdatj FiscalYear 2
KEY curtp CurrencyRole 1
KEY poper FiscalPeriod 2
peinh MaterialPriceUnitQty,MatPriceUnitInCoCodeCurrency 2
pvprs MovingAveragePrice,MovingAveragePriceInCoCodeCrcy 3
stprs StandardPrice,StandardPriceInCoCodeCrcy 3
vprsv MaterialPriceControl 3
waers Currency 2

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 CR (
    BDATJ,
    CURTP,
    POPER,
    PEINH,
    PVPRS,
    STPRS,
    VPRSV,
    WAERS,
    PRIMARY KEY (BDATJ, CURTP, POPER)
);