P_DebtorFinancialData

DDL: P_DEBTORFINANCIALDATA SQL: PFIDEBTORFIDATA Type: view BASIC Package: FINS_FIS_APAR_APPS

Debtor Financial Data

P_DebtorFinancialData is a Basic CDS View that provides data about "Debtor Financial Data" in SAP S/4HANA. It reads from 1 data source (I_CustomerCompany) and exposes 17 fields with key fields Customer, CompanyCode. It has 2 associations to related views. Part of development package FINS_FIS_APAR_APPS.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerCompany I_CustomerCompany from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer _Customer.Customer = $projection.Customer
[0..1] I_CompanyCode _Company _Company.CompanyCode = $projection.CompanyCode

Annotations (5)

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

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
KEY CompanyCode CompanyCode
AccountingClerk AccountingClerk
ReconciliationAccount ReconciliationAccount
AuthorizationGroup AuthorizationGroup
CustomerHeadOffice CustomerHeadOffice
AlternativePayerAccount AlternativePayerAccount
PaymentBlockingReason PaymentBlockingReason
InterestCalculationCode InterestCalculationCode
InterestCalculationDate InterestCalculationDate
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths
CustomerAccountNote CustomerAccountNote
APARToleranceGroup APARToleranceGroup
HouseBank HouseBank
ItemIsToBePaidSeparately ItemIsToBePaidSeparately
PaytAdviceIsSentbyEDI PaytAdviceIsSentbyEDI
_Customer _Customer 
@VDM.viewType: #BASIC
@VDM.private:true
@AbapCatalog.sqlViewName: 'PFIDEBTORFIDATA'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_DebtorFinancialData
  as select from I_CustomerCompany

  association [0..1] to I_Customer    as _Customer on _Customer.Customer = $projection.Customer
  // additional association to I_Company to declare data source of CompanyCode for BW cube

  association [0..1] to I_CompanyCode as _Company  on _Company.CompanyCode = $projection.CompanyCode

{
  key Customer,
  key CompanyCode,

      AccountingClerk,
      ReconciliationAccount,
      AuthorizationGroup,
      CustomerHeadOffice,
      AlternativePayerAccount,
      PaymentBlockingReason,
      InterestCalculationCode,
      InterestCalculationDate,
      IntrstCalcFrequencyInMonths,
      CustomerAccountNote,
      APARToleranceGroup,
      HouseBank,
      ItemIsToBePaidSeparately,
      PaytAdviceIsSentbyEDI,

      _Customer

}

Learn More