SAP table QDBM (Valuation mode)
SAP table QDBM has 2 primary key fields being MANDT,BEWERTMOD.
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 | |
| BEWERTMOD | Valuation Mode | CHAR | 3 | 0 | QBEWMOD | ||
| KZATTRFE | Attributive Inspection by Nonconforming Units | CHAR | 1 | 0 | QKZATTRFE | ||
| KZATTRFZ | Attributive Inspection by Number of Defects | CHAR | 1 | 0 | QKZATTRFZ | ||
| KZVARS | Variable Inspection by S-Method | CHAR | 1 | 0 | QKZVARS | ||
| KZVARSIGM | Variable Inspection by Sigma Method | CHAR | 1 | 0 | QKZVARSIGM | ||
| KZCOD | Valuation by Code | CHAR | 1 | 0 | QKZCOD | ||
| KZMAN | Manual Valuation | CHAR | 1 | 0 | QKZMAN | ||
| KZQRK | Acceptance Using Control Chart | CHAR | 1 | 0 | QKZQRK | ||
| KZAUS | Acceptance Based on Share of Scrap | CHAR | 1 | 0 | QKZAUS | ||
| KZCNULL | Acceptance Number C is Equal to Zero | CHAR | 1 | 0 | QKZCNULL | ||
| KZNVWBM | Valuation Mode Cannot Be Used | CHAR | 1 | 0 | QKZNVWBM | ||
| FBKEY | Identification for the Valuation Rule | CHAR | 2 | 0 | QDFM | QFMKEY | |
| KZKNULL | Check Against Specification Limits (k = 0) | CHAR | 1 | 0 | QKZKNULL | ||
| KZOHNEBEWP | Without Valuation Parameters | CHAR | 1 | 0 | QKZOHNBEWP | ||
| ERSTELLER | Name of User Who Created the Data Record | CHAR | 12 | 0 | QERSTELLER | ||
| AENDERER | Name of User Who Last Changed Data Record | CHAR | 12 | 0 | QAENDERER | ||
| ERSTELLDAT | System Date on Which Data Record Was Created | DATS | 8 | 0 | QDATUMERST | ||
| AENDERDAT | System Date on Which Data Record Was Changed | DATS | 8 | 0 | QDATUMAEND |
QDBM foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QDBM | FBKEY | QDFM | Function modules for valuation mode | MANDT |
| 0 QDBM | FBKEY | QDFM | Function modules for valuation mode | FBKEY |