What is A_ProjNtwkActyMatlComp in SAP S/4HANA?

A_ProjNtwkActyMatlComp is a composite CDS view in SAP S/4HANA. Proj Ntwk Acty Material Component It contains 95 fields.

Which tables does A_ProjNtwkActyMatlComp read from?

A_ProjNtwkActyMatlComp reads data from: R_ProjNtwkActyMatlCompTP.

What VDM layer is A_ProjNtwkActyMatlComp?

A_ProjNtwkActyMatlComp is classified as a Composite view that combines data from multiple basic views.

A_ProjNtwkActyMatlComp

DDL: A_PROJNTWKACTYMATLCOMP Type: view_entity COMPOSITE

95 Fields 1 Data Sources 3 Associations 2 OData Services

Proj Ntwk Acty Material Component

A_ProjNtwkActyMatlComp is a Composite CDS View that provides data about "Proj Ntwk Acty Material Component" in SAP S/4HANA. It reads from 1 data source (R_ProjNtwkActyMatlCompTP) and exposes 95 fields with key fields Reservation, ReservationItem, RecordType. It has 3 associations to related views. It is exposed through 2 OData services (API_PROJECT_V3, API_PROJECTNETWORK).

Data Sources (1)

Source	Alias	Join Type
R_ProjNtwkActyMatlCompTP	R_ProjNtwkActyMatlCompTP	projection

Associations (3)

Cardinality	Target	Alias	Condition
[1..*]	A_ProjNtwkActyMatlCompStatus	_ProjNtwkActyMatlCompStatus	`_ProjectMaterialComp.Reservation = _ProjNtwkActyMatlCompStatus.Reservation and _ProjectMaterialComp.ReservationItem = _ProjNtwkActyMatlCompStatus.ReservationItem and _ProjectMaterialComp.RecordType = _ProjNtwkActyMatlCompStatus.RecordType`
[1..1]	E_ReservationDocumentItem	_ReservationExtension	`$projection.Reservation = _ReservationExtension.Reservation and $projection.ReservationItem = _ReservationExtension.ReservationItem and $projection.RecordType = _ReservationExtension.RecordType`
[1..1]	E_ProjectMaterialComponent	_MaterialExtension	`$projection.Reservation = _MaterialExtension.Reservation and $projection.ReservationItem = _MaterialExtension.ReservationItem and $projection.RecordType = _MaterialExtension.RecordType`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Proj Ntwk Acty Material Component	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
OData.entitySet.name	ProjNtwkActyMatlComp	view
OData.entityType.name	ProjNtwkActyMatlComp_Type	view

OData Services (2)

Service	Binding	Version	Contract	Release
API_PROJECT_V3	API_PROJECT_V3	V4	C2	C1
API_PROJECTNETWORK	API_PROJECTNETWORK	V4	C2	C1

Fields (95)

Key	Field	Source Field	Description
KEY	Reservation	Reservation	Reservation
KEY	ReservationItem	ReservationItem	Reservation Item
KEY	RecordType	RecordType	Reservation Record Type
	ProjectNetworkInternalID	ProjectNetworkInternalID	Plan No.f.Oper.
	NetworkActivityInternalID	NetworkActivityInternalID	Counter
	ProjectNetwork	ProjectNetwork	Order
	NetworkActivity	NetworkActivity	Operation/Activity
	Material	Material	Vehicle Model
	MaterialName	MaterialName	Material Description
	Plant	Plant	Valuation Area
	BOMItemCategory	BOMItemCategory	Item Category
	BillOfMaterialItemNumber	BillOfMaterialItemNumber	Item
	BOMItemDescription	BOMItemDescription	Item Text
	RqmtDateIsEnteredManually	RqmtDateIsEnteredManually	Man. Reqmt Date
	MatlCompRequirementDate	MatlCompRequirementDate	Reqmts date
	OperationLeadTimeOffset	OperationLeadTimeOffset	Oper. LT offset
	OperationLeadTimeOffsetUnit	OperationLeadTimeOffsetUnit
	GoodsRecipientName	GoodsRecipientName	Recipient Name
	UnloadingPointName	UnloadingPointName	Unloading Point Name
	IsMarkedForDeletion	IsMarkedForDeletion	Purch.org. data
	StorageLocation	StorageLocation	StorageLocation
	ProductionSeries	ProductionSeries
	GoodsMovementIsAllowed	GoodsMovementIsAllowed	Mvt Allowed
	ReservationIsFinallyIssued	ReservationIsFinallyIssued	Res Final Issue
	IsBulkMaterialComponent	IsBulkMaterialComponent	Bulk material
	MatlCompIsMarkedForBackflush	MatlCompIsMarkedForBackflush	Backflush
	MaterialComponentIsMissing	MaterialComponentIsMissing
	GoodsMovementType	GoodsMovementType	Movement Type
	MatlCompProcurementType	MatlCompProcurementType
	BaseUnit	BaseUnit	Unit of Measure
	RequirementQuantityInBaseUnit	RequirementQuantityInBaseUnit
	CommittedQuantity	CommittedQuantity
	AlignmentIsOperationStartDate	AlignmentIsOperationStartDate
	AlignmentIsOperationEndDate	AlignmentIsOperationEndDate
	QuantityDistributionKey	QuantityDistributionKey	Distribution
	SortField	SortField	Sort Field
	PurReqnOrResvnGeneration	PurReqnOrResvnGeneration	Purchase Reqn. / Resvn. Generation
	CreatedByUser	CreatedByUser	User Name
	CreationDate	CreationDate	Time Stamp
	LastChangedByUser	LastChangedByUser	User Name
	LastChangeDate	LastChangeDate	Time Stamp
	BillOfMaterialCategory	BillOfMaterialCategory	BOM category
	BOMExplosionFixedKeyDate	BOMExplosionFixedKeyDate
	Batch	Batch	Lot No.
	MaterialCompIsCostRelevant	MaterialCompIsCostRelevant
	PurchasingGroup	PurchasingGroup	Purchasing Group
	MaterialComponentPrice	MaterialComponentPrice	Price
	Currency	Currency	Valuation Crcy
	PurchasingInfoRecord	PurchasingInfoRecord	Info Record
	MaterialPriceUnitQty	MaterialPriceUnitQty	Price unit
	GLAccount	GLAccount	General Ledger
	Creditor	Creditor	Supplier
	GoodsReceiptDurationInDays	GoodsReceiptDurationInDays	GR proc. time
	DeliveryDurationInDays	DeliveryDurationInDays	Del time (days)
	MaterialGroup	MaterialGroup	Product Group
	QuantityInEntryUnit	QuantityInEntryUnit	Quantity in Unit of Entry
	EntryUnit	EntryUnit	Unit of Entry
	PurchaseRequisition	PurchaseRequisition	Requisition
	PurchaseRequisitionItem	PurchaseRequisitionItem	Requisn. item
	PurchasingOrganization	PurchasingOrganization	Purchasing Organization
	PurchaseContract	PurchaseContract	Purchasing Doc.
	PurchaseContractItem	PurchaseContractItem	Item
	RequisitionerUser	RequisitionerUser	Requester
	RequirementTracking	RequirementTracking	Tracking Number
	PurgInfoRecdDataIsFixed	PurgInfoRecdDataIsFixed
	MatlCompProcmtIndicatorCode	MatlCompProcmtIndicatorCode
	AddressNumber	AddressNumber	Src Address No
	Customer	Customer	Sold-to Party
	Supplier	Supplier	Supplier
	VariableSizeDimension1	VariableSizeDimension1	Size 1
	VariableSizeDimension2	VariableSizeDimension2	Size 2
	VariableSizeDimension3	VariableSizeDimension3	Size 3
	VariableSizeDimensionUnit	VariableSizeDimensionUnit	Size unit
	VariableSizeCompFormulaKey	VariableSizeCompFormulaKey	VSI Formula
	NumberOfVariableSizeItem	NumberOfVariableSizeItem	Number Required
	QuantityInUnitOfEntry	QuantityInUnitOfEntry	Quantity in UnE
	VariableSizeItemQuantity	VariableSizeItemQuantity	VSI Quantity
	VariableSizeComponentUnit	VariableSizeComponentUnit	VSI UoM
	ProductTypeGroupCode	ProductTypeGroupCode
	ServicePerformer	ServicePerformer	Service Performer
	PerformancePeriodStartDate	PerformancePeriodStartDate	Start of Performance Period
	PerformancePeriodEndDate	PerformancePeriodEndDate	End of Performance Period
	LeanServiceDuration	LeanServiceDuration	Service Duration
	LeanServiceDurationUnit	LeanServiceDurationUnit	Serv. Dur. Unit
	OverallLimitAmount	OverallLimitAmount	Overall Limit
	ExpectedOverallLimitAmount	ExpectedOverallLimitAmount	Expected Value
	PurReqnCollectiveIndicatorCode	PurReqnCollectiveIndicatorCode
	WBSElementExternalID	WBSElementExternalID	WBS Element External ID
	WBSElementInternalID	WBSElementInternalID	WBS Internal ID
	FldLogsDelivIsHeldOnShore	FldLogsDelivIsHeldOnShore	Hold On-Shore
	FldLogsSupplyProcess	FldLogsSupplyProcess	Supply Process
	FldLogsSupProcVersion	FldLogsSupProcVersion
	ProjectInternalID	ProjectInternalID	Project Def.
	AssignedWBSElementInternalID	AssignedWBSElementInternalID	WBS Element
	_ProjNtwkActyMatlCompStatus	_ProjNtwkActyMatlCompStatus

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 A_ProjNtwkActyMatlComp.
-- 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 A_ProjNtwkActyMatlComp AS
SELECT
  Reservation,
  ReservationItem,
  RecordType,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  ProjectNetwork,
  NetworkActivity,
  Material,
  MaterialName,
  Plant,
  BOMItemCategory,
  BillOfMaterialItemNumber,
  BOMItemDescription,
  RqmtDateIsEnteredManually,
  MatlCompRequirementDate,
  OperationLeadTimeOffset,
  OperationLeadTimeOffsetUnit,
  GoodsRecipientName,
  UnloadingPointName,
  IsMarkedForDeletion,
  StorageLocation,
  ProductionSeries,
  GoodsMovementIsAllowed,
  ReservationIsFinallyIssued,
  IsBulkMaterialComponent,
  MatlCompIsMarkedForBackflush,
  MaterialComponentIsMissing,
  GoodsMovementType,
  MatlCompProcurementType,
  BaseUnit,
  RequirementQuantityInBaseUnit,
  CommittedQuantity,
  AlignmentIsOperationStartDate,
  AlignmentIsOperationEndDate,
  QuantityDistributionKey,
  SortField,
  PurReqnOrResvnGeneration,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  BillOfMaterialCategory,
  BOMExplosionFixedKeyDate,
  Batch,
  MaterialCompIsCostRelevant,
  PurchasingGroup,
  MaterialComponentPrice,
  Currency,
  PurchasingInfoRecord,
  MaterialPriceUnitQty,
  GLAccount,
  Creditor,
  GoodsReceiptDurationInDays,
  DeliveryDurationInDays,
  MaterialGroup,
  QuantityInEntryUnit,
  EntryUnit,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  RequisitionerUser,
  RequirementTracking,
  PurgInfoRecdDataIsFixed,
  MatlCompProcmtIndicatorCode,
  AddressNumber,
  Customer,
  Supplier,
  VariableSizeDimension1,
  VariableSizeDimension2,
  VariableSizeDimension3,
  VariableSizeDimensionUnit,
  VariableSizeCompFormulaKey,
  NumberOfVariableSizeItem,
  QuantityInUnitOfEntry,
  VariableSizeItemQuantity,
  VariableSizeComponentUnit,
  ProductTypeGroupCode,
  ServicePerformer,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  PurReqnCollectiveIndicatorCode,
  WBSElementExternalID,
  WBSElementInternalID,
  FldLogsDelivIsHeldOnShore,
  FldLogsSupplyProcess,
  FldLogsSupProcVersion,
  ProjectInternalID,
  AssignedWBSElementInternalID
FROM R_ProjNtwkActyMatlCompTP
LEFT OUTER JOIN A_ProjNtwkActyMatlCompStatus AS _ProjNtwkActyMatlCompStatus ON _ProjectMaterialComp.Reservation = _ProjNtwkActyMatlCompStatus.Reservation AND _ProjectMaterialComp.ReservationItem = _ProjNtwkActyMatlCompStatus.ReservationItem AND _ProjectMaterialComp.RecordType = _ProjNtwkActyMatlCompStatus.RecordType  -- association [1..*]
LEFT OUTER JOIN E_ReservationDocumentItem AS _ReservationExtension ON Reservation = _ReservationExtension.Reservation AND ReservationItem = _ReservationExtension.ReservationItem AND RecordType = _ReservationExtension.RecordType  -- association [1..1]
LEFT OUTER JOIN E_ProjectMaterialComponent AS _MaterialExtension ON Reservation = _MaterialExtension.Reservation AND ReservationItem = _MaterialExtension.ReservationItem AND RecordType = _MaterialExtension.RecordType  -- association [1..1]
;

Depth:

A_ProjNtwkActyMatlComp view_entity

R_ProjNtwkActyMatlCompTP view_entity