SAP CPIDOCITEMOP Table in S/4 HANA - Generated Table for View
CPIDOCITEMOP 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 CPIDOCITEMOP 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: CPIDOCITEMOP
CPIDOCITEMOP table structure field list
Below is the full CPIDOCITEMOP 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) | T000 | MANDT | ||||
FISCALYEAR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
PHYSICALINVENTORYDOCUMENT | Physical Inventory Document | PI_ITEM_DOCUMENT | CHAR | 10(0) | ALPHA | BELNR | IBN | |||
PHYSICALINVENTORYDOCUMENTITEM | Physical Inventory Item Number | PI_ITEM_NUMBER | NUMC | 3(0) | ZEILE | |||||
MATERIAL | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
PLANT | Plant | WERKS_D | CHAR | 4(0) | MARC | WERKS | WRK | H_T001W_C | WERKS | |
STORAGELOCATION | Storage location | LGORT_D | CHAR | 4(0) | MARD | LGORT | LAG | |||
WAREHOUSESTORAGEBIN | Storage Bin | LGPBE | CHAR | 10(0) | CHAR10 | |||||
BATCH | Batch Number | CHARG_D | CHAR | 10(0) | MCHA | CHARG | CHA | |||
INVENTORYSPECIALSTOCKTYPE | Special Stock Type | NSDM_SPCL_STOCK_TYPE | CHAR | 1(0) | T148 | SOBKZ | ||||
GOODSMOVEMENTTYPE | Movement Type for Adjustment | PI_BWART | CHAR | 3(0) | BWART | |||||
PHYSICALINVENTORYSTOCKTYPE | Stock Type (Physical Inventory) | I_BSTAR | CHAR | 1(0) | T064B | BSTAR | ||||
SALESORDER | Sales Order Number | KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
SALESORDERITEM | Sales Order Item | PI_KDPOS | NUMC | 6(0) | NUM06 | |||||
SCHEDULELINE | Delivery Schedule for Sales Order | PI_SALES_ORDER_SCHED_LINE | NUMC | 4(0) | NUM04 | |||||
SUPPLIER | Vendor's account number | ELIFN | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
CUSTOMER | Customer Number | KUNNR | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR |
LASTCHANGEUSER | Changed By | USNAA | CHAR | 12(0) | USNAM | |||||
LASTCHANGEUSERDESCRIPTION | User Description | VDM_USERDESCRIPTION | CHAR | 80(0) | SUIDTECHDESC | |||||
LASTCHANGEDATE | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
COUNTEDBYUSER | Counted By | USNAZ | CHAR | 12(0) | USNAM | |||||
COUNTEDBYUSERDESCRIPTION | User Description | VDM_USERDESCRIPTION | CHAR | 80(0) | SUIDTECHDESC | |||||
PHYSICALINVENTORYLASTCOUNTDATE | Date of Last Count | DZLDAT | DATS | 8(0) | DATUM | |||||
ADJUSTMENTPOSTINGMADEBYUSER | Adjustment Posting Made By | PI_ITEM_ADJUSTMENT_POSTING_USR | CHAR | 12(0) | USNAM | |||||
ADJMTPOSTINGMADEBYUSERDESC | User Description | VDM_USERDESCRIPTION | CHAR | 80(0) | SUIDTECHDESC | |||||
POSTINGDATE | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
PHYSINVENTORYREFERENCENUMBER | Physical Inventory Reference | PI_ITEM_REFERENCE | CHAR | 16(0) | XBLNR1 | |||||
PHYSICALINVENTORYSTATUSTEXT | Physical Inventory Status | PI_ITEM_STATUS | CHAR | 20(0) | TEXT20 | |||||
ISHANDLEDINALTVUNITOFMSR | Without Unit of Measure Proposal | PI_ITEM_IS_HANDLED_IN_ALTV_UOM | CHAR | 1(0) | XFELD | |||||
PHYSICALINVENTORYITEMISZERO | Is Zero Count | PI_ITEM_IS_ZERO_COUNT | CHAR | 1(0) | XFELD | |||||
QUANTITYINUNITOFENTRY | Counted Quantity in Entry Unit | PI_ITEM_QTY_IN_ENTRY_UOM | QUAN | 13(3) | MENG13 | |||||
QUANTITY | Counted Quantity | PI_ITEM_CNTD_QTY | QUAN | 13(3) | MENG13 | |||||
BOOKQTYBFRCOUNTINMATLBASEUNIT | Book Quantity Immediately Prior to Count | BUCHM | QUAN | 13(3) | MENGV13 | |||||
DIFFERENCEQUANTITYINBASEUNIT | Physical Inventory Item Difference Quantity in Base Unit | PI_ITEM_DIFF_QTY_I_BASE_UNIT | QUAN | 14(3) | ||||||
MATERIALBASEUNIT | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
UNITOFENTRY | Entry Unit | PI_ITEM_ENTRY_UOM | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
CURRENCY | Company Code Currency | NSDM_COMP_CODE_CURRENCY | CUKY | 5(0) | TCURC | WAERS | FWS | |||
SLSPRICEAMOUNTINCOCODECRCY | Sales Price Book Value | PI_ITEM_SP_OF_BOOK_QTY | CURR | 13(2) | WERT13N | |||||
PHYSINVTRYCTAMTINCOCODECRCY | Counted Quantity Value | PI_ITEM_COUNTED_QTY_VALUE | CURR | 13(2) | WERT7 | |||||
BOOKQTYAMOUNTINCOCODECRCY | Book Value | PI_ITEM_BOOK_VALUE | CURR | 13(2) | WERT7 | |||||
DIFFERENCEAMOUNTINCOCODECRCY | Value of Difference | PI_ITEM_DIFF_VALUE | CURR | 13(2) | WERT7 | |||||
ENTEREDSLSAMTINCOCODECRCY | Externally Entered Value Based on Sales Price | PI_ITEM_EXT_VALUE_SP | CURR | 13(2) | WERT7 | |||||
DIFFSLSPRCAMTINCOCODECRCY | Value of Difference Based on Sales Price | PI_ITEM_DIFF_SLS_PRC_CO_CRY | CURR | 13(2) | ||||||
ISVALUEONLYMATERIAL | Is Value-Only Material | PI_ITEM_IS_VALUE_ONLY_MAT | CHAR | 1(0) | XFELD | |||||
MATERIALDOCUMENT | Number of Material Document | MBLNR | CHAR | 10(0) | ALPHA | BELNR | MBN | |||
MATERIALDOCUMENTYEAR | Material Document Year | NSDM_MJAHR | NUMC | 4(0) | GJAHR | GJAHR | ||||
MATERIALDOCUMENTITEM | Material Document Item | NSDM_MBLPO | NUMC | 4(0) | MBLPO | |||||
PHYSINVTRYRECOUNTDOCUMENT | Number of Recount Document | NBLNR | CHAR | 10(0) | ALPHA | BELNR | ||||
CYCLECOUNTTYPE | Cycle Count Type | PI_ITEM_CYCLE_COUNT_TYPE | CHAR | 1(0) | T159C | ABCIN | ||||
WBSELEMENTINTERNALID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8(0) | PRPS | ABPSP | PS_POSNR | |||
WBSELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24(0) | ABPSN | PS_POSID | PRO | |||
PRODUCTCATEGORY | Material Category | ATTYP | CHAR | 2(0) | ATTYP | MTY | ||||
REASONFORPHYSINVTRYDIFFERENCE | Difference Reason | PI_ITEM_DIFFERENCE_REASON | NUMC | 4(0) | T157D | MB_GRBEW | ||||
CROSSPLANTCONFIGURABLEMATERIAL | Cross-Plant Configurable Material | PI_ITEM_CROSS_PLANT_CNF_MAT | CHAR | 40(0) | MARA | MATN1 | MATNR | |||
PHYSINVTRYDIFFISDISTRIBUTED | Is Difference Distributed | PI_ITEM_IS_DIFF_DISTRIBUTED | CHAR | 1(0) | XFELD | |||||
PHYSICALINVENTORYNUMBER | Physical Inventory Number | PI_NUMBER | CHAR | 16(0) | XBLNR1 | |||||
PHYSICALINVENTORYITEMISCOUNTED | Item is Counted | PI_IS_ITEM_COUNTED | CHAR | 1(0) | XFELD | |||||
PHYSINVTRYDIFFERENCEISPOSTED | Difference of Item is Posted | PI_IS_ITEM_DIFFERENCE_POSTED | CHAR | 1(0) | XFELD | |||||
PHYSINVTRYDOCHASQTYSNAPSHOT | Book Inventory Freeze | PI_BOOK_INVENTORY_FREEZE | CHAR | 1(0) | XFELD | |||||
SALESPRICEVALUATIONISACTIVE | Is Sales Price Valuation Active | PI_IS_SP_VALUATION_ACTIVE | CHAR | 1(0) | XFELD | |||||
SERIALNUMBERPROFILE | Serial Number Profile | SERAIL | CHAR | 4(0) | T377P | SERAIL |
Search for further information about these or an SAP related objects