_ITEMS

14 Fields

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

Fields (14)

KeyField CDS FieldsUsed in Views
_SalesOrder _items_salesorder 1
_Worklist _Worklist 1
BankFeeUnitPricingValue BankFeeUnitPricingValue 2
ConditionContract SchedldConditionContract 1
Currency Currency 2
parent_id item_parent_id 1
product_guid node_key 1
SalesOrderID cons_items_soid 1
SetlMgmtSchedgWlLastRunItmSts SetlMgmtSchedgWlLastRunItmSts 1
SettlmtDate SchedldSettlmtDate 1
SettlmtDateCat SchedldSettlmtDateCategory 1
SettlmtMgmtSchedgWl SettlmtMgmtSchedgWl 1
SettlmtMgmtSchedgWlItem SettlmtMgmtSchedgWlItem 1
SettlmtMgmtSchedgWlUUID SettlmtMgmtSchedgWlUUID 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 _ITEMS (
    _SALESORDER,
    _WORKLIST,
    BANKFEEUNITPRICINGVALUE,
    CONDITIONCONTRACT,
    CURRENCY,
    PARENT_ID,
    PRODUCT_GUID,
    SALESORDERID,
    SETLMGMTSCHEDGWLLASTRUNITMSTS,
    SETTLMTDATE,
    SETTLMTDATECAT,
    SETTLMTMGMTSCHEDGWL,
    SETTLMTMGMTSCHEDGWLITEM,
    SETTLMTMGMTSCHEDGWLUUID
);

Learn More