SAP table V_T003 (Generated Table for View)
SAP table V_T003 has 2 primary key fields being MANDT,BLART.
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 | |
| BLART | Document Type | CHAR | 2 | 0 | BLART | ||
| NUMKR | Number Range | CHAR | 2 | 0 | NUMKR | ||
| KOARS | Account Types Allowed | CHAR | 5 | 0 | KOARS_003 | ||
| STBLA | Document Type | CHAR | 2 | 0 | T003 | STBLA_003 | |
| XNETB | Indicator: Document posted net ? | CHAR | 1 | 0 | XNETB | ||
| XRVUP | Indicator: Posting from SAP Billing Document? | CHAR | 1 | 0 | XRVUP | ||
| XSYBL | Indicator: Document Type Can Only Be Used in Batch Input | CHAR | 1 | 0 | XSYBL | ||
| XVORK | Indicator: Document Type for Initial Account Assignment? | CHAR | 1 | 0 | XVORK | ||
| XKKPR | Indicator: Only One Customer/Vendor Allowed | CHAR | 1 | 0 | XKKPR | ||
| XGSUB | Inter-Company Posting | CHAR | 1 | 0 | XGSUB | ||
| XMGES | Indicator: Trading Partner Can Be Entered Manually | CHAR | 1 | 0 | XMGES | ||
| BRGRU | Authorization Group | CHAR | 4 | 0 | BRGRU | ||
| RECID | Debit Recovery Indicator | CHAR | 2 | 0 | T8JW | JV_RECINDD | |
| RECIC | Recovery Indicator Credit | CHAR | 2 | 0 | T8JW | JV_RECINDC | |
| XMTXT | Indicator: Document Header Text | CHAR | 1 | 0 | XMTXT | ||
| XMREF | Indicator: Reference Number | CHAR | 1 | 0 | XMREF | ||
| XNGBK | Indicator: Document Type for Posting Subsequent Adjustment | CHAR | 1 | 0 | XNGBK | ||
| KURST | Exchange Rate Type for Determining the Proposed Rate | CHAR | 4 | 0 | TCURV | KURST_003 | |
| XNEGP | Indicator: Negative Postings Permitted | CHAR | 1 | 0 | XNEGP_BLA | ||
| XKOAA | Indicator: Are Postings to Assets Permitted? | CHAR | 1 | 0 | XKOAA | ||
| XKOAD | Indicator: Are Postings to Customer Permitted? | CHAR | 1 | 0 | XKOAD | ||
| XKOAK | Indicator: Are Postings to Vendor Permitted? | CHAR | 1 | 0 | XKOAK | ||
| XKOAM | Indicator: Are Postings to Material Account Permitted? | CHAR | 1 | 0 | XKOAM | ||
| XKOAS | Indicator: Are Postings to G/L Account Permitted? | CHAR | 1 | 0 | XKOAS | ||
| XKOASECC | Indicator: Are postings to secondary costs permitted? | CHAR | 1 | 0 | XKOASECC | ||
| LTEXT | Document Type Description | CHAR | 20 | 0 | LTEXT_003T | ||
| XROLLUP | Indicator: Document Type Allowed for Rollup | CHAR | 1 | 0 | G_DOCTY_ROLLUP | ||
| XPLAN | Indicator: Document Type Allowed for Planning | CHAR | 1 | 0 | G_DOCTY_PLAN | ||
| XALLOCACT | Indicator: Document Type Allowed for Actual Allocation | CHAR | 1 | 0 | G_DOCTY_ALLOC_ACT | ||
| XALLOCPLAN | Indicator: Document Type Allowed for Plan Allocation | CHAR | 1 | 0 | G_DOCTY_ALLOC_PLAN |
V_T003 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 V_T003 | KURST | TCURV | Exchange rate types for currency translation | MANDT |
| 0 V_T003 | KURST | TCURV | Exchange rate types for currency translation | KURST |
| 1 V_T003 | MANDT | T000 | Clients | MANDT |
| 0 V_T003 | RECIC | T8JW | Internal Recovery Indicator | MANDT |
| 1 V_T003 | RECID | T8JW | Internal Recovery Indicator | MANDT |
| 0 V_T003 | STBLA | T003 | Document Types | MANDT |