P_ProjMatComponentWithVers

DDL: P_PROJMATCOMPONENTWITHVERS SQL: PPROJMATCOMPVERS Type: view COMPOSITE
211 Fields 2 Data Sources

P_ProjMatComponentWithVers is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ProjectMaterialComponent, I_ProjMatComponentVersion) and exposes 211 fields with key fields Reservation, Version, ReservationItem, RecordType, Version.

Data Sources (2)

SourceAliasJoin Type
I_ProjectMaterialComponent I_ProjectMaterialComponent union_all
I_ProjMatComponentVersion I_ProjMatComponentVersion from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPROJMATCOMPVERS view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #CHECK view

Fields (211)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_ProjMatComponentVersion Reservation Reservation
KEY Version I_ProjMatComponentVersion Version XML Vers.
KEY ReservationItem I_ProjMatComponentVersion ReservationItem Reservation Item
KEY RecordType I_ProjMatComponentVersion RecordType Reservation Record Type
IsProjectVersionObject
ProjectNetwork I_ProjMatComponentVersion ProjectNetwork Order
Plant I_ProjMatComponentVersion Plant Valuation Area
Material I_ProjMatComponentVersion Material Vehicle Model
GoodsMovementType I_ProjMatComponentVersion GoodsMovementType Movement Type
PurchasingGroup I_ProjMatComponentVersion PurchasingGroup Purchasing Group
SalesOrder I_ProjMatComponentVersion SalesOrder SD Document
SalesOrderItem I_ProjMatComponentVersion SalesOrderItem Sales Order Item
InventorySpecialStockValnType I_ProjMatComponentVersion InventorySpecialStockValnType Valuation
ConsumptionPosting I_ProjMatComponentVersion ConsumptionPosting Consumption Posting
StorageLocation I_ProjMatComponentVersion StorageLocation StorageLocation
Creditor I_ProjMatComponentVersion Creditor Supplier
BaseUnit I_ProjMatComponentVersion BaseUnit Unit of Measure
MaterialComponentObject I_ProjMatComponentVersion MaterialComponentObject Val. Obj. No.
WBSElementInternalID I_ProjMatComponentVersion WBSElementInternalID WBS Internal ID
GLAccount I_ProjMatComponentVersion GLAccount General Ledger
ReservationIsFinallyIssued I_ProjMatComponentVersion ReservationIsFinallyIssued Res Final Issue
MaterialCompIsCostRelevant I_ProjMatComponentVersion MaterialCompIsCostRelevant
MatlCompIsMarkedForBackflush I_ProjMatComponentVersion MatlCompIsMarkedForBackflush Backflush
IsBulkMaterialComponent I_ProjMatComponentVersion IsBulkMaterialComponent Bulk material
MaterialCompIsSpecialStock I_ProjMatComponentVersion MaterialCompIsSpecialStock
MatlCompIsTextItem I_ProjMatComponentVersion MatlCompIsTextItem
MaterialComponentIsMissing I_ProjMatComponentVersion MaterialComponentIsMissing
MatlCompIsMarkedForDeletion I_ProjMatComponentVersion MatlCompIsMarkedForDeletion
AccountAssignmentCategory I_ProjMatComponentVersion AccountAssignmentCategory Acct Assgmt Cat
MatlCompIsRelevantForMRP I_ProjMatComponentVersion MatlCompIsRelevantForMRP
GoodsRecipientName I_ProjMatComponentVersion GoodsRecipientName Recipient Name
GoodsMovementIsAllowed I_ProjMatComponentVersion GoodsMovementIsAllowed Mvt Allowed
RequisitionerUser I_ProjMatComponentVersion RequisitionerUser Requester
LastChangedByUser I_ProjMatComponentVersion LastChangedByUser User Name
LastChangeDate I_ProjMatComponentVersion LastChangeDate Time Stamp
CreatedByUser I_ProjMatComponentVersion CreatedByUser User Name
CreationDate I_ProjMatComponentVersion CreationDate Time Stamp
Supplier I_ProjMatComponentVersion Supplier Supplier
BillingPlan I_ProjMatComponentVersion BillingPlan Bill. Plan No.
ProjectNetworkDescription I_ProjMatComponentVersion ProjectNetworkDescription Network Name
Project I_ProjMatComponentVersion Project WBS Element
ProjectWithCodingMask I_ProjMatComponentVersion ProjectWithCodingMask
MatlCompRequirementDate I_ProjMatComponentVersion MatlCompRequirementDate Reqmts date
MaterialCompIsProcuredDirectly I_ProjMatComponentVersion MaterialCompIsProcuredDirectly Checkbox
MaterialComponentIsPhantomItem I_ProjMatComponentVersion MaterialComponentIsPhantomItem Phantom Item
MatlCompIsProcuredExternally I_ProjMatComponentVersion MatlCompIsProcuredExternally
NetworkActivity I_ProjMatComponentVersion NetworkActivity Operation/Activity
Currency I_ProjMatComponentVersion Currency Valuation Crcy
ShortfallQuantity I_ProjMatComponentVersion ShortfallQuantity
WithdrawnQuantity I_ProjMatComponentVersion WithdrawnQuantity Withdrawn Quantity
MRPRequiredQuantityInBaseUnit I_ProjMatComponentVersion MRPRequiredQuantityInBaseUnit Open Quantity
RequirementQuantityInBaseUnit I_ProjMatComponentVersion RequirementQuantityInBaseUnit
ConfirmedAvailableQuantity I_ProjMatComponentVersion ConfirmedAvailableQuantity Available Quantity
MaterialComponentPrice I_ProjMatComponentVersion MaterialComponentPrice Price
WithdrawnQuantityAmount I_ProjMatComponentVersion WithdrawnQuantityAmount Withdr. Value
NumberOfMissingMatlComp I_ProjMatComponentVersion NumberOfMissingMatlComp
DeliveryDurationInDays I_ProjMatComponentVersion DeliveryDurationInDays Del time (days)
GoodsReceiptDurationInDays I_ProjMatComponentVersion GoodsReceiptDurationInDays GR proc. time
MaterialPriceUnitQty I_ProjMatComponentVersion MaterialPriceUnitQty Price unit
ControllingArea I_ProjMatComponentVersion ControllingArea Controlling Area
ProjectObjectChangeNumber I_ProjMatComponentVersion ProjectObjectChangeNumber Change Number
PurchaseRequisition I_ProjMatComponentVersion PurchaseRequisition Requisition
PurchaseRequisitionItem I_ProjMatComponentVersion PurchaseRequisitionItem Requisn. item
FormulaKey I_ProjMatComponentVersion FormulaKey VSI Formula
UnloadingPointName I_ProjMatComponentVersion UnloadingPointName Unloading Point Name
BOMItemCategory I_ProjMatComponentVersion BOMItemCategory Item Category
PurchaseOrderExists I_ProjMatComponentVersion PurchaseOrderExists
RqmtDateIsEnteredManually I_ProjMatComponentVersion RqmtDateIsEnteredManually Man. Reqmt Date
ProductionSeries I_ProjMatComponentVersion ProductionSeries
OperationLeadTimeOffset I_ProjMatComponentVersion OperationLeadTimeOffset Oper. LT offset
OperationLeadTimeOffsetUnit I_ProjMatComponentVersion OperationLeadTimeOffsetUnit
BillOfMaterialItemNumber I_ProjMatComponentVersion BillOfMaterialItemNumber Item
ProcurementType I_ProjMatComponentVersion ProcurementType Procurement
BOMItemDescription I_ProjMatComponentVersion BOMItemDescription Item Text
CommittedQuantity I_ProjMatComponentVersion CommittedQuantity
Assembly I_ProjMatComponentVersion Assembly Pegged Reqmt
AssemblyName I_ProjMatComponentVersion AssemblyName
BillOfMaterial I_ProjMatComponentVersion BillOfMaterial BOM
BOMHeaderText I_ProjMatComponentVersion BOMHeaderText BOM Description
BillOfMaterialCategory I_ProjMatComponentVersion BillOfMaterialCategory BOM category
GroupingWBSElementInternalID I_ProjMatComponentVersion GroupingWBSElementInternalID Ownr Grouping WBS El
ReceivedQuantity I_ProjMatComponentVersion ReceivedQuantity Quantity Received
OpenQuantity I_ProjMatComponentVersion OpenQuantity PBE Entry Open Qty
MaterialCompMainAssemblyCat I_ProjMatComponentVersion MaterialCompMainAssemblyCat BOM category
ProductTypeCode I_ProjMatComponentVersion ProductTypeCode Product Type Group
PerformancePeriodStartDate I_ProjMatComponentVersion PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate I_ProjMatComponentVersion PerformancePeriodEndDate End of Performance Period
ServicePerformer I_ProjMatComponentVersion ServicePerformer Service Performer
LeanServiceDuration I_ProjMatComponentVersion LeanServiceDuration Service Duration
LeanServiceDurationUnit I_ProjMatComponentVersion LeanServiceDurationUnit Serv. Dur. Unit
OverallLimitAmount I_ProjMatComponentVersion OverallLimitAmount Overall Limit
ExpectedOverallLimitAmount I_ProjMatComponentVersion ExpectedOverallLimitAmount Expected Value
_AccAssgnmtCategory I_ProjMatComponentVersion _AccAssgnmtCategory
_PlantName I_ProjMatComponentVersion _PlantName
_StorageLocation I_ProjMatComponentVersion _StorageLocation
_BillOfMaterialItemCategory I_ProjMatComponentVersion _BillOfMaterialItemCategory
_Material I_ProjMatComponentVersion _Material
_Supplier I_ProjMatComponentVersion _Supplier
_ProjMatlProcurementType I_ProjMatComponentVersion _ProjMatlProcurementType
_ConsumptionPostingName I_ProjMatComponentVersion _ConsumptionPostingName
_ProjMatBomCategory I_ProjMatComponentVersion _ProjMatBomCategory
_WBSElement I_ProjMatComponentVersion _WBSElement
_WBSGroupElement I_ProjMatComponentVersion _WBSGroupElement
_SpecialStockValuationName I_ProjMatComponentVersion _SpecialStockValuationName
_InventorySpecialStockType I_ProjMatComponentVersion _InventorySpecialStockType
Reservation Reservation
KEY Version XML Vers.
KEY ReservationItem I_ProjectMaterialComponent ReservationItem Reservation Item
KEY RecordType I_ProjectMaterialComponent RecordType Reservation Record Type
IsProjectVersionObject
ProjectNetwork I_ProjectMaterialComponent ProjectNetwork Order
Plant I_ProjectMaterialComponent Plant Valuation Area
Material I_ProjectMaterialComponent Material Vehicle Model
GoodsMovementType I_ProjectMaterialComponent GoodsMovementType Movement Type
PurchasingGroup I_ProjectMaterialComponent PurchasingGroup Purchasing Group
SalesOrder I_ProjectMaterialComponent SalesOrder SD Document
SalesOrderItem I_ProjectMaterialComponent SalesOrderItem Sales Order Item
InventorySpecialStockValnType I_ProjectMaterialComponent InventorySpecialStockValnType Valuation
ConsumptionPosting I_ProjectMaterialComponent ConsumptionPosting Consumption Posting
StorageLocation I_ProjectMaterialComponent StorageLocation StorageLocation
Creditor I_ProjectMaterialComponent Creditor Supplier
BaseUnit I_ProjectMaterialComponent BaseUnit Unit of Measure
MaterialComponentObject I_ProjectMaterialComponent MaterialComponentObject Val. Obj. No.
WBSElementInternalID I_ProjectMaterialComponent WBSElementInternalID WBS Internal ID
GLAccount I_ProjectMaterialComponent GLAccount General Ledger
ReservationIsFinallyIssued I_ProjectMaterialComponent ReservationIsFinallyIssued Res Final Issue
MaterialCompIsCostRelevant I_ProjectMaterialComponent MaterialCompIsCostRelevant
MatlCompIsMarkedForBackflush I_ProjectMaterialComponent MatlCompIsMarkedForBackflush Backflush
IsBulkMaterialComponent I_ProjectMaterialComponent IsBulkMaterialComponent Bulk material
MaterialCompIsSpecialStock I_ProjectMaterialComponent MaterialCompIsSpecialStock
MatlCompIsTextItem I_ProjectMaterialComponent MatlCompIsTextItem
MaterialComponentIsMissing I_ProjectMaterialComponent MaterialComponentIsMissing
MatlCompIsMarkedForDeletion I_ProjectMaterialComponent MatlCompIsMarkedForDeletion
AccountAssignmentCategory I_ProjectMaterialComponent AccountAssignmentCategory Acct Assgmt Cat
MatlCompIsRelevantForMRP I_ProjectMaterialComponent MatlCompIsRelevantForMRP
GoodsRecipientName I_ProjectMaterialComponent GoodsRecipientName Recipient Name
GoodsMovementIsAllowed I_ProjectMaterialComponent GoodsMovementIsAllowed Mvt Allowed
RequisitionerUser I_ProjectMaterialComponent RequisitionerUser Requester
LastChangedByUser I_ProjectMaterialComponent LastChangedByUser User Name
LastChangeDate I_ProjectMaterialComponent LastChangeDate Time Stamp
CreatedByUser I_ProjectMaterialComponent CreatedByUser User Name
CreationDate I_ProjectMaterialComponent CreationDate Time Stamp
Supplier I_ProjectMaterialComponent Supplier Supplier
BillingPlan I_ProjectMaterialComponent BillingPlan Bill. Plan No.
ProjectNetworkDescription I_ProjectMaterialComponent ProjectNetworkDescription Network Name
Project I_ProjectMaterialComponent Project WBS Element
ProjectWithCodingMask I_ProjectMaterialComponent ProjectWithCodingMask
MatlCompRequirementDate I_ProjectMaterialComponent MatlCompRequirementDate Reqmts date
MaterialCompIsProcuredDirectly I_ProjectMaterialComponent MaterialCompIsProcuredDirectly Checkbox
MaterialComponentIsPhantomItem I_ProjectMaterialComponent MaterialComponentIsPhantomItem Phantom Item
MatlCompIsProcuredExternally I_ProjectMaterialComponent MatlCompIsProcuredExternally
NetworkActivity I_ProjectMaterialComponent NetworkActivity Operation/Activity
Currency I_ProjectMaterialComponent Currency Valuation Crcy
ShortfallQuantity I_ProjectMaterialComponent ShortfallQuantity
WithdrawnQuantity I_ProjectMaterialComponent WithdrawnQuantity Withdrawn Quantity
MRPRequiredQuantityInBaseUnit I_ProjectMaterialComponent MRPRequiredQuantityInBaseUnit Open Quantity
RequirementQuantityInBaseUnit I_ProjectMaterialComponent RequirementQuantityInBaseUnit
ConfirmedAvailableQuantity I_ProjectMaterialComponent ConfirmedAvailableQuantity Available Quantity
MaterialComponentPrice I_ProjectMaterialComponent MaterialComponentPrice Price
WithdrawnQuantityAmount I_ProjectMaterialComponent WithdrawnQuantityAmount Withdr. Value
NumberOfMissingMatlComp I_ProjectMaterialComponent NumberOfMissingMatlComp
DeliveryDurationInDays I_ProjectMaterialComponent DeliveryDurationInDays Del time (days)
GoodsReceiptDurationInDays I_ProjectMaterialComponent GoodsReceiptDurationInDays GR proc. time
MaterialPriceUnitQty I_ProjectMaterialComponent MaterialPriceUnitQty Price unit
ControllingArea I_ProjectMaterialComponent ControllingArea Controlling Area
ProjectObjectChangeNumber I_ProjectMaterialComponent ProjectObjectChangeNumber Change Number
PurchaseRequisition I_ProjectMaterialComponent PurchaseRequisition Requisition
PurchaseRequisitionItem I_ProjectMaterialComponent PurchaseRequisitionItem Requisn. item
FormulaKey I_ProjectMaterialComponent FormulaKey VSI Formula
UnloadingPointName I_ProjectMaterialComponent UnloadingPointName Unloading Point Name
BOMItemCategory I_ProjectMaterialComponent BOMItemCategory Item Category
PurchaseOrderExists I_ProjectMaterialComponent PurchaseOrderExists
RqmtDateIsEnteredManually I_ProjectMaterialComponent RqmtDateIsEnteredManually Man. Reqmt Date
ProductionSeries I_ProjectMaterialComponent ProductionSeries
OperationLeadTimeOffset I_ProjectMaterialComponent OperationLeadTimeOffset Oper. LT offset
OperationLeadTimeOffsetUnit I_ProjectMaterialComponent OperationLeadTimeOffsetUnit
BillOfMaterialItemNumber I_ProjectMaterialComponent BillOfMaterialItemNumber Item
ProcurementType I_ProjectMaterialComponent ProcurementType Procurement
BOMItemDescription I_ProjectMaterialComponent BOMItemDescription Item Text
CommittedQuantity I_ProjectMaterialComponent CommittedQuantity
Assembly I_ProjectMaterialComponent Assembly Pegged Reqmt
AssemblyName I_ProjectMaterialComponent AssemblyName
BillOfMaterial I_ProjectMaterialComponent BillOfMaterial BOM
BOMHeaderText I_ProjectMaterialComponent BOMHeaderText BOM Description
BillOfMaterialCategory I_ProjectMaterialComponent BillOfMaterialCategory BOM category
GroupingWBSElementInternalID I_ProjectMaterialComponent GroupingWBSElementInternalID Ownr Grouping WBS El
ReceivedQuantity I_ProjectMaterialComponent ReceivedQuantity Quantity Received
OpenQuantity I_ProjectMaterialComponent OpenQuantity PBE Entry Open Qty
MaterialCompMainAssemblyCat I_ProjectMaterialComponent MaterialCompMainAssemblyCat BOM category
ProductTypeCode I_ProjectMaterialComponent ProductTypeCode Product Type Group
PerformancePeriodStartDate I_ProjectMaterialComponent PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate I_ProjectMaterialComponent PerformancePeriodEndDate End of Performance Period
ServicePerformer I_ProjectMaterialComponent ServicePerformer Service Performer
LeanServiceDuration I_ProjectMaterialComponent LeanServiceDuration Service Duration
LeanServiceDurationUnit I_ProjectMaterialComponent LeanServiceDurationUnit Serv. Dur. Unit
OverallLimitAmount I_ProjectMaterialComponent OverallLimitAmount Overall Limit
ExpectedOverallLimitAmount I_ProjectMaterialComponent ExpectedOverallLimitAmount Expected Value
_AccAssgnmtCategory I_ProjectMaterialComponent _AccAssgnmtCategory
_PlantName I_ProjectMaterialComponent _PlantName
_StorageLocation I_ProjectMaterialComponent _StorageLocation
_BillOfMaterialItemCategory I_ProjectMaterialComponent _BillOfMaterialItemCategory
_Material I_ProjectMaterialComponent _Material
_Supplier I_ProjectMaterialComponent _Supplier
_ProjMatlProcurementType I_ProjectMaterialComponent _ProjMatlProcurementType
_ConsumptionPostingName I_ProjectMaterialComponent _ConsumptionPostingName
_ProjMatBomCategory I_ProjectMaterialComponent _ProjMatBomCategory
_WBSElement I_ProjectMaterialComponent _WBSElement
_WBSGroupElement I_ProjectMaterialComponent _WBSGroupElement
_SpecialStockValuationName I_ProjectMaterialComponent _SpecialStockValuationName
_InventorySpecialStockType I_ProjectMaterialComponent _InventorySpecialStockType
_BillOfMaterialCategory I_ProjectMaterialComponent _BillOfMaterialCategory

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 P_ProjMatComponentWithVers.
-- 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.
-- SQL view name: PPROJMATCOMPVERS

CREATE VIEW P_ProjMatComponentWithVers AS
SELECT
  I_ProjMatComponentVersion.Reservation AS Reservation,
  I_ProjMatComponentVersion.Version AS Version,
  I_ProjMatComponentVersion.ReservationItem AS ReservationItem,
  I_ProjMatComponentVersion.RecordType AS RecordType,
  'X' AS IsProjectVersionObject,
  I_ProjMatComponentVersion.ProjectNetwork AS ProjectNetwork,
  I_ProjMatComponentVersion.Plant AS Plant,
  I_ProjMatComponentVersion.Material AS Material,
  I_ProjMatComponentVersion.GoodsMovementType AS GoodsMovementType,
  I_ProjMatComponentVersion.PurchasingGroup AS PurchasingGroup,
  I_ProjMatComponentVersion.SalesOrder AS SalesOrder,
  I_ProjMatComponentVersion.SalesOrderItem AS SalesOrderItem,
  I_ProjMatComponentVersion.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_ProjMatComponentVersion.ConsumptionPosting AS ConsumptionPosting,
  I_ProjMatComponentVersion.StorageLocation AS StorageLocation,
  I_ProjMatComponentVersion.Creditor AS Creditor,
  I_ProjMatComponentVersion.BaseUnit AS BaseUnit,
  I_ProjMatComponentVersion.MaterialComponentObject AS MaterialComponentObject,
  I_ProjMatComponentVersion.WBSElementInternalID AS WBSElementInternalID,
  I_ProjMatComponentVersion.GLAccount AS GLAccount,
  I_ProjMatComponentVersion.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  I_ProjMatComponentVersion.MaterialCompIsCostRelevant AS MaterialCompIsCostRelevant,
  I_ProjMatComponentVersion.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  I_ProjMatComponentVersion.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  I_ProjMatComponentVersion.MaterialCompIsSpecialStock AS MaterialCompIsSpecialStock,
  I_ProjMatComponentVersion.MatlCompIsTextItem AS MatlCompIsTextItem,
  I_ProjMatComponentVersion.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  I_ProjMatComponentVersion.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  I_ProjMatComponentVersion.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_ProjMatComponentVersion.MatlCompIsRelevantForMRP AS MatlCompIsRelevantForMRP,
  I_ProjMatComponentVersion.GoodsRecipientName AS GoodsRecipientName,
  I_ProjMatComponentVersion.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  I_ProjMatComponentVersion.RequisitionerUser AS RequisitionerUser,
  I_ProjMatComponentVersion.LastChangedByUser AS LastChangedByUser,
  I_ProjMatComponentVersion.LastChangeDate AS LastChangeDate,
  I_ProjMatComponentVersion.CreatedByUser AS CreatedByUser,
  I_ProjMatComponentVersion.CreationDate AS CreationDate,
  I_ProjMatComponentVersion.Supplier AS Supplier,
  I_ProjMatComponentVersion.BillingPlan AS BillingPlan,
  I_ProjMatComponentVersion.ProjectNetworkDescription AS ProjectNetworkDescription,
  I_ProjMatComponentVersion.Project AS Project,
  I_ProjMatComponentVersion.ProjectWithCodingMask AS ProjectWithCodingMask,
  I_ProjMatComponentVersion.MatlCompRequirementDate AS MatlCompRequirementDate,
  I_ProjMatComponentVersion.MaterialCompIsProcuredDirectly AS MaterialCompIsProcuredDirectly,
  I_ProjMatComponentVersion.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  I_ProjMatComponentVersion.MatlCompIsProcuredExternally AS MatlCompIsProcuredExternally,
  I_ProjMatComponentVersion.NetworkActivity AS NetworkActivity,
  I_ProjMatComponentVersion.Currency AS Currency,
  I_ProjMatComponentVersion.ShortfallQuantity AS ShortfallQuantity,
  I_ProjMatComponentVersion.WithdrawnQuantity AS WithdrawnQuantity,
  I_ProjMatComponentVersion.MRPRequiredQuantityInBaseUnit AS MRPRequiredQuantityInBaseUnit,
  I_ProjMatComponentVersion.RequirementQuantityInBaseUnit AS RequirementQuantityInBaseUnit,
  I_ProjMatComponentVersion.ConfirmedAvailableQuantity AS ConfirmedAvailableQuantity,
  I_ProjMatComponentVersion.MaterialComponentPrice AS MaterialComponentPrice,
  I_ProjMatComponentVersion.WithdrawnQuantityAmount AS WithdrawnQuantityAmount,
  I_ProjMatComponentVersion.NumberOfMissingMatlComp AS NumberOfMissingMatlComp,
  I_ProjMatComponentVersion.DeliveryDurationInDays AS DeliveryDurationInDays,
  I_ProjMatComponentVersion.GoodsReceiptDurationInDays AS GoodsReceiptDurationInDays,
  I_ProjMatComponentVersion.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  I_ProjMatComponentVersion.ControllingArea AS ControllingArea,
  I_ProjMatComponentVersion.ProjectObjectChangeNumber AS ProjectObjectChangeNumber,
  I_ProjMatComponentVersion.PurchaseRequisition AS PurchaseRequisition,
  I_ProjMatComponentVersion.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_ProjMatComponentVersion.FormulaKey AS FormulaKey,
  I_ProjMatComponentVersion.UnloadingPointName AS UnloadingPointName,
  I_ProjMatComponentVersion.BOMItemCategory AS BOMItemCategory,
  I_ProjMatComponentVersion.PurchaseOrderExists AS PurchaseOrderExists,
  I_ProjMatComponentVersion.RqmtDateIsEnteredManually AS RqmtDateIsEnteredManually,
  I_ProjMatComponentVersion.ProductionSeries AS ProductionSeries,
  I_ProjMatComponentVersion.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  I_ProjMatComponentVersion.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  I_ProjMatComponentVersion.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  I_ProjMatComponentVersion.ProcurementType AS ProcurementType,
  I_ProjMatComponentVersion.BOMItemDescription AS BOMItemDescription,
  I_ProjMatComponentVersion.CommittedQuantity AS CommittedQuantity,
  I_ProjMatComponentVersion.Assembly AS Assembly,
  I_ProjMatComponentVersion.AssemblyName AS AssemblyName,
  I_ProjMatComponentVersion.BillOfMaterial AS BillOfMaterial,
  I_ProjMatComponentVersion.BOMHeaderText AS BOMHeaderText,
  I_ProjMatComponentVersion.BillOfMaterialCategory AS BillOfMaterialCategory,
  I_ProjMatComponentVersion.GroupingWBSElementInternalID AS GroupingWBSElementInternalID,
  I_ProjMatComponentVersion.ReceivedQuantity AS ReceivedQuantity,
  I_ProjMatComponentVersion.OpenQuantity AS OpenQuantity,
  I_ProjMatComponentVersion.MaterialCompMainAssemblyCat AS MaterialCompMainAssemblyCat,
  I_ProjMatComponentVersion.ProductTypeCode AS ProductTypeCode,
  I_ProjMatComponentVersion.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_ProjMatComponentVersion.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_ProjMatComponentVersion.ServicePerformer AS ServicePerformer,
  I_ProjMatComponentVersion.LeanServiceDuration AS LeanServiceDuration,
  I_ProjMatComponentVersion.LeanServiceDurationUnit AS LeanServiceDurationUnit,
  I_ProjMatComponentVersion.OverallLimitAmount AS OverallLimitAmount,
  I_ProjMatComponentVersion.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  I_ProjMatComponentVersion._AccAssgnmtCategory AS _AccAssgnmtCategory,
  I_ProjMatComponentVersion._PlantName AS _PlantName,
  I_ProjMatComponentVersion._StorageLocation AS _StorageLocation,
  I_ProjMatComponentVersion._BillOfMaterialItemCategory AS _BillOfMaterialItemCategory,
  I_ProjMatComponentVersion._Material AS _Material,
  I_ProjMatComponentVersion._Supplier AS _Supplier,
  I_ProjMatComponentVersion._ProjMatlProcurementType AS _ProjMatlProcurementType,
  I_ProjMatComponentVersion._ConsumptionPostingName AS _ConsumptionPostingName,
  I_ProjMatComponentVersion._ProjMatBomCategory AS _ProjMatBomCategory,
  I_ProjMatComponentVersion._WBSElement AS _WBSElement,
  I_ProjMatComponentVersion._WBSGroupElement AS _WBSGroupElement,
  I_ProjMatComponentVersion._SpecialStockValuationName AS _SpecialStockValuationName,
  I_ProjMatComponentVersion._InventorySpecialStockType AS _InventorySpecialStockType,
  I_ProjectMaterialComponent._BillOfMaterialCategory AS _BillOfMaterialCategory
FROM I_ProjMatComponentVersion
-- UNION ALL with additional select branch(es): I_ProjectMaterialComponent
;

Learn More