KNC1_BAK

Customer Master (Transaction Figures) | #transactional | Component: Financial Accounting
Column Name Description
MANDT FK Client
KUNNR FK Customer Number
BUKRS FK Company Code
GJAHR Fiscal Year
Column Name Description
πŸ’² Currency Key (T001.WAERS):
UMSAV Balance Carried Forward in Local Currency
UM01S Total of the Debit Postings for the Month
UM01H Total of the Credit Postings for the Month
UM01U Sales in the Posting Period
UM02S Total of the Debit Postings for the Month
UM02H Total of the Credit Postings for the Month
UM02U Sales in the Posting Period
UM03S Total of the Debit Postings for the Month
UM03H Total of the Credit Postings for the Month
UM03U Sales in the Posting Period
UM04S Total of the Debit Postings for the Month
UM04H Total of the Credit Postings for the Month
UM04U Sales in the Posting Period
UM05S Total of the Debit Postings for the Month
UM05H Total of the Credit Postings for the Month
UM05U Sales in the Posting Period
UM06S Total of the Debit Postings for the Month
UM06H Total of the Credit Postings for the Month
UM06U Sales in the Posting Period
UM07S Total of the Debit Postings for the Month
UM07H Total of the Credit Postings for the Month
UM07U Sales in the Posting Period
UM08S Total of the Debit Postings for the Month
UM08H Total of the Credit Postings for the Month
UM08U Sales in the Posting Period
UM09S Total of the Debit Postings for the Month
UM09H Total of the Credit Postings for the Month
UM09U Sales in the Posting Period
UM10S Total of the Debit Postings for the Month
UM10H Total of the Credit Postings for the Month
UM10U Sales in the Posting Period
UM11S Total of the Debit Postings for the Month
UM11H Total of the Credit Postings for the Month
UM11U Sales in the Posting Period
UM12S Total of the Debit Postings for the Month
UM12H Total of the Credit Postings for the Month
UM12U Sales in the Posting Period
UM13S Total of the Debit Postings for the Month
UM13H Total of the Credit Postings for the Month
UM13U Sales in the Posting Period
UM14S Total of the Debit Postings for the Month
UM14H Total of the Credit Postings for the Month
UM14U Sales in the Posting Period
UM15S Total of the Debit Postings for the Month
UM15H Total of the Credit Postings for the Month
UM15U Sales in the Posting Period
UM16S Total of the Debit Postings for the Month
UM16H Total of the Credit Postings for the Month
UM16U Sales in the Posting Period
BABZG Authorized Deductions (in Local Currency)
UABZG Accepted Deductions Taken After End of Discount Period
KZINS Acc.Int.Calc.Numerator for Payment Arrears in Fiscal Year
KUMAG Accumulated Clearing Amount in the Fiscal Year
Column Name Description
Column Name Description
ERDAT Date on which the record was created
Column Name Description
Column Name Description Domain name
USNAM User Name XUBNAME
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Customer Number
  • Client
  • KNC1_BAK.BUKRS == KNB1.BUKRS
  • KNC1_BAK.KUNNR == KNB1.KUNNR
  • KNC1_BAK.MANDT == KNB1.MANDT
Customer Number
  • KNC1_BAK.MANDT == KNA1.MANDT
  • KNC1_BAK.KUNNR == KNA1.KUNNR
Client KNC1_BAK.MANDT == T000.MANDT