/LIME/PI_DOC_SER

Transparent Table Application Table
13 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 13 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 (13)

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
idx_usid /LIME/KEY_INDEX Key Table
guid_usid /LIME/GUID_USID GUID Stock
sernr /LIME/SERIAL_NUMBER Serial Number
uii /SCWM/DE_UII UII

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]
    IDX_USID,        -- Key Table [/LIME/KEY_INDEX]
    GUID_USID,       -- GUID Stock [/LIME/GUID_USID]
    SERNR,           -- Serial Number [/LIME/SERIAL_NUMBER]
    UII,             -- UII [/SCWM/DE_UII]
    PRIMARY KEY (MANDT, GUID_DOC, ITEM_NO, LINE_IDX, CHANGE_SEQ, ITEM_TYPE, SER_DOC_STATUS, SER_SEQ)
);

Learn More