SAP table FDZA (Cash Management line items in payment requests)
SAP table FDZA has 2 primary key fields being MANDT,KEYNO.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||
| KEYNO | Key Number for Payment Request | CHAR | 10 | 0 | PRQ_KEYNO | ||||||||||||
| BUKRS | Company Code | CHAR | 4 | 0 | BUKRS | ||||||||||||
| BELNR | Document Number of an Accounting Document | CHAR | 10 | 0 | BELNR_D | ||||||||||||
| GJAHR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||||||||||||
| BUZEI | Number of Line Item Within Accounting Document | NUMC | 3 | 0 | BUZEI | ||||||||||||
| GSBER | Business Area | CHAR | 4 | 0 | GSBER | ||||||||||||
| KOART | Account type | CHAR | 1 | 0 | KOART |
|
|||||||||||
| PARNO | Business Partner | CHAR | 10 | 0 | PRQ_PARNO | ||||||||||||
| GRUPP | Planning Group | CHAR | 10 | 0 | FDGRP | ||||||||||||
| BNKKO | G/L account/internal Cash Mgmt account | CHAR | 10 | 0 | SKPSK | ||||||||||||
| EBENE | Planning Level | CHAR | 2 | 0 | FDLEV | ||||||||||||
| DATUM | Planning Date | DATS | 8 | 0 | FDTAG | ||||||||||||
| DISPW | Planned currency for cash management and forecast | CUKY | 5 | 0 | DISPW | ||||||||||||
| WRSHB | Amount in Planning Currency | CURR | 23 | 2 | WRSHD | ||||||||||||
| DMSHB | Planned Amount in Local Currency | CURR | 23 | 2 | DMSHD | ||||||||||||
| GBUKR | Offsetting company code | CHAR | 4 | 0 | GBUKR | ||||||||||||
| GGRUP | Offsetting account | CHAR | 10 | 0 | GGRUP | ||||||||||||
| GVALT | Offsetting value date | DATS | 8 | 0 | GVALT | ||||||||||||
| GEBEN | Planning Level | CHAR | 2 | 0 | FDLEV |