I_PurchasingSourceItem

DDL: I_PURCHASINGSOURCEITEM SQL: IMPPRGSRCITEM Type: view BASIC
29 Fields 1 Data Sources

Purchasing Source list

I_PurchasingSourceItem is a Basic CDS View that provides data about "Purchasing Source list" in SAP S/4HANA. It reads from 1 data source (I_MPPurchasingSourceItem) and exposes 29 fields with key fields Material, Plant, SourceListRecord.

Data Sources (1)

SourceAliasJoin Type
I_MPPurchasingSourceItem I_MPPurchasingSourceItem from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMPPRGSRCITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchasing Source list 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
Analytics.internalName #LOCAL view
ObjectModel.representativeKey SourceListRecord view
Metadata.allowExtensions true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY SourceListRecord SourceListRecord Number
CreationDate CreationDate Time Stamp
CreatedByUserName CreatedByUserName Person Resp.
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
Supplier Supplier Supplier
SupplierIsFixed SupplierIsFixed Fixed Supplier
PurchaseOutlineAgreement PurchaseOutlineAgreement Agreement
PurchaseOutlineAgreementItem PurchaseOutlineAgreementItem Item
PurOutlineAgreementIsFixed PurOutlineAgreementIsFixed Fixed Agmt Item
SupplyingPlant SupplyingPlant Supplying Plant
IssgPlantIsFixed IssgPlantIsFixed Fixed iss.plant
ManufacturerMaterial ManufacturerMaterial MPN: Material
SourceOfSupplyIsBlocked SourceOfSupplyIsBlocked Blocked
SourceOfSupplyIsFixed SourceOfSupplyIsFixed Indicator
SourceListStatus SourceListStatus Source List Status(Fixed/Blocked)
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
SourceListRecordCategory SourceListRecordCategory Control
MRPSourcingControl MRPSourcingControl MRP
MRPArea MRPArea MRP Area
OrderQuantityUnit OrderQuantityUnit Sales Unit
OriginSystem OriginSystem LogSys: Formula
InventorySpecialStockType InventorySpecialStockType Special Stock Type
LastChangeDateTime LastChangeDateTime Timestamp
_Material _Material
_Plant _Plant

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_PurchasingSourceItem.
-- 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: IMPPRGSRCITEM

CREATE VIEW I_PurchasingSourceItem AS
SELECT
  Material,
  Plant,
  SourceListRecord,
  CreationDate,
  CreatedByUserName,
  ValidityStartDate,
  ValidityEndDate,
  Supplier,
  SupplierIsFixed,
  PurchaseOutlineAgreement,
  PurchaseOutlineAgreementItem,
  PurOutlineAgreementIsFixed,
  SupplyingPlant,
  IssgPlantIsFixed,
  ManufacturerMaterial,
  SourceOfSupplyIsBlocked,
  SourceOfSupplyIsFixed,
  SourceListStatus,
  PurchasingOrganization,
  PurchasingDocumentCategory,
  SourceListRecordCategory,
  MRPSourcingControl,
  MRPArea,
  OrderQuantityUnit,
  OriginSystem,
  InventorySpecialStockType,
  LastChangeDateTime
FROM I_MPPurchasingSourceItem
;

Learn More