LFA1

-- ============================================================
-- Table  : LFA1 Vendor Master (General Section)
-- Purpose: Column-selected read of LFA1 — auto-generated from field metadata
-- Grain  : One row per LIFNR
-- Notes  : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  v.MANDT AS "Client",
  v.LIFNR AS "Account Number of Vendor or Creditor",
  v.LAND1 AS "Country Key",
  v.NAME1 AS "Name 1",
  v.NAME2 AS "Name 2",
  v.NAME3 AS "Name 3",
  v.NAME4 AS "Name 4",
  v.ORT01 AS "City",
  v.ORT02 AS "District",
  v.PFACH AS "PO Box",
  v.PSTL2 AS "P.O. Box Postal Code",
  v.PSTLZ AS "Postal Code",
  v.REGIO AS "Region",
  v.SORTL AS "Sort Field",
  v.STRAS AS "House Number and Street",
  v.ADRNR AS "Address",
  v.MCOD1 AS "Search Term for Matchcode Search",
  v.MCOD2 AS "Search Term for Matchcode Search",
  v.MCOD3 AS "Search Term for Matchcode Search",
  v.ANRED AS "Title",
  v.BAHNS AS "Train Station",
  v.BBBNR AS "International location number (part 1)",
  v.BBSNR AS "International Location Number (Part 2)",
  v.BEGRU AS "Authorization Group",
  v.BRSCH AS "Industry Key",
  v.BUBKZ AS "Check digit for the international location number",
  v.GBDAT AS "Date of Birth of the Person Subject to Withholding Tax",
  v.DTAMS AS "Data Medium Exchange Indicator",
  v.DTAWS AS "Instruction Key for Data Medium Exchange",
  v.ERDAT AS "Date on Which Record Was Created",
  v.ERNAM AS "Name of Person Who Created the Object",
  v.KTOKK AS "Vendor Account Group",
  v.KUNNR AS "Customer Number",
  v.LNRZA AS "Account Number of the Alternative Payee",
  v.LOEVM AS "Central Deletion Flag for Master Record",
  v.SPRAS AS "Language Key",
  v.SPERR AS "Central Posting Block",
  v.SPERM AS "Central Purchasing Block",
  v.STCD1 AS "Tax Number 1",
  v.STCD2 AS "Tax Number 2"
  -- … plus 18 more columns — full list in the Fields section above
FROM <catalog>.<schema>.lfa1 v
WHERE
  v.MANDT = '<MANDT>'
  -- AND v.LIFNR = '<LIFNR>'
ORDER BY v.LIFNR;