The CNTRLRFQDIST_D table in SAP ERP or S/4HANA stores I_CENTRALREQUESTFORQUOTATIONTPI_CENTRALRFQITEMDISTRIBUTIONTP data. There are total 31 fields in CNTRLRFQDIST_D table. The I_CENTRALREQUESTFORQUOTATIONTPI_CENTRALRFQITEMDISTRIBUTIONTP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CNTRLRFQDIST_D table. It is in S/4 HANA Procure:Central RFQ Sofware Dev without Translation (APPL_MM_PUR_CRFQ_SD) ABAP package and is part of the Central RFQ/Central Quotations (MM-PUR-HUB-RFQ) module.
SAP CNTRLRFQDIST_D Table Fields
Following is the list of fields that are available in SAP CNTRLRFQDIST_D table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| ROOTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| CENTRALREQUESTFORQUOTATION | Purchasing Document Number | EBELN | CHAR (10) | |
| CENTRALREQUESTFORQUOTATIONITEM | Item Number of Purchasing Document | EBELP | NUMC (5) | |
| PURCHASINGDOCUMENTCATEGORY | Purchasing Document Category | BSTYP | CHAR (1) | |
| PURCHASINGDOCUMENTTYPE | Purchasing Document Type | ESART | CHAR (4) | |
| PURCHASINGORGANIZATION | Purchasing organization | EKORG | CHAR (4) | |
| COMPANYCODE | Company Code | BUKRS | CHAR (4) | |
| PLANT | Plant | EWERK | CHAR (4) | |
| LOGICALSYSTEM | Logical System | LOGSYSTEM | CHAR (10) | |
| DOCUMENTCURRENCY | Currency Key | WAERS | CUKY (5) | |
| CURRENCY | Currency Key | WAERS | CUKY (5) | |
| PURCHASINGGROUP | Purchasing Group | BKGRP | CHAR (3) | |
| STORAGELOCATION | Storage location | LGORT_D | CHAR (4) | |
| ISDELETED | Link field for view query | BOOL | CHAR (3) | |
| ORDERQUANTITYUNIT | Purchase Order Unit of Measure | BSTME | UNIT (3) | |
| DISTRIBUTIONTYPE | Distribution Type for Central Purchase Contract Item | MM_PUR_CCTR_ITM_DIST_TYPE | CHAR (2) | |
| DISTRRESPONSEMESSAGEUUID | Generic Data Element for GUID Fields (X16) | GUID16 | RAW (16) | |
| ITEMDISTRIBUTIONISRELEVANT | Link field for view query | BOOL | CHAR (3) | |
| PROCUREMENTHUBSOURCESYSTEM | Logical System | LOGSYSTEM | CHAR (10) | |
| PROCMTHUBPURCHASEREQUISITION | Purchase Requisition Number | BANFN | CHAR (10) | |
| PROCMTHUBPURREQUISITIONITEM | Item number of purchase requisition | BNFPO | NUMC (5) | |
| TARGETQUANTITY | Target Quantity | KTMNG | QUAN (13) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
