I_PURCHASINGDOCUMENTTYPE

CDS View

Purchasing Document Type

I_PURCHASINGDOCUMENTTYPE is a CDS View in S/4HANA. Purchasing Document Type. It contains 2 fields. 34 CDS views read from this table.

Used by 34 CDS view(s) 2 fields

CDS Views using this table (34)

ViewTypeJoinVDMDescription
C_CFinPurchaseOrderTypeVH view from CONSUMPTION CFin Value Help for Purchase Order Types
C_CntrlPurContrHierTypeVH view from CONSUMPTION Contract Type VH in Central Purchase Contract Hierarchy
C_CntrlPurContrTypeValueHelp view from CONSUMPTION View for Contract Type F4 Help in Central Purchase Contract
C_POItemOrderTypeValueHelp view from CONSUMPTION Order Type Value Help
C_POMntnDocumentTypeValueHelp view from CONSUMPTION Value Help for Order Types in "Manage Purchase Orders"
C_PurchaseOrderTypeValueHelp view from CONSUMPTION Purchase Order Type
C_PurchaseOrderWorkflowEmail view left_outer CONSUMPTION Purchase Order Details for Workflow Deadline Email
C_PurchasingDocTypeValueHelp view from CONSUMPTION Purchasing Doc Type Value Help
C_PurchasingDocTypeVH view from CONSUMPTION Purchasing Doc Type VH
C_PurReqnTypeForWorkflow view from CONSUMPTION Purchasing Document Type
C_RfqTypeVH view from CONSUMPTION Value help for RFQ Type
C_SchedAgrmtMassUpdtTypeVH view from CONSUMPTION Value Help for Scheduling Agreement Type
C_SSPPurchasingDocumentType view from CONSUMPTION Purchasing Document Type Value Help
C_SubordinateCntrlContrTypeVH view from CONSUMPTION Contract Type VH for Subordinate Central Contracts
I_ARunRequirementDocumentType view union BASIC Requirement document type
I_ARunSupSelRulePurOrdTypeVH view from BASIC
I_ARunSupSelRulePurReqnTypeVH view from BASIC
I_CentralSupplierQuotationType view from BASIC Basic View for Central Supplier Quotation Type
I_CntrlPurContrClassification view from BASIC Central Purchase Contract Classification
I_CntrlReqForQuotationType view from BASIC Basic view for Central Request For Quotation Type Value Help
I_PPS_PurchaseReqnItemCategory view_entity from BASIC Item Category for Purchase Requisition
I_PurchaseContractType view from BASIC Purchase Contract Type
I_Purchasecontracttype_Vh view from BASIC Value Help for Purchase contract
I_PurchaseOrderType view from BASIC Purchase Order Type
I_PurchaseReqnDocumentType view from BASIC Purchase Requisition Document Type
I_PurchaseRequisitionType view from BASIC Purchase Requisition Document Type
I_RequestForQuotationType view from BASIC RFQ Type
I_Schedgagrmttypevh view from BASIC Scheduling Agreement Document Type
I_SupplierQuotationType view from BASIC Supplier Quotation Type
P_CntrlPurContrClassification view from BASIC
P_MMIM_PURDOCTY_M_BEST_BSA_01 view from COMPOSITE
P_POItemOrderTypeValueHelp view from CONSUMPTION PView for PO type Value help
P_WrkflwPurchaseOrderItem view inner CONSUMPTION P View of Purchase Order item Workflow
P_WrkflwPurRequisitionItem view inner CONSUMPTION

Fields (2)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocumentCategory PurchasingDocumentCategory 2
KEY PurchasingDocumentType ARunSupplySelRuleAttribVal,PurchaseRequisitionType,RFQType,SuplrQtnType 9 
@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
}      

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T161"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURCHASINGDOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More