P_MPPurchasingSourceItem
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)
| Source | Alias | Join Type |
|---|---|---|
| I_MPPurchasingSourceItem | I_MPPurchasingSourceItem | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA