FDZA
Finanzdispo-Einzelposten der Zahlungsanordnungen
FDZA is an SAP database table in S/4HANA. Finanzdispo-Einzelposten der Zahlungsanordnungen. It contains 20 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_Cash_Payrq_Offset | view | from | BASIC | |
| P_Cash_Payrq_WO_Offset | view | from | BASIC |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | keyno | prq_keyno | Key Number | |||
| bukrs | bukrs | Company Code | ||||
| belnr | belnr_d | Document Number | ||||
| gjahr | gjahr | Fiscal Year | ||||
| buzei | buzei | Item | ||||
| gsber | gsber | Business Area | ||||
| koart | koart | Account type | ||||
| parno | prq_parno | Business partner | ||||
| grupp | fdgrp | Planning group | ||||
| bnkko | skpsk | G/L account | ||||
| ebene | fdlev | Planning Level | ||||
| datum | fdtag | Planning Date | ||||
| dispw | dispw | Planned currency | ||||
| wrshb | wrshd | Amount | ||||
| dmshb | dmshd | Local Curr. Amount | ||||
| gbukr | gbukr | Offsetting CC | ||||
| ggrup | ggrup | Offsetting acct | ||||
| gvalt | gvalt | Offset. val. dt | ||||
| geben | fdlev | Planning Level |
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.
-- Finanzdispo-Einzelposten der Zahlungsanordnungen
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FDZA (
MANDT, -- Client [mandt]
KEYNO, -- Key Number [prq_keyno]
BUKRS, -- Company Code [bukrs]
BELNR, -- Document Number [belnr_d]
GJAHR, -- Fiscal Year [gjahr]
BUZEI, -- Item [buzei]
GSBER, -- Business Area [gsber]
KOART, -- Account type [koart]
PARNO, -- Business partner [prq_parno]
GRUPP, -- Planning group [fdgrp]
BNKKO, -- G/L account [skpsk]
EBENE, -- Planning Level [fdlev]
DATUM, -- Planning Date [fdtag]
DISPW, -- Planned currency [dispw]
WRSHB, -- Amount [wrshd]
DMSHB, -- Local Curr. Amount [dmshd]
GBUKR, -- Offsetting CC [gbukr]
GGRUP, -- Offsetting acct [ggrup]
GVALT, -- Offset. val. dt [gvalt]
GEBEN, -- Planning Level [fdlev]
PRIMARY KEY (MANDT, KEYNO)
);
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