P_CollsAcctDocInStrCrcy

DDL: P_COLLSACCTDOCINSTRCRCY Type: view COMPOSITE

P_CollsAcctDocInStrCrcy is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_BusinessPartnerCustomer, P_CollsAcctDoc, P_CollsStratPeriod) and exposes 19 fields with key fields BusinessPartner, CollectionSegment, CompanyCode, AccountingDocument, FiscalYear.

3 data source(s) 19 fields

Data Sources (3)

SourceAliasJoin Type
I_BusinessPartnerCustomer I_BusinessPartnerCustomer inner
P_CollsAcctDoc P_CollsAcctDoc inner
P_CollsStratPeriod P_CollsStratPeriod from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PCLLACDOCSTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey AccountingDocument view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner P_CollsStratPeriod BusinessPartner
KEY CollectionSegment P_CollsStratPeriod CollectionSegment
KEY CompanyCode P_CollsAcctDoc CompanyCode
KEY AccountingDocument P_CollsAcctDoc AccountingDocument
KEY FiscalYear P_CollsAcctDoc FiscalYear
KEY AccountingDocumentItem P_CollsAcctDoc AccountingDocumentItem
CollStrgyCurrency P_CollsStratPeriod CollStrgyCurrency
trueasAmountInStrategyCurrency
OverduePeriodReference1 OverduePeriodReference1
OverduePeriodReference2 OverduePeriodReference2
OverduePeriodReference3 OverduePeriodReference3
OverduePeriodReference4 OverduePeriodReference4
OverduePeriodReference5 OverduePeriodReference5
DuePeriodReference1 DuePeriodReference1
DuePeriodReference2 DuePeriodReference2
DuePeriodReference3 DuePeriodReference3
DuePeriodReference4 DuePeriodReference4
DuePeriodReference5 DuePeriodReference5
DaysToDueDate DaysToDueDate 
@AbapCatalog: { sqlViewName: 'PCLLACDOCSTR',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #NOT_REQUIRED,
                  personalData:       { blocking: #BLOCKED_DATA_EXCLUDED } }
@VDM: { viewType: #COMPOSITE,
        private: true }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #X,
                             sizeCategory: #L,
                             dataClass: #TRANSACTIONAL },
                representativeKey: 'AccountingDocument' }

define view P_CollsAcctDocInStrCrcy
  as select from P_CollsStratPeriod
    inner join   I_BusinessPartnerCustomer on P_CollsStratPeriod.BusinessPartner = I_BusinessPartnerCustomer.BusinessPartner
    inner join   P_CollsAcctDoc            on I_BusinessPartnerCustomer.Customer = P_CollsAcctDoc.Customer

{

      // VDM Fields

  key P_CollsStratPeriod.BusinessPartner,
  key P_CollsStratPeriod.CollectionSegment,
  key P_CollsAcctDoc.CompanyCode,
  key P_CollsAcctDoc.AccountingDocument,
  key P_CollsAcctDoc.FiscalYear,
  key P_CollsAcctDoc.AccountingDocumentItem,

      @Semantics: { currencyCode: true }
      P_CollsStratPeriod.CollStrgyCurrency            as CollStrgyCurrency,

      @Semantics: { amount: { currencyCode: 'CollStrgyCurrency' } }
      currency_conversion(
          amount                => AmountInTransactionCurrency,
          source_currency       => TransactionCurrency,
          target_currency       => P_CollsStratPeriod.CollStrgyCurrency,
          exchange_rate_date    => CurrentDate,
          exchange_rate_type    => 'M',
          error_handling        => 'FAIL_ON_ERROR',
          decimal_shift         => #CDSBoolean.true,
          round                 => #CDSBoolean.true ) as AmountInStrategyCurrency,

      OverduePeriodReference1,
      OverduePeriodReference2,
      OverduePeriodReference3,
      OverduePeriodReference4,
      OverduePeriodReference5,
      DuePeriodReference1,
      DuePeriodReference2,
      DuePeriodReference3,
      DuePeriodReference4,
      DuePeriodReference5,
      DaysToDueDate

}

where
      P_CollsAcctDoc.CompanyCode is not null
  and P_CollsAcctDoc.CompanyCode is not initial

Learn More