The CTLGITM_DRAFT table in SAP ERP or S/4HANA stores I_CATALOGITEMMNGTP I_CATALOGITEMMNGTP data. There are total 81 fields in CTLGITM_DRAFT table. The I_CATALOGITEMMNGTP I_CATALOGITEMMNGTP 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 CTLGITM_DRAFT table. It is in OData Package for Manage Catalog Items App (ODATA_MM_PUR_CATALOGITEMS_MNG) ABAP package and is part of the Fiori FXU Purchasing MM-FIO-PUR (CA-GTF-FXU-MM-PUR) module.
SAP CTLGITM_DRAFT Table Fields
Following is the list of fields that are available in SAP CTLGITM_DRAFT 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) | |
| OPNCTLGEXTERNALPRODUCTID | External Product ID | MMPUR_CAT_EXT_PRD_ID | CHAR (40) | |
| OPNCTLGWEBSERVICEID | Catalog Web Service ID | MMPUR_CAT_WS_SERV_ID | CHAR (20) | |
| OPNCTLGWEBSERVICENAME | catalog Web service name | MMPUR_CAT_WS_SERV_NAME | CHAR (250) | |
| PRODUCTCATALOGNAME | Product Catalog Name | MMPUR_CAT_CTLG_NAME | CHAR (250) | |
| OPNCTLGINTCATALOGNAME | Internal catalog name | MMPUR_CAT_INT_CTLG_NAME | CHAR (250) | |
| OPNCTLGSUPPLIERNAME | Vendor Name | MMPUR_CAT_VENDOR_NAME | CHAR (250) | |
| OPNCTLGMATERIALIDBYSUPPLIER | Material ID By Vendor | MMPUR_CAT_VENDOR_MAT | CHAR (40) | |
| ITEMTYPE | Item Type | MMPUR_CAT_ITEM_TYPE | CHAR (1) | |
| SERVICE | Service | MMPUR_CAT_SERVICE | CHAR (1) | |
| NETPRICEQUANTITY | Net Price Quantity | MMPUR_CAT_ITM_QUANTITY | CHAR (15) | |
| MATERIALGROUP | Material Group | MMPUR_CAT_MATGROUP | CHAR (20) | |
| MANUFACTURERNAME | Manufacturer Name | MMPUR_CAT_MANFCT_NAME | CHAR (255) | |
| MANUFACTURER | Manufacturer | MMPUR_CAT_MANUFACT_CODE | CHAR (10) | |
| MANUFACTURERMATERIAL | Manufacturing Material | MMPUR_CAT_MANFCT_MAT | CHAR (250) | |
| LEADTIMEANNCMNTDUEINDAYS | Delivery Time in Days of the Shopping Cart Line | WSI_OCI_LEADTIME | CHAR (5) | |
| OPNCTLGPACKINGQTY | Dataelement for quantity of char 15 | MMPUR_CAT_QUANT_15 | CHAR (15) | |
| OPNCTLGMINORDERQUANTITY | Dataelement for quantity of char 15 | MMPUR_CAT_QUANT_15 | CHAR (15) | |
| MATERIALFIXEDLOTSIZEQUANTITY | Dataelement for quantity of char 15 | MMPUR_CAT_QUANT_15 | CHAR (15) | |
| CONTRACTACCOUNT | Contract Account | MMPUR_CAT_CONTRACT | CHAR (10) | |
| OPNCTLGCONTRACTITEM | Contract Item | MMPUR_CAT_CONTRACT_ITM | CHAR (10) | |
| OPNCTLGEXTQUOTEITEM | External Quote Item | MMPUR_CAT_EXT_ITM_ID | CHAR (10) | |
| OPNCTLGEXTSCHEMATYPE | External Schema Type | MMPUR_CAT_EXT_SCHEMA_TYPE | CHAR (10) | |
| OPNCTLGEXTERNALCATEGORYID | External Category ID | MMPUR_CAT_CATAEGORY_ID | CHAR (60) | |
| OPNCTLGEXTERNALCATEGORY | External Category | MMPUR_CAT_EXT_CATEGORY | CHAR (40) | |
| PARENTITEM | Parent Item | MMPUR_CAT_PARENT_ITM | CHAR (40) | |
| ISMARKEDFORDELETION | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| ISOPNCTLGMANAGED | Is Catalog Managed | MMPUR_CAT_IS_CATALOG_MANAGED | CHAR (1) | |
| ISOPNCTLGITMFRMMATLMSTR | Is From Material Master | MMPUR_CAT_IS_FRM_PROD_MSTR | CHAR (1) | |
| ISOPNCTLGITEM | Is Catalog Item | MMPUR_CAT_IS_CATALOG_ITM | CHAR (1) | |
| OPNCTLGCHANGEDBY | Changed By | MMPUR_CAT_CHANGD_BY | CHAR (12) | |
| OPNCTLGITEMSUSTAINCOMPLIANCE | Item Sustainable Compliance | MMPUR_CAT_SUSTAINABLE_CMPL | CHAR (2) | |
| OPNCTLGDIRECTEMISSIONUNIT | Direct Emission Unit | MMPUR_CAT_DIRECT_EM_UNIT | CHAR (3) | |
| OPNCTLGINDRCTEMISSIONUNIT | InDirect Emission Unit | MMPUR_CAT_INDIR_EM_UNIT | CHAR (3) | |
| OPNCTLGTEMPEMISSIONUNIT | Temp Emission Unit | MMPUR_CAT_TEMP_UNIT | CHAR (3) | |
| OPNCTLGRECYCLEUNIT | Recycle Unit | MMPUR_CAT_RECYCLE_UNIT | CHAR (3) | |
| OPNCTLGWATERCONSUMPTIONUNIT | Water Consumption Unit | MMPUR_CAT_WATER_COM_UNIT | CHAR (3) | |
| OPNCTLGENERGYCONSUMPTIONUNIT | Energy Consumption Unit | MMPUR_CONS_UNIT | CHAR (3) | |
| OPNCTLGWASTEGENERATEDUNIT | Waste Generated Unit | MMPUR_WST_GEN_UNIT | CHAR (3) | |
| LOGICALSYSTEM | Original System | COMT_LOGSYS | CHAR (10) | |
| OPNCTLGSYSTEMNAME | Source Logical System | MMPUR_SLD_SYSTEM | CHAR (60) | |
| SOURCELOGICALSYSTEM | Business Document Service: ID of Logical System | MMPUR_CAT_LOG_SYS | CHAR (10) | |
| PRODUCTTYPE | Product Type | MMPUR_CAT_PRD_TYPE | CHAR (2) | |
| OPNCTLGCATEGORYID | Category | MMPUR_CAT_CATEGORY | RAW (16) | |
| DECIMALS | No. of decimal places for rounding | ANDEC | INT2 (5) | |
| OPNCTLGHASPRODRELATIONEXISTS | Product Relation Exists | MMPUR_CAT_PRD_REL_EXIST | CHAR (1) | |
| OPNCTLGHASPRICESCALE | If price scale exist | MMPUR_CAT_PRCSCL_EXIST | CHAR (1) | |
| PLANTNAME | Plant | WERKS_D | CHAR (4) | |
| COMPANYCODE | Company Code | BUKRS | CHAR (4) | |
| BASEUNIT | Base Unit of Measure | MEINS | UNIT (3) | |
| PURCHASINGDOCUMENTITEM | Item Number of Purchasing Document | EBELP | NUMC (5) | |
| NETPRICEAMOUNT | Price of extracted product from back-end system | MMPUR_EXTRACTED_PRICE | CURR (11) | |
| PURCHASINGDOCUMENTPRICEUNIT | Price unit | EPEIN | DEC (5) | |
| PURCHASINGDOCUMENTORDERQTY | Order Price Unit (Purchasing) | BBPRM | UNIT (3) | |
| CURRENCY | Currency Key | WAERS | CUKY (5) | |
| VALIDITYENDDATE | End of Validity Period | KDATE | DATS (8) | |
| VALIDITYSTARTDATE | Start of Validity Period | KDATB | DATS (8) | |
| SOURCEOFSUPPLYISFIXED | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| SOURCEOFSUPPLYISBLOCKED | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| VALIDFROM | Source List Record Valid From | ORDAB | DATS (8) | |
| VALIDTO | Source List Record Valid To | ORDBI | DATS (8) | |
| PURCHASINGORGANIZATION | Purchasing organization | EKORG | CHAR (4) | |
| ISBUSINESSPURPOSECOMPLETED | Business Purpose Completed Flag | CVP_XBLCK | CHAR (1) | |
| OPNCTLGITEMPRPSLID | Proposal ID | MMPUR_PROPOSAL_ID | RAW (16) | |
| ARCHIVINGSTATUS | Archiving Status Code | MMPUR_ARCHIVING_STATUS_CODE | CHAR (1) | |
| PLANNINGMATERIAL | Material | MMPUR_CAT_MATNR | CHAR (40) | |
| OPNCTLGSUPPLIERID | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| MATERIAL | Material Number | MATNR | CHAR (40) | |
| UNITOFMEASURE | Base Unit of Measure | MEINS | UNIT (3) | |
| OPNCTLGCONTENTUNIT | Base Unit of Measure | MEINS | UNIT (3) | |
| CATALOGITEMDESCRIPTION | CATALOG DESCRIPTION | VDM_CTLG_DESCRIPTION | CHAR (255) | |
| PRODUCTDESCRIPTION | Product Description | MMPUR_CAT_DESC_TEXT | CHAR (255) | |
| OPNCTLGMAINIMAGENAME | Catalog Main Image Name | MMPUR_CAT_IMG_NAM | CHAR (255) | |
| OPNCTLGITEMCURRENCY | Item Currency | MMPUR_CAT_ITM_CURRENCY | CUKY (5) | |
| 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) |
