I_PurchasingSourceItem

DDL: I_PURCHASINGSOURCEITEM SQL: IMPPRGSRCITEM Type: view BASIC

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.

1 data source(s) 29 fields

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 #C 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
KEY Plant Plant
KEY SourceListRecord SourceListRecord
CreationDate CreationDate
CreatedByUserName CreatedByUserName
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
Supplier Supplier
SupplierIsFixed SupplierIsFixed
PurchaseOutlineAgreement PurchaseOutlineAgreement
PurchaseOutlineAgreementItem PurchaseOutlineAgreementItem
PurOutlineAgreementIsFixed PurOutlineAgreementIsFixed
SupplyingPlant SupplyingPlant
IssgPlantIsFixed IssgPlantIsFixed
ManufacturerMaterial ManufacturerMaterial
SourceOfSupplyIsBlocked SourceOfSupplyIsBlocked
SourceOfSupplyIsFixed SourceOfSupplyIsFixed
SourceListStatus SourceListStatus
PurchasingOrganization PurchasingOrganization
PurchasingDocumentCategory PurchasingDocumentCategory
SourceListRecordCategory SourceListRecordCategory
MRPSourcingControl MRPSourcingControl
MRPArea MRPArea
OrderQuantityUnit OrderQuantityUnit
OriginSystem OriginSystem
InventorySpecialStockType InventorySpecialStockType
LastChangeDateTime LastChangeDateTime
_Material _Material
_Plant _Plant 
@AbapCatalog.sqlViewName: 'IMPPRGSRCITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA') 
@EndUserText.label: 'Purchasing Source list'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@Analytics.internalName:#LOCAL 
@ObjectModel.representativeKey:'SourceListRecord'
@Metadata.allowExtensions:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION ]
define view I_PurchasingSourceItem 
as select from I_MPPurchasingSourceItem 
association  to I_Material                 as _Material  on $projection.Material = _Material.Material
association  to I_Plant                    as _Plant     on $projection.Plant    = _Plant.Plant
association  to E_MPPurchasingSourceItem   as _Extension on $projection.Material = _Extension.Material
                                                        and $projection.Plant    = _Extension.Plant  
                                                        and $projection.SourceListRecord = _Extension.SourceListRecord
{
 @ObjectModel.foreignKey.association:'_Material'
 key Material,
 @ObjectModel.foreignKey.association:'_Plant'
 key Plant,
 key 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,
     _Material,
     _Plant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MPPURCHASINGSOURCEITEM"
],
"ASSOCIATED":
[
"E_MPPURCHASINGSOURCEITEM",
"I_MATERIAL",
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More