P_GRIR_USER

DDL: P_GRIR_USER SQL: PFIGRIRUSER Type: view CONSUMPTION

P_GRIR_USER is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentItem, P_GRIRUSR_AUTH_OBJ) and exposes 11 fields.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentItem I_PurchasingDocumentItem from
P_GRIRUSR_AUTH_OBJ P_GRIRUSR_AUTH_OBJ cross

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PFIGRIRUSER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
PurchasingDocument I_PurchasingDocumentItem PurchasingDocument
PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem
CompanyCode I_PurchasingDocumentItem CompanyCode
PurchasingOrganization
PurchasingGroup
Plant I_PurchasingDocumentItem Plant
GRIRClearingProcessStatus
AuthorizationGroup
bname P_GRIRUSR_AUTH_OBJ bname
auth P_GRIRUSR_AUTH_OBJ auth
objct P_GRIRUSR_AUTH_OBJ objct 
@AbapCatalog.sqlViewName: 'PFIGRIRUSER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
//@EndUserText.label: 'User for GRIR Reconcilaition'


@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@Metadata.ignorePropagatedAnnotations: true

define view P_GRIR_USER as select from I_PurchasingDocumentItem 

left outer to one join I_GRIRProcess on  I_PurchasingDocumentItem.CompanyCode = I_GRIRProcess.CompanyCode and
 I_PurchasingDocumentItem.PurchasingDocument = I_GRIRProcess.PurchasingDocument and
 I_PurchasingDocumentItem.PurchasingDocumentItem = I_GRIRProcess.PurchasingDocumentItem
 
 cross join P_GRIRUSR_AUTH_OBJ 
 {
  I_PurchasingDocumentItem.PurchasingDocument,
  I_PurchasingDocumentItem.PurchasingDocumentItem,

 I_PurchasingDocumentItem.CompanyCode,
 I_PurchasingDocumentItem._PurchasingDocument.PurchasingOrganization,
 I_PurchasingDocumentItem._PurchasingDocument.PurchasingGroup,
 I_PurchasingDocumentItem.Plant,
 cast(I_GRIRProcess.GRIRClearingProcessStatus as fis_grir_clearing_status preserving type ) as GRIRClearingProcessStatus,
 I_PurchasingDocumentItem._PurchasingDocument._Supplier.AuthorizationGroup,
 P_GRIRUSR_AUTH_OBJ.bname,
 P_GRIRUSR_AUTH_OBJ.auth,
 P_GRIRUSR_AUTH_OBJ.objct
      
}



/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GRIRPROCESS",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM",
"I_SUPPLIER",
"P_GRIRUSR_AUTH_OBJ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More