I_Supplier

Supplier | view: I_SUPPLIER_CDS | ATTR | Extraction: Full or Incremental | Component: Business Partners
Tables used: LFA1
Column Name Description
Supplier Account Number of Supplier
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
SuplrQltyInProcmtCertfnValidTo Validity Date of Certification
BirthDate Date of Birth of the Person Subject to Withholding Tax
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
AccountIsBlockedForPosting Central posting block Show values
PostingIsBlocked Central posting block Show values
PurchasingIsBlocked Centrally imposed purchasing block Show values
IsNaturalPerson Natural Person Show values
UK_ContractorBusinessType Subcontractor's Business Type Show values
UK_VerificationStatus Verification Status Show values
UK_VerifiedTaxStatus Tax Status of the Verified Subcontractor Show values
VATLiability Liable for VAT Show values
PaymentIsBlockedForSupplier Payment Block Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
IN_GSTSupplierClassification Vendor Classification for GST Show values
SuplrProofOfDelivRlvtCode Supplier indicator relevant for proof of delivery Show values
BR_TaxIsSplit Tax Split Show values
AU_PayerIsPayingToCarryOnEnt Is payer making payment in course of carrying on enterprise Show values
AU_IndividualIsUnder18 Is an individual under 18 and payment does not exceed $350 Show values
AU_PaymentIsExceeding75 The payment does not exceed $75, excl. GST Show values
AU_PaymentIsWhollyInputTaxed The supply that the payment relates to is wholly input taxed Show values
AU_PartnerIsSupplyWithoutGain The supply is made by an individual without gain Show values
AU_SupplierIsEntitledToABN The supplier is not entitled to an ABN Show values
AU_PaymentIsIncomeExempted The whole of the payment is exempt income. Show values
AU_SupplyIsMadeAsPrivateHobby An activity done as a private recreational pursuit Show values
AU_SupplyMadeIsOfDmstcNature wholly of a private or domestic nature Show values
IsToBeAcceptedAtOrigin Acceptance At Origin Show values
BPIsEqualizationTaxSubject Checkbox Show values
BRSpcfcTaxBasePercentageCode Tax Base in Percentage Show values
DataMediumExchangeIndicator Report key for data medium exchange Show values
SupplierIsSubRangeRelevant Indicator: vendor sub-range relevant Show values
AlternativePayeeIsAllowed Indicator: Alternative Payee in Document Allowed? Show values
SupplierIsPlantRelevant Indicator: plant level relevant Show values
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
SupplierFullName Supplier Full Name TEXT220
CreatedByUser Name of Person who Created the Object USNAM
AuthorizationGroup Authorization Group BRGRU
VATRegistration VAT Registration Number STCEG
SupplierCorporateGroup Group key KONZS
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
TaxNumber6 Tax Number 6 CHAR20
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
InternationalLocationNumber3 Check digit for the international location number NUM01
AddressID Address ADRNR
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CityName City TEXT35
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
ConcatenatedInternationalLocNo Cocatenated International Location Number TEXT20
PhoneNumber1 First telephone number TEXT16
FaxNumber Fax Number TEXT31
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
UK_PartnerTradingName Partner's Trading Name TEXT30
UK_PartnerTaxReference Partner's Unique Tax Reference (UTR) CHAR20
UK_VerificationNumber Verification Number CHAR20
UK_CompanyRegistrationNumber Companies House Registration Number
FormOfAddress Title TEXT15
SortField Sort field CHAR10
PhoneNumber2 Second telephone number TEXT16
TaxInvoiceRepresentativeName Name of Representative REPRES
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
TrainStationName Train station BAHNH
PaytSlipWthRefSubscriber ISR subscriber number ESRNR
SupplierPlant Plant (Own or External) WERKS
PaymentReason Payment Reason FARP_PAYT_RSN
Master Data Relations | to Other Relations ↓ Join Conditions
Account Number of the Alternative Payee
  • Client
  • Account Number of the Alternative Payee
  • I_SUPPLIER.MANDT == LFA1.MANDT
  • I_SUPPLIER.ALTERNATIVEPAYEEACCOUNTNUMBER == LFA1.LIFNR
Country/Region Key
  • Client
  • Country/Region Key
  • I_SUPPLIER.MANDT == T005.MANDT
  • I_SUPPLIER.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • I_SUPPLIER.MANDT == KNA1.MANDT
  • I_SUPPLIER.CUSTOMER == KNA1.KUNNR
Factory calendar key I_SUPPLIER.FACTORYCALENDAR == TFACD.IDENT
Account number of the master record with fiscal address
  • Client
  • Account number of the master record with fiscal address
  • I_SUPPLIER.MANDT == LFA1.MANDT
  • I_SUPPLIER.FISCALADDRESS == LFA1.LIFNR
Industry key
  • Client
  • Industry key
  • I_SUPPLIER.MANDT == T016.MANDT
  • I_SUPPLIER.INDUSTRY == T016.BRSCH
Reference Account Group for One-Time Account (Vendor)
  • Client
  • Reference Account Group for One-Time Account (Vendor)
  • I_SUPPLIER.MANDT == T077K.MANDT
  • I_SUPPLIER.REFERENCEACCOUNTGROUP == T077K.KTOKK
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_SUPPLIER.MANDT == T005S.MANDT
  • I_SUPPLIER.COUNTRY == T005S.LAND1
  • I_SUPPLIER.REGION == T005S.BLAND
Tax Type
  • Tax type
  • Client
  • ?
  • I_SUPPLIER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • I_SUPPLIER.MANDT == J_1AFITP.MANDT
  • I_SUPPLIER.[column in domain "KOART"] == J_1AFITP.KOART
Supplier's QM System
  • Client
  • Supplier's QM System
  • I_SUPPLIER.MANDT == TQ02B.MANDT
  • I_SUPPLIER.SUPLRQUALITYMANAGEMENTSYSTEM == TQ02B.QSSYSFAM
Account Number of Master Record of Tax Office Responsible
  • Client
  • Account Number of Master Record of Tax Office Responsible
  • I_SUPPLIER.MANDT == LFA1.MANDT
  • I_SUPPLIER.SUPLRTAXAUTHORITYACCOUNTNUMBER == LFA1.LIFNR
Vendor account group
  • Client
  • Vendor account group
  • I_SUPPLIER.MANDT == T077K.MANDT
  • I_SUPPLIER.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Language Key I_SUPPLIER.SUPPLIERLANGUAGE == T002.SPRAS
Function That Will Be Blocked
  • Client
  • Function That Will Be Blocked
  • I_SUPPLIER.MANDT == TQ04A.MANDT
  • I_SUPPLIER.SUPPLIERPROCUREMENTBLOCK == TQ04A.SPERRFKT
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • I_SUPPLIER.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_SUPPLIER.MANDT == TTXJ.MANDT
  • I_SUPPLIER.TAXJURISDICTION == TTXJ.TXJCD
Possible Checks for Tax Number 1
  • Client
  • Tax Number Type
  • I_SUPPLIER.MANDT == J_1ATODC.MANDT
  • I_SUPPLIER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_SUPPLIER.MANDT == T880.MANDT
  • I_SUPPLIER.TRADINGPARTNER == T880.RCOMP
Shipment: statistics group, transportation service agent
  • Client
  • Shipment: statistics group, transportation service agent
  • I_SUPPLIER.MANDT == VTSGD.MANDT
  • I_SUPPLIER.TRANSPSERVICEAGENTSTSTCGRP == VTSGD.STGDL
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
  • Client
  • Type of Business
  • I_SUPPLIER.MANDT == BUSTYPE.MANDT
  • I_SUPPLIER.BUSINESSTYPE == BUSTYPE.GESTYP
Type of Industry
  • Client
  • Type of Industry