CIC_PURCHASING_INFO_RECORD

DDL: CIC_PURCHASING_INFO_RECORD Type: view_entity
27 Fields 2 Data Sources 1 Associations

Source of Supply Type B: Purchasing Info Record

CIC_PURCHASING_INFO_RECORD is a CDS View that provides data about "Source of Supply Type B: Purchasing Info Record" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingInfoRecord, I_PurgInfoRecdOrgPlantData) and exposes 27 fields with key fields Supplier, Receiver, Product, SourceOfSupplyType, ProductGroup. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurchasingInfoRecord eina from
I_PurgInfoRecdOrgPlantData eine inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Site _Site $projection.Supplier = _Site.SiteSupplier

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Source of Supply Type B: Purchasing Info Record view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_PurchasingInfoRecord Supplier Supplier
KEY Receiver
KEY Product I_PurchasingInfoRecord Material Vehicle Model
KEY SourceOfSupplyType
KEY ProductGroup I_PurchasingInfoRecord MaterialGroup Product Group
KEY PurchasingOrganization I_PurgInfoRecdOrgPlantData PurchasingOrganization Purchasing Organization
KEY ValidityStartDate I_PurchasingInfoRecord AvailabilityStartDate Available from
KEY ValidityEndDate I_PurchasingInfoRecord AvailabilityEndDate Available to
KEY Category I_PurgInfoRecdOrgPlantData PurchasingInfoRecordCategory Infotype
ReceivingTimeZone
SiteendasSupplyingPlant
ReceivingPlant I_PurgInfoRecdOrgPlantData Plant Valuation Area
IsPurchasingBlocked
PurchasingInfoRecord I_PurchasingInfoRecord PurchasingInfoRecord Info Record
SupplierSubrange I_PurchasingInfoRecord SupplierSubrange Suppl. Subrange
OrderQuantityUnit I_PurchasingInfoRecord PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
OrderCurrency I_PurgInfoRecdOrgPlantData Currency Valuation Crcy
MinimumOrderQuantity I_PurgInfoRecdOrgPlantData MinimumPurchaseOrderQuantity Minimum Qty
PlannedDeliveryTimeDays I_PurgInfoRecdOrgPlantData MaterialPlannedDeliveryDurn Pl. Deliv. Time
PurchasingGroup I_PurgInfoRecdOrgPlantData PurchasingGroup Purchasing Group
IncotermsClassification I_PurgInfoRecdOrgPlantData IncotermsClassification Incoterms
IncotermsTransferLocationName I_PurgInfoRecdOrgPlantData IncotermsTransferLocation Incoterms 2
SourceListRecord
NetPriceAmount I_PurgInfoRecdOrgPlantData NetPriceAmount Net Price
NetPriceQuantity I_PurgInfoRecdOrgPlantData MaterialPriceUnitQty Price unit
NetPriceUnit I_PurgInfoRecdOrgPlantData PurchaseOrderPriceUnit Order Price Un.
LogisticalRoundingProfile I_PurgInfoRecdOrgPlantData MaterialRoundingProfile Rnding Profile

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 CIC_PURCHASING_INFO_RECORD.
-- 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 CIC_PURCHASING_INFO_RECORD AS
SELECT
  eina.Supplier AS Supplier,
  eine._Plant.PlantCustomer AS Receiver,
  eina.Material AS Product,
  'B' AS SourceOfSupplyType,
  eina.MaterialGroup AS ProductGroup,
  eine.PurchasingOrganization AS PurchasingOrganization,
  eina.AvailabilityStartDate AS ValidityStartDate,
  eina.AvailabilityEndDate AS ValidityEndDate,
  eine.PurchasingInfoRecordCategory AS Category,
  eine._Plant._Address.AddressTimeZone AS ReceivingTimeZone,
  case when _Site.Site is null then '' else _Site.Site end as SupplyingPlant AS SiteendasSupplyingPlant,
  eine.Plant AS ReceivingPlant,
  '' AS IsPurchasingBlocked,
  eina.PurchasingInfoRecord AS PurchasingInfoRecord,
  eina.SupplierSubrange AS SupplierSubrange,
  eina.PurgDocOrderQuantityUnit AS OrderQuantityUnit,
  eine.Currency AS OrderCurrency,
  eine.MinimumPurchaseOrderQuantity AS MinimumOrderQuantity,
  eine.MaterialPlannedDeliveryDurn AS PlannedDeliveryTimeDays,
  eine.PurchasingGroup AS PurchasingGroup,
  eine.IncotermsClassification AS IncotermsClassification,
  eine.IncotermsTransferLocation AS IncotermsTransferLocationName,
  cast('00000' as dzeord) AS SourceListRecord,
  eine.NetPriceAmount AS NetPriceAmount,
  eine.MaterialPriceUnitQty AS NetPriceQuantity,
  eine.PurchaseOrderPriceUnit AS NetPriceUnit,
  eine.MaterialRoundingProfile AS LogisticalRoundingProfile
FROM I_PurchasingInfoRecord AS eina
INNER JOIN I_PurgInfoRecdOrgPlantData AS eine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Site AS _Site ON Supplier = _Site.SiteSupplier  -- association [0..1]
;

Learn More