C_SSPPurchasingDocumentType

DDL: C_SSPPURCHASINGDOCUMENTTYPE SQL: CSSPPURDOCTYPE Type: view CONSUMPTION

Purchasing Document Type Value Help

C_SSPPurchasingDocumentType is a Consumption CDS View that provides data about "Purchasing Document Type Value Help" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocumentType) and exposes 5 fields with key fields PurchasingDocumentCategory, PurchasingDocumentType, ProcurementHubSourceSystem. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocumentType I_PurchasingDocumentType from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocumentTypeText _Text $projection.PurchasingDocumentCategory = _Text.PurchasingDocumentCategory and $projection.PurchasingDocumentType = _Text.PurchasingDocumentType and _Text.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSSPPURDOCTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PurchasingDocumentType view
EndUserText.label Purchasing Document Type Value Help view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentCategory PurchasingDocumentCategory
KEY PurchasingDocumentType PurchasingDocumentType
KEY ProcurementHubSourceSystem
_Text _Text
_Category _Category 
@AbapCatalog.sqlViewName: 'CSSPPURDOCTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
//@ObjectModel.semanticKey: []

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'PurchasingDocumentType'
@EndUserText.label: 'Purchasing Document Type Value Help'
define view C_SSPPurchasingDocumentType
  as select from I_PurchasingDocumentType
  association [1..1] to I_PurchasingDocumentTypeText as _Text on $projection.PurchasingDocumentCategory = _Text.PurchasingDocumentCategory 
                                                           and $projection.PurchasingDocumentType     = _Text.PurchasingDocumentType
                                                           and _Text.Language = $session.system_language
{
      @ObjectModel.foreignKey.association: '_Category'
  key PurchasingDocumentCategory,
      @ObjectModel.text.association: '_Text'
  key PurchasingDocumentType,
  
   
  
      @UI.hidden: true
  key cast('' as abap.char( 10 ) )                          as ProcurementHubSourceSystem,
  
    //  _Text.PurchasingDocumentTypeName                      as PurchasingDocumentTypeName,

     // @Consumption.hidden: true

      _Text,
      _Category
      
}

Learn More