/LIME/PI_DOC_SER

Transparent Table Application Table
9 Fields 1 CDS Views

Serial Numbers for Physical Inventory Document Items

/LIME/PI_DOC_SER is an SAP database table in S/4HANA. Serial Numbers for Physical Inventory Document Items. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EWM_PInvSerialNumber view from BASIC Serial Numbers of Whse Phys Inventory

Fields (9)

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
KEY ser_doc_status /lime/pi_ser_doc_status Serial Number Status
KEY ser_seq sytabix Table Row
_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.

-- Serial Numbers for Physical Inventory Document Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /LIME/PI_DOC_SER (
    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]
    SER_DOC_STATUS,  -- Serial Number Status [/lime/pi_ser_doc_status]
    SER_SEQ,         -- Table Row [sytabix]
    _DATAAGING,      -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, GUID_DOC, ITEM_NO, LINE_IDX, CHANGE_SEQ, ITEM_TYPE, SER_DOC_STATUS, SER_SEQ)
);

Learn More