I_CustomerCompany

Customer Company | view: ICUSTCMPY | TRAN | Extraction: Full or Incremental | Component: Business Partners
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
LastInterestCalcRunDate Date of Last Interest Calculation Run
LastDunnedOn Date of Last Dunning Notice
LegDunningProcedureOn Date of the Legal Dunning Proceedings
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
PhysicalInventoryBlockInd Posting block for company code Show values
IsToBeLocallyProcessed Indicator: Local Processing? Show values
CustomerSupplierClearingIsUsed Indicator: Clearing between customer and vendor ? Show values
RecordPaymentHistoryIndicator Indicator: Record Payment History ? Show values
DeletionIndicator Deletion Flag for Master Record (Company Code Level) Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
DeletionIsBlocked Deletion bock for master record (company code level) Show values
IsActiveEntity Draft - Indicator - Is active document Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
CustomerAccountNote Memo TEXT30
UserAtCustomer User at customer TEXT15
AccountingClerkPhoneNumber Accounting clerk's telephone number at business partner CHAR30
AccountingClerkFaxNumber Accounting clerk's fax number at the customer/vendor TEXT31
AccountingClerkInternetAddress Internet address of partner company clerk TXT130
AccountByCustomer Our account number at customer CHAR12
CollectiveInvoiceVariant Collective Invoice Variant PERKZ_KNB1
PaymentTerms Terms of payment key ZTERM
PaymentMethodsList List of Respected Payment Methods ZWELS
CreditMemoPaymentTerms Payment Terms Key for Credit Memos ZTERM
CustPreviousMasterRecordNumber Previous Master Record Number CHAR10
PersonnelNumber Personnel Number PERNR
BillExchChargePaymentTerms Terms of Payment Key for Bill of Exchange Charges ZTERM
CheckPaidDurationInDays Probable Time Until Check Is Paid PACK2
PaymentReason Payment Reason FARP_PAYT_RSN
DunningLevel Dunning Level MAHNS
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Client
  • Company Code
  • Accounting Clerk Abbreviation
  • I_CUSTOMERCOMPANY.MANDT == T001S.MANDT
  • I_CUSTOMERCOMPANY.COMPANYCODE == T001S.BUKRS
  • I_CUSTOMERCOMPANY.ACCOUNTINGCLERK == T001S.BUSAB
Accounts Receivable Pledging Indicator
  • Client
  • Company Code
  • Accounts Receivable Pledging Indicator
  • I_CUSTOMERCOMPANY.MANDT == TCESSION.CLIENT
  • I_CUSTOMERCOMPANY.COMPANYCODE == TCESSION.COMPANY
  • I_CUSTOMERCOMPANY.ACCTSRECEIVABLEPLEDGINGCODE == TCESSION.CESSION_KZ
Account number of an alternative payer
  • Client
  • Account number of an alternative payer
  • I_CUSTOMERCOMPANY.MANDT == KNA1.MANDT
  • I_CUSTOMERCOMPANY.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Tolerance Group for Business Partner/G/L Account
  • Client
  • Tolerance Group for Business Partner/G/L Account
  • Company Code
  • I_CUSTOMERCOMPANY.MANDT == T043G.MANDT
  • I_CUSTOMERCOMPANY.APARTOLERANCEGROUP == T043G.TOGRU
  • I_CUSTOMERCOMPANY.COMPANYCODE == T043G.BUKRS
Account Number of Buying Group
  • Account Number of Buying Group
  • Client
  • I_CUSTOMERCOMPANY.BUYINGGROUPACCOUNTNUMBER == KNA1.KUNNR
  • I_CUSTOMERCOMPANY.MANDT == KNA1.MANDT
Planning Group
  • Client
  • Planning Group
  • I_CUSTOMERCOMPANY.MANDT == T035.MANDT
  • I_CUSTOMERCOMPANY.CASHPLANNINGGROUP == T035.GRUPP
Company Code
  • Client
  • Company Code
  • I_CUSTOMERCOMPANY.MANDT == T001.MANDT
  • I_CUSTOMERCOMPANY.COMPANYCODE == T001.BUKRS
Customer Number
  • Client
  • Customer Number
  • I_CUSTOMERCOMPANY.MANDT == KNA1.MANDT
  • I_CUSTOMERCOMPANY.CUSTOMER == KNA1.KUNNR
Head Office Account Number (in branch accounts)
  • Client
  • Head Office Account Number (in branch accounts)
  • I_CUSTOMERCOMPANY.MANDT == KNA1.MANDT
  • I_CUSTOMERCOMPANY.CUSTOMERHEADOFFICE == KNA1.KUNNR
Block Key for Payment
  • Client
  • Block Key for Payment
  • Block Key for Payment
  • I_CUSTOMERCOMPANY.MANDT == T008.MANDT
  • I_CUSTOMERCOMPANY.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • I_CUSTOMERCOMPANY.CUSTOMERPAYMENTBLOCKINGREASON == T008.ZAHLS
Dunning Block
  • Client
  • Dunning Block
  • I_CUSTOMERCOMPANY.MANDT == T040S.MANDT
  • I_CUSTOMERCOMPANY.DUNNINGBLOCK == T040S.MANSP
Key for Dunning Notice Grouping
  • Client
  • Key for Dunning Notice Grouping
  • I_CUSTOMERCOMPANY.MANDT == T047R.MANDT
  • I_CUSTOMERCOMPANY.DUNNINGNOTICEGROUP == T047R.MGRUP
Dunning Procedure
  • Client
  • Dunning Procedure
  • I_CUSTOMERCOMPANY.MANDT == T047A.MANDT
  • I_CUSTOMERCOMPANY.DUNNINGPROCEDURE == T047A.MAHNA
Account Number of the Dunning Recipient
  • Account Number of the Dunning Recipient
  • Client
  • I_CUSTOMERCOMPANY.DUNNINGRECIPIENT == KNA1.KUNNR
  • I_CUSTOMERCOMPANY.MANDT == KNA1.MANDT
Short Key for a House Bank
  • Client
  • ?
  • Short Key for a House Bank
  • I_CUSTOMERCOMPANY.MANDT == T012.MANDT
  • I_CUSTOMERCOMPANY.[column in domain "BUKRS"] == T012.BUKRS
  • I_CUSTOMERCOMPANY.HOUSEBANK == T012.HBKID
Interest Indicator
  • Client
  • Interest Indicator
  • I_CUSTOMERCOMPANY.MANDT == T056.MANDT
  • I_CUSTOMERCOMPANY.INTERESTCALCULATIONCODE == T056.VZSKZ
Short Key for Known/Negotiated Leave
  • Client
  • Short Key for Known/Negotiated Leave
  • I_CUSTOMERCOMPANY.MANDT == T052A.MANDT
  • I_CUSTOMERCOMPANY.KNOWNORNEGOTIATEDLEAVE == T052A.URLID
Key for sorting according to assignment numbers I_CUSTOMERCOMPANY.LAYOUTSORTINGRULE == TZUN.ZUAWA
Block Key for Payment
  • Client
  • Block Key for Payment
  • Block Key for Payment
  • I_CUSTOMERCOMPANY.MANDT == T008.MANDT
  • I_CUSTOMERCOMPANY.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • I_CUSTOMERCOMPANY.CUSTOMERPAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Clearing Group ID
  • Client
  • Payment Clearing Group ID
Payment method supplement
  • Client
  • Payment method supplement
  • I_CUSTOMERCOMPANY.MANDT == T042F.MANDT
  • I_CUSTOMERCOMPANY.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • Client
  • Company Code
  • I_CUSTOMERCOMPANY.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • I_CUSTOMERCOMPANY.MANDT == SKB1.MANDT
  • I_CUSTOMERCOMPANY.COMPANYCODE == SKB1.BUKRS
Release Approval Group
  • Client
  • Release Approval Group
  • I_CUSTOMERCOMPANY.MANDT == VBWF08.MANDT
  • I_CUSTOMERCOMPANY.SUPPLIERRELEASEGROUP == VBWF08.FRGRP
Value Adjustment Key
  • Client
  • Value Adjustment Key
  • ?
  • ?
  • ?
  • ?
  • I_CUSTOMERCOMPANY.MANDT == T044G.MANDT
  • I_CUSTOMERCOMPANY.VALUEADJUSTMENTKEY == T044G.WBRSL
  • I_CUSTOMERCOMPANY.[column in domain "FFUTURE"] == T044G.FUTURE
  • I_CUSTOMERCOMPANY.[column in domain "LAND1"] == T044G.LAND1
  • I_CUSTOMERCOMPANY.[column in domain "OVDUE"] == T044G.OVDUE
  • I_CUSTOMERCOMPANY.[column in domain "BWBER"] == T044G.BWBER
Withholding Tax Country/Region Key
  • Client
  • Withholding Tax Country/Region Key
  • ?
  • I_CUSTOMERCOMPANY.MANDT == T005Q.MANDT
  • I_CUSTOMERCOMPANY.WITHHOLDINGTAXCOUNTRY == T005Q.QLAND
  • I_CUSTOMERCOMPANY.[column in domain "LAND1"] == T005Q.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Key of the Lockbox to Which the Customer Is to Pay
  • Client
  • Company Code
  • Key of the Lockbox to Which the Customer Is to Pay
  • I_CUSTOMERCOMPANY.MANDT == T049L.MANDT
  • I_CUSTOMERCOMPANY.COMPANYCODE == T049L.BUKRS
  • I_CUSTOMERCOMPANY.LOCKBOXINTERNALID == T049L.LOCKB