I_FldLogsNonStockReturnItem

DDL: I_FLDLOGSNONSTOCKRETURNITEM Type: view_entity COMPOSITE
33 Fields 2 Data Sources 2 Associations

Field Logistics Non-Stock Return Item

I_FldLogsNonStockReturnItem is a Composite CDS View that provides data about "Field Logistics Non-Stock Return Item" in SAP S/4HANA. It reads from 2 data sources (I_FldLogsPurDocByPurReqn, I_FldLogsSupplierItemRecord) and exposes 33 fields with key field FldLogsSuplrItemUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_FldLogsPurDocByPurReqn _PurDocByPurReqn from
I_FldLogsSupplierItemRecord _SupplierItem inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FldLogsDefaultQuickAction _DefaultQuickAction $projection.FldLogsSupplyProcess = _DefaultQuickAction.FldLogsSupplyProcess and _DefaultQuickAction.FieldLogisticsProcessType = abap.char'20'
[0..1] I_FldLogsFlogReturnBasic _ReturnBasic _SupplierItem.FldLogsSuplrItemUUID = _ReturnBasic.FldLogsSuplrItemUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label Field Logistics Non-Stock Return Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY FldLogsSuplrItemUUID I_FldLogsSupplierItemRecord FldLogsSuplrItemUUID Suplr Item UUID
FldLogsSuplrItemSerialNumber I_FldLogsSupplierItemRecord FldLogsSuplrItemSerialNumber Manuf. SerialNr
Product I_FldLogsPurDocByPurReqn Product Product Sold
FldLogsSuplrItemName I_FldLogsSupplierItemRecord FldLogsSuplrItemName Suplr Item Name
FldLogsSuplrBasePlant I_FldLogsSupplierItemRecord FldLogsSuplrBasePlant Plant
FldLogsRemotePlant I_FldLogsSupplierItemRecord FldLogsRemotePlant Plant
PurchasingDocument I_FldLogsSupplierItemRecord PurchasingDocument Purchasing Document
FldLogsSuplrItemStatusID I_FldLogsSupplierItemRecord FldLogsSuplrItemStatusID Suplr Item Status ID
FldLogsSuplrItemType I_FldLogsSupplierItemRecord FldLogsSuplrItemType Suplr Item Type
FldLogsMilestoneEventType I_FldLogsSupplierItemRecord FldLogsMilestoneEventType
FldLogsMaintenanceOrder I_FldLogsPurDocByPurReqn FldLogsMaintenanceOrder
MaintenanceOrder I_FldLogsPurDocByPurReqn FldLogsMaintenanceOrder
Plant I_FldLogsPurDocByPurReqn Plant Valuation Area
Reservation I_FldLogsPurDocByPurReqn Reservation Reservation
ReservationItem I_FldLogsPurDocByPurReqn ReservationItem Reservation Item
RequiredQuantityendasRequiredQuantity
OrderQuantityUnit I_FldLogsPurDocByPurReqn OrderQuantityUnit Sales Unit
PurchasingDocumentItem I_FldLogsSupplierItemRecord PurchasingDocumentItem Purchasing Doc. Item
FldLogsSupplyProcess I_FldLogsSupplierItemRecord FldLogsSupplyProcess Supply Process
FldLogsRecommendedAction _DefaultQuickAction FldLogsRecommendedAction Recommended Action
FldLogsSuplrItemQuantity I_FldLogsSupplierItemRecord FldLogsSuplrItemQuantity Quantity
RetblQtyOrderUnit
FldLogsSuplrItemQuantityUnit I_FldLogsSupplierItemRecord FldLogsSuplrItemQuantityUnit Base Unit
MaintenanceOrderOperation
FldLogsMaintOrderComponent
ProcmtHubReferencePurOrder I_FldLogsSupplierItemRecord ProcmtHubReferencePurOrder Purchasing Doc.
ProcmtHubReferencePurOrderItm I_FldLogsSupplierItemRecord ProcmtHubReferencePurOrderItm Item
MaintComponentItemCategory I_FldLogsPurDocByPurReqn MaintComponentItemCategory
AccountAssignmentCategory I_FldLogsPurDocByPurReqn AccountAssignmentCategory Acct Assgmt Cat
MaintenanceOrderCategory I_FldLogsPurDocByPurReqn MaintenanceOrderCategory
_ReturnBasic _ReturnBasic
EntryUnit
ActualDeliveryQuantity

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FldLogsNonStockReturnItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_FldLogsNonStockReturnItem AS
SELECT
  _SupplierItem.FldLogsSuplrItemUUID AS FldLogsSuplrItemUUID,
  _SupplierItem.FldLogsSuplrItemSerialNumber AS FldLogsSuplrItemSerialNumber,
  _PurDocByPurReqn.Product AS Product,
  _SupplierItem.FldLogsSuplrItemName AS FldLogsSuplrItemName,
  _SupplierItem.FldLogsSuplrBasePlant AS FldLogsSuplrBasePlant,
  _SupplierItem.FldLogsRemotePlant AS FldLogsRemotePlant,
  _SupplierItem.PurchasingDocument AS PurchasingDocument,
  _SupplierItem.FldLogsSuplrItemStatusID AS FldLogsSuplrItemStatusID,
  _SupplierItem.FldLogsSuplrItemType AS FldLogsSuplrItemType,
  _SupplierItem.FldLogsMilestoneEventType AS FldLogsMilestoneEventType,
  _PurDocByPurReqn.FldLogsMaintenanceOrder AS FldLogsMaintenanceOrder,
  _PurDocByPurReqn.FldLogsMaintenanceOrder AS MaintenanceOrder,
  _PurDocByPurReqn.Plant AS Plant,
  _PurDocByPurReqn.Reservation AS Reservation,
  _PurDocByPurReqn.ReservationItem AS ReservationItem,
  case when _SupplierItem.FldLogsSupplyProcess = 'SERV' then _SupplierItem.FldLogsSuplrItemQuantity else _PurDocByPurReqn.RequiredQuantity end as RequiredQuantity AS RequiredQuantityendasRequiredQuantity,
  _PurDocByPurReqn.OrderQuantityUnit AS OrderQuantityUnit,
  _SupplierItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  _SupplierItem.FldLogsSupplyProcess AS FldLogsSupplyProcess,
  _DefaultQuickAction.FldLogsRecommendedAction AS FldLogsRecommendedAction,
  _SupplierItem.FldLogsSuplrItemQuantity AS FldLogsSuplrItemQuantity,
  cast( _SupplierItem.FldLogsSuplrItemQuantityUnit as flog_ounit ) AS RetblQtyOrderUnit,
  _SupplierItem.FldLogsSuplrItemQuantityUnit AS FldLogsSuplrItemQuantityUnit,
  cast( _SupplierItem._SupplierItemAux[FldLogsAuxPrflID = 'REL_DOC' and FldLogsAuxSubTypeCode = 'PMO_OPR'].FldLogsAuxValue as abap.char( 4 ) ) AS MaintenanceOrderOperation,
  cast( _SupplierItem._SupplierItemAux[FldLogsAuxPrflID = 'REL_DOC' and FldLogsAuxSubTypeCode = 'PMO_COMP'].FldLogsAuxValue as abap.char( 4 )) AS FldLogsMaintOrderComponent,
  _SupplierItem.ProcmtHubReferencePurOrder AS ProcmtHubReferencePurOrder,
  _SupplierItem.ProcmtHubReferencePurOrderItm AS ProcmtHubReferencePurOrderItm,
  _PurDocByPurReqn.MaintComponentItemCategory AS MaintComponentItemCategory,
  _PurDocByPurReqn.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurDocByPurReqn.MaintenanceOrderCategory AS MaintenanceOrderCategory,
  cast( _SupplierItem._MaterialDocumentItem.EntryUnit as meins ) AS EntryUnit,
  _SupplierItem._MaterialDocumentItem.QuantityInEntryUnit AS ActualDeliveryQuantity
FROM I_FldLogsPurDocByPurReqn AS _PurDocByPurReqn
INNER JOIN I_FldLogsSupplierItemRecord AS _SupplierItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FldLogsDefaultQuickAction AS _DefaultQuickAction ON FldLogsSupplyProcess = _DefaultQuickAction.FldLogsSupplyProcess AND _DefaultQuickAction.FieldLogisticsProcessType = abap.char'20'  -- association [0..1]
LEFT OUTER JOIN I_FldLogsFlogReturnBasic AS _ReturnBasic ON _SupplierItem.FldLogsSuplrItemUUID = _ReturnBasic.FldLogsSuplrItemUUID  -- association [0..1]
;

Learn More