P_PurchDocWthGRIRFlagNotSet

DDL: P_PURCHDOCWTHGRIRFLAGNOTSET SQL: PPURCHINVNOTSET Type: view CONSUMPTION

Purchasing Document filtered by date

P_PurchDocWthGRIRFlagNotSet is a Consumption CDS View that provides data about "Purchasing Document filtered by date" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentItem, I_PurchasingDocument) and exposes 14 fields with key fields PurchasingDocument, PurchasingDocumentItem.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentItem PurchasingDocumentItem inner
I_PurchasingDocument PurchDoc from

Parameters (2)

NameTypeDefault
P_StartDate vdm_validitystart
P_EndDate vdm_validityend

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPURCHINVNOTSET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchasing Document filtered by date view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocument PurchasingDocument
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem
PurchasingDocumentItemUniqueID I_PurchasingDocumentItem PurchasingDocumentItemUniqueID
Supplier I_PurchasingDocument Supplier
PurchasingOrganization I_PurchasingDocument PurchasingOrganization
PurchasingDocumentCategory I_PurchasingDocument PurchasingDocumentCategory
PurchasingGroup I_PurchasingDocument PurchasingGroup
Material I_PurchasingDocumentItem Material
MaterialGroup I_PurchasingDocumentItem MaterialGroup
Plant I_PurchasingDocumentItem Plant
NetPriceAmount I_PurchasingDocumentItem NetPriceAmount
DocumentCurrency I_PurchasingDocumentItem DocumentCurrency
PurchasingDocumentOrderDate PurchasingDocumentOrderDate
_PurchasingDocumentCategory _PurchasingDocumentCategory 
@AbapCatalog.sqlViewName: 'PPURCHINVNOTSET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.private : true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType : #CONSUMPTION
@EndUserText.label: 'Purchasing Document filtered by date'


define view P_PurchDocWthGRIRFlagNotSet 
with parameters

  P_StartDate       : vdm_validitystart,
  P_EndDate       : vdm_validityend
  
as select from I_PurchasingDocument as PurchDoc 
inner join I_PurchasingDocumentItem     as PurchasingDocumentItem     on  PurchDoc.PurchasingDocument = PurchasingDocumentItem.PurchasingDocument
{

  key  PurchDoc.PurchasingDocument  as PurchasingDocument,
  key  PurchasingDocumentItem.PurchasingDocumentItem,
       PurchasingDocumentItem.PurchasingDocumentItemUniqueID,
       PurchDoc.Supplier,
       PurchDoc.PurchasingOrganization as PurchasingOrganization,
       PurchDoc.PurchasingDocumentCategory as PurchasingDocumentCategory,
       PurchDoc.PurchasingGroup as PurchasingGroup,
       PurchasingDocumentItem.Material,
       PurchasingDocumentItem.MaterialGroup,
       PurchasingDocumentItem.Plant,
       PurchasingDocumentItem.NetPriceAmount,
       
       PurchasingDocumentItem.DocumentCurrency,
       PurchasingDocumentOrderDate,
       _PurchasingDocumentCategory
      
       
       //   PurchDoc.PurchasingDocumentOrderDate,

  
} where PurchDoc.PurchasingDocumentOrderDate between $parameters.P_StartDate and $parameters.P_EndDate
 and ( PurchDoc.PurchasingDocumentCategory = 'F' )
 and PurchasingDocumentItem.InvoiceIsGoodsReceiptBased = ''
 and PurchDoc.PurchasingCompletenessStatus = '' 
 and PurchasingDocumentItem.PurchasingDocumentDeletionCode = '' 
 and PurchDoc.Supplier <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENTCATEGORY"
],
"BASE":
[
"I_PURCHASINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More