VTBZV
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FinTransPaymentDetail | view_entity | from | BASIC | Fin Trans Payment Detail |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA