P_MPPurchasingSourceItem

DDL: P_MPPURCHASINGSOURCEITEM SQL: PMPPRSRCITM Type: view COMPOSITE

P_MPPurchasingSourceItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MPPurchasingSourceItem) and exposes 40 fields with key fields Material, Plant, SourceListRecord.

Data Sources (1)

SourceAliasJoin Type
I_MPPurchasingSourceItem I_MPPurchasingSourceItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMPPRSRCITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (40)

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
LastChangeDateTime I_MPPurchasingSourceItem LastChangeDateTime
IsActiveEntity
_MPPurchasingSource I_MPPurchasingSourceItem _MPPurchasingSource
_Material I_MPPurchasingSourceItem _Material
_Plant I_MPPurchasingSourceItem _Plant
_Supplier I_MPPurchasingSourceItem _Supplier
_PurchaseContract I_MPPurchasingSourceItem _PurchaseContract
_PurchaseContractItem I_MPPurchasingSourceItem _PurchaseContractItem
_SupplyingPlant I_MPPurchasingSourceItem _SupplyingPlant
_PurchasingOrganization I_MPPurchasingSourceItem _PurchasingOrganization
_MaterialPlanningUsage_SL I_MPPurchasingSourceItem _MaterialPlanningUsage_SL
_MPPurchasingSourceStatus I_MPPurchasingSourceItem _MPPurchasingSourceStatus
_UnitOfMeasure I_MPPurchasingSourceItem _UnitOfMeasure
_LogicalSystem I_MPPurchasingSourceItem _LogicalSystem
@AbapCatalog.sqlViewName: 'PMPPRSRCITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE

@ObjectModel.semanticKey:['Material', 'Plant', 'SourceListRecord']

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_MPPurchasingSourceItem as select from I_MPPurchasingSourceItem {
  key I_MPPurchasingSourceItem.Material,
  key I_MPPurchasingSourceItem.Plant,
  key I_MPPurchasingSourceItem.SourceListRecord,
  I_MPPurchasingSourceItem.CreationDate,
  I_MPPurchasingSourceItem.CreatedByUserName,
  I_MPPurchasingSourceItem.ValidityStartDate, 
  I_MPPurchasingSourceItem.ValidityEndDate,
  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,
  I_MPPurchasingSourceItem.LastChangeDateTime,
  cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity,
   
  I_MPPurchasingSourceItem._MPPurchasingSource,
  
  I_MPPurchasingSourceItem._Material,
  I_MPPurchasingSourceItem._Plant,
  I_MPPurchasingSourceItem._Supplier,
  I_MPPurchasingSourceItem._PurchaseContract,
  I_MPPurchasingSourceItem._PurchaseContractItem,
  I_MPPurchasingSourceItem._SupplyingPlant,
  I_MPPurchasingSourceItem._PurchasingOrganization,
  I_MPPurchasingSourceItem._MaterialPlanningUsage_SL,
  I_MPPurchasingSourceItem._MPPurchasingSourceStatus,
  I_MPPurchasingSourceItem._UnitOfMeasure,
  I_MPPurchasingSourceItem._LogicalSystem
}                                              
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MPPURCHASINGSOURCEITEM"
],
"ASSOCIATED":
[
"I_LOGICALSYSTEM",
"I_MATERIAL",
"I_MATERIALPLANNINGUSAGE_SL",
"I_MPPURCHASINGSOURCE",
"I_MPPURCHASINGSOURCESTATUS",
"I_PLANT",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MPPURCHASINGSOURCEITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/