SAP table T090Z (Period control for transactions)
SAP table T090Z has 6 primary key fields being MANDT,PERIV,PERBSL,BDATJ,BUMON,BUTAG.
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 | |
| PERIV | Fiscal Year Variant | CHAR | 2 | 0 | T009 | PERIV | |
| PERBSL | Key for Period Control in Transactions | CHAR | 2 | 0 | T090R | PERBSL | |
| BDATJ | Posting Date YYYY | NUMC | 4 | 0 | BDATJ | ||
| BUMON | Posting date calendar month | NUMC | 2 | 0 | BUMON | ||
| BUTAG | Calendar day from the posting date | NUMC | 2 | 0 | BUTAG | ||
| PERAFA | Value Date Period for Depreciation/Interest Calculation | NUMC | 3 | 0 | PERAFA | ||
| XMONMI | Depreciation Calculated from Mid-Month | CHAR | 1 | 0 | XMONMI |
T090Z foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T090Z | PERBSL | T090R | Period control rules for transactions | MANDT |
| 0 T090Z | PERBSL | T090R | Period control rules for transactions | PERBSL |
| 1 T090Z | PERIV | T009 | Fiscal Year Variants | MANDT |
| 1 T090Z | PERIV | T009 | Fiscal Year Variants | PERIV |