I_ProcmtHubPurgDocType

DDL: I_PROCMTHUBPURGDOCTYPE SQL: ICPODOCTYPE Type: view BASIC

Document type basic view

I_ProcmtHubPurgDocType is a Basic CDS View that provides data about "Document type basic view" in SAP S/4HANA. It reads from 1 data source (mmpur_ext_t161) and exposes 4 fields with key fields PurchasingDocumentType, PurchasingDocumentCategory, ExtSourceSystem. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
mmpur_ext_t161 mmpur_ext_t161 from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ProcmtHubPurgDocTypeText _Purchasingdocumenttypetext $projection.PurchasingDocumentType = _Purchasingdocumenttypetext.PurchasingDocumentType and $projection.PurchasingDocumentCategory = _Purchasingdocumenttypetext.PurchasingDocumentCategory and $projection.ExtSourceSystem = _Purchasingdocumenttypetext.ExtSourceSystem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICPODOCTYPE view
ObjectModel.representativeKey PurchasingDocumentType view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Document type basic view view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentType documenttype
KEY PurchasingDocumentCategory documentcategory
KEY ExtSourceSystem extsourcesystem
_Purchasingdocumenttypetext _Purchasingdocumenttypetext 
@AbapCatalog.sqlViewName: 'ICPODOCTYPE'
@ObjectModel.representativeKey: 'PurchasingDocumentType'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Document type basic view'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType : #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API 


define view I_ProcmtHubPurgDocType
  as select from mmpur_ext_t161
  association [1..*] to I_ProcmtHubPurgDocTypeText as _Purchasingdocumenttypetext on  $projection.PurchasingDocumentType     = _Purchasingdocumenttypetext.PurchasingDocumentType
                                                                                  and $projection.PurchasingDocumentCategory = _Purchasingdocumenttypetext.PurchasingDocumentCategory
                                                                                  and $projection.ExtSourceSystem = _Purchasingdocumenttypetext.ExtSourceSystem
{

      //mmpur_ext_t161

//  key mandt            as Client,

  key documenttype     as PurchasingDocumentType,
  key documentcategory as PurchasingDocumentCategory,

  key extsourcesystem  as ExtSourceSystem,
      _Purchasingdocumenttypetext

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MMPUR_EXT_T161"
],
"ASSOCIATED":
[
"I_PROCMTHUBPURGDOCTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More