FDZA

Transparent Table Application Table
20 Fields 2 CDS Views

Cash Management line items in payment requests

FDZA is an SAP database table in S/4HANA. Cash Management line items in payment requests. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_Cash_Payrq_Offset view from BASIC
P_Cash_Payrq_WO_Offset view from BASIC

Fields (20)

KeyField Data ElementDescription DomainTypeLength
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.

-- Cash Management line items in payment requests
-- 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