SAP table OICQC (Quotation Check Table)
SAP table OICQC has 4 primary key fields being MANDT,QUOSRC,QUOTYP,QUOTNO.
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 | |||||||||
| QUOSRC | Quotation source | CHAR | 2 | 0 | OICQS | OIC_SOURCE | |||||||||
| QUOTYP | Quotation type | CHAR | 5 | 0 | OICQT | OIC_QUOTYP | |||||||||
| QUOTNO | Quotation number | CHAR | 18 | 0 | OIC_QUOTA | ||||||||||
| DEFCURR | Default currency for price quotations | CUKY | 5 | 0 | TCURC | OIC_DEFCUR | |||||||||
| DEFPRUN | Default condition pricing unit for quotations | DEC | 5 | 0 | OIC_DEFPER | ||||||||||
| DEFUOM | Default unit of measure for price quotation | UNIT | 3 | 0 | T006 | OIC_DEFUOM | |||||||||
| FACTCAL | Factory calendar for quotation | CHAR | 2 | 0 | TFACD | OIC_FACTCA | |||||||||
| OIGRNET | Gross/net pricing indicator | CHAR | 1 | 0 | OIC_GRNET |
|
OICQC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 OICQC | DEFCURR | TCURC | Currency Codes | MANDT |
| 0 OICQC | DEFCURR | TCURC | Currency Codes | WAERS |
| 1 OICQC | DEFUOM | T006 | Units of Measurement | MANDT |
| 0 OICQC | MANDT | T000 | Clients | MANDT |
| 1 OICQC | QUOSRC | OICQS | Quotation Source | MANDT |
| 1 OICQC | QUOSRC | OICQS | Quotation Source | QUOSRC |
| 0 OICQC | QUOTYP | OICQT | Quotation Type | MANDT |