I_ActlFlxMtPlObjIssdQty

DDL: I_ACTLFLXMTPLOBJISSDQTY Type: view_entity COMPOSITE
15 Fields 2 Data Sources

Issued Quantity for FMPO

I_ActlFlxMtPlObjIssdQty is a Composite CDS View that provides data about "Issued Quantity for FMPO" in SAP S/4HANA. It reads from 2 data sources (I_FlxMtPlObjModLogsInformation, I_DFS_PositionPersonnelStkDet) and exposes 15 fields with key fields Material, FlxblMatlPlngObjectUUID, Plant, StorageLocation, DfsPositionSequenceNumber.

Data Sources (2)

SourceAliasJoin Type
I_FlxMtPlObjModLogsInformation _FlxMtPlObjModLogsInformation from
I_DFS_PositionPersonnelStkDet _PositionPersonnelStkDet inner

Parameters (1)

NameTypeDefault
P_KeyDate syst_datum

Annotations (7)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Material I_FlxMtPlObjModLogsInformation Material Vehicle Model
KEY FlxblMatlPlngObjectUUID I_FlxMtPlObjModLogsInformation FlxblMatlPlngObjectUUID FMPO UUID
KEY Plant I_DFS_PositionPersonnelStkDet Plant Valuation Area
KEY StorageLocation I_DFS_PositionPersonnelStkDet StorageLocation StorageLocation
KEY DfsPositionSequenceNumber I_DFS_PositionPersonnelStkDet DfsPositionSequenceNumber Tank ID
KEY EmployeePersonnelNumber I_DFS_PositionPersonnelStkDet EmployeePersonnelNumber Personnel no.
KEY StartDate I_DFS_PositionPersonnelStkDet StartDate Valid From
KEY EndDate I_DFS_PositionPersonnelStkDet EndDate Term to
KEY DfsObjectSubType I_DFS_PositionPersonnelStkDet DfsObjectSubType Subtype
KEY DfsIssueToPersonnelUsageType I_DFS_PositionPersonnelStkDet DfsIssueToPersonnelUsageType Usage Type
WBSElementExternalID
Batch I_DFS_PositionPersonnelStkDet Batch Lot No.
MaterialBaseUnit I_DFS_PositionPersonnelStkDet MaterialBaseUnit Valuation Unit
GoodsIssueQtyInBaseUnit I_DFS_PositionPersonnelStkDet GoodsIssueQtyInBaseUnit GI/GR Quantity
ReturnQuantity I_DFS_PositionPersonnelStkDet ReturnQuantity GI/GR Quantity

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_ActlFlxMtPlObjIssdQty.
-- 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.
-- Parameters: P_KeyDate : syst_datum

CREATE VIEW I_ActlFlxMtPlObjIssdQty AS
SELECT
  _FlxMtPlObjModLogsInformation.Material AS Material,
  _FlxMtPlObjModLogsInformation.FlxblMatlPlngObjectUUID AS FlxblMatlPlngObjectUUID,
  _PositionPersonnelStkDet.Plant AS Plant,
  _PositionPersonnelStkDet.StorageLocation AS StorageLocation,
  _PositionPersonnelStkDet.DfsPositionSequenceNumber AS DfsPositionSequenceNumber,
  _PositionPersonnelStkDet.EmployeePersonnelNumber AS EmployeePersonnelNumber,
  _PositionPersonnelStkDet.StartDate AS StartDate,
  _PositionPersonnelStkDet.EndDate AS EndDate,
  _PositionPersonnelStkDet.DfsObjectSubType AS DfsObjectSubType,
  _PositionPersonnelStkDet.DfsIssueToPersonnelUsageType AS DfsIssueToPersonnelUsageType,
  cast(_PositionPersonnelStkDet.WBSElementExternalID as abap.char(24)) AS WBSElementExternalID,
  _PositionPersonnelStkDet.Batch AS Batch,
  _PositionPersonnelStkDet.MaterialBaseUnit AS MaterialBaseUnit,
  _PositionPersonnelStkDet.GoodsIssueQtyInBaseUnit AS GoodsIssueQtyInBaseUnit,
  _PositionPersonnelStkDet.ReturnQuantity AS ReturnQuantity
FROM I_FlxMtPlObjModLogsInformation AS _FlxMtPlObjModLogsInformation
INNER JOIN I_DFS_PositionPersonnelStkDet AS _PositionPersonnelStkDet ON /* join condition not captured in parsed metadata */
;

Learn More