R_FldLogsOrdResvnItmQtyTP

DDL: R_FLDLOGSORDRESVNITMQTYTP Type: view_entity TRANSACTIONAL
32 Fields 2 Associations

View to change qty for reservation itm

R_FldLogsOrdResvnItmQtyTP is a Transactional CDS View that provides data about "View to change qty for reservation itm" in SAP S/4HANA. It has 2 associations to related views.

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FldLogsStorLocation _StorageBin $projection.Product = _StorageBin.Material and $projection.Plant = _StorageBin.Plant and $projection.RemoteStorageLocation = _StorageBin.StorageLocation
[0..1] I_WBSElementBasicData _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label View to change qty for reservation itm 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 FldLogsMaintenanceOrder FldLogsMaintenanceOrder
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
KEY ReservationItem ReservationItem Reservation Item
KEY Reservation Reservation Reservation
KEY Operation Operation Transaction
KEY MaintComponentItemCategory MaintComponentItemCategory
KEY AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
FldLogsMaintOrderComponent FldLogsMaintOrderComponent
RemoteStorageLocation RemoteStorageLocation
RequiredQuantity RequiredQuantity Requirement qty
BaseUnit BaseUnit Unit of Measure
WithdrawnQuantity WithdrawnQuantity Withdrawn Quantity
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderQty PurchaseOrderQty Purchase Order Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
FldLogsRemoteQuantity FldLogsRemoteQuantity
Quantity Quantity Value
WarehouseStorageBin _StorageBin WarehouseStorageBin Storage Bin
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
RecipientLocationCode RecipientLocationCode Recipient Loc.
DefaultValueIsUsed
WBSElementInternalID WBSElementInternalID WBS Internal ID
InventorySpecialStockType InventorySpecialStockType Special Stock Type
MaintenanceOrderCategory MaintenanceOrderCategory
_UnitOfMeasure _UnitOfMeasure
_Product _Product
_WBSElement _WBSElement

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_FldLogsOrdResvnItmQtyTP.
-- 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_FldLogsOrdResvnItmQtyTP AS
SELECT
  FldLogsMaintenanceOrder,
  Product,
  Plant,
  ReservationItem,
  Reservation,
  Operation,
  MaintComponentItemCategory,
  AccountAssignmentCategory,
  FldLogsMaintOrderComponent,
  RemoteStorageLocation,
  RequiredQuantity,
  BaseUnit,
  WithdrawnQuantity,
  FldLogsSupplyProcess,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderQty,
  OrderQuantityUnit,
  FldLogsRemoteQuantity,
  Quantity,
  _StorageBin.WarehouseStorageBin AS WarehouseStorageBin,
  IsEndOfPurposeBlocked,
  RecipientLocationCode,
  cast('X' as xfeld ) AS DefaultValueIsUsed,
  WBSElementInternalID,
  InventorySpecialStockType,
  MaintenanceOrderCategory
LEFT OUTER JOIN I_FldLogsStorLocation AS _StorageBin ON Product = _StorageBin.Material AND Plant = _StorageBin.Plant AND RemoteStorageLocation = _StorageBin.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;

Learn More