I_FLDLOGSPROCRCPTSRCHENBLD

CDS View

Field Logistics Process Receipts

I_FLDLOGSPROCRCPTSRCHENBLD is a CDS View in S/4HANA. Field Logistics Process Receipts. It contains 90 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FldLogsOvrdItemsByItemType view_entity from COMPOSITE Calculate Overdue receipts by Item type
I_FldLogsProcessReceiptsTP view from TRANSACTIONAL Field Logistics : Process Receipts

Fields (90)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument DeliveryDocument 1
KEY DeliveryDocumentItem DeliveryDocumentItem 1
KEY FldLogsSuplrItemUUID FldLogsSuplrItemUUID 1
KEY MaterialDocument MaterialDocument 1
KEY MaterialDocumentItem MaterialDocumentItem 1
KEY MaterialDocumentYear MaterialDocumentYear 1
Batch Batch 1
CreatedByUser CreatedByUser 1
DeliveryDate DeliveryDate 2
DeliveryDocumentBySupplier DeliveryDocumentBySupplier 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
EWMWarehouse EWMWarehouse 1
FldLogsActlDeliveredQuantity FldLogsActlDeliveredQuantity 1
FldLogsBlockedQty FldLogsBlockedQty 1
FldLogsDelivDocItem FldLogsDelivDocItem 1
FldLogsDelivIsHeldOnShore FldLogsDelivIsHeldOnShore 1
FldLogsDelivQty FldLogsDelivQty 1
FldLogsEWMStockType FldLogsEWMStockType 1
FldLogsGRQty FldLogsGRQty 1
FldLogsIsContainerHidden FldLogsIsContainerHidden 1
FldLogsIsValnType FldLogsIsValnType 1
FldLogsItemType FldLogsItemType 2
FldLogsItmIsAtRemote FldLogsItmIsAtRemote 1
FldLogsItmIsFailed FldLogsItmIsFailed 1
FldLogsItmIsPreReceived FldLogsItmIsPreReceived 1
FldLogsItmIsReceived FldLogsItmIsReceived 1
FldLogsItmIsToBeReceived FldLogsItmIsToBeReceived 1
FldLogsManufactureDate FldLogsManufactureDate 1
FldLogsOpenDelivQty FldLogsOpenDelivQty 1
FldLogsOpenPackQty FldLogsOpenPackQty 1
FldLogsPOTotalQty FldLogsPOTotalQty 1
FldLogsProcRcptExtUnionID FldLogsProcRcptExtUnionID 1
FldLogsProcRecRcvgStatus FldLogsProcRecRcvgStatus 1
FldLogsPurOrdItem FldLogsPurOrdItem 1
FldLogsPutawayQty FldLogsPutawayQty 1
FldLogsRemotePlant FldLogsRemotePlant 1
FldLogsReversedQty FldLogsReversedQty 1
FldLogsShelfLifeExpiryDate FldLogsShelfLifeExpiryDate 1
FldLogsStatus FldLogsStatus 1
FldLogsStatusFrmEWMInbDeliv FldLogsStatusFrmEWMInbDeliv 1
FldLogsSuplrItemVislInspCode FldLogsSuplrItemVislInspCode 1
FldLogsSuplrItmMatlDoc FldLogsSuplrItmMatlDoc 1
GoodsMovementEntryUnit GoodsMovementEntryUnit 1
GoodsMovementItem GoodsMovementItem 1
GoodsMovementStatus GoodsMovementStatus 1
GoodsMovementType GoodsMovementType 1
GoodsMovementYear GoodsMovementYear 1
GoodsRecipientName GoodsRecipientName 1
HandlingUnitExternalID HandlingUnitExternalID 1
HandlingUnitId HandlingUnitId 1
InventoryStockType InventoryStockType 1
InventoryStockTypeName InventoryStockTypeName 1
InventoryUsabilityCode InventoryUsabilityCode,StockType 1
InventoryValuationType InventoryValuationType 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
IsBusPrpsCmpltdCustomer IsBusPrpsCmpltdCustomer 1
IsCompletelyDelivered IsCompletelyDelivered 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin 1
LoadingPoint LoadingPoint 1
MaintenanceOrder MaintenanceOrder 1
MaintPriority MaintPriority 1
Material Material 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialDocumentHeaderText MaterialDocumentHeaderText 1
MaterialGroup MaterialGroup 1
MaterialIsSerialManaged MaterialIsSerialManaged 1
MaterialName MaterialName 1
NetPriceAmount NetPriceAmount 1
OpenQtyInPurchaseOrderUnit OpenQtyInPurchaseOrderUnit 1
OrderCategory OrderCategory 1
OrderQuantityUnit OrderQuantityUnit 1
OutboundDelivery OutboundDelivery 1
OutboundDeliveryItem OutboundDeliveryItem 1
PickingStatus PickingStatus 1
PlanningMaterialBaseUnit PlanningMaterialBaseUnit 1
Plant Plant 1
PostingDate PostingDate 1
POUnitOfMeasure POUnitOfMeasure 1
PurchaseRequisition PurchaseRequisition 1
PurchasingDocumentSubtype PurchasingDocumentSubtype 1
QltyMgmtInProcmtIsActive QltyMgmtInProcmtIsActive 1
RequisitionerName RequisitionerName 1
ReversedMaterialDocument ReversedMaterialDocument 1
StorageLocation StorageLocation 1
SuplrCoIsBusPrpsCmpltd SuplrCoIsBusPrpsCmpltd 1
Supplier Supplier 1
UnloadingPointName UnloadingPointName 1

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 Process Receipts
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FLDLOGSPROCRCPTSRCHENBLD (
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    FLDLOGSSUPLRITEMUUID,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    BATCH,
    CREATEDBYUSER,
    DELIVERYDATE,
    DELIVERYDOCUMENTBYSUPPLIER,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EWMWAREHOUSE,
    FLDLOGSACTLDELIVEREDQUANTITY,
    FLDLOGSBLOCKEDQTY,
    FLDLOGSDELIVDOCITEM,
    FLDLOGSDELIVISHELDONSHORE,
    FLDLOGSDELIVQTY,
    FLDLOGSEWMSTOCKTYPE,
    FLDLOGSGRQTY,
    FLDLOGSISCONTAINERHIDDEN,
    FLDLOGSISVALNTYPE,
    FLDLOGSITEMTYPE,
    FLDLOGSITMISATREMOTE,
    FLDLOGSITMISFAILED,
    FLDLOGSITMISPRERECEIVED,
    FLDLOGSITMISRECEIVED,
    FLDLOGSITMISTOBERECEIVED,
    FLDLOGSMANUFACTUREDATE,
    FLDLOGSOPENDELIVQTY,
    FLDLOGSOPENPACKQTY,
    FLDLOGSPOTOTALQTY,
    FLDLOGSPROCRCPTEXTUNIONID,
    FLDLOGSPROCRECRCVGSTATUS,
    FLDLOGSPURORDITEM,
    FLDLOGSPUTAWAYQTY,
    FLDLOGSREMOTEPLANT,
    FLDLOGSREVERSEDQTY,
    FLDLOGSSHELFLIFEEXPIRYDATE,
    FLDLOGSSTATUS,
    FLDLOGSSTATUSFRMEWMINBDELIV,
    FLDLOGSSUPLRITEMVISLINSPCODE,
    FLDLOGSSUPLRITMMATLDOC,
    GOODSMOVEMENTENTRYUNIT,
    GOODSMOVEMENTITEM,
    GOODSMOVEMENTSTATUS,
    GOODSMOVEMENTTYPE,
    GOODSMOVEMENTYEAR,
    GOODSRECIPIENTNAME,
    HANDLINGUNITEXTERNALID,
    HANDLINGUNITID,
    INVENTORYSTOCKTYPE,
    INVENTORYSTOCKTYPENAME,
    INVENTORYUSABILITYCODE,
    INVENTORYVALUATIONTYPE,
    ISBUSINESSPURPOSECOMPLETED,
    ISBUSPRPSCMPLTDCUSTOMER,
    ISCOMPLETELYDELIVERED,
    ISENDOFPURPOSEBLOCKED,
    ISTOBEACCEPTEDATORIGIN,
    LOADINGPOINT,
    MAINTENANCEORDER,
    MAINTPRIORITY,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALDOCUMENTHEADERTEXT,
    MATERIALGROUP,
    MATERIALISSERIALMANAGED,
    MATERIALNAME,
    NETPRICEAMOUNT,
    OPENQTYINPURCHASEORDERUNIT,
    ORDERCATEGORY,
    ORDERQUANTITYUNIT,
    OUTBOUNDDELIVERY,
    OUTBOUNDDELIVERYITEM,
    PICKINGSTATUS,
    PLANNINGMATERIALBASEUNIT,
    PLANT,
    POSTINGDATE,
    POUNITOFMEASURE,
    PURCHASEREQUISITION,
    PURCHASINGDOCUMENTSUBTYPE,
    QLTYMGMTINPROCMTISACTIVE,
    REQUISITIONERNAME,
    REVERSEDMATERIALDOCUMENT,
    STORAGELOCATION,
    SUPLRCOISBUSPRPSCMPLTD,
    SUPPLIER,
    UNLOADINGPOINTNAME,
    PRIMARY KEY (DELIVERYDOCUMENT, DELIVERYDOCUMENTITEM, FLDLOGSSUPLRITEMUUID, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR)
);