C_MPPurchasingSLGenerate

DDL: C_MPPURCHASINGSLGENERATE SQL: CMPPRSRCGENR Type: view CONSUMPTION

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.

1 data source(s) 27 fields

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
KEY Plant I_MPPurchasingSourceItem Plant
KEY SourceListRecord I_MPPurchasingSourceItem SourceListRecord
CreationDate I_MPPurchasingSourceItem CreationDate
CreatedByUserName I_MPPurchasingSourceItem CreatedByUserName
ValidityStartDate I_MPPurchasingSourceItem ValidityStartDate
ValidityEndDate I_MPPurchasingSourceItem ValidityEndDate
Supplier I_MPPurchasingSourceItem Supplier
SupplierIsFixed I_MPPurchasingSourceItem SupplierIsFixed
PurchaseOutlineAgreement I_MPPurchasingSourceItem PurchaseOutlineAgreement
PurchaseOutlineAgreementItem I_MPPurchasingSourceItem PurchaseOutlineAgreementItem
PurOutlineAgreementIsFixed I_MPPurchasingSourceItem PurOutlineAgreementIsFixed
SupplyingPlant I_MPPurchasingSourceItem SupplyingPlant
IssgPlantIsFixed I_MPPurchasingSourceItem IssgPlantIsFixed
ManufacturerMaterial I_MPPurchasingSourceItem ManufacturerMaterial
SourceOfSupplyIsBlocked I_MPPurchasingSourceItem SourceOfSupplyIsBlocked
SourceOfSupplyIsFixed I_MPPurchasingSourceItem SourceOfSupplyIsFixed
SourceListStatus I_MPPurchasingSourceItem SourceListStatus
PurchasingOrganization I_MPPurchasingSourceItem PurchasingOrganization
PurchasingDocumentCategory I_MPPurchasingSourceItem PurchasingDocumentCategory
SourceListRecordCategory I_MPPurchasingSourceItem SourceListRecordCategory
MRPSourcingControl I_MPPurchasingSourceItem MRPSourcingControl
MRPArea I_MPPurchasingSourceItem MRPArea
OrderQuantityUnit I_MPPurchasingSourceItem OrderQuantityUnit
OriginSystem I_MPPurchasingSourceItem OriginSystem
InventorySpecialStockType I_MPPurchasingSourceItem InventorySpecialStockType
_Supplier _Supplier 
@AbapCatalog.sqlViewName: 'CMPPRSRCGENR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption View for Source List Generate records'
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M  
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_MPPurchasingSLGenerate as select from I_MPPurchasingSourceItem
association [0..1] to I_Supplier                   as _Supplier     on  $projection.Supplier = _Supplier.Supplier
{
key I_MPPurchasingSourceItem.Material, 
key I_MPPurchasingSourceItem.Plant, 
key I_MPPurchasingSourceItem.SourceListRecord, 
I_MPPurchasingSourceItem.CreationDate, 
I_MPPurchasingSourceItem.CreatedByUserName, 
I_MPPurchasingSourceItem.ValidityStartDate, 
I_MPPurchasingSourceItem.ValidityEndDate, 
@ObjectModel.text.association: '_Supplier'
I_MPPurchasingSourceItem.Supplier, 
I_MPPurchasingSourceItem.SupplierIsFixed, 
I_MPPurchasingSourceItem.PurchaseOutlineAgreement, 
I_MPPurchasingSourceItem.PurchaseOutlineAgreementItem, 
I_MPPurchasingSourceItem.PurOutlineAgreementIsFixed, 
I_MPPurchasingSourceItem.SupplyingPlant, 
I_MPPurchasingSourceItem.IssgPlantIsFixed, 
I_MPPurchasingSourceItem.ManufacturerMaterial, 
I_MPPurchasingSourceItem.SourceOfSupplyIsBlocked, 
I_MPPurchasingSourceItem.SourceOfSupplyIsFixed, 
I_MPPurchasingSourceItem.SourceListStatus, 
I_MPPurchasingSourceItem.PurchasingOrganization, 
I_MPPurchasingSourceItem.PurchasingDocumentCategory, 
I_MPPurchasingSourceItem.SourceListRecordCategory, 
I_MPPurchasingSourceItem.MRPSourcingControl, 
I_MPPurchasingSourceItem.MRPArea, 
I_MPPurchasingSourceItem.OrderQuantityUnit, 
I_MPPurchasingSourceItem.OriginSystem, 
I_MPPurchasingSourceItem.InventorySpecialStockType,
_Supplier
}           
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MPPURCHASINGSOURCEITEM"
],
"ASSOCIATED":
[
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More