CTLGITM_DRAFT - I_CATALOGITEMMNGTP I_CATALOGITEMMNGTP
I_CATALOGITEMMNGTP I_CATALOGITEMMNGTP information is stored in SAP table CTLGITM_DRAFT.
It is part of development package ODATA_MM_PUR_CATALOGITEMS_MNG in software component MM-PUR-SSP. This development package consists of objects that can be grouped under "OData Package for Manage Catalog Items App".
It is part of development package ODATA_MM_PUR_CATALOGITEMS_MNG in software component MM-PUR-SSP. This development package consists of objects that can be grouped under "OData Package for Manage Catalog Items App".
Fields for table CTLGITM_DRAFT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DRAFTUUID | UUID serving as key (parent key, root key) | X | /BOBF/UUID | RAW | 16 | |
| OPNCTLGITEMID | Catalog Item Key | MMPUR_CAT_D_ITM_KEY | INT4 | 4 | ||
| OPNCTLGPRICEID | Price Key | MMPUR_CAT_D_PRC_KEY | INT4 | 4 | ||
| PRICINGSCALETYPE | CHAR | 2 | ||||
| OPNCTLGEXTERNALPRODUCTID | External Product ID | MMPUR_CAT_EXT_PRD_ID | CHAR | 80 | ||
| OPNCTLGWEBSERVICEID | Catalog Web Service ID | MMPUR_CAT_WS_SERV_ID | CHAR | 40 | ||
| OPNCTLGWEBSERVICENAME | catalog Web service name | MMPUR_CAT_WS_SERV_NAME | CHAR | 500 | ||
| PRODUCTCATALOGNAME | Product Catalog Name | MMPUR_CAT_CTLG_NAME | CHAR | 500 | ||
| OPNCTLGINTCATALOGNAME | Internal catalog name | MMPUR_CAT_INT_CTLG_NAME | CHAR | 500 | ||
| OPNCTLGSUPPLIERNAME | Vendor Name | MMPUR_CAT_VENDOR_NAME | CHAR | 500 | ||
| OPNCTLGMATERIALIDBYSUPPLIER | Material ID By Vendor | MMPUR_CAT_VENDOR_MAT | CHAR | 80 | ||
| ITEMTYPE | Item Type | MMPUR_CAT_ITEM_TYPE | CHAR | 2 | ||
| SERVICE | Service | MMPUR_CAT_SERVICE | CHAR | 2 | ||
| NETPRICEQUANTITY | Net Price Quantity | MMPUR_CAT_ITM_QUANTITY | CHAR | 30 | ||
| TAXTOLERANCEPERCENT | Data element for Percentage | MMPUR_CAT_PERCNT | DEC | 3 | ||
| MATERIALGROUP | Material Group | MMPUR_CAT_MATGROUP | CHAR | 40 | ||
| MANUFACTURERNAME | Manufacturer Name | MMPUR_CAT_MANFCT_NAME | CHAR | 510 | ||
| MANUFACTURER | Manufacturer | MMPUR_CAT_MANUFACT_CODE | CHAR | 20 | ||
| MANUFACTURERMATERIAL | Manufacturing Material | MMPUR_CAT_MANFCT_MAT | CHAR | 500 | ||
| LEADTIMEANNCMNTDUEINDAYS | Delivery Time in Days of the Shopping Cart Line | WSI_OCI_LEADTIME | CHAR | 10 | ||
| OPNCTLGPACKINGQTY | Dataelement for quantity of char 15 | MMPUR_CAT_QUANT_15 | CHAR | 30 | ||
| OPNCTLGMINORDERQUANTITY | Dataelement for quantity of char 15 | MMPUR_CAT_QUANT_15 | CHAR | 30 | ||
| MATERIALFIXEDLOTSIZEQUANTITY | Dataelement for quantity of char 15 | MMPUR_CAT_QUANT_15 | CHAR | 30 | ||
| CONTRACTACCOUNT | Contract Account | MMPUR_CAT_CONTRACT | CHAR | 20 | ||
| OPNCTLGCONTRACTITEM | Contract Item | MMPUR_CAT_CONTRACT_ITM | CHAR | 20 | ||
| OPNCTLGEXTERNALQUOTEID | External Quote ID | MMPUR_CAT_EXT_QUOTE_ID | CHAR | 70 | ||
| OPNCTLGEXTQUOTEITEM | External Quote Item | MMPUR_CAT_EXT_ITM_ID | CHAR | 20 | ||
| OPNCTLGEXTSCHEMATYPE | External Schema Type | MMPUR_CAT_EXT_SCHEMA_TYPE | CHAR | 20 | ||
| OPNCTLGEXTERNALCATEGORYID | External Category ID | MMPUR_CAT_CATAEGORY_ID | CHAR | 120 | ||
| OPNCTLGEXTERNALCATEGORY | External Category | MMPUR_CAT_EXT_CATEGORY | CHAR | 80 | ||
| USAGERATING | Rating | MMPUR_CAT_RATNG | DEC | 2 | ||
| PARENTITEM | Parent Item | MMPUR_CAT_PARENT_ITM | CHAR | 80 | ||
| ISMARKEDFORDELETION | Boolean Variable (X = True, - = False, Space = Unknown) | BOOLEAN | CHAR | 2 | ||
| ISOPNCTLGMANAGED | Is Catalog Managed | MMPUR_CAT_IS_CATALOG_MANAGED | CHAR | 2 | ||
| ISOPNCTLGITMFRMMATLMSTR | Is From Material Master | MMPUR_CAT_IS_FRM_PROD_MSTR | CHAR | 2 | ||
| ISOPNCTLGITEM | Is Catalog Item | MMPUR_CAT_IS_CATALOG_ITM | CHAR | 2 | ||
| CHANGEDDATETIME | CHAR | 60 | ||||
| OPNCTLGCHANGEDBY | Changed By | MMPUR_CAT_CHANGD_BY | CHAR | 24 | ||
| OPNCTLGITEMSUSTAINCOMPLIANCE | Item Sustainable Compliance | MMPUR_CAT_SUSTAINABLE_CMPL | CHAR | 4 | ||
| OPNCTLGDIRECTEMISSIONVALUE | Direct Emission Value | MMPUR_CAT_DIRECT_EM_VALUE | DEC | 12 | ||
| OPNCTLGDIRECTEMISSIONUNIT | Direct Emission Unit | MMPUR_CAT_DIRECT_EM_UNIT | CHAR | 6 | ||
| OPNCTLGINDRCTEMISSIONVALUE | Temp Emission Value | MMPUR_CAT_TEMP_VALUE | DEC | 12 | ||
| OPNCTLGINDRCTEMISSIONUNIT | InDirect Emission Unit | MMPUR_CAT_INDIR_EM_UNIT | CHAR | 6 | ||
| OPNCTLGTEMPEMISSIONVALUE | Temp Emission Value | MMPUR_CAT_TEMP_VALUE | DEC | 12 | ||
| OPNCTLGTEMPEMISSIONUNIT | Temp Emission Unit | MMPUR_CAT_TEMP_UNIT | CHAR | 6 | ||
| OPNCTLGRECYCLEVALUE | Recycle Value | MMPUR_CAT_RECYCLE_VALUE | DEC | 12 | ||
| OPNCTLGRECYCLEUNIT | Recycle Unit | MMPUR_CAT_RECYCLE_UNIT | CHAR | 6 | ||
| OPNCTLGWATERCONSUMPTIONVALUE | Water Consumption Value | MMPUR_CAT_WATER_COM_VALUE | DEC | 12 | ||
| OPNCTLGWATERCONSUMPTIONUNIT | Water Consumption Unit | MMPUR_CAT_WATER_COM_UNIT | CHAR | 6 | ||
| OPNCTLGENERGYCONSUMPTIONVALUE | Energy Consumption Value | MMPUR_CONS_VAL | DEC | 12 | ||
| OPNCTLGENERGYCONSUMPTIONUNIT | Energy Consumption Unit | MMPUR_CONS_UNIT | CHAR | 6 | ||
| OPNCTLGWASTEGENERATEDVALUE | Waste Generated Value | MMPUR_WATE_GEN_VAL | DEC | 12 | ||
| OPNCTLGWASTEGENERATEDUNIT | Waste Generated Unit | MMPUR_WST_GEN_UNIT | CHAR | 6 | ||
| LOGICALSYSTEM | Original System | COMT_LOGSYS | CHAR | 20 | ||
| OPNCTLGSYSTEMNAME | Source Logical System | MMPUR_SLD_SYSTEM | CHAR | 120 | ||
| SOURCELOGICALSYSTEM | Business Document Service: ID of Logical System | MMPUR_CAT_LOG_SYS | CHAR | 20 | ||
| PRODUCTTYPE | Product Type | MMPUR_CAT_PRD_TYPE | CHAR | 4 | ||
| OPNCTLGCATEGORYID | Category | MMPUR_CAT_CATEGORY | RAW | 16 | ||
| DECIMALS | No. of decimal places for rounding | ANDEC | INT2 | 2 | ||
| OPNCTLGHASPRODRELATIONEXISTS | Product Relation Exists | MMPUR_CAT_PRD_REL_EXIST | CHAR | 2 | ||
| OPNCTLGHASPRICESCALE | If price scale exist | MMPUR_CAT_PRCSCL_EXIST | CHAR | 2 | ||
| PLANTNAME | Plant | WERKS_D | CHAR | 8 | ||
| COMPANYCODE | Company Code | BUKRS | CHAR | 8 | ||
| BASEUNIT | Base Unit of Measure | MEINS | UNIT | 6 | ||
| PURCHASINGDOCUMENT | Document number for source of supply | MMPUR_SOS_NUMBER | CHAR | 20 | ||
| PURCHASINGDOCUMENTITEM | Item Number of Purchasing Document | EBELP | NUMC | 10 | ||
| NETPRICEAMOUNT | Price of extracted product from back-end system | MMPUR_EXTRACTED_PRICE | CURR | 6 | ||
| PURCHASINGDOCUMENTPRICEUNIT | Price unit | EPEIN | DEC | 3 | ||
| PURCHASINGDOCUMENTORDERQTY | Order Price Unit (Purchasing) | BBPRM | UNIT | 6 | ||
| CURRENCY | Currency Key | WAERS | CUKY | 10 | ||
| PURCHASINGDOCUMENTTYPE | SOS type | MMPUR_HUB_SOS_TYPE | CHAR | 2 | ||
| VALIDITYENDDATE | End of Validity Period | KDATE | DATS | 16 | ||
| VALIDITYSTARTDATE | Start of Validity Period | KDATB | DATS | 16 | ||
| SOURCEOFSUPPLYISFIXED | Boolean Variable (X = True, - = False, Space = Unknown) | BOOLEAN | CHAR | 2 | ||
| SOURCEOFSUPPLYISBLOCKED | Boolean Variable (X = True, - = False, Space = Unknown) | BOOLEAN | CHAR | 2 | ||
| VALIDFROM | Source List Record Valid From | ORDAB | DATS | 16 | ||
| VALIDTO | Source List Record Valid To | ORDBI | DATS | 16 | ||
| PURCHASINGORGANIZATION | Purchasing organization | EKORG | CHAR | 8 | ||
| EXTERNALDOCUMENTREFERENCEID | Catalog Item Key | MMPUR_CAT_D_ITM_KEY | INT4 | 4 | ||
| ISBUSINESSPURPOSECOMPLETED | Business Purpose Completed Flag | CVP_XBLCK | CHAR | 2 | ||
| OPNCTLGITEMPRPSLID | Proposal ID | MMPUR_PROPOSAL_ID | RAW | 16 | ||
| ARCHIVINGSTATUS | Archiving Status Code | MMPUR_ARCHIVING_STATUS_CODE | CHAR | 2 | ||
| PLANNINGMATERIAL | Material | MMPUR_CAT_MATNR | CHAR | 80 | ||
| OPNCTLGSUPPLIERID | Account Number of Supplier | LIFNR | CHAR | 20 | ||
| MATERIAL | Material Number | MATNR | CHAR | 80 | ||
| UNITOFMEASURE | Base Unit of Measure | MEINS | UNIT | 6 | ||
| OPNCTLGCONTENTUNIT | Base Unit of Measure | MEINS | UNIT | 6 | ||
| LANGUAGE | LANG | 2 | ||||
| STATUSCRITICALITY | INT1 | 1 | ||||
| DUEDATECRITICALITY | CHAR | 20 | ||||
| OPNCTLGPRCVALIDITYSTARTDATE | DATS | 16 | ||||
| OPNCTLGPRCVALIDITYENDDATE | DATS | 16 | ||||
| CATALOGITEMDESCRIPTION | CATALOG DESCRIPTION | VDM_CTLG_DESCRIPTION | CHAR | 510 | ||
| PRODUCTDESCRIPTION | Product Description | MMPUR_CAT_DESC_TEXT | CHAR | 510 | ||
| OPNCTLGSEARCHTERM | CHAR | 2666 | ||||
| OPNCTLGSRCHLONGTEXT | Search Long Text | MMPUR_CAT_LONGTEXT | STRG | 8 | ||
| OPNCTLGIMAGEID | Search Image Key | MMPUR_CAT_D_IMAGE_KEY | INT4 | 4 | ||
| OPNCTLGMAINIMAGENAME | Catalog Main Image Name | MMPUR_CAT_IMG_NAM | CHAR | 510 | ||
| OPNCTLGMAINIMAGEURL | Catalog Main Image URL | MMPUR_CAT_URL | STRG | 8 | ||
| OPNCTLGITEMPRICE | Catalog Item Price | MMPUR_CAT_ITM_PRICE_CURR | CURR | 12 | ||
| OPNCTLGITEMCURRENCY | Item Currency | MMPUR_CAT_ITM_CURRENCY | CUKY | 10 | ||
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
| .INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
| DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 |