I_SupplierCompany

Supplier Company | view: ISUPPLCOMPANY | TRAN | Extraction: Full or Incremental | Component: Business Partners
Tables used: T001, TKA02, LFB1
Column Name Description
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
InterestCalculationDate Key Date of Last Interest Calculation
SupplierCertificationDate Certification Date
LastInterestCalcRunDate Date of Last Interest Calculation Run
US_FW9ReceiveDate US W8 Form Received Date
US_FW8BENReceiveDate US W8 Form Received Date
Column Name Description
SupplierIsBlockedForPosting Posting block for company code Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
ClearCustomerSupplier Indicator: Clearing between customer and vendor? Show values
IsToBeLocallyProcessed Indicator: Local Processing? Show values
ItemIsToBePaidSeparately Indicator: Pay All Items Separately? Show values
PaymentIsToBeSentByEDI Indicator: Send Payment Advices by EDI Show values
IsDoubleInvoice Check Flag for Double Invoices or Credit Memos Show values
CustomerSupplierClearingIsUsed Indicator: Clearing between customer and vendor? Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
DeletionIndicator Deletion Flag for Master Record (Company Code Level) Show values
IsToBeCheckedForDuplicates Check Flag for Double Invoices or Credit Memos Show values
US_ForeignSuplrHasPartnership Partnership Interest Indicator Show values
US_SecondTINNoticeIsIssued Second TIN Notice from IRS Show values
US_FrgnAcctTaxFilingIsRequired US FATCA Indicator Show values
IsActiveEntity Draft - Indicator - Is active document Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
CompanyCodeName Name of Company Code or Company TEXT25
AccountingClerkFaxNumber Accounting clerk's fax number at the customer/vendor TEXT31
AccountingClerkPhoneNumber Accounting clerk's telephone number at business partner CHAR30
AccountingClerkInternetAddress Internet address of partner company clerk TXT130
SupplierClerk Clerk at vendor TEXT15
SupplierClerkURL Internet address of partner company clerk TXT130
PaymentMethodsList List of Respected Payment Methods ZWELS
PaymentTerms Terms of payment key ZTERM
CheckPaidDurationInDays Probable Time Until Check Is Paid PACK2
SupplierClerkIDBySupplier Our account number with the vendor CHAR12
SupplierAccountNote Memo TEXT30
PersonnelNumber Personnel Number PERNR
PreviousAccountNumber Previous Master Record Number CHAR10
US_ForeignSuplrLmtnOnBnftCode LOB Treaty Code
CreditMemoPaymentTerms Payment Terms Key for Credit Memos ZTERM
US_RecipientForeignTaxID US Recipient Foreign Tax ID
US_FrgnAcctTaxRcpntCntry Country/Region Key LAND1
US_GlobIntermediaryIdnNumber US Recipient GIIN
US_LobTreatyCode LOB Treaty Code
PaymentReason Payment Reason FARP_PAYT_RSN
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Accounting Clerk Abbreviation
  • Company Code
  • Client
  • I_SUPPLIERCOMPANY.ACCOUNTINGCLERK == T001S.BUSAB
  • I_SUPPLIERCOMPANY.COMPANYCODE == T001S.BUKRS
  • I_SUPPLIERCOMPANY.MANDT == T001S.MANDT
Account number of the alternative payee
  • Account number of the alternative payee
  • Client
  • I_SUPPLIERCOMPANY.ALTERNATIVEPAYEE == LFA1.LIFNR
  • I_SUPPLIERCOMPANY.MANDT == LFA1.MANDT
Tolerance Group for Business Partner/G/L Account
  • Tolerance Group for Business Partner/G/L Account
  • Company Code
  • Client
  • I_SUPPLIERCOMPANY.APARTOLERANCEGROUP == T043G.TOGRU
  • I_SUPPLIERCOMPANY.COMPANYCODE == T043G.BUKRS
  • I_SUPPLIERCOMPANY.MANDT == T043G.MANDT
Planning Group
  • Planning Group
  • Client
  • I_SUPPLIERCOMPANY.CASHPLANNINGGROUP == T035.GRUPP
  • I_SUPPLIERCOMPANY.MANDT == T035.MANDT
Company Code
  • Company Code
  • Client
  • I_SUPPLIERCOMPANY.COMPANYCODE == T001.BUKRS
  • I_SUPPLIERCOMPANY.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • I_SUPPLIERCOMPANY.MANDT == TCURC.MANDT
  • I_SUPPLIERCOMPANY.CURRENCY == TCURC.WAERS
Short Key for a House Bank
  • Short Key for a House Bank
  • Client
  • ?
  • I_SUPPLIERCOMPANY.HOUSEBANK == T012.HBKID
  • I_SUPPLIERCOMPANY.MANDT == T012.MANDT
  • I_SUPPLIERCOMPANY.[column in domain "BUKRS"] == T012.BUKRS
Interest Indicator
  • Client
  • Interest Indicator
  • I_SUPPLIERCOMPANY.MANDT == T056.MANDT
  • I_SUPPLIERCOMPANY.INTERESTCALCULATIONCODE == T056.VZSKZ
Key for sorting according to assignment numbers I_SUPPLIERCOMPANY.LAYOUTSORTINGRULE == TZUN.ZUAWA
Minority Indicator
  • Client
  • Minority Indicator
  • I_SUPPLIERCOMPANY.MANDT == T059M.MANDT
  • I_SUPPLIERCOMPANY.MINORITYGROUP == T059M.MINDK
Block Key for Payment
  • Client
  • Block Key for Payment
  • I_SUPPLIERCOMPANY.MANDT == T008.MANDT
  • I_SUPPLIERCOMPANY.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Clearing Group ID
  • Client
  • Payment Clearing Group ID
Payment method supplement
  • Client
  • Payment method supplement
  • I_SUPPLIERCOMPANY.MANDT == T042F.MANDT
  • I_SUPPLIERCOMPANY.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Reconciliation Account in General Ledger
  • Company Code
  • Reconciliation Account in General Ledger
  • Client
  • I_SUPPLIERCOMPANY.COMPANYCODE == SKB1.BUKRS
  • I_SUPPLIERCOMPANY.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • I_SUPPLIERCOMPANY.MANDT == SKB1.MANDT
Tolerance Group in Invoice Verification
  • Company Code
  • Tolerance Group in Invoice Verification
  • Client
  • I_SUPPLIERCOMPANY.COMPANYCODE == T169L.BUKRS
  • I_SUPPLIERCOMPANY.SUPLRINVCVERIFICATTOLGROUP == T169L.TOGRR
  • I_SUPPLIERCOMPANY.MANDT == T169L.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_SUPPLIERCOMPANY.MANDT == LFA1.MANDT
  • I_SUPPLIERCOMPANY.SUPPLIER == LFA1.LIFNR
Head office account number
  • Head office account number
  • Client
  • I_SUPPLIERCOMPANY.SUPPLIERHEADOFFICE == LFA1.LIFNR
  • I_SUPPLIERCOMPANY.MANDT == LFA1.MANDT
Release Approval Group
  • Release Approval Group
  • Client
  • I_SUPPLIERCOMPANY.SUPPLIERRELEASEGROUP == VBWF08.FRGRP
  • I_SUPPLIERCOMPANY.MANDT == VBWF08.MANDT
Withholding Tax Country/Region Key
  • Client
  • ?
  • Withholding Tax Country/Region Key
  • I_SUPPLIERCOMPANY.MANDT == T005Q.MANDT
  • I_SUPPLIERCOMPANY.[column in domain "LAND1"] == T005Q.LAND1
  • I_SUPPLIERCOMPANY.WITHHOLDINGTAXCOUNTRY == T005Q.QLAND