FLOG_PROCRET_D
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 62 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_FldLogsReturnedItemDraft | view_entity | from | EXTENSION | FldLog ProcRetItmDrft - Extn |
| R_FldLogsProcReturnHeaderDraft | view_entity | from | BASIC | Draft Query View : FieldLogsProcessReturnHeader |
Fields (62)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | ||||
| 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 | abap.char | |||||
| 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 | ||||
| semanticobject | char20 | Char20 | ||||
| ordercategory | auftyp | Order category |
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]
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]
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, -- abap.char
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]
SEMANTICOBJECT, -- Char20 [char20]
ORDERCATEGORY, -- Order category [auftyp]
PRIMARY KEY (MANDT, FLDLOGSRETURNHEADERUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA