/LIME/PI_IT_BIZ

Transparent Table Application Table
7 Fields 1 CDS Views

Physical Inventory Document Business Key Item Object

/LIME/PI_IT_BIZ is an SAP database table in S/4HANA. Physical Inventory Document Business Key Item Object. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EWM_PInvDocBusKeyItem view from BASIC Bus Keys of Whse Physical Inventory Item

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY guid_doc /lime/pi_guid_doc GUID
KEY item_no /lime/line_item_id Item
KEY line_idx sytabix Table Row
KEY change_seq /lime/pi_de_change_seq Version
KEY item_type /lime/pi_line_type Line Category
_dataaging data_temperature Data Aging

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.

-- Physical Inventory Document Business Key Item Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /LIME/PI_IT_BIZ (
    MANDT,       -- Client [mandt]
    GUID_DOC,    -- GUID [/lime/pi_guid_doc]
    ITEM_NO,     -- Item [/lime/line_item_id]
    LINE_IDX,    -- Table Row [sytabix]
    CHANGE_SEQ,  -- Version [/lime/pi_de_change_seq]
    ITEM_TYPE,   -- Line Category [/lime/pi_line_type]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, GUID_DOC, ITEM_NO, LINE_IDX, CHANGE_SEQ, ITEM_TYPE)
);

Learn More