FAC_DART_Z3_VENDOR

Vendor Master Data | view: FAC_DZVENDOR | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: ADCPADRCT001TKA02LFA1T077KT077YLFB1
Column Name Description
CompanyCode FK Company Code
Supplier FK Account Number of Supplier
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
ClearCustomerSupplier Indicator: Clearing between customer and vendor? Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
AlternativePayeeIsAllowed Indicator: Alternative Payee in Document Allowed? Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
StreetName Street TEXT60
CityName City TEXT40
District District TEXT40
PostalCode City postal code CHAR10
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
AddressID Address ADRNR
AccountGroupName Account Group Name TEXT30
PaymentTerms Terms of payment key ZTERM
TaxNumberResponsible Tax Number at Responsible Tax Authority CHAR18
CreatedByUser Name of Person who Created the Object USNAM
PaymentMethodsList List of Respected Payment Methods ZWELS
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
AuthorizationGroup Authorization Group BRGRU
SystemClient Client
Master Data Relations Join Conditions
Account Number of the Alternative Payee
  • Client
  • Account Number of the Alternative Payee
  • FAC_DART_Z3_VENDOR.MANDT == LFA1.MANDT
  • FAC_DART_Z3_VENDOR.ALTERNATIVEPAYEEACCOUNTNUMBER == LFA1.LIFNR
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_VENDOR.MANDT == T001.MANDT
  • FAC_DART_Z3_VENDOR.COMPANYCODE == T001.BUKRS
Country key
  • Client
  • Country/Region Key
  • FAC_DART_Z3_VENDOR.MANDT == T005.MANDT
  • FAC_DART_Z3_VENDOR.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • FAC_DART_Z3_VENDOR.MANDT == KNA1.MANDT
  • FAC_DART_Z3_VENDOR.CUSTOMER == KNA1.KUNNR
Industry key
  • Client
  • Industry key
  • FAC_DART_Z3_VENDOR.MANDT == T016.MANDT
  • FAC_DART_Z3_VENDOR.INDUSTRY == T016.BRSCH
Minority Indicator
  • Client
  • Minority Indicator
  • FAC_DART_Z3_VENDOR.MANDT == T059M.MANDT
  • FAC_DART_Z3_VENDOR.MINORITYGROUP == T059M.MINDK
Payment method supplement
  • Client
  • Payment method supplement
  • FAC_DART_Z3_VENDOR.MANDT == T042F.MANDT
  • FAC_DART_Z3_VENDOR.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Reconciliation Account in General Ledger
  • Client
  • Company Code
  • Reconciliation Account in General Ledger
  • FAC_DART_Z3_VENDOR.MANDT == SKB1.MANDT
  • FAC_DART_Z3_VENDOR.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_VENDOR.RECONCILIATIONACCOUNT == SKB1.SAKNR
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • FAC_DART_Z3_VENDOR.MANDT == T005S.MANDT
  • FAC_DART_Z3_VENDOR.COUNTRY == T005S.LAND1
  • FAC_DART_Z3_VENDOR.REGION == T005S.BLAND
Account Number of Master Record of Tax Office Responsible
  • Client
  • Account Number of Master Record of Tax Office Responsible
  • FAC_DART_Z3_VENDOR.MANDT == LFA1.MANDT
  • FAC_DART_Z3_VENDOR.SUPLRTAXAUTHORITYACCOUNTNUMBER == LFA1.LIFNR
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • FAC_DART_Z3_VENDOR.SUPPLIER == LFA1.LIFNR
  • FAC_DART_Z3_VENDOR.MANDT == LFA1.MANDT
Vendor account group
  • Client
  • Vendor account group
  • FAC_DART_Z3_VENDOR.MANDT == T077K.MANDT
  • FAC_DART_Z3_VENDOR.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Head office account number
  • Client
  • Head office account number
  • FAC_DART_Z3_VENDOR.MANDT == LFA1.MANDT
  • FAC_DART_Z3_VENDOR.SUPPLIERHEADOFFICE == LFA1.LIFNR
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • FAC_DART_Z3_VENDOR.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • FAC_DART_Z3_VENDOR.MANDT == TTXJ.MANDT
  • FAC_DART_Z3_VENDOR.TAXJURISDICTION == TTXJ.TXJCD
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FAC_DART_Z3_VENDOR.MANDT == T880.MANDT
  • FAC_DART_Z3_VENDOR.TRADINGPARTNER == T880.RCOMP