FLOG_SUPLRITEM

Transparent Table Application Table
43 Fields 6 CDS Views

Field Logistics: Supplier Item Repository

FLOG_SUPLRITEM is an SAP database table in S/4HANA. Field Logistics: Supplier Item Repository. It contains 43 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_FldLogsSupplierItem view_entity from EXTENSION Extension Include View for Supplier Item
I_FldLogsSuplrItemAttachment view_entity from BASIC Supplier Item Attachments
I_FldLogsSuplrItmMatlDocInfo view_entity from BASIC Supplier Item Material Document Info
I_FldLogsSuplrItmOutbDelivInfo view_entity from BASIC Supplier Item Outbound Delivery Info
I_FldLogsSupplierItem view_entity from BASIC Field Logistics Supplier Items
I_FldLogsSupplierItemName view_entity from BASIC Supplier Item Name

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY fldlogssuplritemuuid FLOG_SUPLRITEM_UUID Suplr Item UUID
fldlogssuplritemtype FLOG_SUPLRITEM_TYPE Suplr Item Type
fldlogssuplrparentitemuuid FLOG_SUPLRITEM_UUID Suplr Item UUID
fldlogssuplritemserialnumber FLOG_SUPLRITEM_SERIALNMBR Manuf. SerialNr
fldlogssuplritemname FLOG_SUPLRITEM_NAME Suplr Item Name
preferredsupplier LIFNR Supplier
fldlogssuplrbaseplant WERKS_D Plant
fldlogsremoteplant WERKS_D Plant
fldlogssuplritmpoitmuniqueid FLOG_PURORDITEM_UNIQUE_ID PO Item Uniq ID
fldlogssuplritemvislinspcode FLOG_SUPLRITEM_VISL_INSP_CODE Visual Inspection
purgdocnetpriceamount BPREI Net Price
fldlogssuplritemrateunit WAERS Currency
fldlogssuplritemquantity MENGE_D Quantity
fldlogssuplritemquantityunit MEINS Base Unit
fldlogssuplritemgrossvolume VOLUM Volume
fldlogssuplritmgrossvolumeunit VOLEH Volume Unit
productgrossweight BRGEW Gross Weight
productweightunit GEWEI Unit of Weight
fldlogssuplritemlength LAENG Length
fldlogssuplritemwidth BREIT Width
fldlogssuplritemheight HOEHE Height
fldlogssuplritemmeasureunit MEABM Unit
fldlogssuplritemstatusid FLOG_SUPLRITEM_STATUS_ID Suplr Item Status ID
itemisdangerousgood BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
dangerousgoodsidnnumbercnctntd FLOG_SUPLRITM_DGIDNNMBRCNCTNTD DG IDNo ConCat
fldlogsisworkorderonhold FLOG_WRK_ORD_ON_HOLD WorkOrderOnHold
fldlogssuplritemplnddelivdate EINDT Delivery Date
fldlogssuplritemhealthstate FLOG_SUPLRITEM_HEALTH_STATE SuplrItemHealthSt
fldlogssuplritmchangedatetime FLOG_CHANGEDAT Changed On
fldlogssuplritmpackggtypecode FLOG_SUPLRITEM_PACKGG_TYPE Packaging Type
fldlogssupplyprocess FLOG_SPROC Supply Process
packagingmaterial /SCWM/DE_PMAT Pack. Material
fldlogssealnumber1 /SCWM/DE_SEAL_NUM Seal Number
fldlogssealnumber2 /SCWM/DE_SEAL_NUM Seal Number
fldlogssealnumber3 /SCWM/DE_SEAL_NUM Seal Number
fldlogssealnumber4 /SCWM/DE_SEAL_NUM Seal Number
fldlogssealnumber5 /SCWM/DE_SEAL_NUM Seal Number
fldlogscontainerowner BU_PARTNER Busn. Partner
fldlogssupplieritemsource FLOG_SUPLRITEM_SOURCE_IND source ind
fldlogstransfertype FLOG_TRANSFER_TYPE Transfer Type
fieldlogisticstransferplant WERKS_D Plant
dummy_suplritm_ps CFD_DUMMY Dummy

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.

-- Field Logistics: Supplier Item Repository
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_SUPLRITEM (
    CLIENT,                          -- Client [MANDT]
    FLDLOGSSUPLRITEMUUID,            -- Suplr Item UUID [FLOG_SUPLRITEM_UUID]
    FLDLOGSSUPLRITEMTYPE,            -- Suplr Item Type [FLOG_SUPLRITEM_TYPE]
    FLDLOGSSUPLRPARENTITEMUUID,      -- Suplr Item UUID [FLOG_SUPLRITEM_UUID]
    FLDLOGSSUPLRITEMSERIALNUMBER,    -- Manuf. SerialNr [FLOG_SUPLRITEM_SERIALNMBR]
    FLDLOGSSUPLRITEMNAME,            -- Suplr Item Name [FLOG_SUPLRITEM_NAME]
    PREFERREDSUPPLIER,               -- Supplier [LIFNR]
    FLDLOGSSUPLRBASEPLANT,           -- Plant [WERKS_D]
    FLDLOGSREMOTEPLANT,              -- Plant [WERKS_D]
    FLDLOGSSUPLRITMPOITMUNIQUEID,    -- PO Item Uniq ID [FLOG_PURORDITEM_UNIQUE_ID]
    FLDLOGSSUPLRITEMVISLINSPCODE,    -- Visual Inspection [FLOG_SUPLRITEM_VISL_INSP_CODE]
    PURGDOCNETPRICEAMOUNT,           -- Net Price [BPREI]
    FLDLOGSSUPLRITEMRATEUNIT,        -- Currency [WAERS]
    FLDLOGSSUPLRITEMQUANTITY,        -- Quantity [MENGE_D]
    FLDLOGSSUPLRITEMQUANTITYUNIT,    -- Base Unit [MEINS]
    FLDLOGSSUPLRITEMGROSSVOLUME,     -- Volume [VOLUM]
    FLDLOGSSUPLRITMGROSSVOLUMEUNIT,  -- Volume Unit [VOLEH]
    PRODUCTGROSSWEIGHT,              -- Gross Weight [BRGEW]
    PRODUCTWEIGHTUNIT,               -- Unit of Weight [GEWEI]
    FLDLOGSSUPLRITEMLENGTH,          -- Length [LAENG]
    FLDLOGSSUPLRITEMWIDTH,           -- Width [BREIT]
    FLDLOGSSUPLRITEMHEIGHT,          -- Height [HOEHE]
    FLDLOGSSUPLRITEMMEASUREUNIT,     -- Unit [MEABM]
    FLDLOGSSUPLRITEMSTATUSID,        -- Suplr Item Status ID [FLOG_SUPLRITEM_STATUS_ID]
    ITEMISDANGEROUSGOOD,             -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    DANGEROUSGOODSIDNNUMBERCNCTNTD,  -- DG IDNo ConCat [FLOG_SUPLRITM_DGIDNNMBRCNCTNTD]
    FLDLOGSISWORKORDERONHOLD,        -- WorkOrderOnHold [FLOG_WRK_ORD_ON_HOLD]
    FLDLOGSSUPLRITEMPLNDDELIVDATE,   -- Delivery Date [EINDT]
    FLDLOGSSUPLRITEMHEALTHSTATE,     -- SuplrItemHealthSt [FLOG_SUPLRITEM_HEALTH_STATE]
    FLDLOGSSUPLRITMCHANGEDATETIME,   -- Changed On [FLOG_CHANGEDAT]
    FLDLOGSSUPLRITMPACKGGTYPECODE,   -- Packaging Type [FLOG_SUPLRITEM_PACKGG_TYPE]
    FLDLOGSSUPPLYPROCESS,            -- Supply Process [FLOG_SPROC]
    PACKAGINGMATERIAL,               -- Pack. Material [/SCWM/DE_PMAT]
    FLDLOGSSEALNUMBER1,              -- Seal Number [/SCWM/DE_SEAL_NUM]
    FLDLOGSSEALNUMBER2,              -- Seal Number [/SCWM/DE_SEAL_NUM]
    FLDLOGSSEALNUMBER3,              -- Seal Number [/SCWM/DE_SEAL_NUM]
    FLDLOGSSEALNUMBER4,              -- Seal Number [/SCWM/DE_SEAL_NUM]
    FLDLOGSSEALNUMBER5,              -- Seal Number [/SCWM/DE_SEAL_NUM]
    FLDLOGSCONTAINEROWNER,           -- Busn. Partner [BU_PARTNER]
    FLDLOGSSUPPLIERITEMSOURCE,       -- source ind [FLOG_SUPLRITEM_SOURCE_IND]
    FLDLOGSTRANSFERTYPE,             -- Transfer Type [FLOG_TRANSFER_TYPE]
    FIELDLOGISTICSTRANSFERPLANT,     -- Plant [WERKS_D]
    DUMMY_SUPLRITM_PS,               -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, FLDLOGSSUPLRITEMUUID)
);

Learn More