FLOG_PROCRET_D

Transparent Table Application Table
72 Fields 2 CDS Views

Draft table for entity R_FLDLOGSPROCESSRETURNHEADERTP

FLOG_PROCRET_D is an SAP database table in S/4HANA. Draft table for entity R_FLDLOGSPROCESSRETURNHEADERTP. It contains 72 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FldLogsReturnedItemDraft view_entity from EXTENSION FldLog ProcRetItmDrft - Extn
R_FldLogsProcReturnHeaderDraft view_entity from BASIC Draft Query View : FieldLogsProcessReturnHeader

Fields (72)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fldlogsreturnheaderuuid FLOG_RETURNHEADER_UUID Return Header UUID
fldlogscontainerid FLOG_CONTID Container ID
dispatchedstartdate FLOG_DISPDAT Dispatch Date
fldlogsdispatchplant WERKS_D Plant
numberofctntripsperday FLOG_TRIPCNT Trip Counter
fldlogsreferencedocumentnumber FLOG_REFDOC Reference Doc Number
fldlogsreferenceobjectnumber FLOG_REFDOC Reference Doc Number
fldlogsshptitemuuid FLOG_SHPTITEM_ID Shipment Item ID
fldlogsshptitmhndlgunitid FLOG_SHPTITEM_HNDLGUNIT_ID Handling Unit ID
handlingunitexternalid EXIDV Handling Unit
material MATNR Material
receiptdate EDI_WEDKD Goods receipt date
fldlogsretdqtyinorderunit FLOG_QUANTITY Quantity
fldlogsqtyinprocess FLOG_QUANTITY Quantity
fldlogsretdqtyorderunit FLOG_OUNIT Order Unit
fldlogssupplyprocess FLOG_SPROC Supply Process
fldlogsctnquickaction FLOG_QK_ACTION Handling Decision
fldlogsreturneditemstatus FLOG_RETURNITEM_STATUS Return Item Status
fldlogskititmrefdocument2 FLOG_DOC Reference Doc Number
referencedocumentitem VGPOS Reference Item
fldlogsretitmstatuscriticality INT1 INT1
fldlogsisupdatehidden BOOLE_D TRUE
orderid AUFNR Order
fldlogsshptvoyagenumber FLOG_SHPTVOYAGE_NUMBER Voyage Number
fldlogsrecommendedaction FLOG_RT_ACTION Recommended Action
materialdocument MBLNR Material Doc.
materialdocumentyear MJAHR Mat. Doc. Year
materialdocumentitem MBLPO Mat. Doc.Item
fieldlogisticsprocesstype FLOG_PROCESS_TYPE Process Type
batch CHARG_D Batch
changelogrefobjid CHAR90 CHAR90
valuationtype BWTAR_D Valuation Type
serialnumber GERNR Serial Number
reservation RSNUM Reservation
reservationitem RSPOS Item no.
fldlogsrefurbishmentorder AUFNR Order
referencesddocument VGBEL Reference Doc.
referencesddocumentitem VGPOS Reference Item
purchasingdocumentitem EBELP Item
fldlogsreturnprocgcomment FLOG_RT_CMNTS Comments
warehousestoragebin LGPBE Storage Bin
wbselementexternalid PS_POSID_EDIT WBS Element
inventoryspecialstocktype KNTTP Acct Assgmt Cat
fldlogssuplritemuuid FLOG_SUPLRITEM_UUID Suplr Item UUID
outbounddelivery VBELN_VL Delivery
outbounddeliveryitem POSNR_VL Item
referencepurchasingdocument EBELN Purchasing Doc.
ismarkedfordeletion FLOG_DELETE Delete
lastchangedatetime FLOG_CHANGEDAT Changed On
locallastchangedatetime FLOG_LOCALCHANGEDAT Changed On
operation abap.char
purchaseorder EBELN Purchasing Doc.
purchaseorderitem EBELP Item
fldlogssrcestorlocid LGORT_D Location
fldlogsdeststorlocid LGORT_D Location
fldlogssrceplnt WERKS_D Plant
fldlogsdestplnt WERKS_D Plant
fldlogsretitminactvcriticality INT1 INT1
fldlogsissingleplant BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
inbounddelivery VBELN_VL Delivery
inbounddeliveryitem POSNR_VL Item
ordercategory AUFTYP Order category
semanticobject CHAR20 Char20
materialname MAKTX Description
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
dummy_procrethdr_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.

-- Draft table for entity R_FLDLOGSPROCESSRETURNHEADERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_PROCRET_D (
    MANDT,                           -- Client [MANDT]
    FLDLOGSRETURNHEADERUUID,         -- Return Header UUID [FLOG_RETURNHEADER_UUID]
    FLDLOGSCONTAINERID,              -- Container ID [FLOG_CONTID]
    DISPATCHEDSTARTDATE,             -- Dispatch Date [FLOG_DISPDAT]
    FLDLOGSDISPATCHPLANT,            -- Plant [WERKS_D]
    NUMBEROFCTNTRIPSPERDAY,          -- Trip Counter [FLOG_TRIPCNT]
    FLDLOGSREFERENCEDOCUMENTNUMBER,  -- Reference Doc Number [FLOG_REFDOC]
    FLDLOGSREFERENCEOBJECTNUMBER,    -- Reference Doc Number [FLOG_REFDOC]
    FLDLOGSSHPTITEMUUID,             -- Shipment Item ID [FLOG_SHPTITEM_ID]
    FLDLOGSSHPTITMHNDLGUNITID,       -- Handling Unit ID [FLOG_SHPTITEM_HNDLGUNIT_ID]
    HANDLINGUNITEXTERNALID,          -- Handling Unit [EXIDV]
    MATERIAL,                        -- Material [MATNR]
    RECEIPTDATE,                     -- Goods receipt date [EDI_WEDKD]
    FLDLOGSRETDQTYINORDERUNIT,       -- Quantity [FLOG_QUANTITY]
    FLDLOGSQTYINPROCESS,             -- Quantity [FLOG_QUANTITY]
    FLDLOGSRETDQTYORDERUNIT,         -- Order Unit [FLOG_OUNIT]
    FLDLOGSSUPPLYPROCESS,            -- Supply Process [FLOG_SPROC]
    FLDLOGSCTNQUICKACTION,           -- Handling Decision [FLOG_QK_ACTION]
    FLDLOGSRETURNEDITEMSTATUS,       -- Return Item Status [FLOG_RETURNITEM_STATUS]
    FLDLOGSKITITMREFDOCUMENT2,       -- Reference Doc Number [FLOG_DOC]
    REFERENCEDOCUMENTITEM,           -- Reference Item [VGPOS]
    FLDLOGSRETITMSTATUSCRITICALITY,  -- INT1 [INT1]
    FLDLOGSISUPDATEHIDDEN,           -- TRUE [BOOLE_D]
    ORDERID,                         -- Order [AUFNR]
    FLDLOGSSHPTVOYAGENUMBER,         -- Voyage Number [FLOG_SHPTVOYAGE_NUMBER]
    FLDLOGSRECOMMENDEDACTION,        -- Recommended Action [FLOG_RT_ACTION]
    MATERIALDOCUMENT,                -- Material Doc. [MBLNR]
    MATERIALDOCUMENTYEAR,            -- Mat. Doc. Year [MJAHR]
    MATERIALDOCUMENTITEM,            -- Mat. Doc.Item [MBLPO]
    FIELDLOGISTICSPROCESSTYPE,       -- Process Type [FLOG_PROCESS_TYPE]
    BATCH,                           -- Batch [CHARG_D]
    CHANGELOGREFOBJID,               -- CHAR90 [CHAR90]
    VALUATIONTYPE,                   -- Valuation Type [BWTAR_D]
    SERIALNUMBER,                    -- Serial Number [GERNR]
    RESERVATION,                     -- Reservation [RSNUM]
    RESERVATIONITEM,                 -- Item no. [RSPOS]
    FLDLOGSREFURBISHMENTORDER,       -- Order [AUFNR]
    REFERENCESDDOCUMENT,             -- Reference Doc. [VGBEL]
    REFERENCESDDOCUMENTITEM,         -- Reference Item [VGPOS]
    PURCHASINGDOCUMENTITEM,          -- Item [EBELP]
    FLDLOGSRETURNPROCGCOMMENT,       -- Comments [FLOG_RT_CMNTS]
    WAREHOUSESTORAGEBIN,             -- Storage Bin [LGPBE]
    WBSELEMENTEXTERNALID,            -- WBS Element [PS_POSID_EDIT]
    INVENTORYSPECIALSTOCKTYPE,       -- Acct Assgmt Cat [KNTTP]
    FLDLOGSSUPLRITEMUUID,            -- Suplr Item UUID [FLOG_SUPLRITEM_UUID]
    OUTBOUNDDELIVERY,                -- Delivery [VBELN_VL]
    OUTBOUNDDELIVERYITEM,            -- Item [POSNR_VL]
    REFERENCEPURCHASINGDOCUMENT,     -- Purchasing Doc. [EBELN]
    ISMARKEDFORDELETION,             -- Delete [FLOG_DELETE]
    LASTCHANGEDATETIME,              -- Changed On [FLOG_CHANGEDAT]
    LOCALLASTCHANGEDATETIME,         -- Changed On [FLOG_LOCALCHANGEDAT]
    OPERATION,                       -- abap.char
    PURCHASEORDER,                   -- Purchasing Doc. [EBELN]
    PURCHASEORDERITEM,               -- Item [EBELP]
    FLDLOGSSRCESTORLOCID,            -- Location [LGORT_D]
    FLDLOGSDESTSTORLOCID,            -- Location [LGORT_D]
    FLDLOGSSRCEPLNT,                 -- Plant [WERKS_D]
    FLDLOGSDESTPLNT,                 -- Plant [WERKS_D]
    FLDLOGSRETITMINACTVCRITICALITY,  -- INT1 [INT1]
    FLDLOGSISSINGLEPLANT,            -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    INBOUNDDELIVERY,                 -- Delivery [VBELN_VL]
    INBOUNDDELIVERYITEM,             -- Item [POSNR_VL]
    ORDERCATEGORY,                   -- Order category [AUFTYP]
    SEMANTICOBJECT,                  -- Char20 [CHAR20]
    MATERIALNAME,                    -- Description [MAKTX]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_PROCRETHDR_PS,             -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FLDLOGSRETURNHEADERUUID)
);

Learn More