VTBZV

Transparent Table Application Table

Payment Details for Transaction

VTBZV is an SAP database table in S/4HANA. Payment Details for Transaction. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinTransPaymentDetail view_entity from BASIC Fin Trans Payment Detail

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY rfha tb_rfha Transaction
KEY ssign tb_ssign Direction
KEY waers waers Currency
KEY dzverb tb_dzverb Valid From
KEY sbewart sbewart Flow Type
cruser tb_cruser Entered By
dcrdat tb_crdat Entry Date
tcrtim tb_tcrtim Entry Time
upuser tb_upuser Changed By
dupdat tb_dupdat Changed On
tuptim tb_tuptim Time Changed
hbkid hbkid House Bank
hktid hktid Account ID
rpzahl tb_rpzahl_new Payer/Payee
rpbank tb_rpbank Partner Bank
szart tb_szart Pmnt Transact.
zlsch dzlsch Pymt Meth.
uzawe uzawe Pmnt Meth. Sup.
spayrq tb_spayrqk Payment Request
sprsng tb_sprsngk Individual Pmnt
sprgrd tb_sprgrd Group Determ.
scspay tb_scspay Same Direction
zwels dzwels Payment Methods
rpcode rpcode Repetitive Code
rp_text rpcode_text Reference Text
lzbkz lzbkz SCB Ind.
landl landl Supply C/R
novation_oid os_guid GUID
mndid sepa_mndid Mandate Ref.

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.

-- Payment Details for Transaction
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTBZV (
    MANDT,         -- Client [mandt]
    BUKRS,         -- Company Code [bukrs]
    RFHA,          -- Transaction [tb_rfha]
    SSIGN,         -- Direction [tb_ssign]
    WAERS,         -- Currency [waers]
    DZVERB,        -- Valid From [tb_dzverb]
    SBEWART,       -- Flow Type [sbewart]
    CRUSER,        -- Entered By [tb_cruser]
    DCRDAT,        -- Entry Date [tb_crdat]
    TCRTIM,        -- Entry Time [tb_tcrtim]
    UPUSER,        -- Changed By [tb_upuser]
    DUPDAT,        -- Changed On [tb_dupdat]
    TUPTIM,        -- Time Changed [tb_tuptim]
    HBKID,         -- House Bank [hbkid]
    HKTID,         -- Account ID [hktid]
    RPZAHL,        -- Payer/Payee [tb_rpzahl_new]
    RPBANK,        -- Partner Bank [tb_rpbank]
    SZART,         -- Pmnt Transact. [tb_szart]
    ZLSCH,         -- Pymt Meth. [dzlsch]
    UZAWE,         -- Pmnt Meth. Sup. [uzawe]
    SPAYRQ,        -- Payment Request [tb_spayrqk]
    SPRSNG,        -- Individual Pmnt [tb_sprsngk]
    SPRGRD,        -- Group Determ. [tb_sprgrd]
    SCSPAY,        -- Same Direction [tb_scspay]
    ZWELS,         -- Payment Methods [dzwels]
    RPCODE,        -- Repetitive Code [rpcode]
    RP_TEXT,       -- Reference Text [rpcode_text]
    LZBKZ,         -- SCB Ind. [lzbkz]
    LANDL,         -- Supply C/R [landl]
    NOVATION_OID,  -- GUID [os_guid]
    MNDID,         -- Mandate Ref. [sepa_mndid]
    PRIMARY KEY (MANDT, BUKRS, RFHA, SSIGN, WAERS, DZVERB, SBEWART)
);