P_WrkDistrPurDoc

DDL: P_WRKDISTRPURDOC SQL: PWRKPURDOC Type: view CONSUMPTION

P_WrkDistrPurDoc is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocument) and exposes 11 fields with key field PurchasingDocument. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocument I_PurchasingDocument from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PurchasingDocumentTypeText _PurchasingDocumentTypeText $projection.PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType and $projection.PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory and _PurchasingDocumentTypeText.Language = $session.system_language
[0..1] I_PurgDocumentCategoryText _PurchasingDocumentCatText $projection.PurchasingDocumentCategory = _PurchasingDocumentCatText.PurchasingDocumentCategory and _PurchasingDocumentCatText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PWRKPURDOC view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument
PurchasingDocumentItem
PurchasingDocumentType PurchasingDocumentType
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingOrganization I_PurchasingDocument PurchasingOrganization
PurchasingGroup I_PurchasingDocument PurchasingGroup
PurchasingGroupName _PurchasingGroup PurchasingGroupName
PurchasingOrganizationName
CreationDate CreationDate
_PurchasingDocumentTypeText _PurchasingDocumentTypeText
_PurchasingDocumentCatText _PurchasingDocumentCatText 
@AbapCatalog.sqlViewName: 'PWRKPURDOC'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED
@VDM.viewType : #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_WrkDistrPurDoc as select from I_PurchasingDocument 
association [0..1] to I_PurchasingDocumentTypeText as _PurchasingDocumentTypeText on $projection.PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType
                                                                                  and $projection.PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory 
                                                                                  and   _PurchasingDocumentTypeText.Language = $session.system_language
association  [0..1] to I_PurgDocumentCategoryText as _PurchasingDocumentCatText on $projection.PurchasingDocumentCategory  = _PurchasingDocumentCatText.PurchasingDocumentCategory
                                                                                and _PurchasingDocumentCatText.Language = $session.system_language
 {

key PurchasingDocument as PurchasingDocument ,
cast ('' as abap.char( 16  ))  as PurchasingDocumentItem ,
PurchasingDocumentType as PurchasingDocumentType ,
PurchasingDocumentCategory as PurchasingDocumentCategory ,
I_PurchasingDocument.PurchasingOrganization as PurchasingOrganization ,
I_PurchasingDocument.PurchasingGroup as PurchasingGroup ,
_PurchasingGroup.PurchasingGroupName as PurchasingGroupName ,
I_PurchasingDocument._PurchasingOrganization.PurchasingOrganizationName as PurchasingOrganizationName ,
@Semantics.businessDate.createdAt: true
CreationDate,

_PurchasingDocumentTypeText,
_PurchasingDocumentCatText 
  
}where 
    (_PurchasingDocumentTypeText.PurchasingDocumentCategory = 'R' or _PurchasingDocumentTypeText.PurchasingDocumentCategory = 'K' or _PurchasingDocumentTypeText.PurchasingDocumentCategory = 'F')
and (IsEndOfPurposeBlocked = ''  or IsEndOfPurposeBlocked is null )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTTYPETEXT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENTTYPETEXT",
"I_PURGDOCUMENTCATEGORYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More