C_PurOrdMaintainActACatValHelp

DDL: C_PURORDMAINTAINACTACATVALHELP SQL: CPOMAINTVHACACAT Type: view CONSUMPTION

PO Maintenance: Value Help for Account Assignment Category

C_PurOrdMaintainActACatValHelp is a Consumption CDS View that provides data about "PO Maintenance: Value Help for Account Assignment Category" in SAP S/4HANA. It reads from 1 data source (I_AccountAssignmentCategory) and exposes 2 fields with key field AccountAssignmentCategory.

Data Sources (1)

SourceAliasJoin Type
I_AccountAssignmentCategory I_AccountAssignmentCategory from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPOMAINTVHACACAT view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PO Maintenance: Value Help for Account Assignment Category view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY AccountAssignmentCategory AccountAssignmentCategory
_Text _Text
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass:#MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CPOMAINTVHACACAT'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'PO Maintenance: Value Help for Account Assignment Category'

//----------------------------------------------------------------------------------------------

// Remark: 

// Currently only the following Account Assignment Categories are supported:

//  -> 'C': Sales Order

//  -> 'K': Cost Center

//  -> 'P': Project

//  -> 'S': Third-Party

//  -> 'U': Unknown

//----------------------------------------------------------------------------------------------


define view C_PurOrdMaintainActACatValHelp 
  as select from I_AccountAssignmentCategory 
{
  key AccountAssignmentCategory as AccountAssignmentCategory,
      _Text
}
where AccountAssignmentCategory = 'C'
   or AccountAssignmentCategory = 'K'
   or AccountAssignmentCategory = 'P'
   or AccountAssignmentCategory = 'S'
   or AccountAssignmentCategory = 'U'  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTASSIGNMENTCATEGORY"
],
"ASSOCIATED":
[
"I_ACCTASSIGNMENTCATEGORYTEXT"
],
"BASE":
[
"I_ACCOUNTASSIGNMENTCATEGORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/