SAP Table
T163 Item Categories in Purchasing Document
SAP table T163 has 2 primary key fields being MANDT,PSTYP.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T163 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeyPSTYP | Item category in purchasing document | CHAR | 1 | 0 | PSTYP | ||||||||
| MATNO | Indicator: Material number required | CHAR | 1 | 0 | MATNO | ||||||||
| KNTZU | Indicator: Account assignment required | CHAR | 1 | 0 | KNTZU | ||||||||
| BFKNZ | Inventory management indicator for purchasing | CHAR | 1 | 0 | EBFKZ | ||||||||
|
|||||||||||||
| WEPOS | Goods Receipt Indicator | CHAR | 1 | 0 | WEPOS | ||||||||
| WEPOV | Goods receipt indicator binding | CHAR | 1 | 0 | WEPOV | ||||||||
| WEUNB | Goods Receipt, Non-Valuated | CHAR | 1 | 0 | WEUNB | ||||||||
| WEUNV | Good receipt non-valuated (binding) | CHAR | 1 | 0 | WEUNV | ||||||||
| REPOS | Invoice receipt indicator | CHAR | 1 | 0 | REPOS | ||||||||
| REPOV | Invoice receipt indicator binding | CHAR | 1 | 0 | REPOV | ||||||||
| STAFO | Update Group for statistics update | CHAR | 6 | 0 | TMCB | STAFO | |||||||
| J_1BITMTYP | Nota Fiscal Item Type | CHAR | 2 | 0 | J_1BITEMTYPES | J_1BITMTYP | |||||||
| DIFF_INVOICE | Differential Invoicing | CHAR | 2 | 0 | DIFF_INVOICE | ||||||||
|
|||||||||||||
/ Relationships
T163 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T163 | J_1BITMTYP | J_1BITEMTYPES | Nota Fiscal Record Types | MANDT |
| T163 | J_1BITMTYP | J_1BITEMTYPES | Nota Fiscal Record Types | ITMTYP |
| T163 | MANDT | T000 | Clients | MANDT |
| T163 | STAFO | TMCB | Update groups | MANDT |
| T163 | STAFO | TMCB | Update groups | STAFO |