SAP table QVDM (QM Info Record - QM Control in SD)
SAP table QVDM has 5 primary key fields being MANDT,KUNNR,VKORG,MATNR,REVLV.
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 | |
| KUNNR | Customer Number | CHAR | 10 | 0 | KNA1 | KUNNR | |
| VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| REVLV | Revision Level | CHAR | 2 | 0 | QREVLV | ||
| ERSTELLER | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| ERSTELLDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| AENDERER | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| AENDERDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| LTEXTKZ | Inspection Characteristic Long Text Exists | CHAR | 1 | 0 | QLTEXTKZ | ||
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| INSPBYDEBI | Inspection Carried Out By Customer (No Inspection Lot) | CHAR | 1 | 0 | QINSPBYDEB | ||
| INSPATDEBI | Inspection for a Delivery Note After Outbound Delivery | CHAR | 1 | 0 | QINSPATDEB | ||
| ABRVW | Delivery Category | CHAR | 3 | 0 | TVLV | QABRVW | |
| INFO10 | Text Line for Additional Information | CHAR | 10 | 0 | QTXT10 | ||
| INFO20 | Text Line for Additional Information | CHAR | 20 | 0 | QTXT20 | ||
| INFO40 | Text Line for Additional Information | CHAR | 40 | 0 | QTXT40 | ||
| LOEKZ | Deletion Flag | CHAR | 1 | 0 | QLOEKZ |
QVDM foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QVDM | ABRVW | TVLV | Check table for release orders: Usage ID | ABRVW |
| 1 QVDM | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 1 QVDM | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 0 QVDM | MATNR | MARA | General Material Data | MANDT |
| 0 QVDM | MATNR | MARA | General Material Data | MATNR |
| 1 QVDM | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
| 0 QVDM | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| 0 QVDM | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |