P_DebtorFinancialData

Debtor Financial Data | view: PFIDEBTORFIDATA | Extraction: Not supported | Component: Information System
Tables used: KNB1, KNB5
Column Name Description
Customer FK Customer Number
CompanyCode FK Company Code
Column Name Description
Column Name Description
Column Name Description
InterestCalculationDate Key Date of Last Interest Calculation
Column Name Description
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
ItemIsToBePaidSeparately Indicator: Pay All Items Separately? Show values
PaytAdviceIsSentbyEDI Indicator: Send Payment Advices by EDI Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
CustomerAccountNote Memo TEXT30
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Client
  • Company Code
  • Accounting Clerk Abbreviation
  • P_DEBTORFINANCIALDATA.MANDT == T001S.MANDT
  • P_DEBTORFINANCIALDATA.COMPANYCODE == T001S.BUKRS
  • P_DEBTORFINANCIALDATA.ACCOUNTINGCLERK == T001S.BUSAB
Account number of an alternative payer
  • Account number of an alternative payer
  • Client
  • P_DEBTORFINANCIALDATA.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
  • P_DEBTORFINANCIALDATA.MANDT == KNA1.MANDT
Tolerance Group for Business Partner/G/L Account
  • Client
  • Tolerance Group for Business Partner/G/L Account
  • Company Code
  • P_DEBTORFINANCIALDATA.MANDT == T043G.MANDT
  • P_DEBTORFINANCIALDATA.APARTOLERANCEGROUP == T043G.TOGRU
  • P_DEBTORFINANCIALDATA.COMPANYCODE == T043G.BUKRS
Company Code
  • Client
  • Company Code
  • P_DEBTORFINANCIALDATA.MANDT == T001.MANDT
  • P_DEBTORFINANCIALDATA.COMPANYCODE == T001.BUKRS
Customer Number
  • Client
  • Customer Number
  • P_DEBTORFINANCIALDATA.MANDT == KNA1.MANDT
  • P_DEBTORFINANCIALDATA.CUSTOMER == KNA1.KUNNR
Head Office Account Number (in branch accounts)
  • Client
  • Head Office Account Number (in branch accounts)
  • P_DEBTORFINANCIALDATA.MANDT == KNA1.MANDT
  • P_DEBTORFINANCIALDATA.CUSTOMERHEADOFFICE == KNA1.KUNNR
Short Key for a House Bank
  • Client
  • ?
  • Short Key for a House Bank
  • P_DEBTORFINANCIALDATA.MANDT == T012.MANDT
  • P_DEBTORFINANCIALDATA.[column in domain "BUKRS"] == T012.BUKRS
  • P_DEBTORFINANCIALDATA.HOUSEBANK == T012.HBKID
Interest Indicator
  • Client
  • Interest Indicator
  • P_DEBTORFINANCIALDATA.MANDT == T056.MANDT
  • P_DEBTORFINANCIALDATA.INTERESTCALCULATIONCODE == T056.VZSKZ
Block Key for Payment
  • Client
  • Block Key for Payment
  • P_DEBTORFINANCIALDATA.MANDT == T008.MANDT
  • P_DEBTORFINANCIALDATA.PAYMENTBLOCKINGREASON == T008.ZAHLS
Reconciliation Account in General Ledger
  • Client
  • Reconciliation Account in General Ledger
  • Company Code
  • P_DEBTORFINANCIALDATA.MANDT == SKB1.MANDT
  • P_DEBTORFINANCIALDATA.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • P_DEBTORFINANCIALDATA.COMPANYCODE == SKB1.BUKRS