FINSCDS_F4_ACVTP

DDL: FINSVD_F4_ACT_VERSN_TP SQL: FINSV_F4_ACVTP Type: view

Actual Transfer Price Versions in Contr. Area

FINSCDS_F4_ACVTP is a CDS View that provides data about "Actual Transfer Price Versions in Contr. Area" in SAP S/4HANA. It reads from 2 data sources (tka09, tkt09) and exposes 4 fields with key fields mandt, kokrs, versn.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
tka09 tka09 from
tkt09 tkt09 left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_F4_ACVTP view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Actual Transfer Price Versions in Contr. Area view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY mandt tka09 mandt
KEY kokrs tka09 kokrs
KEY versn tka09 versn
txt tkt09 txt 
@AbapCatalog.sqlViewName: 'FINSV_F4_ACVTP'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #CHECK commented out because there is no DCL and it is customizing table access only

@EndUserText.label: 'Actual Transfer Price Versions in Contr. Area'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
define view FINSCDS_F4_ACVTP as select 

from  tka09 

left outer join tkt09   on tkt09.mandt = tka09.mandt
                       and tkt09.kokrs = tka09.kokrs
                       and tkt09.versn = tka09.versn
                       and tkt09.langu = $session.system_language
                  
     
//association [0..*] to I_ValuationViewText     as _valuation_view_name     on  $projection.valuation_view   = _valuation_view_name.ValuationView


{

  key tka09.mandt,
  key tka09.kokrs,
  key tka09.versn,
      tkt09.txt       
//    tka09.valutyp,

//    cast( _valuation_view_name[1:Language=$session.system_language].ValuationViewName as FINS_VALUATION_VIEW_NAME ) as valuationviewname //to have a smaller column in value help for text


}

where tka09.actual = 'X'
  and ( tka09.valutyp = '0' or tka09.valutyp = '1' or tka09.valutyp = '2' )  //only Transferprice versions, no COGM versions  

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

Learn More