P_FilteredSourceOfSupply

DDL: P_FILTEREDSOURCEOFSUPPLY SQL: PFILTERDSOS Type: view CONSUMPTION

Filtered Source of Supply

P_FilteredSourceOfSupply is a Consumption CDS View that provides data about "Filtered Source of Supply" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocument, I_PurchasingDocumentItem) and exposes 19 fields with key fields SourceDocument, SourceDocumentItem.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocument SourceDocument from
I_PurchasingDocumentItem SourceDocumentItem inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFILTERDSOS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Filtered Source of Supply view
AbapCatalog.preserveKey true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SourceDocument I_PurchasingDocument PurchasingDocument
KEY SourceDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem
Supplier I_PurchasingDocument Supplier
PurchasingOrganization I_PurchasingDocument PurchasingOrganization
PurchasingGroup I_PurchasingDocument PurchasingGroup
PurchasingDocumentType I_PurchasingDocument PurchasingDocumentType
PurchasingSourceType I_PurchasingDocument PurchasingDocumentCategory
Material I_PurchasingDocumentItem Material
MaterialGroup I_PurchasingDocumentItem MaterialGroup
Plant I_PurchasingDocumentItem Plant
ValidityEndDate I_PurchasingDocument ValidityEndDate
ValidityStartDate I_PurchasingDocument ValidityStartDate
CreationDate I_PurchasingDocument CreationDate
TargetAmount
DocumentCurrency I_PurchasingDocument DocumentCurrency
TargetQuantity I_PurchasingDocumentItem TargetQuantity
OrderQuantityUnit I_PurchasingDocumentItem OrderQuantityUnit
NetPriceAmount I_PurchasingDocumentItem NetPriceAmount
NetPriceQuantity I_PurchasingDocumentItem NetPriceQuantity 
@AbapCatalog.sqlViewName: 'PFILTERDSOS'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #CONSUMPTION
//@Analytics.dataCategory: #CUBE

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Filtered Source of Supply'
@AbapCatalog.preserveKey:true
define view P_FilteredSourceOfSupply
  as select from I_PurchasingDocument     as SourceDocument
    inner join   I_PurchasingDocumentItem as SourceDocumentItem on SourceDocument.PurchasingDocument = SourceDocumentItem.PurchasingDocument
{

  key SourceDocument.PurchasingDocument               as SourceDocument,
  key SourceDocumentItem.PurchasingDocumentItem       as SourceDocumentItem,
      //  key SourceDocument.PurchasingSourceType,


      SourceDocument.Supplier,
      SourceDocument.PurchasingOrganization,
      SourceDocument.PurchasingGroup,
      SourceDocument.PurchasingDocumentType,
      SourceDocument.PurchasingDocumentCategory       as PurchasingSourceType,
      SourceDocumentItem.Material,
      SourceDocumentItem.MaterialGroup,
      SourceDocumentItem.Plant,
      //ContractClassification.PurchaseContractClassification,


      SourceDocument.ValidityEndDate,
      SourceDocument.ValidityStartDate,
      SourceDocument.CreationDate,
      cast(   SourceDocument.TargetAmount  as ktwrt ) as TargetAmount,
      SourceDocument.DocumentCurrency,
      SourceDocumentItem.TargetQuantity,
      SourceDocumentItem.OrderQuantityUnit,
      SourceDocumentItem.NetPriceAmount,
      SourceDocumentItem.NetPriceQuantity

}
where
       SourceDocument.ValidityStartDate              < $session.system_date
  and  SourceDocument.ValidityEndDate                > $session.system_date
  and(
       SourceDocument.PurchasingDocumentCategory     = 'K'
    or SourceDocument.PurchasingDocumentCategory     = 'L'
  )
  and  SourceDocumentItem.Material != ''
  and  SourceDocument.PurchasingDocumentDeletionCode = ''
  and  SourceDocument.IsEndOfPurposeBlocked          = ''
  and  SourceDocument. ReleaseIsNotCompleted         = ''

Learn More