finoc_vbap_incorrect_prctr

DDL: FINOC_VBAP_INCORRECT_PRCTR Type: view_entity Package: FINS_ORGL_CHANGE_ANALYSIS

Sales Doc Items with Incorrect PrftCtr

finoc_vbap_incorrect_prctr is a CDS View that provides data about "Sales Doc Items with Incorrect PrftCtr" in SAP S/4HANA. It reads from 2 data sources (finoc_rt_soi, vbap) and exposes 5 fields with key fields kdauf, kdpos. Part of development package FINS_ORGL_CHANGE_ANALYSIS.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
finoc_rt_soi rt from
vbap vbap inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Sales Doc Items with Incorrect PrftCtr view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY kdauf finoc_rt_soi kdauf
KEY kdpos finoc_rt_soi kdpos
prctr_rt finoc_rt_soi prctr
prctr_sd vbap prctr
sdm_status 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Sales Doc Items with Incorrect PrftCtr'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #P,
  sizeCategory: #S,
  dataClass: #TRANSACTIONAL
}
define view entity finoc_vbap_incorrect_prctr
  as select from finoc_rt_soi as rt
    inner join   vbap on  rt.kdauf = vbap.vbeln
                      and rt.kdpos = vbap.posnr
{
  key rt.kdauf                              as kdauf,
  key rt.kdpos                              as kdpos,
      rt.prctr                              as prctr_rt,
      vbap.prctr                            as prctr_sd,
      cast( '00' as sdm_status_value_done ) as sdm_status
}
where
      rt.valid_to        =  '99991231' // last organizational change

  and rt.reassgmt_status =  'DONE'     // successfully reassigned

  and rt.prctr           <> vbap.prctr // profit center in VBAP differs

Learn More