I_PurchasingDocumentType

DDL: I_PURCHASINGDOCUMENTTYPE SQL: IMMPURGDOCTYP Type: view BASIC

Purchasing Document Type

I_PurchasingDocumentType is a Basic CDS View (Dimension) that provides data about "Purchasing Document Type" in SAP S/4HANA. It reads from 1 data source (t161) and exposes 8 fields with key fields PurchasingDocumentCategory, PurchasingDocumentType. It has 2 associations to related views. It is exposed through 1 OData service (UI_RFM_PO_MNG). It is used in 1 Fiori application: Manage Purchase Orders - Fashion.

Data Sources (1)

SourceAliasJoin Type
t161 t161 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocumentCategory _Category $projection.PurchasingDocumentCategory = _Category.PurchasingDocumentCategory
[0..*] I_PurchasingDocumentTypeText _Text

Annotations (17)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PurchasingDocumentType view
ObjectModel.sapObjectNodeType.name PurchasingDocumentType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.sqlViewName IMMPURGDOCTYP view
EndUserText.label Purchasing Document Type view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
Search.searchable true view
Analytics.dataExtraction.enabled true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_PO_MNG UI_RFM_PO_MNG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5391 Manage Purchase Orders - Fashion Transactional

Manage Purchase Orders - Fashion

Business Role: Purchaser (Retail)

With this app, you can now consolidate purchase order items into an existing purchase order based on the settings in the rule maintained using the Configure Purchase Order Consolidation Rule app.

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentCategory bstyp
KEY PurchasingDocumentType bsart
PurchasingDocumentSubtype bsakz
PurgDocFieldSelControlKey brefn
PurgHasFlxblWorkflowApproval scnr_based_wfl
IsPurReqnOvrlRel gsfrg
_Text _Text
_Category _Category
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.representativeKey: 'PurchasingDocumentType'
@ObjectModel.sapObjectNodeType.name:'PurchasingDocumentType'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.supportedCapabilities: [ #SEARCHABLE_ENTITY, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@AbapCatalog.sqlViewName: 'IMMPURGDOCTYP'
@EndUserText.label: 'Purchasing Document Type'
@Analytics.dataCategory: #DIMENSION 
@AccessControl.authorizationCheck:#NOT_REQUIRED
@VDM.viewType : #BASIC
@Search.searchable: true
@Analytics.dataExtraction.enabled: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations:true

define root view I_PurchasingDocumentType as select from t161 

association [1..1] to I_PurchasingDocumentCategory as _Category on $projection.PurchasingDocumentCategory = _Category.PurchasingDocumentCategory 
composition [0..*] of I_PurchasingDocumentTypeText as _Text 
                                                           
                                                           
                                                          
{
    
    
    @ObjectModel.foreignKey.association: '_Category'
    key bstyp               as PurchasingDocumentCategory,
    @ObjectModel.text.association: '_Text'
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8
    @Search.ranking: #HIGH
    key bsart               as PurchasingDocumentType,
    bsakz                   as PurchasingDocumentSubtype,
    brefn                   as PurgDocFieldSelControlKey,
    scnr_based_wfl          as PurgHasFlxblWorkflowApproval,
    gsfrg                   as IsPurReqnOvrlRel,
    _Text ,
    _Category
}