C_Supplier

Display Supplier List | view: CSUPPLIST | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Tables used: ADCP, ADRC, ADR6, BNKA, BUT000, BUT0BK, T001, TKA02, T005, T005T, TIBAN, T024W, T024E, T001K, T005U, LFA1, T077K, T077Y, LFB1, LFM1, CVI_VEND_LINK, FITHA_PBUPL_K, FITHA_PBUPL_K_T, ADCP, ADR2, ADR3, ADR6, ADRP, USR21
Column Name Description
Supplier Account Number of Supplier
CompanyCode Company Code
BusinessPartner Business Partner Number
PurchasingOrganization Purchasing organization
BankCountry Country/Region Key of Bank
Bank Bank Number
BankAccount Bank Account Number
Country FK Country/Region Key
BPTaxType Tax Number Category
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
IsNaturalPerson Natural Person Show values
AccountIsBlockedForPosting Central Posting Block Show values
PaymentIsBlockedForSupplier Payment Block Show values
SuplrIsDeltdCoCode Deletion Flag for Master Record on Company Code Level Show values
IsToBeCheckedForDuplicates Check Flag for Double Invoices or Credit Memos Show values
SupplierIsBlockedForPosting Posting block for company code Show values
PurOrdAutoGenerationIsAllowed Automatic Generation of Purchase Order Allowed Show values
PurchasingIsBlockedForSupplier Purchasing block at purchasing organization level Show values
SuplrIsDeltdPurgOrg Deletion Flag for Master Record on Purchasing Org. Level Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
VATLiability Liable for VAT Show values
IsDefaultValue Default Branch Code Show values
Column Name Description Domain name
SupplierName Name of Supplier
SupplierFullName Supplier Full Name TEXT220
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
SupplierCountryName Country/Region Name TEXT50
RegionName Description TEXT20
PostalCode Postal Code PSTLZ
CityName City TEXT40
StreetName Street and House Number TEXT35
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
PhoneNumber1 First telephone number TEXT16
FaxNumber Fax Number TEXT31
CreatedByUser Name of Person who Created the Object USNAM
PhoneNumber2 Second telephone number TEXT16
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
TaxNumber4 Tax Number 4 CHAR18
TaxNumber5 Tax Number 5 CHAR60
VATRegistration Business Partner Tax Number BPTAXNUM
TaxTypeName Name: Business Partner Tax Number Categories TXT40
TaxNumberResponsible Tax Number at Authority CHAR18
AddressID Address ADRNR
DeletionIndicator Deletion Flag for Master Record on Supplier Level
AccountGroupName Account Group Name TEXT30
AuthorizationGroup Authorization Group BRGRU
PaymentMethodsList List of Respected Payment Methods
AccountingClerkFaxNumber Accounting clerk's fax number at the customer/supplier TEXT31
SupplierClerkURL Internet address of partner company clerk TXT130
AccountingClerkPhoneNumber Accounting clerk's telephone number at business partner CHAR30
SuplrCoCodePaymentTerms Terms of Payment Key (Company Code) ZTERM
CompanyCodeName Name of Company Code or Company TEXT25
SupplierPurgOrgPaymentTerms Terms of Payment Key (Purchasing Org) ZTERM
EmailAddress Email Address AD_SMTPADR
SearchEmailAddress E-Mail Address Search Field CHAR20
BankName Name of Financial Institution
BankInternalID Bank Keys BANKK
SWIFTCode SWIFT/BIC for International Payments SWIFT
IBAN IBAN (International Bank Account Number) CHAR34
BankControlKey Bank Control Key BKONT
BankAccountHolderName Bank Account Holder TEXT60
CountryName null
BusPartPOBoxDvtgCityName Business Partner PO Box Deviating City Name TEXT40
FullName Full Name of Person TEXT80
SearchTerm1 Search Term 1 for Business Partner BU_SORT1
SearchTerm2 Search Term 2 for Business Partner BU_SORT1
BranchCode Branch Code BCODE
TH_BranchCodeDescription Branch Descriptopn TEXT40
PreviousAccountNumber Previous Master Record Number CHAR10
Master Data Relations Join Conditions
Accounting Clerk
  • Company Code
  • Accounting Clerk
  • Client
  • C_SUPPLIER.SEARCHSTRING == T001S.BUKRS
  • C_SUPPLIER.ACCOUNTINGCLERK == T001S.BUSAB
  • C_SUPPLIER.MANDT == T001S.MANDT
Account number of the alternative payee
  • Account number of the alternative payee
  • Client
  • C_SUPPLIER.ALTERNATIVEPAYEE == LFA1.LIFNR
  • C_SUPPLIER.MANDT == LFA1.MANDT
Account Number of the Alternative Payee
  • Account Number of the Alternative Payee
  • Client
  • C_SUPPLIER.ALTERNATIVEPAYEEACCOUNTNUMBER == LFA1.LIFNR
  • C_SUPPLIER.MANDT == LFA1.MANDT
Planning Group
  • Client
  • Planning Group
  • C_SUPPLIER.MANDT == T035.MANDT
  • C_SUPPLIER.CASHPLANNINGGROUP == T035.GRUPP
Country/Region Key
  • Country/Region Key
  • Client
  • C_SUPPLIER.COUNTRY == T005.LAND1
  • C_SUPPLIER.MANDT == T005.MANDT
Key for sorting according to assignment numbers C_SUPPLIER.LAYOUTSORTINGRULE == TZUN.ZUAWA
Minority Indicator
  • Client
  • Minority Indicator
  • C_SUPPLIER.MANDT == T059M.MANDT
  • C_SUPPLIER.MINORITYGROUP == T059M.MINDK
Payment Block on Item
  • Client
  • Payment Block on Item
  • C_SUPPLIER.MANDT == T008.MANDT
  • C_SUPPLIER.PAYMENTBLOCKINGREASON == T008.ZAHLS
Purchase order currency
  • Purchase order currency
  • Client
  • C_SUPPLIER.PURCHASEORDERCURRENCY == TCURC.WAERS
  • C_SUPPLIER.MANDT == TCURC.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_SUPPLIER.PURCHASINGGROUP == T024.EKGRP
  • C_SUPPLIER.MANDT == T024.MANDT
Reconciliation Account in General Ledger
  • Company Code
  • Client
  • Reconciliation Account in General Ledger
  • C_SUPPLIER.SEARCHSTRING == SKB1.BUKRS
  • C_SUPPLIER.MANDT == SKB1.MANDT
  • C_SUPPLIER.RECONCILIATIONACCOUNT == SKB1.SAKNR
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_SUPPLIER.COUNTRY == T005S.LAND1
  • C_SUPPLIER.MANDT == T005S.MANDT
  • C_SUPPLIER.REGION == T005S.BLAND
Tax Type
  • Tax Type
  • ?
  • Client
  • C_SUPPLIER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • C_SUPPLIER.[column in domain "KOART"] == J_1AFITP.KOART
  • C_SUPPLIER.MANDT == J_1AFITP.MANDT
Company Code
  • Company Code
  • Client
  • C_SUPPLIER.SEARCHSTRING == T001.BUKRS
  • C_SUPPLIER.MANDT == T001.MANDT
Supplier Account Group
  • Client
  • Supplier Account Group
  • C_SUPPLIER.MANDT == T077K.MANDT
  • C_SUPPLIER.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Release Approval Group
  • Release Approval Group
  • Client
  • C_SUPPLIER.SUPPLIERRELEASEGROUP == VBWF08.FRGRP
  • C_SUPPLIER.MANDT == VBWF08.MANDT
Possible Checks for Tax Number 1
  • Tax Number Type
  • Client
  • C_SUPPLIER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
  • C_SUPPLIER.MANDT == J_1ATODC.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_SUPPLIER.TRADINGPARTNER == T880.RCOMP
  • C_SUPPLIER.MANDT == T880.MANDT
Withholding Tax Country/Region Key
  • Country/Region Key
  • Client
  • Withholding Tax Country/Region Key
  • C_SUPPLIER.COUNTRY == T005Q.LAND1
  • C_SUPPLIER.MANDT == T005Q.MANDT
  • C_SUPPLIER.WITHHOLDINGTAXCOUNTRY == T005Q.QLAND