FINOC_ACDOCA_BUZEI

DDL: FINOC_ACDOCA_BUZEI SQL: FINOCV_AC_BUZEI Type: view

Orgl Change: Unique BUZEI of ACDOCA

FINOC_ACDOCA_BUZEI is a CDS View that provides data about "Orgl Change: Unique BUZEI of ACDOCA" in SAP S/4HANA. It reads from 1 data source (acdoca) and exposes 6 fields with key fields rldnr, rbukrs, gjahr, belnr, buzei.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
acdoca acdoca from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_AC_BUZEI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Orgl Change: Unique BUZEI of ACDOCA view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY rldnr
KEY rbukrs
KEY gjahr
KEY belnr
KEY buzei
docln 
@AbapCatalog.sqlViewName: 'FINOCV_AC_BUZEI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Orgl Change: Unique BUZEI of ACDOCA'

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL 
@ObjectModel.usageType.dataClass: #MIXED

define view FINOC_ACDOCA_BUZEI as select from acdoca
{
  key cast(acdoca.rldnr       as fins_ledger_pers preserving type) as rldnr,
  key cast(acdoca.rbukrs      as fis_bukrs preserving type)        as rbukrs,
  key cast(acdoca.gjahr       as fis_gjahr preserving type)        as gjahr,
  key cast(acdoca.belnr       as fis_belnr preserving type)        as belnr,
  key cast(acdoca.buzei as fis_buzei preserving type)              as buzei,
      cast(min(acdoca.docln) as fis_docln preserving type)         as docln
}
group by
  acdoca.rldnr,
  acdoca.rbukrs,
  acdoca.gjahr,
  acdoca.belnr,
  acdoca.buzei
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More