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 |