PER

13 Fields

PER is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 1
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
KEY LedgerValuationCurrencyRole LedgerValuationCurrencyRole 1
KEY ValuationArea ValuationArea 1
BaseUnit BaseUnit 1
CurrencyRole CurrencyRole 1
InventoryValuationType InventoryValuationType 1
Ledger Ledger 1
MaterialPrice MaterialPrice 1
MaterialPriceControl MaterialPriceControl 1
MaterialPriceUnitQty MaterialPriceUnitQty 1
period_type period_type 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 PER (
    COSTESTIMATE,
    FISCALPERIOD,
    FISCALYEAR,
    LEDGERVALUATIONCURRENCYROLE,
    VALUATIONAREA,
    BASEUNIT,
    CURRENCYROLE,
    INVENTORYVALUATIONTYPE,
    LEDGER,
    MATERIALPRICE,
    MATERIALPRICECONTROL,
    MATERIALPRICEUNITQTY,
    PERIOD_TYPE,
    PRIMARY KEY (COSTESTIMATE, FISCALPERIOD, FISCALYEAR, LEDGERVALUATIONCURRENCYROLE, VALUATIONAREA)
);

Learn More