I_PPS_PurchaseReqnDocumentType

DDL: I_PPS_PURCHASEREQNDOCUMENTTYPE Type: view_entity BASIC

Purchase Requisition Document Type

I_PPS_PurchaseReqnDocumentType is a Basic CDS View that provides data about "Purchase Requisition Document Type" in SAP S/4HANA. It reads from 1 data source (t161) and exposes 5 fields with key fields PurchasingDocumentCategory, PurchaseRequisitionType. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
t161 t161 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocumentTypeText _TextDocType _TextDocType.PurchasingDocumentCategory = t161.bstyp and _TextDocType.PurchasingDocumentType = t161.bsart and _TextDocType.Language = $session.system_language

Annotations (7)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Purchase Requisition Document Type view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentCategory bstyp
KEY PurchaseRequisitionType bsart
PurchasingDocumentTypeName _TextDocType PurchasingDocumentTypeName
DocumentTypeIsDefault default_doc_ty
_TextDoc _TextDocType 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Purchase Requisition Document Type'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
//@JIRA-KEY S4PPS-9793

define view entity I_PPS_PurchaseReqnDocumentType

  as select from t161

  association [1..1] to I_PurchasingDocumentTypeText as _TextDocType on  
                                                  _TextDocType.PurchasingDocumentCategory = t161.bstyp
                                              and _TextDocType.PurchasingDocumentType = t161.bsart
                                              and _TextDocType.Language = $session.system_language

{
  key bstyp              as PurchasingDocumentCategory,
      @ObjectModel.text.element: ['PurchasingDocumentTypeName']
  key bsart              as PurchaseRequisitionType,
      @Semantics.text: true
      _TextDocType.PurchasingDocumentTypeName as PurchasingDocumentTypeName,
      default_doc_ty     as DocumentTypeIsDefault,

      _TextDocType as _TextDoc
}
where
      pps_relevant = 'X'
  and t161.bstyp   = 'B'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENTTYPETEXT",
"T161"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More