SAP CDOCMSGDET Table in S/4 HANA - Generated Table for View
CDOCMSGDET is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP CDOCMSGDET table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: CDOCMSGDET
CDOCMSGDET table structure field list
Below is the full CDOCMSGDET field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
APPLICATIONLOG | GUID in 'RAW' format | GUID_16 | RAW | 16(0) | MMPUR_MASSAPLJOB | SYSUUID | ||||
SYSTEMMESSAGENUMBER | Message Number | SYMSGNO | NUMC | 3(0) | SYMSGNO | |||||
SYSTEMMESSAGEIDENTIFICATION | Message Class | SYMSGID | CHAR | 20(0) | ARBGB | |||||
SYSTEMMESSAGETYPE | Message Type | SYMSGTY | CHAR | 1(0) | SYCHAR01 | |||||
SYSTEMMESSAGEVARIABLE1 | Message Variable | SYMSGV | CHAR | 50(0) | SYCHAR50 | |||||
SYSTEMMESSAGEVARIABLE2 | Message Variable | SYMSGV | CHAR | 50(0) | SYCHAR50 | |||||
SYSTEMMESSAGEVARIABLE3 | Message Variable | SYMSGV | CHAR | 50(0) | SYCHAR50 | |||||
SYSTEMMESSAGEVARIABLE4 | Message Variable | SYMSGV | CHAR | 50(0) | SYCHAR50 | |||||
FORMATTEDPURCHASINGDOCITEM | Purchasing Document Items | VDM_FORMATTED_PROCMTDOC | CHAR | 16(0) | TEXT16 | |||||
PURCHASINGDOCUMENT | Purchasing Document Number | EBELN | CHAR | 10(0) | ALPHA | EBELN | BES | MEKK_C | EBELN | |
PURCHASINGDOCUMENTITEM | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EBELP | BSP | ||||
SUPPLIER | Supplier | MD_SUPPLIER | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | |||
SUPPLIERNAME | Name of Supplier | MD_SUPPLIER_NAME | CHAR | 80(0) | TEXT80 | |||||
PURCHASINGORGANIZATION | Purchasing organization | EKORG | CHAR | 4(0) | T024E | EKORG | EKO | |||
PURCHASINGORGANIZATIONNAME | Purchasing Organization Name | MM_A_PURG_ORG_NAME | CHAR | 20(0) | TEXT20 | |||||
PURCHASEORDERTYPE | Purchasing Document Type | ESART | CHAR | 4(0) | BSART | BSA | ||||
PURCHASINGDOCUMENTTYPENAME | Short Description of Purchasing Document Type | BATXT | CHAR | 20(0) | TEXT20 | |||||
PURCHASEORDERDATE | Purchase Order Date | BEDAT | DATS | 8(0) | DATUM | |||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
COMPANYCODENAME | Name of Company Code or Company | BUTXT | CHAR | 25(0) | TEXT25 | |||||
PLANT | Plant | EWERK | CHAR | 4(0) | T001W | WERKS | WRK | |||
PLANTNAME | Plant Name | WERKS_NAME | CHAR | 30(0) | TEXT30 | |||||
MATERIAL | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
MATERIALNAME | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
PAYMENTTERMS | Terms of Payment Key | FARP_DZTERM | CHAR | 4(0) | ZTERM | |||||
PAYMENTTERMSNAME | Description of terms of payment | DZTERM_BEZ | CHAR | 30(0) | TEXT30 | |||||
CASHDISCOUNT1DAYS | Cash discount days 1 | DZBD1T | DEC | 3(0) | ZBDXT | |||||
CASHDISCOUNT2DAYS | Cash discount days 2 | DZBD2T | DEC | 3(0) | ZBDXT | |||||
NETPAYMENTDAYS | Net Payment Terms Period | DZBD3T | DEC | 3(0) | ZBDXT | |||||
CASHDISCOUNT1PERCENT | Cash discount percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | |||||
CASHDISCOUNT2PERCENT | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | |||||
PURCHASINGGROUP | Purchasing Group | BKGRP | CHAR | 3(0) | T024 | EKGRP | EKG | |||
PURCHASINGGROUPNAME | Purchasing Group Name | MM_A_PURG_GRP_NAME | CHAR | 18(0) | TEXT18 | |||||
DOCUMENTCURRENCY | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
VALIDITYSTARTDATE | Start of Validity Period | KDATB | DATS | 8(0) | DATUM | |||||
VALIDITYENDDATE | End of Validity Period | KDATE | DATS | 8(0) | DATUM | |||||
SUPPLIERRESPSALESPERSONNAME | Responsible Salesperson at Supplier's Office | EVERK | CHAR | 30(0) | TEXT30 | |||||
SUPPLIERPHONENUMBER | Supplier's Telephone Number | TELF0 | CHAR | 16(0) | TEXT16 | |||||
SUPPLYINGSUPPLIER | Goods Supplier | LLIEF | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LLI | ||
SUPPLIERFULLNAME | Supplier Full Name | MD_SUPPLIER_FULL_NAME | CHAR | 220(0) | TEXT220 | |||||
INCOTERMSCLASSIFICATION | Incoterms (Part 1) | INCO1 | CHAR | 3(0) | TINC | INCO1 | ||||
INCOTERMSCLASSIFICATIONNAME | Description | BEZEI30 | CHAR | 30(0) | TEXT30 | |||||
INVOICINGPARTY | Different Invoicing Party | LIFRE | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LRE | ||
INVOICINGPARTYNAME | Supplier Full Name | MD_SUPPLIER_FULL_NAME | CHAR | 220(0) | TEXT220 | |||||
EXCHANGERATE | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | ||||
INCOTERMSVERSION | Incoterms Version | INCOV | CHAR | 4(0) | TINCV | INCOV | ||||
INCOTERMSVERSIONNAME | Description | BEZEI30 | CHAR | 30(0) | TEXT30 | |||||
HEADERINCOTERMSLOC1 | Incoterms Location 1 | INCO2_L | CHAR | 70(0) | INCO_L | |||||
HEADERINCOTERMSLOC2 | Incoterms Location 2 | INCO3_L | CHAR | 70(0) | INCO_L | |||||
STORAGELOCATION | Storage Location | VDM_STORAGE_LOCATION | CHAR | 4(0) | T001L | LGORT | LAG | |||
STORAGELOCATIONNAME | Storage Location Name | LGORT_NAME | CHAR | 16(0) | TEXT16 | |||||
MATERIALGROUP | Material Group | MATKL | CHAR | 9(0) | T023 | MATKL | MKL | S_WBWG | MATKL | |
MATERIALGROUPNAME | Product Group Description | PRODUCTGROUPDESCRIPTION | CHAR | 20(0) | TEXT20 | |||||
PURCHASINGINFORECORD | Number of purchasing info record | INFNR | CHAR | 10(0) | EINA | ALPHA | INFNR | INF | MEIN_C | INFNR |
SUPPLIERMATERIALNUMBER | Material Number Used by Supplier | IDNLF | CHAR | 35(0) | IDNEX | |||||
ORDERPRICEUNITTOORDERUNITNMRTR | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5(0) | UMBSZ | |||||
ORDPRICEUNITTOORDERUNITDNMNTR | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5(0) | UMBSN | |||||
ORDERITEMQTYTOBASEQTYNMRTR | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5(0) | UMBSZ | |||||
ORDERITEMQTYTOBASEQTYDNMNTR | Denominator for Conversion of Order Unit to Base Unit | UMBSN | DEC | 5(0) | UMBSN | |||||
NETPRICEQUANTITY | Price Unit | VDM_PRICE_UNIT | DEC | 5(0) | DEC5 | |||||
NETAMOUNT | Net Order Value in PO Currency | BWERT | CURR | 13(2) | WERT7 | |||||
TAXCODE | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | T007A | MWSKZ | ||||
PRICEISTOBEPRINTED | Price Printout | PRSDR | CHAR | 1(0) | XFELD | |||||
OVERDELIVTOLRTDLMTRATIOINPCT | Overdelivery Tolerance | UEBTO | DEC | 3(1) | PRZ21 | |||||
UNLIMITEDOVERDELIVERYISALLOWED | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1(0) | XFELD | |||||
UNDERDELIVTOLRTDLMTRATIOINPCT | Underdelivery Tolerance | UNTTO | DEC | 3(1) | PRZ21 | |||||
VALUATIONTYPE | Valuation Type | BWTAR_D | CHAR | 10(0) | T149D | BWTAR | BWT | |||
ISCOMPLETELYDELIVERED | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1(0) | XFELD | |||||
ISFINALLYINVOICED | Final Invoice Indicator | EREKZ | CHAR | 1(0) | XFELD | |||||
PURCHASEORDERITEMCATEGORY | Item Category in Purchasing Document | EPSTP | CHAR | 1(0) | EPSTP | |||||
PURGDOCITEMCATEGORYNAME | Text for Item Category | PTEXT_D | CHAR | 20(0) | TEXT20 | |||||
ACCOUNTASSIGNMENTCATEGORY | Account Assignment Category | KNTTP | CHAR | 1(0) | T163K | KNTTP | KNT | |||
GOODSRECEIPTISEXPECTED | Goods Receipt Indicator | WEPOS | CHAR | 1(0) | XFELD | |||||
GOODSRECEIPTISNONVALUATED | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1(0) | XFELD | |||||
INVOICEISEXPECTED | Invoice receipt indicator | REPOS | CHAR | 1(0) | XFELD | |||||
INVOICEISGOODSRECEIPTBASED | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1(0) | XFELD | |||||
BASEUNIT | Base Unit of Measure | LAGME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
EFFECTIVEAMOUNT | Effective value of item | EFFWR | CURR | 13(2) | WERT7 | |||||
ITEMNETWEIGHT | Net Weight | ENTGE | QUAN | 13(3) | MENG13 | |||||
ITEMWEIGHTUNIT | Unit of Weight | EGEWE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
TAXJURISDICTION | Tax Jurisdiction | TXJCD | CHAR | 15(0) | TTXJ | TXJCD | TXJ | |||
INTERNATIONALARTICLENUMBER | International Article Number (EAN/UPC) | EAN11 | CHAR | 18(0) | EAN11 | EAN11 | EAN | |||
SUPPLIERCONFIRMATIONCONTROLKEY | Confirmation Control Key | BSTAE | CHAR | 4(0) | T163L | BSTAE | ||||
SUPPLIERCONFCONTROLKEYNAME | Confirmation Category: Description | BSBEZ | CHAR | 20(0) | TEXT20 | |||||
PRICINGDATECONTROL | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1(0) | MEPRF | |||||
ITEMVOLUME | Volume | VOLUM | QUAN | 13(3) | MENG13 | |||||
ITEMVOLUMEUNIT | Volume unit | VOLEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ITEMINCOTERMSCLASSIFICATION | Incoterms (Part 1) | INCO1 | CHAR | 3(0) | TINC | INCO1 | ||||
SUPPLIERSUBRANGE | Supplier Subrange | LTSNR | CHAR | 6(0) | LTSNR | |||||
SERVICEPACKAGE | Package number | PACKNO | NUMC | 10(0) | ESLH | PACKNO | ||||
EVALDRCPTSETTLMTISALLOWED | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1(0) | XFELD | |||||
ISRETURNSITEM | Returns Item | RETPO | CHAR | 1(0) | XFELD | |||||
EARMARKEDFUNDSDOCUMENT | Document Number for Earmarked Funds | KBLNR | CHAR | 10(0) | ALPHA | KBLNR | KBL | |||
EARMARKEDFUNDSDOCUMENTITEM | Earmarked Funds: Document Item | KBLPOS | NUMC | 3(0) | KBLPOS | KBP | ||||
INCOTERMSLOCATION1 | Incoterms Location 1 | INCO2_L | CHAR | 70(0) | INCO_L | |||||
INCOTERMSLOCATION2 | Incoterms Location 2 | INCO3_L | CHAR | 70(0) | INCO_L | |||||
SERVICEPERFORMER | Service Performer | SERVICEPERFORMER | CHAR | 10(0) | ALPHA | BU_PARTNER | ||||
PRODUCTTYPE | Product Type Group | PRODUCT_TYPE | CHAR | 2(0) | CHAR2 | |||||
PRODUCTTYPENAME | Product Type Group Description | PRODUCT_TYPE_DESCRIPTION | CHAR | 40(0) | TEXT40 | |||||
ORDERPRICEUNIT | Order Price Unit (Purchasing) | BBPRM | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
PURCHASINGDOCUMENTSTATUS | CHAR | 2(0) | ||||||||
PURCHASINGDOCUMENTSTATUSNAME | Short Text for Fixed Values | VAL_TEXT | CHAR | 60(0) | DDTEXT | |||||
PURCHASEORDERITEMTEXT | Short Text | TXZ01 | CHAR | 40(0) | TEXT40 |
Search for further information about these or an SAP related objects