C_MPPurchasingSLGenerate

DDL: C_MPPURCHASINGSLGENERATE SQL: CMPPRSRCGENR Type: view CONSUMPTION
27 Fields 1 Data Sources 1 Associations

Consumption View for Source List Generate records

C_MPPurchasingSLGenerate is a Consumption CDS View that provides data about "Consumption View for Source List Generate records" in SAP S/4HANA. It reads from 1 data source (I_MPPurchasingSourceItem) and exposes 27 fields with key fields Material, Plant, SourceListRecord. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MPPurchasingSourceItem I_MPPurchasingSourceItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMPPRSRCGENR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View for Source List Generate records view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (27)

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

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_MPPurchasingSLGenerate.
-- 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: CMPPRSRCGENR

CREATE VIEW C_MPPurchasingSLGenerate AS
SELECT
  I_MPPurchasingSourceItem.Material AS Material,
  I_MPPurchasingSourceItem.Plant AS Plant,
  I_MPPurchasingSourceItem.SourceListRecord AS SourceListRecord,
  I_MPPurchasingSourceItem.CreationDate AS CreationDate,
  I_MPPurchasingSourceItem.CreatedByUserName AS CreatedByUserName,
  I_MPPurchasingSourceItem.ValidityStartDate AS ValidityStartDate,
  I_MPPurchasingSourceItem.ValidityEndDate AS ValidityEndDate,
  I_MPPurchasingSourceItem.Supplier AS Supplier,
  I_MPPurchasingSourceItem.SupplierIsFixed AS SupplierIsFixed,
  I_MPPurchasingSourceItem.PurchaseOutlineAgreement AS PurchaseOutlineAgreement,
  I_MPPurchasingSourceItem.PurchaseOutlineAgreementItem AS PurchaseOutlineAgreementItem,
  I_MPPurchasingSourceItem.PurOutlineAgreementIsFixed AS PurOutlineAgreementIsFixed,
  I_MPPurchasingSourceItem.SupplyingPlant AS SupplyingPlant,
  I_MPPurchasingSourceItem.IssgPlantIsFixed AS IssgPlantIsFixed,
  I_MPPurchasingSourceItem.ManufacturerMaterial AS ManufacturerMaterial,
  I_MPPurchasingSourceItem.SourceOfSupplyIsBlocked AS SourceOfSupplyIsBlocked,
  I_MPPurchasingSourceItem.SourceOfSupplyIsFixed AS SourceOfSupplyIsFixed,
  I_MPPurchasingSourceItem.SourceListStatus AS SourceListStatus,
  I_MPPurchasingSourceItem.PurchasingOrganization AS PurchasingOrganization,
  I_MPPurchasingSourceItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_MPPurchasingSourceItem.SourceListRecordCategory AS SourceListRecordCategory,
  I_MPPurchasingSourceItem.MRPSourcingControl AS MRPSourcingControl,
  I_MPPurchasingSourceItem.MRPArea AS MRPArea,
  I_MPPurchasingSourceItem.OrderQuantityUnit AS OrderQuantityUnit,
  I_MPPurchasingSourceItem.OriginSystem AS OriginSystem,
  I_MPPurchasingSourceItem.InventorySpecialStockType AS InventorySpecialStockType
FROM I_MPPurchasingSourceItem
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;

Learn More