P_RTPCORDERTOTALPOSTEDVARC

DDL: P_RTPCORDERTOTALPOSTEDVARC SQL: PFIRTPCORTOTVAR Type: view BASIC

RTPC Order Total Posted Variance

P_RTPCORDERTOTALPOSTEDVARC is a Basic CDS View that provides data about "RTPC Order Total Posted Variance" in SAP S/4HANA. It reads from 2 data sources (acdoca, I_Ledger) and exposes 17 fields with key fields OrderID, ItemNumber, CompanyCode, Ledger.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
acdoca _item from
I_Ledger _ledger inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PFIRTPCORTOTVAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label RTPC Order Total Posted Variance view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY OrderID aufnr
KEY ItemNumber aufps
KEY CompanyCode rbukrs
KEY Ledger rldnr
hsl hsl
ksl ksl
osl osl
vsl vsl
bsl bsl
csl csl
dsl dsl
esl esl
fsl fsl
gsl gsl
kfsl kfsl
vmsl vmsl
msl msl 
@AbapCatalog.sqlViewName: 'PFIRTPCORTOTVAR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'RTPC Order Actual Cost Settled'

@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'RTPC Order Total Posted Variance'
define view P_RTPCORDERTOTALPOSTEDVARC 
as select from acdoca   as _item
    inner join   I_Ledger as _ledger on  _ledger.Ledger     = _item.rldnr
                                     and _ledger.LedgerType = '' //standard ledger only

{
  key aufnr       as OrderID,
  key objnr       as controllingobject,
  key aufps       as ItemNumber,
  key rbukrs      as CompanyCode,
  key rldnr       as Ledger,

      hsl,
      ksl,
      osl,
      vsl,
      bsl,
      csl,
      dsl,
      esl,
      fsl,
      gsl,
      kfsl,
      vmsl,
      msl
}
where
       xsettling =  'X'
  and(
       accasty  =  'OR'
    or accasty  =  'OP'
  )
  and  bttype   <> 'TBCS' --ignore Transaction-Based Split
  and(
       autyp    =  '10'
    or autyp    =  '40'
  )
  and  objnr    <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More