I_PPS_PurchasingDocumentType

DDL: I_PPS_PURCHASINGDOCUMENTTYPE Type: view_entity BASIC

Purchasing Document Type

I_PPS_PurchasingDocumentType is a Basic CDS View that provides data about "Purchasing Document Type" in SAP S/4HANA. It reads from 1 data source (t161) and exposes 4 fields with key fields PurchasingDocumentCategory, PurchasingDocumentType. It has 2 associations to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
t161 t161 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_PurchasingObjectCategoryText _DocCategoryText $projection.PurchasingDocumentCategory = _DocCategoryText.PurchasingDocumentCategory
[0..*] I_PurchasingDocumentTypeText _DocTypeText $projection.PurchasingDocumentCategory = _DocTypeText.PurchasingDocumentCategory and $projection.PurchasingDocumentType = _DocTypeText.PurchasingDocumentType

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchasing Document Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentCategory bstyp
KEY PurchasingDocumentType bsart
PurchasingDocumentDescription
PurchasingDocumentTypeName 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Purchasing Document Type'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
//@JIRA-KEY S4PPS-11497

define view entity I_PPS_PurchasingDocumentType
  as select from t161
  association [0..*] to I_PurchasingObjectCategoryText as _DocCategoryText on  $projection.PurchasingDocumentCategory = _DocCategoryText.PurchasingDocumentCategory
  association [0..*] to I_PurchasingDocumentTypeText   as _DocTypeText     on  $projection.PurchasingDocumentCategory = _DocTypeText.PurchasingDocumentCategory
                                                                           and $projection.PurchasingDocumentType     = _DocTypeText.PurchasingDocumentType

{
  key bstyp                                                                                   as PurchasingDocumentCategory,
  key bsart                                                                                   as PurchasingDocumentType,
      _DocCategoryText[1: Language = $session.system_language].PurchasingDocumentCategoryName as PurchasingDocumentDescription,
      _DocTypeText[1: Language = $session.system_language].PurchasingDocumentTypeName         as PurchasingDocumentTypeName
}
where
  pps_relevant = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENTTYPETEXT",
"I_PURCHASINGOBJECTCATEGORYTEXT",
"T161"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More