What is I_PurgInfoRecdOrgPlntDataApi01 in SAP S/4HANA?

I_PurgInfoRecdOrgPlntDataApi01 is a basic CDS view in SAP S/4HANA. Org Plant Data for Purch Info Record It contains 51 fields.

Which tables does I_PurgInfoRecdOrgPlntDataApi01 read from?

I_PurgInfoRecdOrgPlntDataApi01 reads data from: I_PurgInfoRecdOrgPlantData.

What VDM layer is I_PurgInfoRecdOrgPlntDataApi01?

I_PurgInfoRecdOrgPlntDataApi01 is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PurgInfoRecdOrgPlntDataApi01

DDL: I_PURGINFORECDORGPLNTDATAAPI01 SQL: IINFORECORGAPI01 Type: view BASIC

51 Fields 1 Data Sources

Org Plant Data for Purch Info Record

I_PurgInfoRecdOrgPlntDataApi01 (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_PurgInfoRecdOrgPlntDataApi01 is a Basic CDS View that provides data about "Org Plant Data for Purch Info Record" in SAP S/4HANA. It reads from 1 data source (I_PurgInfoRecdOrgPlantData) and exposes 51 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant.

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-SQ-QTA
Capabilities	Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_PurgInfoRecdOrgPlantData	I_PurgInfoRecdOrgPlantData	from

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	IINFORECORGAPI01	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#BASIC	view
EndUserText.label	Org Plant Data for Purch Info Record	view

Fields (51)

Key	Field	Source Table	Source Field	Description
KEY	PurchasingInfoRecord	I_PurgInfoRecdOrgPlantData	PurchasingInfoRecord	Number of purchasing info record
KEY	PurchasingOrganization	I_PurgInfoRecdOrgPlantData	PurchasingOrganization	Purchasing Organization
KEY	PurchasingInfoRecordCategory	I_PurgInfoRecdOrgPlantData	PurchasingInfoRecordCategory	Purchasing info record category
KEY	Plant	I_PurgInfoRecdOrgPlantData	Plant	Valuation Area
	CreatedByUser	I_PurgInfoRecdOrgPlantData	CreatedByUser	Name of Person Responsible for Creating the Object
	IsMarkedForDeletion	I_PurgInfoRecdOrgPlantData	IsMarkedForDeletion	Purch. info: Purch. organization data flagged for deletion
	PurchasingGroup	I_PurgInfoRecdOrgPlantData	PurchasingGroup	Purchasing Group
	Currency	I_PurgInfoRecdOrgPlantData	Currency	Valuation Crcy
	MinimumPurchaseOrderQuantity	I_PurgInfoRecdOrgPlantData	MinimumPurchaseOrderQuantity	Minimum Purchase Order Quantity
	StandardPurchaseOrderQuantity	I_PurgInfoRecdOrgPlantData	StandardPurchaseOrderQuantity	Standard Purchase Order Quantity
	MaterialPlannedDeliveryDurn	I_PurgInfoRecdOrgPlantData	MaterialPlannedDeliveryDurn	Planned Delivery Time in Days
	OverdelivTolrtdLmtRatioInPct	I_PurgInfoRecdOrgPlantData	OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance
	UnderdelivTolrtdLmtRatioInPct	I_PurgInfoRecdOrgPlantData	UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance
	UnlimitedOverdeliveryIsAllowed	I_PurgInfoRecdOrgPlantData	UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed
	LastReferencingPurchaseOrder	I_PurgInfoRecdOrgPlantData	LastReferencingPurchaseOrder	Purchasing Document Number
	LastReferencingPurOrderItem	I_PurgInfoRecdOrgPlantData	LastReferencingPurOrderItem	Item Number of Purchasing Document
	NetPriceAmount	I_PurgInfoRecdOrgPlantData	NetPriceAmount	Net Price in Purchasing Info Record
	PurgInfoRecdEffctvPrc	I_PurgInfoRecdOrgPlantData	PurgInfoRecdEffctvPrc	Effective Price in Purchasing Info Record
	MaterialPriceUnitQty	I_PurgInfoRecdOrgPlantData	MaterialPriceUnitQty	Price unit
	PurchaseOrderPriceUnit	I_PurgInfoRecdOrgPlantData	PurchaseOrderPriceUnit	Order Price Unit (Purchasing)
	PriceValidityEndDate	I_PurgInfoRecdOrgPlantData	PriceValidityEndDate	Price Valid Until
	OrderPriceUnitToOrderUnitNmrtr	I_PurgInfoRecdOrgPlantData	OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit
	OrdPriceUnitToOrderUnitDnmntr	I_PurgInfoRecdOrgPlantData	OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit
	InvoiceIsGoodsReceiptBased	I_PurgInfoRecdOrgPlantData	InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification
	TaxCode	I_PurgInfoRecdOrgPlantData	TaxCode	Tax on sales/purchases code
	IncotermsClassification	I_PurgInfoRecdOrgPlantData	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	I_PurgInfoRecdOrgPlantData	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsLocation1	I_PurgInfoRecdOrgPlantData	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	I_PurgInfoRecdOrgPlantData	IncotermsLocation2	Incoterms Location 2
	MaximumOrderQuantity	I_PurgInfoRecdOrgPlantData	MaximumOrderQuantity	Maximum Purchase Order Quantity
	IsRelevantForAutomSrcg	I_PurgInfoRecdOrgPlantData	IsRelevantForAutomSrcg	Relevant for Automatic Sourcing
	IncotermsVersion	I_PurgInfoRecdOrgPlantData	IncotermsVersion	Incoterms Version
	SupplierQuotation	I_PurgInfoRecdOrgPlantData	SupplierQuotation	Quotation Number
	SupplierQuotationDate	I_PurgInfoRecdOrgPlantData	SupplierQuotationDate	Quotation Validity Date
	MinRemainingShelfLife	I_PurgInfoRecdOrgPlantData	MinRemainingShelfLife	Minimum Remaining Shelf Life
	ShippingInstruction	I_PurgInfoRecdOrgPlantData	ShippingInstruction	Shipping Instructions
	IsEvaluatedRcptSettlmtAllowed	I_PurgInfoRecdOrgPlantData	IsEvaluatedRcptSettlmtAllowed	No Evaluated Receipt Settlement (ERS)
	IsPurOrderAllwdForInbDeliv	I_PurgInfoRecdOrgPlantData	IsPurOrderAllwdForInbDeliv	Create Purchase Order for Delivery Without Reference
	IsOrderAcknRqd	I_PurgInfoRecdOrgPlantData	IsOrderAcknRqd	Order Acknowledgment Requirement
	SupplierConfirmationControlKey	I_PurgInfoRecdOrgPlantData	SupplierConfirmationControlKey	Confirmation Control Key
	MaterialRoundingProfile	I_PurgInfoRecdOrgPlantData	MaterialRoundingProfile	Rounding Profile
	MaterialStagingTime	I_PurgInfoRecdOrgPlantData	MaterialStagingTime	Staging Time in Days
	ProductUnitGroup	I_PurgInfoRecdOrgPlantData	ProductUnitGroup	Unit of Measure Group
	IsRetMatlAuthznRqdBySupplier	I_PurgInfoRecdOrgPlantData	IsRetMatlAuthznRqdBySupplier	Supplier RMA Number Required
	SuplrRetMatlAuthznRqmtSts	I_PurgInfoRecdOrgPlantData	IsRetMatlAuthznRqdBySupplier	Supplier RMA Number Required
	IsCashDiscountGranted	I_PurgInfoRecdOrgPlantData	IsCashDiscountGranted	Item Does Not Qualify for Cash Discount
	MaterialConditionGroup	I_PurgInfoRecdOrgPlantData	MaterialConditionGroup	Condition Group with Supplier
	PricingDateControl	I_PurgInfoRecdOrgPlantData	PricingDateControl	Price Determination (Pricing) Date Control
	PurchasingDocumentDate	I_PurgInfoRecdOrgPlantData	PurchasingDocumentDate	Date of Last PO or Sched. Agreement Document in Info Record
	ShelfLifeExpirationDatePeriod	I_PurgInfoRecdOrgPlantData	ShelfLifeExpirationDatePeriod	Period Indicator for Shelf Life Expiration Date
	ProductionVersion	I_PurgInfoRecdOrgPlantData	ProductionVersion	Production Version

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_PurgInfoRecdOrgPlntDataApi01.
-- 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: IINFORECORGAPI01

CREATE VIEW I_PurgInfoRecdOrgPlntDataApi01 AS
SELECT
  I_PurgInfoRecdOrgPlantData.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_PurgInfoRecdOrgPlantData.PurchasingOrganization AS PurchasingOrganization,
  I_PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  I_PurgInfoRecdOrgPlantData.Plant AS Plant,
  I_PurgInfoRecdOrgPlantData.CreatedByUser AS CreatedByUser,
  I_PurgInfoRecdOrgPlantData.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_PurgInfoRecdOrgPlantData.PurchasingGroup AS PurchasingGroup,
  I_PurgInfoRecdOrgPlantData.Currency AS Currency,
  I_PurgInfoRecdOrgPlantData.MinimumPurchaseOrderQuantity AS MinimumPurchaseOrderQuantity,
  I_PurgInfoRecdOrgPlantData.StandardPurchaseOrderQuantity AS StandardPurchaseOrderQuantity,
  I_PurgInfoRecdOrgPlantData.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  I_PurgInfoRecdOrgPlantData.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  I_PurgInfoRecdOrgPlantData.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  I_PurgInfoRecdOrgPlantData.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  I_PurgInfoRecdOrgPlantData.LastReferencingPurchaseOrder AS LastReferencingPurchaseOrder,
  I_PurgInfoRecdOrgPlantData.LastReferencingPurOrderItem AS LastReferencingPurOrderItem,
  I_PurgInfoRecdOrgPlantData.NetPriceAmount AS NetPriceAmount,
  I_PurgInfoRecdOrgPlantData.PurgInfoRecdEffctvPrc AS PurgInfoRecdEffctvPrc,
  I_PurgInfoRecdOrgPlantData.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  I_PurgInfoRecdOrgPlantData.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  I_PurgInfoRecdOrgPlantData.PriceValidityEndDate AS PriceValidityEndDate,
  I_PurgInfoRecdOrgPlantData.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  I_PurgInfoRecdOrgPlantData.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  I_PurgInfoRecdOrgPlantData.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  I_PurgInfoRecdOrgPlantData.TaxCode AS TaxCode,
  I_PurgInfoRecdOrgPlantData.IncotermsClassification AS IncotermsClassification,
  I_PurgInfoRecdOrgPlantData.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_PurgInfoRecdOrgPlantData.IncotermsLocation1 AS IncotermsLocation1,
  I_PurgInfoRecdOrgPlantData.IncotermsLocation2 AS IncotermsLocation2,
  I_PurgInfoRecdOrgPlantData.MaximumOrderQuantity AS MaximumOrderQuantity,
  I_PurgInfoRecdOrgPlantData.IsRelevantForAutomSrcg AS IsRelevantForAutomSrcg,
  I_PurgInfoRecdOrgPlantData.IncotermsVersion AS IncotermsVersion,
  I_PurgInfoRecdOrgPlantData.SupplierQuotation AS SupplierQuotation,
  I_PurgInfoRecdOrgPlantData.SupplierQuotationDate AS SupplierQuotationDate,
  I_PurgInfoRecdOrgPlantData.MinRemainingShelfLife AS MinRemainingShelfLife,
  I_PurgInfoRecdOrgPlantData.ShippingInstruction AS ShippingInstruction,
  I_PurgInfoRecdOrgPlantData.IsEvaluatedRcptSettlmtAllowed AS IsEvaluatedRcptSettlmtAllowed,
  I_PurgInfoRecdOrgPlantData.IsPurOrderAllwdForInbDeliv AS IsPurOrderAllwdForInbDeliv,
  I_PurgInfoRecdOrgPlantData.IsOrderAcknRqd AS IsOrderAcknRqd,
  I_PurgInfoRecdOrgPlantData.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  I_PurgInfoRecdOrgPlantData.MaterialRoundingProfile AS MaterialRoundingProfile,
  I_PurgInfoRecdOrgPlantData.MaterialStagingTime AS MaterialStagingTime,
  I_PurgInfoRecdOrgPlantData.ProductUnitGroup AS ProductUnitGroup,
  I_PurgInfoRecdOrgPlantData.IsRetMatlAuthznRqdBySupplier AS IsRetMatlAuthznRqdBySupplier,
  I_PurgInfoRecdOrgPlantData.IsRetMatlAuthznRqdBySupplier AS SuplrRetMatlAuthznRqmtSts,
  I_PurgInfoRecdOrgPlantData.IsCashDiscountGranted AS IsCashDiscountGranted,
  I_PurgInfoRecdOrgPlantData.MaterialConditionGroup AS MaterialConditionGroup,
  I_PurgInfoRecdOrgPlantData.PricingDateControl AS PricingDateControl,
  I_PurgInfoRecdOrgPlantData.PurchasingDocumentDate AS PurchasingDocumentDate,
  I_PurgInfoRecdOrgPlantData.ShelfLifeExpirationDatePeriod AS ShelfLifeExpirationDatePeriod,
  I_PurgInfoRecdOrgPlantData.ProductionVersion AS ProductionVersion
FROM I_PurgInfoRecdOrgPlantData
;

Depth:

I_PurgInfoRecdOrgPlntDataApi01 view

I_PurgInfoRecdOrgPlantData view