/LIME/PI_LOGHIST

Transparent Table Application Table
12 Fields 1 CDS Views

History Table for Physical Inventory LOG Entries

/LIME/PI_LOGHIST is an SAP database table in S/4HANA. History Table for Physical Inventory LOG Entries. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EWM_PInvDocItemLogHist view from BASIC Log History of Whse Phys Inventory Item

Fields (12)

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 log_type /LIME/PI_LOG_TYPE Log Entry Cat.
KEY log_seq SYTABIX Table Row
KEY timestamp /LIME/TIMESTAMP_INT End
userid UNAME User Name
process_type /LIME/PI_PROCESS_TYPE Process Type
ref_doc_id /LIME/REF_DOC_ID Document ID
ref_doc_type /LIME/REF_DOC_TYPE Document Type
ref_doc_logsys LOGSYS Logical system
_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.

-- History Table for Physical Inventory LOG Entries
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /LIME/PI_LOGHIST (
    MANDT,           -- Client [MANDT]
    GUID_DOC,        -- GUID [/LIME/PI_GUID_DOC]
    ITEM_NO,         -- Item [/LIME/LINE_ITEM_ID]
    LOG_TYPE,        -- Log Entry Cat. [/LIME/PI_LOG_TYPE]
    LOG_SEQ,         -- Table Row [SYTABIX]
    TIMESTAMP,       -- End [/LIME/TIMESTAMP_INT]
    USERID,          -- User Name [UNAME]
    PROCESS_TYPE,    -- Process Type [/LIME/PI_PROCESS_TYPE]
    REF_DOC_ID,      -- Document ID [/LIME/REF_DOC_ID]
    REF_DOC_TYPE,    -- Document Type [/LIME/REF_DOC_TYPE]
    REF_DOC_LOGSYS,  -- Logical system [LOGSYS]
    _DATAAGING,      -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, GUID_DOC, ITEM_NO, LOG_TYPE, LOG_SEQ, TIMESTAMP)
);

Learn More