SAP table V_T8A00 (Generated Table for View)
SAP table V_T8A00 has 5 primary key fields being MANDT,KOKRS,MTART,BKLAS,BWMOD.
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 | T000 | MANDT | |
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |
| MTART | Material type | CHAR | 4 | 0 | T134 | MTART | |
| BKLAS | Valuation Class | CHAR | 4 | 0 | T025 | BKLAS | |
| BWMOD | Valuation Grouping Code | CHAR | 4 | 0 | BWMOD | ||
| ROHKZ | Do not write receiver records | CHAR | 1 | 0 | ROHKZ | ||
| PCERL | Account for internal revenues in Profit Center Accounting | CHAR | 10 | 0 | SKA1 | PCERL | |
| PCLVA | Account for deliveries from other profit centers | CHAR | 10 | 0 | SKA1 | PCLVA | |
| PCDBV | Account for change in stock for Profit Center Accounting | CHAR | 10 | 0 | SKA1 | PCDBV | |
| BEZEI | Name of the controlling area | CHAR | 25 | 0 | BEZEI | ||
| PCDBVE | Acct: Change in Stock for Profit Ctr Accountg: Receiver Side | CHAR | 10 | 0 | SKA1 | PCDBVE |
V_T8A00 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 V_T8A00 | BKLAS | T025 | Valuation Classes | MANDT |
| 0 V_T8A00 | BKLAS | T025 | Valuation Classes | BKLAS |
| 1 V_T8A00 | KOKRS | TKA01 | Controlling Areas | MANDT |
| 0 V_T8A00 | MANDT | T000 | Clients | MANDT |
| 1 V_T8A00 | MTART | T134 | Material Types | MANDT |
| 1 V_T8A00 | MTART | T134 | Material Types | MTART |
| 0 V_T8A00 | PCDBV | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 V_T8A00 | PCDBV | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 V_T8A00 | PCDBV | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 V_T8A00 | PCDBVE | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 V_T8A00 | PCDBVE | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 V_T8A00 | PCDBVE | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 V_T8A00 | PCERL | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 V_T8A00 | PCERL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 V_T8A00 | PCERL | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 V_T8A00 | PCLVA | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 V_T8A00 | PCLVA | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 V_T8A00 | PCLVA | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |