I_BusinessPartnerCustCo

core view for customer company code | view: IBUPAPCUSTCO | Extraction: Not supported | Component: Business Partners
Tables used: BUT000, T001, TKA02, KNB1, KNB5, CVI_CUST_LINK
Column Name Description
CompanyCode FK Company Code
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
InterestCalculationDate Key Date of Last Interest Calculation
LastInterestCalcRunDate Date of Last Interest Calculation Run
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
ExtendedWhldgTaxIsActive Indicator: Extended Withholding Tax Active Show values
IsActiveEntity Draft - Indicator - Is active document Show values
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
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
CreditMemoPaymentTerms Payment Terms Key for Credit Memos ZTERM
PaymentMethodsList List of Respected Payment Methods ZWELS
CompanyCodeName Name of Company Code or Company TEXT25
PersonnelNumber Personnel Number PERNR
BillExchChargePaymentTerms Terms of Payment Key for Bill of Exchange Charges ZTERM
CheckPaidDurationInDays Probable Time Until Check Is Paid PACK2
CustPreviousMasterRecordNumber Previous Master Record Number CHAR10
PaymentReason Payment Reason FARP_PAYT_RSN
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Accounting Clerk Abbreviation
  • Client
  • Company Code
  • I_BUSINESSPARTNERCUSTCO.ACCOUNTINGCLERK == T001S.BUSAB
  • I_BUSINESSPARTNERCUSTCO.MANDT == T001S.MANDT
  • I_BUSINESSPARTNERCUSTCO.COMPANYCODE == T001S.BUKRS
Accounts Receivable Pledging Indicator
  • Client
  • Company Code
  • Accounts Receivable Pledging Indicator
  • I_BUSINESSPARTNERCUSTCO.MANDT == TCESSION.CLIENT
  • I_BUSINESSPARTNERCUSTCO.COMPANYCODE == TCESSION.COMPANY
  • I_BUSINESSPARTNERCUSTCO.ACCTSRECEIVABLEPLEDGINGCODE == TCESSION.CESSION_KZ
Account number of an alternative payer
  • Client
  • Account number of an alternative payer
  • I_BUSINESSPARTNERCUSTCO.MANDT == KNA1.MANDT
  • I_BUSINESSPARTNERCUSTCO.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Tolerance Group for Business Partner/G/L Account
  • Client
  • Company Code
  • Tolerance Group for Business Partner/G/L Account
  • I_BUSINESSPARTNERCUSTCO.MANDT == T043G.MANDT
  • I_BUSINESSPARTNERCUSTCO.COMPANYCODE == T043G.BUKRS
  • I_BUSINESSPARTNERCUSTCO.APARTOLERANCEGROUP == T043G.TOGRU
Account Number of Buying Group
  • Client
  • Account Number of Buying Group
  • I_BUSINESSPARTNERCUSTCO.MANDT == KNA1.MANDT
  • I_BUSINESSPARTNERCUSTCO.BUYINGGROUPACCOUNTNUMBER == KNA1.KUNNR
Planning Group
  • Client
  • Planning Group
  • I_BUSINESSPARTNERCUSTCO.MANDT == T035.MANDT
  • I_BUSINESSPARTNERCUSTCO.CASHPLANNINGGROUP == T035.GRUPP
Company Code
  • Client
  • Company Code
  • I_BUSINESSPARTNERCUSTCO.MANDT == T001.MANDT
  • I_BUSINESSPARTNERCUSTCO.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • I_BUSINESSPARTNERCUSTCO.MANDT == T005.MANDT
  • I_BUSINESSPARTNERCUSTCO.COUNTRY == T005.LAND1
Customer Number
  • Customer Number
  • Client
  • I_BUSINESSPARTNERCUSTCO.CUSTOMER == KNA1.KUNNR
  • I_BUSINESSPARTNERCUSTCO.MANDT == KNA1.MANDT
Head Office Account Number (in branch accounts)
  • Head Office Account Number (in branch accounts)
  • Client
  • I_BUSINESSPARTNERCUSTCO.CUSTOMERHEADOFFICE == KNA1.KUNNR
  • I_BUSINESSPARTNERCUSTCO.MANDT == KNA1.MANDT
Block Key for Payment
  • Client
  • Block Key for Payment
  • Block Key for Payment
  • I_BUSINESSPARTNERCUSTCO.MANDT == T008.MANDT
  • I_BUSINESSPARTNERCUSTCO.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • I_BUSINESSPARTNERCUSTCO.CUSTOMERPAYMENTBLOCKINGREASON == T008.ZAHLS
Short Key for a House Bank
  • Client
  • Short Key for a House Bank
  • ?
  • I_BUSINESSPARTNERCUSTCO.MANDT == T012.MANDT
  • I_BUSINESSPARTNERCUSTCO.HOUSEBANK == T012.HBKID
  • I_BUSINESSPARTNERCUSTCO.[column in domain "BUKRS"] == T012.BUKRS
Interest Indicator
  • Client
  • Interest Indicator
  • I_BUSINESSPARTNERCUSTCO.MANDT == T056.MANDT
  • I_BUSINESSPARTNERCUSTCO.INTERESTCALCULATIONCODE == T056.VZSKZ
Short Key for Known/Negotiated Leave
  • Client
  • Short Key for Known/Negotiated Leave
  • I_BUSINESSPARTNERCUSTCO.MANDT == T052A.MANDT
  • I_BUSINESSPARTNERCUSTCO.KNOWNORNEGOTIATEDLEAVE == T052A.URLID
Key for sorting according to assignment numbers I_BUSINESSPARTNERCUSTCO.LAYOUTSORTINGRULE == TZUN.ZUAWA
Block Key for Payment
  • Client
  • Block Key for Payment
  • Block Key for Payment
  • I_BUSINESSPARTNERCUSTCO.MANDT == T008.MANDT
  • I_BUSINESSPARTNERCUSTCO.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • I_BUSINESSPARTNERCUSTCO.CUSTOMERPAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Clearing Group ID
  • Client
  • Payment Clearing Group ID
Payment method supplement
  • Client
  • Payment method supplement
  • I_BUSINESSPARTNERCUSTCO.MANDT == T042F.MANDT
  • I_BUSINESSPARTNERCUSTCO.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Reconciliation Account in General Ledger
  • Client
  • Company Code
  • Reconciliation Account in General Ledger
  • I_BUSINESSPARTNERCUSTCO.MANDT == SKB1.MANDT
  • I_BUSINESSPARTNERCUSTCO.COMPANYCODE == SKB1.BUKRS
  • I_BUSINESSPARTNERCUSTCO.RECONCILIATIONACCOUNT == SKB1.SAKNR
Release Approval Group
  • Release Approval Group
  • Client
  • I_BUSINESSPARTNERCUSTCO.SUPPLIERRELEASEGROUP == VBWF08.FRGRP
  • I_BUSINESSPARTNERCUSTCO.MANDT == VBWF08.MANDT
Value Adjustment Key
  • ?
  • ?
  • ?
  • ?
  • Client
  • Value Adjustment Key
  • I_BUSINESSPARTNERCUSTCO.[column in domain "FFUTURE"] == T044G.FUTURE
  • I_BUSINESSPARTNERCUSTCO.[column in domain "LAND1"] == T044G.LAND1
  • I_BUSINESSPARTNERCUSTCO.[column in domain "OVDUE"] == T044G.OVDUE
  • I_BUSINESSPARTNERCUSTCO.[column in domain "BWBER"] == T044G.BWBER
  • I_BUSINESSPARTNERCUSTCO.MANDT == T044G.MANDT
  • I_BUSINESSPARTNERCUSTCO.VALUEADJUSTMENTKEY == T044G.WBRSL
Withholding Tax Country/Region Key
  • Withholding Tax Country/Region Key
  • Client
  • Country/Region Key
  • I_BUSINESSPARTNERCUSTCO.WITHHOLDINGTAXCOUNTRY == T005Q.QLAND
  • I_BUSINESSPARTNERCUSTCO.MANDT == T005Q.MANDT
  • I_BUSINESSPARTNERCUSTCO.COUNTRY == 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_BUSINESSPARTNERCUSTCO.MANDT == T049L.MANDT
  • I_BUSINESSPARTNERCUSTCO.COMPANYCODE == T049L.BUKRS
  • I_BUSINESSPARTNERCUSTCO.LOCKBOXINTERNALID == T049L.LOCKB