_KEYDATE

_KEYDATE is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY CurrencyRole CurrencyRole 1
_CurrencyRole _CurrencyRole 1
_Ledger _Ledger 1
BaseUnit BaseUnit 1
CompanyCode CompanyCode 1
Currency Currency 1
Ledger Ledger 1
Material Material 1
MaterialPriceControl MaterialPriceControl 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
StandardPrice StandardPrice 1
Supplier Supplier 1
ValuationArea ValuationArea 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 _KEYDATE (
    CURRENCYROLE,
    _CURRENCYROLE,
    _LEDGER,
    BASEUNIT,
    COMPANYCODE,
    CURRENCY,
    LEDGER,
    MATERIAL,
    MATERIALPRICECONTROL,
    SALESORDER,
    SALESORDERITEM,
    STANDARDPRICE,
    SUPPLIER,
    VALUATIONAREA,
    PRIMARY KEY (CURRENCYROLE)
);