VBRK

Transparent Table Application Table
157 Fields 21 CDS Views

Billing Document: Header Data

VBRK is an SAP database table in S/4HANA. Billing Document: Header Data. It contains 157 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
E_BillingDocument view from EXTENSION Extension View for VBRK
I_BillingDocumentBasic view from BASIC Billing Document Basic
I_ElectronicDocCkptBillingDoc view from BASIC Electronic Document: Billing Document
I_PL_SAFTBillingDocumentPriced view_entity from BASIC SAFT PL Billing Doc Prcd BPI
P_BillingDocumentItemBasic_2 view_entity inner BASIC
P_CancelledBillgDocDtaMigrtn view_entity inner BASIC
SHSM_VBRK view from CDS View replacing VBRK check table
SHSM_VF_F view from CDS view replacing SHVF_F
SHSM_VMCFA view from CDS view replacing M_VMCFA for VMCFA
SHSM_VMCFB view from CDS View replacing M_VMCFB in search help VMCFB
SHSM_VMCFC view from CDS view replacing M_VMCFC for VMCFC
SHSM_VMCFE view from CDS View replacing M_VMCFE in search help VMCFE
SHSM_VMCRA view from CDS view replacing M_VMCRA for VMCRA
SHSM_VMCRB view from CDS view replacing M_VMCRB or VMCRB
TMA_V_VBRK_VBRP_1 view from Business Volume from Billing Document
V_VBUK_S4 view union_all Vbuk Cds View
v_vrpma view from
V_WB2_VBRK_VBRP_1 view inner Business Volume from Billing Document
V_Wb2_Vbrk_Vbrp_Tpm view inner CCS: Business Volume from Sales for TPM
V_WB2_VBRK_VBRP_TPM_1 view inner Business Volume from Billing Document with Campaign
view_sdi_head_p view from Header Related Data of a Billing Document

Fields (157)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vbeln VBELN_VF Billing Doc.
fkart FKART Billing Type
fktyp FKTYP BillingCategory
vbtyp VBTYPL Document Cat.
waerk WAERK Doc. Currency
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
kalsm KALSMASD Pric. Procedure
knumv KNUMV Doc. Condition
vsbed VSBED Shipping Conditions
fkdat FKDAT Billing Date
belnr BELNR_D Document Number
gjahr GJAHR Fiscal Year
poper POPER Posting Period
konda KONDA CustPrice Group
kdgrp KDGRP Customer Group
bzirk BZIRK Sales District
pltyp PLTYP Price List Tp.
inco1 INCO1 Incoterms
inco2 INCO2 Incoterms 2
rfbsk RFBSK Posting Status
mrnkz MRNKZ Man.Inv.Maint.
kurrf KURRF Exch.Rate Acct.
cpkur CPKUR Set Exchange Rt
valtg VALTG Add. Value Days
valdt VALDT Fixed Val. Date
zterm DZTERM Pyt Terms
zlsch SCHZW_BSEG Payt Method
ktgrd KTGRD AccAssmtGrpCust
land1 LLAND Dest. Ctry/Reg
regio REGIO Region
counc COUNC County Code
cityc CITYC City Code
bukrs BUKRS Company Code
taxk1 TAXK1 Tax Cls.1 Cust.
taxk2 TAXK2 Tax Cls.2 Cust.
taxk3 TAXK3 Tax Cls.3 Cust.
taxk4 TAXK4 Tax Cls.4 Cust.
taxk5 TAXK5 Tax Cls.5 Cust.
taxk6 TAXK6 Tax Cls.6 Cust.
taxk7 TAXK7 Tax Cls.7 Cust.
taxk8 TAXK8 Tax Cls.8 Cust.
taxk9 TAXK9 Tax Cls.9 Cust.
netwr NETWR Net Value
zukri DZUKRI Comb. Criteria
ernam ERNAM Created By
erzet ERZET Time
erdat ERDAT Created On
stafo STAFO Update Group
kunrg KUNRG Payer
kunag KUNAG Sold-to Party
maber MABER Dunning Area
stwae STWAE Stats. Currency
stceg STCEG VAT Reg. No.
aedat AEDAT Changed On
sfakn SFAKN Canceld Bill.Dc
knuma KNUMA Agreement
fkart_rl FKART_RL Inv. List Type
fkdat_rl FKDAT_RL Inv.Lst Bill.Dt
kurst KURST Exch. Rate Type
mschl MSCHL Dunning key
mansp MANSP Dunn. Block
spart SPART Division
kkber KKBER Cred.Contr.Area
knkli KNKLI Credit Account
cmwae WAERS_CM Currency
cmkuf CMKUF Exchange Rate
hityp_pr HITYP_PR HierTypePricing
custh_univ_sales_relvnce SD_CUSTH_CHRELV Cust. Hier. Relvnc.
custh_branch_uuid SD_CUSTH_UUID Cust. Hier. Br. UUID
bstnk_vf BSTKD Cust. Reference
vbund RASSC Trading Partner
fkart_ab FKART_AB AccrualBillType
kappl KAPPL Application
landtx LANDTX Tax Depar. C/R
stceg_h STCEG_H OriginSlsTxNo.
stceg_l STCEG_L CtryRgnSlsTxNo.
xblnr XBLNR_V1 Reference
zuonr ORDNR_V Assignment
mwsbk MWSBP Tax Amount
logsys LOGSYS Logical system
fksto FKSTO Canceled
xegdr XEGDR EU Triang. Deal
rplnr RPLNR Paym.Ca.Pl.No.
j_1afitp J_1AFITP_D Tax Type
kurrf_dat WWERT_D Translatn Date
kidno KIDNO Payment Ref.
bvtyp BVTYP Part.bank type
numpg J_1ANOPG Number of Pages
bupla BUPLA Business place
vkont CORR_VKONT_KK Contract Acct
fkk_docstat DOCSTAT_KK Add. Fin.Status
nrzas CHAR12 Character Field of Length 12
spe_billing_ind /SPE/DE_BILLING_IND Billing Indicator
vtref CORR_VTREF_KK Contract
fk_source_sys FK_SOURCE_SYS Source System
fktyp_crm FKTYP_CRM Serv. Bill.Cat.
stgrd STGRD Reversal Reason
changed_on TIMESTAMPL Time Stamp
expkz EXPKZ Export
exnum EXNUM Foreign Trade DataNr
akwae AKWAE LettOfCredCrcy
akkur AKKUR LettofCredRate
lcnum LCNUM Financ.Doc.No.
_dataaging DATA_TEMPERATURE Data Aging
buchk BUCHK Posting Status
gbstk GBSTK Overall Status
relik RELIK Inv.List Status
uvals UVALL_SU All Items
uvprs UVPRS_UK Prcg – All Itms
clrst CLRST Clearing Status
fksak FKSAK Ord.Rel.BillgSt
fkara FKARA Ord-Rel.Bill.Ty
vf_status VF_STATUS Status
vf_todo VF_TODO Issue Type
bdr_status BDR_STATUS Status
bdr_ref BDR_REF BDR Source Document
bdr_ref_logsys BDR_REF_LOGSYS BDR Source System
bdr_ref_vbtyp BDR_REF_VBTYP BDR Src. Doc. Cat.
pbd_status PBD_STATUS Status
abstk ABSTK Rejection Sts
draft VF_DRAFT_INDICATOR Draft Indicator
activedocument VBELN SD Document
grwcu GRWCU Currency
blart BLART Document Type
intra_rel INTRA_REL Intrastat rel.
intra_excl INTRA_EXCL exclude Intra
accrrel ISACCRUALRELEVANT Relevant for Accrual
pspsd PSPSD Paym Split Predec SD
apm_approval_status SD_APM_APPROVAL_STATUS Approval Status
apm_approval_reason SD_APM_APPROVAL_REASON Apprvl Req. Rsn ID
srcedoc_ext_comm_syst_type SRCE_DOC_EXT_COMM_SYST_TYPE SrceDocExtCommSystTy
ico_lifnr LIFNR_WK Sppl. No. Plnt
j_1tpbupl BCODE Branch Code
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
sdm_version SDBIL_SDM_VERSION_VBRK SDM Versioning
dummy_billingdoc_incl_eew_ps DUMMY Dummy function in length 1
glo_log_ref1_hd GLO_LOG_REF1_HD Business Process Indicator
zapcgkh /ILE/TAPCGK Annexing Package
apcgk_extendh /ILE/TAPCGK_EXT Ann.Package Extend
zabdath /ILE/TABDAT Annexing base date
dpc_rel /SAPPCE/DPC_REL DPC relevant
ad01basdoc AD01BASDOC Initial Doc.
ad01fareg AD01FAREG A&D Bill. Rule
vchrnmbr AD04VCHNR Voucher No.
j_3gkbaul J_3GKBAUL ETM-Rel. Ind.
j_3gkenie J_3GKENIE Intern./extern.
kunwe KUNWE Ship-to Party
mndid SEPA_MNDID Mandate Ref.
pay_type SEPA_PAY_TYPE Payment Type
sepon SD_SEPA_FLAG SEPA-Relevant
mndvg SD_SEPA_FLAG SEPA-Relevant
sppaym SPPAYM PaymMethod
sppord SPPORD Sales Order

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Billing Document: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBRK (
    MANDT,                         -- Client [MANDT]
    VBELN,                         -- Billing Doc. [VBELN_VF]
    FKART,                         -- Billing Type [FKART]
    FKTYP,                         -- BillingCategory [FKTYP]
    VBTYP,                         -- Document Cat. [VBTYPL]
    WAERK,                         -- Doc. Currency [WAERK]
    VKORG,                         -- Sales Org. [VKORG]
    VTWEG,                         -- Distr. Channel [VTWEG]
    KALSM,                         -- Pric. Procedure [KALSMASD]
    KNUMV,                         -- Doc. Condition [KNUMV]
    VSBED,                         -- Shipping Conditions [VSBED]
    FKDAT,                         -- Billing Date [FKDAT]
    BELNR,                         -- Document Number [BELNR_D]
    GJAHR,                         -- Fiscal Year [GJAHR]
    POPER,                         -- Posting Period [POPER]
    KONDA,                         -- CustPrice Group [KONDA]
    KDGRP,                         -- Customer Group [KDGRP]
    BZIRK,                         -- Sales District [BZIRK]
    PLTYP,                         -- Price List Tp. [PLTYP]
    INCO1,                         -- Incoterms [INCO1]
    INCO2,                         -- Incoterms 2 [INCO2]
    RFBSK,                         -- Posting Status [RFBSK]
    MRNKZ,                         -- Man.Inv.Maint. [MRNKZ]
    KURRF,                         -- Exch.Rate Acct. [KURRF]
    CPKUR,                         -- Set Exchange Rt [CPKUR]
    VALTG,                         -- Add. Value Days [VALTG]
    VALDT,                         -- Fixed Val. Date [VALDT]
    ZTERM,                         -- Pyt Terms [DZTERM]
    ZLSCH,                         -- Payt Method [SCHZW_BSEG]
    KTGRD,                         -- AccAssmtGrpCust [KTGRD]
    LAND1,                         -- Dest. Ctry/Reg [LLAND]
    REGIO,                         -- Region [REGIO]
    COUNC,                         -- County Code [COUNC]
    CITYC,                         -- City Code [CITYC]
    BUKRS,                         -- Company Code [BUKRS]
    TAXK1,                         -- Tax Cls.1 Cust. [TAXK1]
    TAXK2,                         -- Tax Cls.2 Cust. [TAXK2]
    TAXK3,                         -- Tax Cls.3 Cust. [TAXK3]
    TAXK4,                         -- Tax Cls.4 Cust. [TAXK4]
    TAXK5,                         -- Tax Cls.5 Cust. [TAXK5]
    TAXK6,                         -- Tax Cls.6 Cust. [TAXK6]
    TAXK7,                         -- Tax Cls.7 Cust. [TAXK7]
    TAXK8,                         -- Tax Cls.8 Cust. [TAXK8]
    TAXK9,                         -- Tax Cls.9 Cust. [TAXK9]
    NETWR,                         -- Net Value [NETWR]
    ZUKRI,                         -- Comb. Criteria [DZUKRI]
    ERNAM,                         -- Created By [ERNAM]
    ERZET,                         -- Time [ERZET]
    ERDAT,                         -- Created On [ERDAT]
    STAFO,                         -- Update Group [STAFO]
    KUNRG,                         -- Payer [KUNRG]
    KUNAG,                         -- Sold-to Party [KUNAG]
    MABER,                         -- Dunning Area [MABER]
    STWAE,                         -- Stats. Currency [STWAE]
    STCEG,                         -- VAT Reg. No. [STCEG]
    AEDAT,                         -- Changed On [AEDAT]
    SFAKN,                         -- Canceld Bill.Dc [SFAKN]
    KNUMA,                         -- Agreement [KNUMA]
    FKART_RL,                      -- Inv. List Type [FKART_RL]
    FKDAT_RL,                      -- Inv.Lst Bill.Dt [FKDAT_RL]
    KURST,                         -- Exch. Rate Type [KURST]
    MSCHL,                         -- Dunning key [MSCHL]
    MANSP,                         -- Dunn. Block [MANSP]
    SPART,                         -- Division [SPART]
    KKBER,                         -- Cred.Contr.Area [KKBER]
    KNKLI,                         -- Credit Account [KNKLI]
    CMWAE,                         -- Currency [WAERS_CM]
    CMKUF,                         -- Exchange Rate [CMKUF]
    HITYP_PR,                      -- HierTypePricing [HITYP_PR]
    CUSTH_UNIV_SALES_RELVNCE,      -- Cust. Hier. Relvnc. [SD_CUSTH_CHRELV]
    CUSTH_BRANCH_UUID,             -- Cust. Hier. Br. UUID [SD_CUSTH_UUID]
    BSTNK_VF,                      -- Cust. Reference [BSTKD]
    VBUND,                         -- Trading Partner [RASSC]
    FKART_AB,                      -- AccrualBillType [FKART_AB]
    KAPPL,                         -- Application [KAPPL]
    LANDTX,                        -- Tax Depar. C/R [LANDTX]
    STCEG_H,                       -- OriginSlsTxNo. [STCEG_H]
    STCEG_L,                       -- CtryRgnSlsTxNo. [STCEG_L]
    XBLNR,                         -- Reference [XBLNR_V1]
    ZUONR,                         -- Assignment [ORDNR_V]
    MWSBK,                         -- Tax Amount [MWSBP]
    LOGSYS,                        -- Logical system [LOGSYS]
    FKSTO,                         -- Canceled [FKSTO]
    XEGDR,                         -- EU Triang. Deal [XEGDR]
    RPLNR,                         -- Paym.Ca.Pl.No. [RPLNR]
    J_1AFITP,                      -- Tax Type [J_1AFITP_D]
    KURRF_DAT,                     -- Translatn Date [WWERT_D]
    KIDNO,                         -- Payment Ref. [KIDNO]
    BVTYP,                         -- Part.bank type [BVTYP]
    NUMPG,                         -- Number of Pages [J_1ANOPG]
    BUPLA,                         -- Business place [BUPLA]
    VKONT,                         -- Contract Acct [CORR_VKONT_KK]
    FKK_DOCSTAT,                   -- Add. Fin.Status [DOCSTAT_KK]
    NRZAS,                         -- Character Field of Length 12 [CHAR12]
    SPE_BILLING_IND,               -- Billing Indicator [/SPE/DE_BILLING_IND]
    VTREF,                         -- Contract [CORR_VTREF_KK]
    FK_SOURCE_SYS,                 -- Source System [FK_SOURCE_SYS]
    FKTYP_CRM,                     -- Serv. Bill.Cat. [FKTYP_CRM]
    STGRD,                         -- Reversal Reason [STGRD]
    CHANGED_ON,                    -- Time Stamp [TIMESTAMPL]
    EXPKZ,                         -- Export [EXPKZ]
    EXNUM,                         -- Foreign Trade DataNr [EXNUM]
    AKWAE,                         -- LettOfCredCrcy [AKWAE]
    AKKUR,                         -- LettofCredRate [AKKUR]
    LCNUM,                         -- Financ.Doc.No. [LCNUM]
    _DATAAGING,                    -- Data Aging [DATA_TEMPERATURE]
    BUCHK,                         -- Posting Status [BUCHK]
    GBSTK,                         -- Overall Status [GBSTK]
    RELIK,                         -- Inv.List Status [RELIK]
    UVALS,                         -- All Items [UVALL_SU]
    UVPRS,                         -- Prcg – All Itms [UVPRS_UK]
    CLRST,                         -- Clearing Status [CLRST]
    FKSAK,                         -- Ord.Rel.BillgSt [FKSAK]
    FKARA,                         -- Ord-Rel.Bill.Ty [FKARA]
    VF_STATUS,                     -- Status [VF_STATUS]
    VF_TODO,                       -- Issue Type [VF_TODO]
    BDR_STATUS,                    -- Status [BDR_STATUS]
    BDR_REF,                       -- BDR Source Document [BDR_REF]
    BDR_REF_LOGSYS,                -- BDR Source System [BDR_REF_LOGSYS]
    BDR_REF_VBTYP,                 -- BDR Src. Doc. Cat. [BDR_REF_VBTYP]
    PBD_STATUS,                    -- Status [PBD_STATUS]
    ABSTK,                         -- Rejection Sts [ABSTK]
    DRAFT,                         -- Draft Indicator [VF_DRAFT_INDICATOR]
    ACTIVEDOCUMENT,                -- SD Document [VBELN]
    GRWCU,                         -- Currency [GRWCU]
    BLART,                         -- Document Type [BLART]
    INTRA_REL,                     -- Intrastat rel. [INTRA_REL]
    INTRA_EXCL,                    -- exclude Intra [INTRA_EXCL]
    ACCRREL,                       -- Relevant for Accrual [ISACCRUALRELEVANT]
    PSPSD,                         -- Paym Split Predec SD [PSPSD]
    APM_APPROVAL_STATUS,           -- Approval Status [SD_APM_APPROVAL_STATUS]
    APM_APPROVAL_REASON,           -- Apprvl Req. Rsn ID [SD_APM_APPROVAL_REASON]
    SRCEDOC_EXT_COMM_SYST_TYPE,    -- SrceDocExtCommSystTy [SRCE_DOC_EXT_COMM_SYST_TYPE]
    ICO_LIFNR,                     -- Sppl. No. Plnt [LIFNR_WK]
    J_1TPBUPL,                     -- Branch Code [BCODE]
    INCOV,                         -- Inco. Version [INCOV]
    INCO2_L,                       -- Inco. Location1 [INCO2_L]
    INCO3_L,                       -- Inco. Location2 [INCO3_L]
    SDM_VERSION,                   -- SDM Versioning [SDBIL_SDM_VERSION_VBRK]
    DUMMY_BILLINGDOC_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    GLO_LOG_REF1_HD,               -- Business Process Indicator [GLO_LOG_REF1_HD]
    ZAPCGKH,                       -- Annexing Package [/ILE/TAPCGK]
    APCGK_EXTENDH,                 -- Ann.Package Extend [/ILE/TAPCGK_EXT]
    ZABDATH,                       -- Annexing base date [/ILE/TABDAT]
    DPC_REL,                       -- DPC relevant [/SAPPCE/DPC_REL]
    AD01BASDOC,                    -- Initial Doc. [AD01BASDOC]
    AD01FAREG,                     -- A&D Bill. Rule [AD01FAREG]
    VCHRNMBR,                      -- Voucher No. [AD04VCHNR]
    J_3GKBAUL,                     -- ETM-Rel. Ind. [J_3GKBAUL]
    J_3GKENIE,                     -- Intern./extern. [J_3GKENIE]
    KUNWE,                         -- Ship-to Party [KUNWE]
    MNDID,                         -- Mandate Ref. [SEPA_MNDID]
    PAY_TYPE,                      -- Payment Type [SEPA_PAY_TYPE]
    SEPON,                         -- SEPA-Relevant [SD_SEPA_FLAG]
    MNDVG,                         -- SEPA-Relevant [SD_SEPA_FLAG]
    SPPAYM,                        -- PaymMethod [SPPAYM]
    SPPORD,                        -- Sales Order [SPPORD]
    PRIMARY KEY (MANDT, VBELN)
);

Learn More