SAP MEV_D_AD_ITEM Table in S/4 HANA - Period-End Valuation: Accruals Document Item
MEV_D_AD_ITEM is a standard SAP Table which is used to store Period-End Valuation: Accruals Document Item data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MEV_D_AD_ITEM table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: MEV_D_AD_ITEM
MEV_D_AD_ITEM table structure field list
Below is the full MEV_D_AD_ITEM 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) | Assigned to domain | MANDT | ||||
| GUID_ITEM | Period-End Valuation: GUID as RAW 16 | MEV_GUID | RAW | 16(0) | MEV_GUID | |||||
| GUID_ROOT | Period-End Valuation: GUID as RAW 16 | MEV_GUID | RAW | 16(0) | MEV_GUID | |||||
| ITEMNR | Period-End Valuation: Document Item | MEV_DOC_ITEM | NUMC | 6(0) | CMM_DOC_ITEM | |||||
| MATNR | Material Number | MATNR | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
| MATKL | Material Group | MATKL | CHAR | 9(0) | Assigned to domain | MATKL | MKL | S_WBWG | MATKL | |
| CHARG | Batch Number | CHARG_D | CHAR | 10(0) | Assigned to domain | CHARG | CHA | |||
| WERKS | Plant | WERKS_D | CHAR | 4(0) | Assigned to domain | WERKS | WRK | H_T001W_C | WERKS | |
| VAL_DATE | Valuation Key Date for Worklist | MEV_VAL_DATE | DATS | 8(0) | DATUM | |||||
| ACCRUAL_AMOUNT | Accrual Amount | MEV_ACCRUAL_AMOUNT | CURR | 15(2) | WERTV8 | |||||
| ANTICIP_AMOUNT | Anticipated Final Invoice Item Amount | MEV_ANTICIPATED_AMOUNT | CURR | 15(2) | WERT8 | |||||
| POSTED_AMOUNT | Amount Posted by GR or Provisional/Differential Invoice | MEV_POSTED_AMOUNT | CURR | 15(2) | WERT8 | |||||
| ACCRUAL_AMOUNT_LC | Accrual Amount in Local Currency | MEV_ACCRUAL_AMOUNT_LC | CURR | 15(2) | WERTV8 | |||||
| ANTICIP_AMOUNT_LC | Anticipated Amount in Local Currency | MEV_ANTICIPATED_AMOUNT_LC | CURR | 15(2) | WERT8 | |||||
| POSTED_AMOUNT_LC | Posted Amount in Local Currency | MEV_POSTED_AMOUNT_LC | CURR | 15(2) | WERT8 | |||||
| ANTICIP_QUANTITY | Anticipated Final Invoice Item Quantity | MEV_ANTICIPATED_QUANTITY | QUAN | 13(3) | MENG13 | |||||
| POSTED_QUANTITY | Quantity Posted by Goods Movement or Prov. / Diff. Invoice | MEV_POSTED_QUANTITY | QUAN | 13(3) | MENG13 | |||||
| ORDER_UOM | Order Unit of Measure | MEV_ORDER_UOM | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
| GUID_TEXT | GUID for SAPScript Text | MEV_TEXT_GUID | CHAR | 32(0) | SYSUUID_C32 | |||||
| CALC_RESULT_STATUS | Calculation Result Status | MEV_AD_ITEM_CALC_RESULT_STATUS | CHAR | 2(0) | MEV_CALC_RESULT_STATUS | |||||
| NOT_EFFECTIVE | Valuation Result/Accrual Doc. Item without Accr. Posting | MEV_ITEM_NOT_EFFECTIVE | CHAR | 1(0) | XFELD | |||||
| OBJ_ITEM_HL | Commodity Management: High Level Number of Object Item | CMM_OBJ_ITEM_HIGH_LEVEL | NUMC | 6(0) | CMM_OBJ_ITEM | |||||
| OBJ_TYPE | Commodity Management: Object Type | CMM_OBJ_TYPE | CHAR | 10(0) | Assigned to domain | OJ_NAME | ||||
| OBJ_ID | Commodity Management: ID of Reference Document | CMM_OBJ_ID | CHAR | 35(0) | CMM_OBJ_ID | |||||
| OBJ_ITEM | Commodity Management: Item Number of Reference Document | CMM_OBJ_ITEM | NUMC | 6(0) | CMM_OBJ_ITEM | |||||
| PRE_OBJ_TYPE | Commodity Management: Object Type | CMM_OBJ_TYPE | CHAR | 10(0) | Assigned to domain | OJ_NAME | ||||
| PRE_OBJ_ID | Commodity Management: ID of Reference Document | CMM_OBJ_ID | CHAR | 35(0) | CMM_OBJ_ID | |||||
| PRE_OBJ_ITEM | Commodity Management: Item Number of Reference Document | CMM_OBJ_ITEM | NUMC | 6(0) | CMM_OBJ_ITEM | |||||
| PRE_OBJ_DOC_TYPE | Commodity Management: Document Type | CMM_OBJ_DOC_TYPE | CHAR | 4(0) | CMM_OBJ_DOC_TYPE | |||||
| PRE_OBJ_DOC_CAT | Commodity Management: Document Category | CMM_OBJ_DOC_CAT | CHAR | 4(0) | CMM_OBJ_DOC_CAT | |||||
| START_OBJ_TYPE | Commodity Management: Object Type | CMM_OBJ_TYPE | CHAR | 10(0) | Assigned to domain | OJ_NAME | ||||
| START_OBJ_ID | Commodity Management: ID of Reference Document | CMM_OBJ_ID | CHAR | 35(0) | CMM_OBJ_ID | |||||
| START_OBJ_ITEM | Commodity Management: Item Number of Reference Document | CMM_OBJ_ITEM | NUMC | 6(0) | CMM_OBJ_ITEM | |||||
| START_OBJ_DOC_TYPE | Commodity Management: Document Type | CMM_OBJ_DOC_TYPE | CHAR | 4(0) | CMM_OBJ_DOC_TYPE | |||||
| START_OBJ_DOC_CAT | Commodity Management: Document Category | CMM_OBJ_DOC_CAT | CHAR | 4(0) | CMM_OBJ_DOC_CAT | |||||
| START_OBJ_EXT_ID | Commodity Management: External ID | CMM_OBJ_EXT_ID | CHAR | 35(0) | CMM_OBJ_EXT_ID | |||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
| CRTSP | UTC Time Stamp When Object Was Added | MEV_CRTSP | DEC | 15(0) | TSTMP | MEV_TSP | ||||
| AENAM | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
| CHTSP | UTC Time Stamp When Object Was Changed | MEV_CHTSP | DEC | 15(0) | TSTMP | MEV_TSP |
Search for further information about these or an SAP related objects