A_Supplier

Supplier | view: ASUPPLIER | Extraction: Not supported | 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
BirthDate Date of Birth of the Person Subject to Withholding Tax
SuplrQltyInProcmtCertfnValidTo Validity Date of Certification
Column Name Description
PaymentIsBlockedForSupplier Payment Block Show values
PostingIsBlocked Central posting block Show values
PurchasingIsBlocked Centrally imposed purchasing block Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
IsNaturalPerson Natural Person Show values
SuplrProofOfDelivRlvtCode Supplier indicator relevant for proof of delivery Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
BR_TaxIsSplit Tax Split Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person who Created the Object USNAM
SupplierFullName Supplier Full Name TEXT220
SupplierName Name of Supplier TEXT80
VATRegistration VAT Registration Number STCEG
ConcatenatedInternationalLocNo Cocatenated International Location Number TEXT20
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
InternationalLocationNumber3 Check digit for the international location number NUM01
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
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
Master Data Relations Join Conditions
Account Number of the Alternative Payee
  • Account Number of the Alternative Payee
  • Client
  • A_SUPPLIER.ALTERNATIVEPAYEEACCOUNTNUMBER == LFA1.LIFNR
  • A_SUPPLIER.MANDT == LFA1.MANDT
Customer Number
  • Customer Number
  • Client
  • A_SUPPLIER.CUSTOMER == KNA1.KUNNR
  • A_SUPPLIER.MANDT == KNA1.MANDT
Account number of the master record with fiscal address
  • Account number of the master record with fiscal address
  • Client
  • A_SUPPLIER.FISCALADDRESS == LFA1.LIFNR
  • A_SUPPLIER.MANDT == LFA1.MANDT
Industry key
  • Industry key
  • Client
  • A_SUPPLIER.INDUSTRY == T016.BRSCH
  • A_SUPPLIER.MANDT == T016.MANDT
Tax Type
  • ?
  • Client
  • Tax type
  • A_SUPPLIER.[column in domain "KOART"] == J_1AFITP.KOART
  • A_SUPPLIER.MANDT == J_1AFITP.MANDT
  • A_SUPPLIER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
Supplier's QM System
  • Client
  • Supplier's QM System
  • A_SUPPLIER.MANDT == TQ02B.MANDT
  • A_SUPPLIER.SUPLRQUALITYMANAGEMENTSYSTEM == TQ02B.QSSYSFAM
Vendor account group
  • Client
  • Vendor account group
  • A_SUPPLIER.MANDT == T077K.MANDT
  • A_SUPPLIER.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Function That Will Be Blocked
  • Client
  • Function That Will Be Blocked
  • A_SUPPLIER.MANDT == TQ04A.MANDT
  • A_SUPPLIER.SUPPLIERPROCUREMENTBLOCK == TQ04A.SPERRFKT
Possible Checks for Tax Number 1
  • Client
  • Tax Number Type
  • A_SUPPLIER.MANDT == J_1ATODC.MANDT
  • A_SUPPLIER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC