VBRK

-- ============================================================
-- Table  : VBRK Billing Document: Header Data
-- Purpose: Column-selected read of VBRK — auto-generated from field metadata
-- Grain  : One row per VBELN
-- 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
  h.MANDT    AS "Client",
  h.VBELN    AS "Billing Document",
  h.FKART    AS "Billing Type",
  h.FKTYP    AS "Billing Category",
  h.VBTYP    AS "SD Document Category",
  h.WAERK    AS "SD Document Currency",
  h.VKORG    AS "Sales Organization",
  h.VTWEG    AS "Distribution Channel",
  h.SPART    AS "Division",
  h.ERNAM    AS "Name of Person Who Created the Object",
  h.ERDAT    AS "Date on Which Record Was Created",
  h.ERZET    AS "Entry Time",
  h.BUKRS    AS "Company Code",
  h.GJAHR    AS "Fiscal Year",
  h.FKDAT    AS "Billing Date for Billing Index and Printout",
  h.KUNRG    AS "Payer",
  h.KUNAG    AS "Sold-To Party",
  h.KNUMV    AS "Number of the Document Condition",
  h.NETWR    AS "Net Value in Document Currency",
  h.MWSBK    AS "Tax Amount in Document Currency",
  h.BELNR    AS "Accounting Document Number",
  h.XBLNR    AS "Reference Document Number",
  h.STCEG    AS "VAT Registration Number",
  h.INCO1    AS "Incoterms (Part 1)",
  h.INCO2    AS "Incoterms (Part 2)",
  h.LAND1    AS "Country Key",
  h.REGIO    AS "Region",
  h.ZTERM    AS "Terms of Payment Key",
  h.RFBSK    AS "Status for Transfer to Accounting",
  h.BSTNK_VF AS "Customer Purchase Order Number"
FROM <catalog>.<schema>.vbrk h
WHERE
  h.MANDT = '<MANDT>'
ORDER BY h.VBELN;