A_SupplierCompany

Supplier Company | view: ASUPPCOMPANY | Extraction: Not supported | Component: Business Partners
Tables used: T001, TKA02, LFA1, 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
Column Name Description
SupplierIsBlockedForPosting Posting block for company code 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
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
IsBusinessPurposeCompleted Business Purpose Completed Flag 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
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
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Client
  • Accounting Clerk Abbreviation
  • Company Code
  • A_SUPPLIERCOMPANY.MANDT == T001S.MANDT
  • A_SUPPLIERCOMPANY.ACCOUNTINGCLERK == T001S.BUSAB
  • A_SUPPLIERCOMPANY.COMPANYCODE == T001S.BUKRS
Account number of the alternative payee
  • Client
  • Account number of the alternative payee
  • A_SUPPLIERCOMPANY.MANDT == LFA1.MANDT
  • A_SUPPLIERCOMPANY.ALTERNATIVEPAYEE == LFA1.LIFNR
Tolerance Group for Business Partner/G/L Account
  • Client
  • Tolerance Group for Business Partner/G/L Account
  • Company Code
  • A_SUPPLIERCOMPANY.MANDT == T043G.MANDT
  • A_SUPPLIERCOMPANY.APARTOLERANCEGROUP == T043G.TOGRU
  • A_SUPPLIERCOMPANY.COMPANYCODE == T043G.BUKRS
Planning Group
  • Client
  • Planning Group
  • A_SUPPLIERCOMPANY.MANDT == T035.MANDT
  • A_SUPPLIERCOMPANY.CASHPLANNINGGROUP == T035.GRUPP
Company Code
  • Client
  • Company Code
  • A_SUPPLIERCOMPANY.MANDT == T001.MANDT
  • A_SUPPLIERCOMPANY.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • A_SUPPLIERCOMPANY.MANDT == TCURC.MANDT
  • A_SUPPLIERCOMPANY.CURRENCY == TCURC.WAERS
Short Key for a House Bank
  • Short Key for a House Bank
  • Client
  • ?
  • A_SUPPLIERCOMPANY.HOUSEBANK == T012.HBKID
  • A_SUPPLIERCOMPANY.MANDT == T012.MANDT
  • A_SUPPLIERCOMPANY.[column in domain "BUKRS"] == T012.BUKRS
Interest Indicator
  • Client
  • Interest Indicator
  • A_SUPPLIERCOMPANY.MANDT == T056.MANDT
  • A_SUPPLIERCOMPANY.INTERESTCALCULATIONCODE == T056.VZSKZ
Key for sorting according to assignment numbers A_SUPPLIERCOMPANY.LAYOUTSORTINGRULE == TZUN.ZUAWA
Minority Indicator
  • Client
  • Minority Indicator
  • A_SUPPLIERCOMPANY.MANDT == T059M.MANDT
  • A_SUPPLIERCOMPANY.MINORITYGROUP == T059M.MINDK
Block Key for Payment
  • Client
  • Block Key for Payment
  • A_SUPPLIERCOMPANY.MANDT == T008.MANDT
  • A_SUPPLIERCOMPANY.PAYMENTBLOCKINGREASON == T008.ZAHLS
Reconciliation Account in General Ledger
  • Client
  • Reconciliation Account in General Ledger
  • Company Code
  • A_SUPPLIERCOMPANY.MANDT == SKB1.MANDT
  • A_SUPPLIERCOMPANY.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • A_SUPPLIERCOMPANY.COMPANYCODE == SKB1.BUKRS
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • A_SUPPLIERCOMPANY.MANDT == LFA1.MANDT
  • A_SUPPLIERCOMPANY.SUPPLIER == LFA1.LIFNR
Vendor account group
  • Client
  • Vendor account group
  • A_SUPPLIERCOMPANY.MANDT == T077K.MANDT
  • A_SUPPLIERCOMPANY.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Head office account number
  • Head office account number
  • Client
  • A_SUPPLIERCOMPANY.SUPPLIERHEADOFFICE == LFA1.LIFNR
  • A_SUPPLIERCOMPANY.MANDT == LFA1.MANDT
Withholding Tax Country/Region Key
  • Client
  • ?
  • Withholding Tax Country/Region Key
  • A_SUPPLIERCOMPANY.MANDT == T005Q.MANDT
  • A_SUPPLIERCOMPANY.[column in domain "LAND1"] == T005Q.LAND1
  • A_SUPPLIERCOMPANY.WITHHOLDINGTAXCOUNTRY == T005Q.QLAND