I_PurchaseReqnDocumentType

DDL: I_PURCHASEREQNDOCUMENTTYPE SQL: IPURREQNDOCTYPE Type: view BASIC

Purchase Requisition Document Type

I_PurchaseReqnDocumentType is a Basic CDS View that provides data about "Purchase Requisition Document Type" in SAP S/4HANA. It reads from 2 data sources (t161p, I_PurchasingDocumentType) and exposes 5 fields with key fields PurchaseRequisitionType, PurchasingDocumentCategory, PurchasingDocumentItemCategory. It has 2 associations to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
t161p DocItem inner
I_PurchasingDocumentType PurchaseReqnDocumentType from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PurchasingDocumentTypeText _PurchasingDocumentTypeText $projection.PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory and $projection.PurchaseRequisitionType = _PurchasingDocumentTypeText.PurchasingDocumentType and _PurchasingDocumentTypeText.Language = $session.system_language
[0..1] I_PurgDocumentItemCategoryText _PurgDocumentItemCategoryText $projection.PurchasingDocumentItemCategory = _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory and _PurgDocumentItemCategoryText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPURREQNDOCTYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchase Requisition Document Type view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.sapObjectNodeType.name PurchaseRequisitionType view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisitionType I_PurchasingDocumentType PurchasingDocumentType
KEY PurchasingDocumentCategory I_PurchasingDocumentType PurchasingDocumentCategory
KEY PurchasingDocumentItemCategory t161p pstyp
_PurchasingDocumentTypeText _PurchasingDocumentTypeText
_PurgDocumentItemCategoryText _PurgDocumentItemCategoryText 
@AbapCatalog.sqlViewName: 'IPURREQNDOCTYPE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Purchase Requisition Document Type'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.sapObjectNodeType.name: 'PurchaseRequisitionType'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

define view I_PurchaseReqnDocumentType

    as select from I_PurchasingDocumentType as PurchaseReqnDocumentType
    
      inner join t161p as DocItem 
        on  PurchaseReqnDocumentType.PurchasingDocumentType     = DocItem.bsart
        and PurchaseReqnDocumentType.PurchasingDocumentCategory = DocItem.bstyp
        
      association [0..1] to I_PurchasingDocumentTypeText as _PurchasingDocumentTypeText
        on  $projection.PurchasingDocumentCategory  = _PurchasingDocumentTypeText.PurchasingDocumentCategory
        and $projection.PurchaseRequisitionType     = _PurchasingDocumentTypeText.PurchasingDocumentType
        and _PurchasingDocumentTypeText.Language    = $session.system_language

      association [0..1] to I_PurgDocumentItemCategoryText as _PurgDocumentItemCategoryText
        on  $projection.PurchasingDocumentItemCategory  = _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory
        and _PurgDocumentItemCategoryText.Language      = $session.system_language
    {
          @ObjectModel.text: { association: '_PurchasingDocumentTypeText' }
      key PurchaseReqnDocumentType.PurchasingDocumentType as PurchaseRequisitionType,
      
      key PurchaseReqnDocumentType.PurchasingDocumentCategory as PurchasingDocumentCategory,
      
          @ObjectModel.text: { association: '_PurgDocumentItemCategoryText' }
      key DocItem.pstyp as PurchasingDocumentItemCategory,
          
            /*Associations*/
          _PurchasingDocumentTypeText,
          _PurgDocumentItemCategoryText  
              
    }
      where PurchaseReqnDocumentType.PurchasingDocumentCategory = 'B'
      and (DocItem.pstyp = '0' or DocItem.pstyp = '5' or DocItem.pstyp = 'A')
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENTTYPE",
"T161P"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENTTYPETEXT",
"I_PURGDOCUMENTITEMCATEGORYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More