A_CustomerCompany

Customer Company | view: ACUSTCOMPANY | Extraction: Not supported | Component: Business Partners
Tables used: KNA1, 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
CustomerSupplierClearingIsUsed Indicator: Clearing between customer and vendor ? Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
IsToBeLocallyProcessed Indicator: Local Processing? 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
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
Column Name Description Domain name
AccountByCustomer Our account number at customer CHAR12
AccountingClerkFaxNumber Accounting clerk's fax number at the customer/vendor TEXT31
AccountingClerkInternetAddress Internet address of partner company clerk TXT130
AccountingClerkPhoneNumber Accounting clerk's telephone number at business partner CHAR30
AuthorizationGroup Authorization Group BRGRU
CollectiveInvoiceVariant Collective Invoice Variant PERKZ_KNB1
CustomerAccountNote Memo TEXT30
PaymentMethodsList List of Respected Payment Methods ZWELS
PaymentTerms Terms of payment key ZTERM
UserAtCustomer User at customer TEXT15
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Company Code
  • Client
  • Accounting Clerk Abbreviation
  • A_CUSTOMERCOMPANY.COMPANYCODE == T001S.BUKRS
  • A_CUSTOMERCOMPANY.MANDT == T001S.MANDT
  • A_CUSTOMERCOMPANY.ACCOUNTINGCLERK == T001S.BUSAB
Account number of an alternative payer
  • Client
  • Account number of an alternative payer
  • A_CUSTOMERCOMPANY.MANDT == KNA1.MANDT
  • A_CUSTOMERCOMPANY.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Tolerance Group for Business Partner/G/L Account
  • Tolerance Group for Business Partner/G/L Account
  • Company Code
  • Client
  • A_CUSTOMERCOMPANY.APARTOLERANCEGROUP == T043G.TOGRU
  • A_CUSTOMERCOMPANY.COMPANYCODE == T043G.BUKRS
  • A_CUSTOMERCOMPANY.MANDT == T043G.MANDT
Planning Group
  • Planning Group
  • Client
  • A_CUSTOMERCOMPANY.CASHPLANNINGGROUP == T035.GRUPP
  • A_CUSTOMERCOMPANY.MANDT == T035.MANDT
Company Code
  • Company Code
  • Client
  • A_CUSTOMERCOMPANY.COMPANYCODE == T001.BUKRS
  • A_CUSTOMERCOMPANY.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • A_CUSTOMERCOMPANY.CUSTOMER == KNA1.KUNNR
  • A_CUSTOMERCOMPANY.MANDT == KNA1.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • A_CUSTOMERCOMPANY.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • A_CUSTOMERCOMPANY.MANDT == T077D.MANDT
Head Office Account Number (in branch accounts)
  • Head Office Account Number (in branch accounts)
  • Client
  • A_CUSTOMERCOMPANY.CUSTOMERHEADOFFICE == KNA1.KUNNR
  • A_CUSTOMERCOMPANY.MANDT == KNA1.MANDT
Short Key for a House Bank
  • ?
  • Client
  • Short Key for a House Bank
  • A_CUSTOMERCOMPANY.[column in domain "BUKRS"] == T012.BUKRS
  • A_CUSTOMERCOMPANY.MANDT == T012.MANDT
  • A_CUSTOMERCOMPANY.HOUSEBANK == T012.HBKID
Interest Indicator
  • Client
  • Interest Indicator
  • A_CUSTOMERCOMPANY.MANDT == T056.MANDT
  • A_CUSTOMERCOMPANY.INTERESTCALCULATIONCODE == T056.VZSKZ
Short Key for Known/Negotiated Leave
  • Client
  • Short Key for Known/Negotiated Leave
  • A_CUSTOMERCOMPANY.MANDT == T052A.MANDT
  • A_CUSTOMERCOMPANY.KNOWNORNEGOTIATEDLEAVE == T052A.URLID
Key for sorting according to assignment numbers A_CUSTOMERCOMPANY.LAYOUTSORTINGRULE == TZUN.ZUAWA
Block Key for Payment
  • Client
  • Block Key for Payment
  • A_CUSTOMERCOMPANY.MANDT == T008.MANDT
  • A_CUSTOMERCOMPANY.PAYMENTBLOCKINGREASON == T008.ZAHLS
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • Company Code
  • Client
  • A_CUSTOMERCOMPANY.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • A_CUSTOMERCOMPANY.COMPANYCODE == SKB1.BUKRS
  • A_CUSTOMERCOMPANY.MANDT == SKB1.MANDT
Value Adjustment Key
  • ?
  • ?
  • ?
  • ?
  • Client
  • Value Adjustment Key
  • A_CUSTOMERCOMPANY.[column in domain "FFUTURE"] == T044G.FUTURE
  • A_CUSTOMERCOMPANY.[column in domain "LAND1"] == T044G.LAND1
  • A_CUSTOMERCOMPANY.[column in domain "OVDUE"] == T044G.OVDUE
  • A_CUSTOMERCOMPANY.[column in domain "BWBER"] == T044G.BWBER
  • A_CUSTOMERCOMPANY.MANDT == T044G.MANDT
  • A_CUSTOMERCOMPANY.VALUEADJUSTMENTKEY == T044G.WBRSL