R_FldLogsNonStockReturnItemTP

DDL: R_FLDLOGSNONSTOCKRETURNITEMTP Type: view_entity TRANSACTIONAL
32 Fields 1 Data Sources 3 Associations

Non-Stock Return Item

R_FldLogsNonStockReturnItemTP is a Transactional CDS View that provides data about "Non-Stock Return Item" in SAP S/4HANA. It reads from 1 data source (I_FldLogsNonStockReturnItem) and exposes 32 fields with key fields MaintenanceOrder, Product, Plant, ReservationItem, Reservation. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsNonStockReturnItem I_FldLogsNonStockReturnItem from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_RecommendedActionText _ActionText $projection.FldLogsRecommendedAction = _ActionText.FldLogsRecommendedAction
[0..1] I_StorageLocation _RemoteStorageLocationText $projection.RemoteStorageLocation = _RemoteStorageLocationText.StorageLocation and $projection.Plant = _RemoteStorageLocationText.Plant
[0..1] I_FldLogsReturnStatusT _RetStatText $projection.FldLogsReturnStatus = _RetStatText.FldLogsReturnStatus

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Non-Stock Return Item view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
KEY ReservationItem ReservationItem Reservation Item
KEY Reservation Reservation Reservation
KEY MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
KEY FldLogsMaintOrderComponent FldLogsMaintOrderComponent
KEY FldLogsSuplrItemUUID FldLogsSuplrItemUUID Suplr Item UUID
KEY MaintComponentItemCategory MaintComponentItemCategory
KEY AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
FldLogsMaintenanceOrder FldLogsMaintenanceOrder
FldLogsSuplrItemName FldLogsSuplrItemName Suplr Item Name
FldLogsRemotePlant FldLogsRemotePlant Plant
PurchasingDocument PurchasingDocument Purchasing Document
FldLogsSuplrItemSerialNumber FldLogsSuplrItemSerialNumber Manuf. SerialNr
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
ProcmtHubReferencePurOrder ProcmtHubReferencePurOrder Purchasing Doc.
ProcmtHubReferencePurOrderItm ProcmtHubReferencePurOrderItm Item
RemoteStorageLocation RemoteStorageLocation
FldLogsRecommendedAction FldLogsRecommendedAction Recommended Action
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
OrderQuantityUnit OrderQuantityUnit Sales Unit
FldLogsSuplrItemQuantity FldLogsSuplrItemQuantity Quantity
FldLogsSuplrItemQuantityUnit FldLogsSuplrItemQuantityUnit Base Unit
EntryUnit EntryUnit Unit of Entry
RetblQtyInOrderUnit _ReturnBasic RetblQtyInOrderUnit
RetblQtyOrderUnit _ReturnBasic RetblQtyOrderUnit
MaintenanceOrderCategory MaintenanceOrderCategory
_Product _Product
_RetStatText _RetStatText
_ActionText _ActionText
_RemoteStorageLocationText _RemoteStorageLocationText

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 R_FldLogsNonStockReturnItemTP.
-- 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 R_FldLogsNonStockReturnItemTP AS
SELECT
  MaintenanceOrder,
  Product,
  Plant,
  ReservationItem,
  Reservation,
  MaintenanceOrderOperation,
  FldLogsMaintOrderComponent,
  FldLogsSuplrItemUUID,
  MaintComponentItemCategory,
  AccountAssignmentCategory,
  FldLogsMaintenanceOrder,
  FldLogsSuplrItemName,
  FldLogsRemotePlant,
  PurchasingDocument,
  FldLogsSuplrItemSerialNumber,
  PurchasingDocumentItem,
  ProcmtHubReferencePurOrder,
  ProcmtHubReferencePurOrderItm,
  RemoteStorageLocation,
  FldLogsRecommendedAction,
  FldLogsSupplyProcess,
  OrderQuantityUnit,
  FldLogsSuplrItemQuantity,
  FldLogsSuplrItemQuantityUnit,
  EntryUnit,
  _ReturnBasic.RetblQtyInOrderUnit AS RetblQtyInOrderUnit,
  _ReturnBasic.RetblQtyOrderUnit AS RetblQtyOrderUnit,
  MaintenanceOrderCategory
FROM I_FldLogsNonStockReturnItem
LEFT OUTER JOIN I_RecommendedActionText AS _ActionText ON FldLogsRecommendedAction = _ActionText.FldLogsRecommendedAction  -- association [0..*]
LEFT OUTER JOIN I_StorageLocation AS _RemoteStorageLocationText ON RemoteStorageLocation = _RemoteStorageLocationText.StorageLocation AND Plant = _RemoteStorageLocationText.Plant  -- association [0..1]
LEFT OUTER JOIN I_FldLogsReturnStatusT AS _RetStatText ON FldLogsReturnStatus = _RetStatText.FldLogsReturnStatus  -- association [0..1]
;

Learn More