I_BPAddlSuplrCompanyCodeTP

BO view for Company Code for Suppliers | view: IBPADDSCCTP | Extraction: Not supported | Component: Business Partners

Tables used: T047, MDG_MLT_ASSGMNT, T001, TKA02, LFB1

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities
📅 Dates (3)
☰ Categorical (8)
Other (12)
🔗 Relations (18)

Column Name	Description
BusinessPartner	Business Partner Number
Supplier FK	Account Number of Supplier
CompanyCode FK	Company Code

Column Name	Description
💲 Currency Key (Currency):
BillOfExchLmtAmtInCoCodeCrcy	Bill of Exchange Limit (in Local Currency)

Column Name	Description

Column Name	Description
SupplierCertificationDate	Certification Date
InterestCalculationDate	Key Date of Last Interest Calculation
LastInterestCalcRunDate	Date of Last Interest Calculation Run

Column Name	Description
SupplierIsBlockedForPosting	Posting block for company code	Show values
IsToBeLocallyProcessed	Indicator: Local Processing?	Show values
IsDoubleInvoice	Check Flag for Double Invoices or Credit Memos	Show values
CustomerSupplierClearingIsUsed	Indicator: Clearing between customer and vendor?	Show values
ItemIsToBePaidSeparately	Indicator: Pay All Items Separately?	Show values
PaymentIsToBeSentByEDI	Indicator: Send Payment Advices by EDI	Show values
IntrstCalcFrequencyInMonths	Interest Calculation Frequency in Months	Show values
CompanyCodeDunningIsByDunArea	Dunning by Dunning Area	Show values

Column Name	Description	Domain name
BusinessPartnerForEdit	Business Partner Number	BU_PARTNER
SupplierClerk	Clerk at vendor	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
SupplierClerkIDBySupplier	Our account number with the vendor	CHAR12
SupplierAccountNote	Memo	TEXT30
PaymentTerms	Terms of payment key	ZTERM
CheckPaidDurationInDays	Probable Time Until Check Is Paid	PACK2
PaymentMethodsList	List of Respected Payment Methods	ZWELS
AuthorizationGroup	Authorization Group	BRGRU
CompanyCodeName	Name of Company Code or Company	TEXT25

Master Data Relations	Join Conditions
Accounting Clerk Abbreviation Accounting Clerk Abbreviation Client Company Code Company Code	`I_BPADDLSUPLRCOMPANYCODETP.ACCOUNTINGCLERK == T001S.BUSAB` `I_BPADDLSUPLRCOMPANYCODETP.MANDT == T001S.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODE == T001S.BUKRS` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODEFOREDIT == T001S.BUKRS`
Account number of the alternative payee Client Account number of the alternative payee	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == LFA1.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.ALTERNATIVEPAYEE == LFA1.LIFNR`
Tolerance Group for Business Partner/G/L Account Client Tolerance Group for Business Partner/G/L Account Company Code Company Code	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == T043G.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.APARTOLERANCEGROUP == T043G.TOGRU` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODE == T043G.BUKRS` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODEFOREDIT == T043G.BUKRS`
Planning Group Client Planning Group	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == T035.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.CASHPLANNINGGROUP == T035.GRUPP`
Company Code Client Company Code Company Code	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == T001.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODE == T001.BUKRS` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODEFOREDIT == T001.BUKRS`
Company Code Client Company Code Company Code	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == T001.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODE == T001.BUKRS` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODEFOREDIT == T001.BUKRS`
Country/Region Key Country/Region Key Client	`I_BPADDLSUPLRCOMPANYCODETP.COUNTRY == T005.LAND1` `I_BPADDLSUPLRCOMPANYCODETP.MANDT == T005.MANDT`
Currency Key Client Currency Key	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == TCURC.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.CURRENCY == TCURC.WAERS`
Short Key for a House Bank Client ? Short Key for a House Bank	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == T012.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.[column in domain "BUKRS"] == T012.BUKRS` `I_BPADDLSUPLRCOMPANYCODETP.HOUSEBANK == T012.HBKID`
Interest Indicator Client Interest Indicator	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == T056.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.INTERESTCALCULATIONCODE == T056.VZSKZ`
Key for sorting according to assignment numbers	`I_BPADDLSUPLRCOMPANYCODETP.LAYOUTSORTINGRULE == TZUN.ZUAWA`
Minority Indicator Client Minority Indicator	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == T059M.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.MINORITYGROUP == T059M.MINDK`
Block Key for Payment Client Block Key for Payment	`I_BPADDLSUPLRCOMPANYCODETP.MANDT == T008.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.PAYMENTBLOCKINGREASON == T008.ZAHLS`
Reconciliation Account in General Ledger Reconciliation Account in General Ledger Client Company Code Company Code	`I_BPADDLSUPLRCOMPANYCODETP.RECONCILIATIONACCOUNT == SKB1.SAKNR` `I_BPADDLSUPLRCOMPANYCODETP.MANDT == SKB1.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODE == SKB1.BUKRS` `I_BPADDLSUPLRCOMPANYCODETP.COMPANYCODEFOREDIT == SKB1.BUKRS`
Account Number of Supplier Account Number of Supplier Account Number of Supplier Client	`I_BPADDLSUPLRCOMPANYCODETP.SUPPLIER == LFA1.LIFNR` `I_BPADDLSUPLRCOMPANYCODETP.SUPPLIERFOREDIT == LFA1.LIFNR` `I_BPADDLSUPLRCOMPANYCODETP.MANDT == LFA1.MANDT`
Account Number of Supplier Account Number of Supplier Account Number of Supplier Client	`I_BPADDLSUPLRCOMPANYCODETP.SUPPLIER == LFA1.LIFNR` `I_BPADDLSUPLRCOMPANYCODETP.SUPPLIERFOREDIT == LFA1.LIFNR` `I_BPADDLSUPLRCOMPANYCODETP.MANDT == LFA1.MANDT`
Head office account number Head office account number Client	`I_BPADDLSUPLRCOMPANYCODETP.SUPPLIERHEADOFFICE == LFA1.LIFNR` `I_BPADDLSUPLRCOMPANYCODETP.MANDT == LFA1.MANDT`
Withholding Tax Country/Region Key Country/Region Key Client Withholding Tax Country/Region Key	`I_BPADDLSUPLRCOMPANYCODETP.COUNTRY == T005Q.LAND1` `I_BPADDLSUPLRCOMPANYCODETP.MANDT == T005Q.MANDT` `I_BPADDLSUPLRCOMPANYCODETP.WITHHOLDINGTAXCOUNTRY == T005Q.QLAND`