I_FlxMtPlObjOrddQtyInformation

DDL: I_FLXMTPLOBJORDDQTYINFORMATION Type: view_entity COMPOSITE
14 Fields 2 Data Sources 2 Associations

PO Quantity for FMPO

I_FlxMtPlObjOrddQtyInformation is a Composite CDS View that provides data about "PO Quantity for FMPO" in SAP S/4HANA. It reads from 2 data sources (I_FlxMtPlObjModLogsInformation, I_PurchaseOrderItem) and exposes 14 fields with key fields Material, FlxblMatlPlngObjectUUID, Plant, StorageLocation, PurchaseOrder. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_FlxMtPlObjModLogsInformation _FlxMtPlObjModLogsInformation from
I_PurchaseOrderItem _PurchaseOrderItem inner

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_PurgDocScheduleLine _PurgDocScheduleLine _PurchaseOrderItem.PurchaseOrder = _PurgDocScheduleLine.PurchasingDocument and _PurchaseOrderItem.PurchaseOrderItem = _PurgDocScheduleLine.PurchasingDocumentItem
[1..1] I_PurgDocAccountAssignment _PurgDocAccountAssignment _PurchaseOrderItem.PurchaseOrder = _PurgDocAccountAssignment.PurchasingDocument and _PurchaseOrderItem.PurchaseOrderItem = _PurgDocAccountAssignment.PurchasingDocumentItem and _PurgDocAccountAssignment.AccountAssignmentNumber = '01'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PO Quantity for FMPO view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Material
KEY FlxblMatlPlngObjectUUID I_FlxMtPlObjModLogsInformation FlxblMatlPlngObjectUUID FMPO UUID
KEY Plant I_PurchaseOrderItem Plant Valuation Area
KEY StorageLocation I_PurchaseOrderItem StorageLocation StorageLocation
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine _PurgDocScheduleLine ScheduleLine Schedule Line
KEY AccountAssignmentNumber _PurgDocAccountAssignment AccountAssignmentNumber Account Assgmt No.
WBSElementInternalID _PurgDocAccountAssignment WBSElementInternalID_2
PurchaseOrderQuantityUnit I_PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
Batch _PurgDocScheduleLine Batch Lot No.
SupplyingPlant
SupplyingStorageLocation I_PurchaseOrderItem IssuingStorageLocation Iss. Stor. Loc.
BaseUnit I_PurchaseOrderItem BaseUnit Unit of Measure

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_FlxMtPlObjOrddQtyInformation.
-- 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_FlxMtPlObjOrddQtyInformation AS
SELECT
  _FlxMtPlObjModLogsInformation .Material AS Material,
  _FlxMtPlObjModLogsInformation.FlxblMatlPlngObjectUUID AS FlxblMatlPlngObjectUUID,
  _PurchaseOrderItem.Plant AS Plant,
  _PurchaseOrderItem.StorageLocation AS StorageLocation,
  _PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  _PurgDocScheduleLine.ScheduleLine AS ScheduleLine,
  _PurgDocAccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  _PurgDocAccountAssignment.WBSElementInternalID_2 AS WBSElementInternalID,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _PurgDocScheduleLine.Batch AS Batch,
  _PurchaseOrderItem._PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  _PurchaseOrderItem.IssuingStorageLocation AS SupplyingStorageLocation,
  _PurchaseOrderItem.BaseUnit AS BaseUnit
FROM I_FlxMtPlObjModLogsInformation AS _FlxMtPlObjModLogsInformation
INNER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocScheduleLine AS _PurgDocScheduleLine ON _PurchaseOrderItem.PurchaseOrder = _PurgDocScheduleLine.PurchasingDocument AND _PurchaseOrderItem.PurchaseOrderItem = _PurgDocScheduleLine.PurchasingDocumentItem  -- association [1..*]
LEFT OUTER JOIN I_PurgDocAccountAssignment AS _PurgDocAccountAssignment ON _PurchaseOrderItem.PurchaseOrder = _PurgDocAccountAssignment.PurchasingDocument AND _PurchaseOrderItem.PurchaseOrderItem = _PurgDocAccountAssignment.PurchasingDocumentItem AND _PurgDocAccountAssignment.AccountAssignmentNumber = '01'  -- association [1..1]
;

Learn More