C_RequirementTrackingPurOrd

DDL: C_REQUIREMENTTRACKINGPURORD Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_REQUIREMENT_TRACK
55 Fields 1 Data Sources 5 Associations

Purchase Orders by Requirement Tracking

C_RequirementTrackingPurOrd is a Consumption CDS View that provides data about "Purchase Orders by Requirement Tracking" in SAP S/4HANA. It reads from 1 data source (P_RequirementTrackingPurOrd) and exposes 55 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 5 associations to related views. Part of development package ODATA_MM_PUR_REQUIREMENT_TRACK.

Data Sources (1)

SourceAliasJoin Type
P_RequirementTrackingPurOrd P_RequirementTrackingPurOrd from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_PurchasingCategoryMatlGroup _PurchasingCategoryMatlGrp $projection.MaterialGroup = _PurchasingCategoryMatlGrp.MaterialGroup
[0..1] C_MM_AccountAssignCatValueHelp _AccAssignValHelp _AccAssignValHelp.AccountAssignmentCategory = $projection.AccountAssignmentCategory
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] I_PurchasingOrganization _PurchasingOrganization $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
[1..1] I_PurchasingGroup _PurchasingGroup $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase Orders by Requirement Tracking view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #NONE view
Environment.sql.passValueForClient true view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchase Order
KEY PurchaseOrderItem PurchaseOrderItem Item
FormattedPurchaseOrderItem FormattedPurchaseOrderItem Purchase Order Item
RequirementTracking RequirementTracking Requirement Tracking Number
Material Material Vehicle Model
OrderQuantity OrderQuantity Order Quantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
OrderPriceUnit OrderPriceUnit Order Price Un.
NetAmount NetAmount Net Order Value
DocumentCurrency DocumentCurrency Document Currency
Supplier Supplier Supplier
MaterialGroup MaterialGroup Product Group
PurchasingText PurchasingText Short Text
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area
AccountAssignmentCategory AccountAssignmentCategory Account Assignment Category
CompanyCode CompanyCode Receiver Company Code
StorageLocation StorageLocation StorageLocation
PurchasingCategory PurchasingCategory Purchasing Category
PurgCatName PurgCatName Purchasing Cat. Name
PurchasingDocumentType PurchasingDocumentType Purchasing Document Type
PurchasingDocumentCategory PurchasingDocumentCategory Purchasing Document Category
PurchasingDocumentTypeName PurchasingDocumentTypeName Description
PurgDocExternalItemCategory PurgDocExternalItemCategory Item Category
PurchaseOrderItemCategory PurchaseOrderItemCategory Item Category
PurgDocItemCategoryName PurgDocItemCategoryName Text for ItCat.
PurchaseOrderDate PurchaseOrderDate PO Date
CreatedByUser CreatedByUser User Name
UserDescription UserDescription Created By
NetPriceAmount NetPriceAmount Net Price
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
DueDateCriticality DueDateCriticality
OpenPurchaseOrderQuantity OpenPurchaseOrderQuantity Open Purchase Order Quantity
PurchasingIsBlockedForSupplier PurchasingIsBlockedForSupplier Supplier Block Status
NetPriceQuantity NetPriceQuantity Price Unit
CreationDate CreationDate Time Stamp
GoodsReceiptQty GoodsReceiptQty Delivered Quantity
StillToBeDeliveredQuantity StillToBeDeliveredQuantity
GoodsReceiptAmountInDspCrcy GoodsReceiptAmountInDspCrcy Delivered Value
StillToBeDeliveredValue StillToBeDeliveredValue
InvoiceReceiptQty InvoiceReceiptQty Invoice Quantity
StillToInvoiceQuantity StillToInvoiceQuantity
InvoicedAmountInDspCurrency InvoicedAmountInDspCurrency
StillToInvoiceValue StillToInvoiceValue
_PurchasingCategoryMatlGrp _PurchasingCategoryMatlGrp
_AccAssignValHelp _AccAssignValHelp
_Material _Material
_MaterialGroup _MaterialGroup
_Plant _Plant
_CompanyCode _CompanyCode
_StorageLocation _StorageLocation
_Supplier _Supplier
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup

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 C_RequirementTrackingPurOrd.
-- 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 C_RequirementTrackingPurOrd AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  FormattedPurchaseOrderItem,
  RequirementTracking,
  Material,
  OrderQuantity,
  PurchaseOrderQuantityUnit,
  OrderPriceUnit,
  NetAmount,
  DocumentCurrency,
  Supplier,
  MaterialGroup,
  PurchasingText,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  AccountAssignmentCategory,
  CompanyCode,
  StorageLocation,
  PurchasingCategory,
  PurgCatName,
  PurchasingDocumentType,
  PurchasingDocumentCategory,
  PurchasingDocumentTypeName,
  PurgDocExternalItemCategory,
  PurchaseOrderItemCategory,
  PurgDocItemCategoryName,
  PurchaseOrderDate,
  CreatedByUser,
  UserDescription,
  NetPriceAmount,
  ScheduleLineDeliveryDate,
  DueDateCriticality,
  OpenPurchaseOrderQuantity,
  PurchasingIsBlockedForSupplier,
  NetPriceQuantity,
  CreationDate,
  GoodsReceiptQty,
  StillToBeDeliveredQuantity,
  GoodsReceiptAmountInDspCrcy,
  StillToBeDeliveredValue,
  InvoiceReceiptQty,
  StillToInvoiceQuantity,
  InvoicedAmountInDspCurrency,
  StillToInvoiceValue
FROM P_RequirementTrackingPurOrd
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGrp ON MaterialGroup = _PurchasingCategoryMatlGrp.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN C_MM_AccountAssignCatValueHelp AS _AccAssignValHelp ON _AccAssignValHelp.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
;

Learn More