C_PurchasingSourceItemDEX

DDL: C_PURCHASINGSOURCEITEMDEX SQL: CMMPPRSRCITMDEX Type: view CONSUMPTION

Data Extraction for Source List Item

C_PurchasingSourceItemDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Source List Item" in SAP S/4HANA. It reads from 1 data source (I_MPPurchasingSourceItem) and exposes 27 fields with key fields Material, Plant, SourceListRecord.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_MPPurchasingSourceItem I_MPPurchasingSourceItem from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMMPPRSRCITMDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Data Extraction for Source List Item view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.supportedCapabilities #EXTRACTION_DATA_SOURCE view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view

Fields (27)

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 
@AbapCatalog.sqlViewName: 'CMMPPRSRCITMDEX'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl:{ authorizationCheck             : #CHECK,
                 personalData.blocking          : #BLOCKED_DATA_EXCLUDED
               }
@EndUserText.label: 'Data Extraction for Source List Item'

@ClientHandling.algorithm                       : #SESSION_VARIABLE
@ObjectModel :{ usageType.dataClass             : #TRANSACTIONAL,
                usageType.sizeCategory          : #L,
                usageType.serviceQuality        : #D,
                supportedCapabilities           : #EXTRACTION_DATA_SOURCE
              }
     
@VDM.viewType                                   : #CONSUMPTION

@Metadata.ignorePropagatedAnnotations           : true

@Analytics: { dataCategory                      : #FACT,
              dataExtraction: {
                enabled                         : true,
                delta.changeDataCapture         : {
                    mapping:[ { table           : 'eord', role: #MAIN,
                                viewElement     : ['Material', 'Plant','SourceListRecord'],
                                tableElement    : ['matnr','werks','zeord']
                              }
                            ]
                }
              }
}
         
define view C_PurchasingSourceItemDEX
  as select from I_MPPurchasingSourceItem
{
  key  Material                     as Material,

  key  Plant                        as Plant,

  key  SourceListRecord             as SourceListRecord,

       @Semantics.businessDate.createdAt: true
       CreationDate                 as CreationDate,

       @Semantics.user.createdBy: true
       CreatedByUserName            as CreatedByUserName,

       @Semantics.businessDate.from: true
       ValidityStartDate            as ValidityStartDate,

       @Semantics.businessDate.to: true
       ValidityEndDate              as ValidityEndDate,

       Supplier                     as Supplier,

       SupplierIsFixed              as SupplierIsFixed,

       PurchaseOutlineAgreement     as PurchaseOutlineAgreement,

       PurchaseOutlineAgreementItem as PurchaseOutlineAgreementItem,

       PurOutlineAgreementIsFixed   as PurOutlineAgreementIsFixed,

       SupplyingPlant               as SupplyingPlant,

       IssgPlantIsFixed             as IssgPlantIsFixed,

       ManufacturerMaterial         as ManufacturerMaterial,

       SourceOfSupplyIsBlocked      as SourceOfSupplyIsBlocked,

       SourceOfSupplyIsFixed        as SourceOfSupplyIsFixed,

       SourceListStatus             as SourceListStatus,

       PurchasingOrganization       as PurchasingOrganization,

       PurchasingDocumentCategory   as PurchasingDocumentCategory,

       SourceListRecordCategory     as SourceListRecordCategory,

       MRPSourcingControl           as MRPSourcingControl,

       MRPArea                      as MRPArea,

       @Semantics.unitOfMeasure: true
       OrderQuantityUnit            as OrderQuantityUnit,

       OriginSystem                 as OriginSystem,

       InventorySpecialStockType    as InventorySpecialStockType,

       LastChangeDateTime           as LastChangeDateTime

}

Learn More