P_RblsItmForKeyDteDuePerd4A

DDL: P_RBLSITMFORKEYDTEDUEPERD4A SQL: PRBLSKDATDUE4A Type: view COMPOSITE Package: FINS_FIS_APAR_APPS

Open Accounts Receivables for Smart Business Apps 1

P_RblsItmForKeyDteDuePerd4A is a Composite CDS View that provides data about "Open Accounts Receivables for Smart Business Apps 1" in SAP S/4HANA. It reads from 2 data sources (P_RblsItmForKeyDteRepPeriod, I_OperationalAcctgDocItem) and exposes 10 fields. Part of development package FINS_FIS_APAR_APPS.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
P_RblsItmForKeyDteRepPeriod P_RblsItmForKeyDteRepPeriod from
I_OperationalAcctgDocItem Receivables inner

Parameters (2)

NameTypeDefault
P_KeyDate sydate
P_PeriodType fis_period_type

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRBLSKDATDUE4A view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
CompanyCode I_OperationalAcctgDocItem CompanyCode
Customer I_OperationalAcctgDocItem Customer
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode
GLAccount I_OperationalAcctgDocItem GLAccount
PartialPaymentAmtInDspCrcy I_OperationalAcctgDocItem AmountInCompanyCodeCurrency
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency
ReportingPeriodStartDate Period ReportingPeriodStartDate
ReportingPeriodEndDate Period ReportingPeriodEndDate
ReportingPeriod Period ReportingPeriod
ReportingYear Period ReportingYear 
@AbapCatalog.sqlViewName: 'PRBLSKDATDUE4A'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RblsItmForKeyDteDuePerd4A
  with parameters
    P_KeyDate : sydate,
    P_PeriodType : fis_period_type
  as select from  P_RblsItmForKeyDteRepPeriod( P_KeyDate: :P_KeyDate,
                                               P_PeriodType: :P_PeriodType ) as Period
inner join I_OperationalAcctgDocItem as Receivables
  on Period.CompanyCode = Receivables.CompanyCode
{
      Receivables.CompanyCode,      
      Receivables.Customer,      
      Receivables.SpecialGLCode,
      Receivables.GLAccount,
      
      Receivables.AmountInCompanyCodeCurrency as PartialPaymentAmtInDspCrcy,
      Receivables.CompanyCodeCurrency,
      
      Period.ReportingPeriodStartDate,
      Period.ReportingPeriodEndDate,
      Period.ReportingPeriod,
      Period.ReportingYear

}
where
    Receivables.FinancialAccountType = 'D'
    and Receivables.AccountingDocumentCategory =  '' 
    and Receivables.IsUsedInPaymentTransaction = 'X'  
    and Receivables.PostingDate >= Period.ReportingPeriodStartDate
    and Receivables.PostingDate <= Period.ReportingPeriodEndDate
    and Receivables.PostingDate <= $parameters.P_KeyDate

Learn More