/LIME/PI_IT_BIZ

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

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
matnr MATNR Material
charg CHARG_D Batch
owner /LIME/OWNER Owner
owner_role /LIME/OWNER_ROLE Partner Role
gtin /LIME/GTIN GTIN
gtin_variant /LIME/GTIN_VARIANT Variant
cat /LIME/STOCK_CATEGORY Stock Type
stock_usage /LIME/STOCK_USAGE Usage
sales_ord_stock /LIME/SALES_ORD_STOCK Sales Order
s_ord_item_stock /LIME/S_ORD_ITEM_STOCK Sales Order Item
wbs_stock /LIME/WBS_STOCK WBS Element
vrsioid /LIME/MDL_VRSIOID PlanVersion
prdid /LIME/MDL_PRDID Product
apo_matnr /LIME/APO_MATNR APO NaterialNo.
lgnum_stock /SCWM/LGNUM Warehouse No.
matid /SCWM/DE_MATID Product
batchid /SCWM/DE_BATCHID Batch
stock_doccat /SCWM/DE_STOCK_DOCCAT Type
stock_docno /SCWM/DE_STOCK_DOCNO Stk Ref. Doc.
stock_itmno /SCWM/DE_STOCK_ITMNO Ref. Doc. Itm
doccat /SCWM/DE_DOCCAT Document Cat.
entitled /SCWM/DE_ENTITLED Disposal Party
entitled_role /SCWM/DE_ENTITLED_ROLE Partner Role
stock_cnt /SCWM/DE_STOCK_CNT Counter
sscc /LIME/SSCC SSCC
lgnum_hu /SCWM/LGNUM Warehouse No.
huident /SCWM/DE_HUIDENT Handling Unit
vhi /SCWM/VHI Virtual HU
werks WERKS_D Plant
lgort LGORT_D Location
gln /LIME/GLN GLN
duns4 /LIME/DUNS4 D-U-N-S+4
locid /LIME/MDL_LOCID Location
apo_locno /LIME/APO_LOCNO APO Location
partner /LIME/PARTNER Partner
partner_role /LIME/PARTNER_ROLE Partner Role
motid /LIME/MDL_MOTID Mns of Trans.ID
motscode /LIME/MDL_MOTSCODE Standard Code
lgnum /SCWM/LGNUM Warehouse No.
lgtyp /SCWM/LGTYP Storage Type
lgpla /SCWM/LGPLA Storage Bin
rsrc /SCWM/DE_RSRC Resource
tu_num /SCWM/DE_TU_NUM Internal TU No.
lgnum_view /SCWM/DE_LGNUM_VIEW View
hu_pmat /SCWM/DE_PMAT Pack. Material
hu_type /SCWM/DE_HUTYP HU Type
_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]
    MATNR,             -- Material [MATNR]
    CHARG,             -- Batch [CHARG_D]
    OWNER,             -- Owner [/LIME/OWNER]
    OWNER_ROLE,        -- Partner Role [/LIME/OWNER_ROLE]
    GTIN,              -- GTIN [/LIME/GTIN]
    GTIN_VARIANT,      -- Variant [/LIME/GTIN_VARIANT]
    CAT,               -- Stock Type [/LIME/STOCK_CATEGORY]
    STOCK_USAGE,       -- Usage [/LIME/STOCK_USAGE]
    SALES_ORD_STOCK,   -- Sales Order [/LIME/SALES_ORD_STOCK]
    S_ORD_ITEM_STOCK,  -- Sales Order Item [/LIME/S_ORD_ITEM_STOCK]
    WBS_STOCK,         -- WBS Element [/LIME/WBS_STOCK]
    VRSIOID,           -- PlanVersion [/LIME/MDL_VRSIOID]
    PRDID,             -- Product [/LIME/MDL_PRDID]
    APO_MATNR,         -- APO NaterialNo. [/LIME/APO_MATNR]
    LGNUM_STOCK,       -- Warehouse No. [/SCWM/LGNUM]
    MATID,             -- Product [/SCWM/DE_MATID]
    BATCHID,           -- Batch [/SCWM/DE_BATCHID]
    STOCK_DOCCAT,      -- Type [/SCWM/DE_STOCK_DOCCAT]
    STOCK_DOCNO,       -- Stk Ref. Doc. [/SCWM/DE_STOCK_DOCNO]
    STOCK_ITMNO,       -- Ref. Doc. Itm [/SCWM/DE_STOCK_ITMNO]
    DOCCAT,            -- Document Cat. [/SCWM/DE_DOCCAT]
    ENTITLED,          -- Disposal Party [/SCWM/DE_ENTITLED]
    ENTITLED_ROLE,     -- Partner Role [/SCWM/DE_ENTITLED_ROLE]
    STOCK_CNT,         -- Counter [/SCWM/DE_STOCK_CNT]
    SSCC,              -- SSCC [/LIME/SSCC]
    LGNUM_HU,          -- Warehouse No. [/SCWM/LGNUM]
    HUIDENT,           -- Handling Unit [/SCWM/DE_HUIDENT]
    VHI,               -- Virtual HU [/SCWM/VHI]
    WERKS,             -- Plant [WERKS_D]
    LGORT,             -- Location [LGORT_D]
    GLN,               -- GLN [/LIME/GLN]
    DUNS4,             -- D-U-N-S+4 [/LIME/DUNS4]
    LOCID,             -- Location [/LIME/MDL_LOCID]
    APO_LOCNO,         -- APO Location [/LIME/APO_LOCNO]
    PARTNER,           -- Partner [/LIME/PARTNER]
    PARTNER_ROLE,      -- Partner Role [/LIME/PARTNER_ROLE]
    MOTID,             -- Mns of Trans.ID [/LIME/MDL_MOTID]
    MOTSCODE,          -- Standard Code [/LIME/MDL_MOTSCODE]
    LGNUM,             -- Warehouse No. [/SCWM/LGNUM]
    LGTYP,             -- Storage Type [/SCWM/LGTYP]
    LGPLA,             -- Storage Bin [/SCWM/LGPLA]
    RSRC,              -- Resource [/SCWM/DE_RSRC]
    TU_NUM,            -- Internal TU No. [/SCWM/DE_TU_NUM]
    LGNUM_VIEW,        -- View [/SCWM/DE_LGNUM_VIEW]
    HU_PMAT,           -- Pack. Material [/SCWM/DE_PMAT]
    HU_TYPE,           -- HU Type [/SCWM/DE_HUTYP]
    _DATAAGING,        -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, GUID_DOC, ITEM_NO, LINE_IDX, CHANGE_SEQ, ITEM_TYPE)
);

Learn More