SAP CSTKKPITSCOMPRNQ Table in S/4 HANA - Generated Table for View
CSTKKPITSCOMPRNQ 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 CSTKKPITSCOMPRNQ 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: CSTKKPITSCOMPRNQ
CSTKKPITSCOMPRNQ table structure field list
Below is the full CSTKKPITSCOMPRNQ 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 | |||||
COMPRNPERIODSEQUENCENUMBER | Time Series Period Sequence Number | NSDM_TS_PERIOD_SEQUENCE | DEC | 12(0) | DEC12 | |||||
MATERIAL | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
PLANT | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
STORAGELOCATION | Storage location | LGORT_D | CHAR | 4(0) | LGORT | LAG | ||||
STOCKIDENTIFYINGBATCH | Batch Number (Stock Identifier) | NSDM_CHARG | CHAR | 10(0) | CHARG | CHA | ||||
SPECIALSTOCKIDFGSUPPLIER | Supplier for Special Stock | NSDM_LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
SPECIALSTOCKIDFGSALESORDER | Sales order number of valuated sales order stock | MAT_KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
SPECIALSTOCKIDFGSALESORDERITEM | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
SPECIALSTOCKIDFGWBSELEMENT | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 8(0) | ABPSP | PS_POSNR | ||||
SPECIALSTOCKIDFGCUSTOMER | Customer for Special Stock | NSDM_KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
INVENTORYSPECIALSTOCKTYPE | Special Stock Type | NSDM_SPCL_STOCK_TYPE | CHAR | 1(0) | SOBKZ | |||||
INVENTORYSTOCKTYPE | Stock Type of Goods Movement (Stock Identifier) | NSDM_LBBSA | CHAR | 2(0) | NSDM_LBBSA | |||||
MATERIALBASEUNIT | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
CURRENCY | Company Code Currency | NSDM_COMP_CODE_CURRENCY | CUKY | 5(0) | WAERS | FWS | ||||
STKQTYDELTAINPERCENT | Stock Quantity Difference in Percent | NSDM_STK_QTY_DELTA_PERCENT | DEC | 31(14) | ||||||
CNSMPNQTYDELTAINPERCENT | Consumption Quantity Difference in Percent | NSDM_CONS_QTY_DELTA_PERCENT | DEC | 31(14) | ||||||
INVTRYTURNOVERDELTAINPERCENT | Inventory Turnover Difference in Percent | NSDM_TURNOVER_DELTA_PERCENT | DEC | 31(14) | ||||||
INVTRYAGINGDELTAINPERCENT | Inventory Aging Difference in Percent | NSDM_INV_AGING_DELTA_PERCENT | DEC | 31(14) | ||||||
RANGEOFCVRGDELTAINPERCENT | Range of Coverage Difference in Percent | NSDM_ROC_DELTA_PERCENT | DEC | 31(14) | ||||||
WBSELEMENTEXTERNALID | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | CHAR | 24(0) | PS_POSID_EDIT | |||||
DISPLAYCURRENCY | Display Currency | NSDM_DISPLAY_CURRENCY | CUKY | 5(0) | CURRENCY | |||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
YEARQUARTEROFPREVIOUSPERIOD | Year-Quarter-Combination (Previous Period) | NSDM_YEARQUARTER_PREV | NUMC | 5(0) | ||||||
YEARMONTHOFPREVIOUSPERIOD | Year-Month-Combination (Previous Period) | NSDM_YEARMONTH_PREV | NUMC | 6(0) | ||||||
YEARQUARTEROFREFERENCEPERIOD | Year-Quarter-Combination (Reference Period) | NSDM_YEARQUARTER_REF | NUMC | 5(0) | ||||||
YEARMONTHOFREFERENCEPERIOD | Year-Month-Combination (Reference Period) | NSDM_YEARMONTH_REF | NUMC | 6(0) | ||||||
DAYOFREFERENCEMONTH | Day of the Month (Reference Period) | NSDM_DAYOFMONTH_REF | DATS | 8(0) | ||||||
DAYOFPREVIOUSMONTH | Day of the Month (Previous Period) | NSDM_DAYOFMONTH_PREV | DATS | 8(0) | ||||||
MATLWRHSSTKQTYONPREVDATE | Stock Quantity in Base UoM (Previous Period) | NSDM_STK_QTY_PREV | QUAN | 17(3) | MENGV9 | |||||
MATLWRHSSTKQTYONREFDATE | Stock Quantity in Base UoM (Reference Period) | NSDM_STK_QTY_REF | QUAN | 17(3) | MENGV9 | |||||
STKVALUEINCCCRCYONPREVDATE | Stock Value in Company Code Currency (Previous Period) | NSDM_STK_VAL_CCCRCY_PREV | CURR | 17(2) | ||||||
STKVALUEINCCCRCYONREFDATE | Stock Value in Company Code Currency (Reference Period) | NSDM_STK_VAL_CCCRCY_REF | CURR | 17(2) | ||||||
STKVALUEINDSPCRCYONPREVDATE | Stock Value in Display Currency (Previous Period) | NSDM_STK_VAL_DCRCY_PREV | CURR | 17(2) | ||||||
STKVALUEINDSPCRCYONREFDATE | Stock Value in Display Currency (Reference Period) | NSDM_STK_VAL_DCRCY_REF | CURR | 17(2) | ||||||
CNSMPNVALUEINCCCRCYONPREVDATE | Consumption Value in Company Code Currency (Previous Period) | NSDM_CONS_VAL_CCCRCY_PREV | CURR | 17(2) | ||||||
CNSMPNVALUEINCCCRCYONREFDATE | Consumption Value in Company Code Currency (Ref. Period) | NSDM_CONS_VAL_CCCRCY_REF | CURR | 17(2) | ||||||
CNSMPNVALUEINDSPCRCYONPREVDATE | Consumption Value in Display Currency (Previous Period) | NSDM_CONS_VAL_DCRCY_PREV | CURR | 17(2) | ||||||
CNSMPNVALUEINDSPCRCYONREFDATE | Consumption Value in Display Currency (Reference Period) | NSDM_CONS_VAL_DCRCY_REF | CURR | 17(2) | ||||||
CNSMPNQTYINBASEUNITONPREVDATE | Consumption Quantity in Base UoM (Previous Period) | NSDM_CONS_QTY_PREV | QUAN | 17(3) | MENGV9 | |||||
CNSMPNQTYINBASEUNITONREFDATE | Consumption Quantity in Base UoM (Reference Period) | NSDM_CONS_QTY_REF | QUAN | 17(3) | MENGV9 | |||||
INVTRYTURNOVERONPREVDATE | Inventory Turnover (Previous Period) | NSDM_TURNOVER_PREV | DEC | 31(3) | ||||||
INVTRYTURNOVERONREFDATE | Inventory Turnover (Reference Period) | NSDM_TURNOVER_REF | DEC | 31(3) | ||||||
INVTRYAGINGONPREVDATE | Inventory Aging (Previous Period) | NSDM_INV_AGING_PREV | DEC | 20(3) | ||||||
INVTRYAGINGONREFDATE | Inventory Aging (Reference Period) | NSDM_INV_AGING_REF | DEC | 20(3) | ||||||
RANGEOFCVRGINDAYSONPREVDATE | Range of Coverage in Days (Previous Period) | NSDM_ROC_DAYS_PREV | DEC | 30(0) | ||||||
RANGEOFCVRGINDAYSONREFDATE | Range of Coverage in Days (Reference Period) | NSDM_ROC_DAYS_REF | DEC | 30(0) | ||||||
MATERIALNAME | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
MATERIALGROUP | Material Group | MATKL | CHAR | 9(0) | T023 | MATKL | MKL | S_WBWG | MATKL | |
MATERIALGROUPNAME | Material Group Description | WGBEZ | CHAR | 20(0) | TEXT20 | |||||
MATERIALTYPE | Material type | MTART | CHAR | 4(0) | T134 | MTART | MTA | |||
MATERIALTYPENAME | Description of Material Type | MTBEZ | CHAR | 25(0) | TEXT25 | |||||
PLANTNAME | Plant Name | WERKS_NAME | CHAR | 30(0) | TEXT30 |
Search for further information about these or an SAP related objects