FINOC_RT_SOI_MONTHS

CDS View

Orgl Chg: Sales Doc Crte Dt Plus Months

FINOC_RT_SOI_MONTHS is a CDS View in S/4HANA. Orgl Chg: Sales Doc Crte Dt Plus Months. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FINOC_RT_SOI_OBJ_STATUS view left_outer Orgl Chg: SDocItms with object status 
@AbapCatalog.sqlViewName: 'FINOCV_RTSOIMNTH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Orgl Chg: Sales Doc Crte Dt Plus Months'

define view FINOC_RT_SOI_MONTHS
  as select from           vbap
    inner join             vbak             on vbap.vbeln = vbak.vbeln
    left outer to one join fagl_r_sdcus_001 on  fagl_r_sdcus_001.trvog       =  vbak.trvog                                            
{
  key vbap.vbeln                                                        as SalesDocument,
  key vbap.posnr                                                        as SalesDocumentItem,
      vbap.erdat                                                        as CreationDate,
      coalesce(
        DATS_ADD_MONTHS(vbap.erdat, cast(fagl_r_sdcus_001.months_open as int4), 'NULL'),
        cast('99991231' as dats))                                       as CreationDatePlusMonths
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAGL_R_SDCUS_001",
"VBAK",
"VBAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More