I_BusinessPartnerSupplier

Business Partner Supplier | view: IBPSUPPLIER | ATTR | Extraction: Full or Incremental | Component: Business Partners
Tables used: BUT000CVI_VEND_LINKLFA1
Column Name Description
Supplier Account Number of Supplier
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
SuplrQltyInProcmtCertfnValidTo Validity Date of Certification
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
PostingIsBlocked Central posting block Show values
PurchasingIsBlocked Centrally imposed purchasing block Show values
VATLiability Liable for VAT Show values
PaymentIsBlockedForSupplier Payment Block Show values
SuplrProofOfDelivRlvtCode Supplier indicator relevant for proof of delivery Show values
BR_TaxIsSplit Tax Split Show values
IsActiveEntity Draft - Indicator - Is active document 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
DeletionIndicator Central Deletion Flag for Master Record Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
FormOfAddress Title TEXT15
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
AuthorizationGroup Authorization Group BRGRU
SupplierCorporateGroup Group key KONZS
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
TrainStationName Train station BAHNH
PaytSlipWthRefSubscriber ISR subscriber number ESRNR
SupplierPlant Plant (Own or External) WERKS
PaymentReason Payment Reason FARP_PAYT_RSN
Master Data Relations Join Conditions
Customer Number
  • Client
  • Customer Number
  • I_BUSINESSPARTNERSUPPLIER.MANDT == KNA1.MANDT
  • I_BUSINESSPARTNERSUPPLIER.CUSTOMER == KNA1.KUNNR
Factory calendar key I_BUSINESSPARTNERSUPPLIER.FACTORYCALENDAR == TFACD.IDENT
Account number of the master record with fiscal address
  • Client
  • Account number of the master record with fiscal address
  • I_BUSINESSPARTNERSUPPLIER.MANDT == LFA1.MANDT
  • I_BUSINESSPARTNERSUPPLIER.FISCALADDRESS == LFA1.LIFNR
Reference Account Group for One-Time Account (Vendor)
  • Client
  • Reference Account Group for One-Time Account (Vendor)
  • I_BUSINESSPARTNERSUPPLIER.MANDT == T077K.MANDT
  • I_BUSINESSPARTNERSUPPLIER.REFERENCEACCOUNTGROUP == T077K.KTOKK
Tax Type
  • Tax type
  • Client
  • ?
  • I_BUSINESSPARTNERSUPPLIER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • I_BUSINESSPARTNERSUPPLIER.MANDT == J_1AFITP.MANDT
  • I_BUSINESSPARTNERSUPPLIER.[column in domain "KOART"] == J_1AFITP.KOART
Supplier's QM System
  • Client
  • Supplier's QM System
  • I_BUSINESSPARTNERSUPPLIER.MANDT == TQ02B.MANDT
  • I_BUSINESSPARTNERSUPPLIER.SUPLRQUALITYMANAGEMENTSYSTEM == TQ02B.QSSYSFAM
Vendor account group
  • Client
  • Vendor account group
  • I_BUSINESSPARTNERSUPPLIER.MANDT == T077K.MANDT
  • I_BUSINESSPARTNERSUPPLIER.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Account Number of the Alternative Payee
  • Client
  • Account Number of the Alternative Payee
  • I_BUSINESSPARTNERSUPPLIER.MANDT == LFA1.MANDT
  • I_BUSINESSPARTNERSUPPLIER.SUPPLIERALTERNATIVEPAYEE == LFA1.LIFNR
Function That Will Be Blocked
  • Client
  • Function That Will Be Blocked
  • I_BUSINESSPARTNERSUPPLIER.MANDT == TQ04A.MANDT
  • I_BUSINESSPARTNERSUPPLIER.SUPPLIERPROCUREMENTBLOCK == TQ04A.SPERRFKT
Possible Checks for Tax Number 1
  • Client
  • Tax Number Type
  • I_BUSINESSPARTNERSUPPLIER.MANDT == J_1ATODC.MANDT
  • I_BUSINESSPARTNERSUPPLIER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
Shipment: statistics group, transportation service agent
  • Client
  • Shipment: statistics group, transportation service agent
  • I_BUSINESSPARTNERSUPPLIER.MANDT == VTSGD.MANDT
  • I_BUSINESSPARTNERSUPPLIER.TRANSPSERVICEAGENTSTSTCGRP == VTSGD.STGDL