SAP CCNSLDTNJRNLENTR Table in S/4 HANA - Generated Table for View
CCNSLDTNJRNLENTR 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 CCNSLDTNJRNLENTR 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: CCNSLDTNJRNLENTR
CCNSLDTNJRNLENTR table structure field list
Below is the full CCNSLDTNJRNLENTR 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 | ||||
CONSOLIDATIONLEDGER | Ledger | RLDNR | CHAR | 2(0) | T881 | ALPHA | RLDNR | GLN | H_T881 | RLDNR |
CONSOLIDATIONDIMENSION | Dimension | FC_DIMEN | CHAR | 2(0) | TF150 | FC_DIMEN | DIN | FC_DIMEN | DIMEN | |
FISCALYEAR | Fiscal Year | FINS_GJAHR | NUMC | 4(0) | GJAHR | GJAHR | ||||
REFERENCEFISCALYEAR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
COMPANYCODE | Original company code | OBUKR | CHAR | 4(0) | T001 | BUKRS | ||||
CONSOLIDATIONDOCUMENTNUMBER | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
CONSOLIDATIONPOSTINGITEM | Six-Character Posting Item for Ledger | DOCLN6 | CHAR | 6(0) | DOCLN6 | |||||
COMPANYCODENAME | Name of Company Code or Company | BUTXT | CHAR | 25(0) | TEXT25 | |||||
GLRECORDTYPE | Record Type | FINCS_RRCTY | CHAR | 1(0) | FINCS_RRCTY | |||||
CONSOLIDATIONVERSION | Version | RVERS | CHAR | 3(0) | ALPHA | RVERS | GVS | |||
CONSOLIDATIONVERSIONTEXT | Description | FC_TXT | CHAR | 30(0) | TEXT30 | |||||
TRANSACTIONCURRENCY | Currency Key | RTCUR | CUKY | 5(0) | WAERS | FWS | ||||
LOCALCURRENCY | Currency key of the local currency | LCURR | CUKY | 5(0) | TCURC | WAERS | GLC | |||
GROUPCURRENCY | Currency key of the ledger currency | GCURR | CUKY | 5(0) | TCURC | WAERS | FWS | |||
BASEUNIT | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
FISCALPERIOD | Posting period | POPER | NUMC | 3(0) | POPER | POPR | ||||
CONSOLIDATIONDOCUMENTTYPE | Document Type | FC_DOCTY | CHAR | 2(0) | FC_DOCTY | BAR | ||||
CONSOLIDATIONDOCUMENTTYPETEXT | Description | FC_TXT | CHAR | 30(0) | TEXT30 | |||||
DEBITCREDITCODE | Debit/Credit Indicator | SHKZG | CHAR | 1(0) | SHKZG | |||||
COMPANY | Company | RCOMP_D | CHAR | 6(0) | ALPHA | RCOMP | GCC | |||
CONSOLIDATIONUNIT | Consolidation Unit | FC_BUNIT | CHAR | 18(0) | TF160 | AFIMC | FC_BUNIT | BUN | ||
CONSOLIDATIONUNITMDMTEXT | Medium description | RSTXTMD | CHAR | 40(0) | TEXT40 | |||||
CONSOLIDATIONCHARTOFACCOUNTS | Consolidation Chart of Accounts | FC_ITCLG | CHAR | 2(0) | FC_ITCLG | ITC | FC_ITCLG | ITCLG | ||
CONSOLIDATIONCHARTOFACCTSTEXT | Description | FC_TXT | CHAR | 30(0) | TEXT30 | |||||
FINANCIALSTATEMENTITEM | Financial Statement Item | FC_ITEM | CHAR | 10(0) | BFIMC | FC_ITEM | ITM | |||
FINANCIALSTATEMENTITEMMDMTEXT | Description | FINCS_DESC | CHAR | 50(0) | TEXT50 | |||||
PARTNERCONSOLIDATIONUNIT | Partner Unit | FC_BUPTR | CHAR | 18(0) | AFIMC | FC_BUNIT | ||||
PARTNERCNSLDTNUNITMEDIUMTEXT | Medium description | RSTXTMD | CHAR | 40(0) | TEXT40 | |||||
CONSOLIDATIONGROUP | Consolidation Group | FC_CONGR | CHAR | 18(0) | AFIMC | FC_CONGR | CGR | |||
CONSOLIDATIONGROUPMEDIUMTEXT | Medium Text | FC_TXTMI | CHAR | 30(0) | TEXT30 | |||||
SUBITEMCATEGORY | Subitem Category | FC_SITYP | CHAR | 3(0) | FC_SITYP | STP | FC_SITYP | SITYP | ||
SUBITEM | Subitem | FC_SITEM | CHAR | 10(0) | FC_SITEM | STM | ||||
POSTINGLEVEL | Posting Level | FC_PLEVL | CHAR | 2(0) | FC_PLEVL | |||||
POSTINGLEVELTEXT | Short Text for Fixed Values | VAL_TEXT | CHAR | 60(0) | DDTEXT | |||||
CONSOLIDATIONAPPORTIONMENT | Apportionment | FC_RPFLG | NUMC | 1(0) | FC_RPFLG | |||||
CURRENCYCONVERSIONSDIFFTYPE | Currency Translation | FC_RTFLG | NUMC | 1(0) | FC_RTFLG | |||||
CONSOLIDATIONACQUISITIONYEAR | Year of Acquisition | FC_RYACQ | NUMC | 4(0) | GJAHR | GJAHR | ||||
CONSOLIDATIONACQUISITIONPERIOD | Period of Acquisition | RPACQ | NUMC | 3(0) | NUM03 | |||||
INVESTEECONSOLIDATIONUNIT | Investee Unit | FC_COICU | CHAR | 18(0) | AFIMC | FC_BUNIT | CCU | |||
INVESTEECONSOLIDATIONUNITTEXT | Medium description | RSTXTMD | CHAR | 40(0) | TEXT40 | |||||
AMOUNTINTRANSACTIONCURRENCY | Value in Transaction Currency | VTCUR9 | CURR | 23(2) | AC172 | AFLE17D2O23S_TO_23D2O31S | ||||
AMOUNTINLOCALCURRENCY | Value in local currency | VLCUR9 | CURR | 23(2) | AC172 | AFLE17D2O23S_TO_23D2O31S | ||||
AMOUNTINGROUPCURRENCY | Value in group currency | VGCUR9 | CURR | 23(2) | AC172 | AFLE17D2O23S_TO_23D2O31S | ||||
QUANTITYINBASEUNIT | Quantity | QUAN1_9 | QUAN | 17(3) | MENGV9 | |||||
DOCUMENTITEMTEXT | Item Text | SGTXT | CHAR | 50(0) | TEXT50 | |||||
CONSOLIDATIONPOSTGITEMAUTOFLAG | Indicator: Automatic posting lines | AUTOM | CHAR | 1(0) | TEXT1 | |||||
BUSINESSTRANSACTIONTYPE | Business Transaction | GLVOR | CHAR | 4(0) | CHAR4 | |||||
POSTINGDATE | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
CURRENCYTRANSLATIONDATE | Value Date for Currency Translation | WSDAT | DATS | 8(0) | DATUM | WSD | ||||
CREATIONDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
CREATIONDATE | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8(0) | DATUM | |||||
CREATIONTIME | Time of Entry | CPUTM | TIMS | 6(0) | UZEIT | |||||
USERID | User Name | USNAM | CHAR | 12(0) | XUBNAME | USR | ||||
REVERSEDOCUMENT | Reverse Document Number | STBLG | CHAR | 10(0) | ALPHA | BELNR | ||||
REVERSEDDOCUMENT | Number of Reversed Document | STBLN | CHAR | 10(0) | ALPHA | BELNR | ||||
INVESTMENTACTIVITYTYPE | Consolidation of Investments Activity | FC_COIAC | CHAR | 2(0) | FC_COIAC | COA | ||||
INVESTMENTACTIVITY | Consolidation of Investments Activity Number | FC_COINR | CHAR | 10(0) | ALPHA | BELNR | CNR | |||
CONSOLIDATIONDOCREVERSALYEAR | Year of reversal document or reversed document | FC_REVYEAR | NUMC | 4(0) | GJAHR | GJAHR | ||||
REFERENCEDOCUMENTTYPE | Reference procedure | AWTYP | CHAR | 5(0) | TTYP | AWTYP | ||||
REFERENCEDOCUMENTCONTEXT | Reference Organizational Units | AWORG | CHAR | 10(0) | AWORG | |||||
LOGICALSYSTEM | Logical system | LOGSYS | CHAR | 10(0) | TBDLS | ALPHA | LOGSYS | |||
CHARTOFACCOUNTS | Chart of Accounts | KTOPL | CHAR | 4(0) | T004 | KTOPL | KPL | C_KTOPL | KTOPL | |
CHARTOFACCOUNTSNAME | Chart of Accounts Description | KTPLT | CHAR | 50(0) | TEXT50 | |||||
GLACCOUNT | Account Number | RACCT | CHAR | 10(0) | SKB1 | ALPHA | SAKNR | ACC | ||
GLACCOUNTNAME | G/L account short text | TXT20_SKAT | CHAR | 20(0) | TEXT20 | |||||
ASSIGNMENTREFERENCE | Assignment number | DZUONR | CHAR | 18(0) | ZUONR | |||||
COSTCENTER | Cost Center | KOSTL | CHAR | 10(0) | CSKS | ALPHA | KOSTL | KOS | ||
COSTCENTERNAME | Cost Center Name | FIS_KOSTL_NAME | CHAR | 20(0) | TEXT20 | |||||
PROFITCENTER | Profit Center | PRCTR | CHAR | 10(0) | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR |
PROFITCENTERNAME | Description of Profit Center | FIS_PRCTR_SHORTTEXT | CHAR | 20(0) | TEXT20 | |||||
FUNCTIONALAREA | Functional Area | FKBER | CHAR | 16(0) | TFKB | FKBER | FBE | |||
BUSINESSAREA | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
BUSINESSAREANAME | Business Area Description | FARP_GTEXT | CHAR | 30(0) | TEXT30 | |||||
CONTROLLINGAREA | Controlling Area | KOKRS | CHAR | 4(0) | TKA01 | CACCD | CAC | |||
CONTROLLINGAREANAME | Controlling Area Name | FIS_KOKRS_NAME | CHAR | 25(0) | TEXT25 | |||||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10(0) | FAGL_SEGM | ALPHA | FB_SEGMENT | |||
SEGMENTNAME | Segment Name | FIS_SEGMENT_NAME | CHAR | 50(0) | TEXT50 | |||||
PARTNERCOSTCENTER | Sender cost center | SKOST | CHAR | 10(0) | CSKS | ALPHA | KOSTL | KSK | ||
PARTNERCOSTCENTERNAME | Cost Center Name | FIS_KOSTL_NAME | CHAR | 20(0) | TEXT20 | |||||
PARTNERPROFITCENTER | Partner Profit Center | PPRCTR | CHAR | 10(0) | CEPC | ALPHA | PRCTR | PPC | ||
PARTNERPROFITCENTERNAME | Description of Profit Center | FIS_PRCTR_SHORTTEXT | CHAR | 20(0) | TEXT20 | |||||
PARTNERFUNCTIONALAREA | Partner Functional Area | SFKBER | CHAR | 16(0) | TFKB | FKBER | ||||
PARTNERBUSINESSAREA | Trading partner's business area | PARGB | CHAR | 4(0) | TGSB | GSBER | GSB | |||
PARTNERBUSINESSAREANAME | Business Area Description | FARP_GTEXT | CHAR | 30(0) | TEXT30 | |||||
PARTNERCOMPANY | Company ID of Trading Partner | RASSC | CHAR | 6(0) | T880 | ALPHA | RCOMP | PGS | ||
PARTNERSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10(0) | FAGL_SEGM | ALPHA | FB_SEGMENT | |||
PARTNERSEGMENTNAME | Segment Name | FIS_SEGMENT_NAME | CHAR | 50(0) | TEXT50 | |||||
ORDERID | Order Number | AUFNR | CHAR | 12(0) | AUFK | ALPHA | AUFNR | ANR | ||
CUSTOMER | Customer Number | KUNNR | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR |
CUSTOMERNAME | Name of Customer | MD_CUSTOMER_NAME | CHAR | 80(0) | TEXT80 | |||||
SUPPLIER | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
SUPPLIERNAME | Name of Supplier | MD_SUPPLIER_NAME | CHAR | 80(0) | TEXT80 | |||||
MATERIAL | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
PLANT | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
FINANCIALTRANSACTIONTYPE | Transaction type | RMVCT | CHAR | 3(0) | T856 | RMVCT | ||||
PROJECT | Project definition | PS_PSPID | CHAR | 24(0) | ABPSN | PS_PSPID | PSP | PD_DUMMY | PSPID | |
BILLINGDOCUMENTTYPE | Billing Type | FKART | CHAR | 4(0) | TVFK | FKART | ||||
SALESORGANIZATION | Sales Organization | VKORG | CHAR | 4(0) | TVKO | VKORG | VKO | C_VKORG | VKORG | |
DISTRIBUTIONCHANNEL | Distribution Channel | VTWEG | CHAR | 2(0) | TVTW | VTWEG | VTW | C_VTWEG | VTWEG | |
ORGANIZATIONDIVISION | Division | SPART | CHAR | 2(0) | TSPA | SPART | SPA | C_SPART | SPART | |
SOLDMATERIAL | Product Sold | FINS_MATNR_PA | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | ||
MATERIALGROUP | Material Group | FINS_MATKL_MM | CHAR | 9(0) | T023 | MATKL | S_WBWG | MATKL | ||
CUSTOMERGROUP | Customer Group | KDGRP | CHAR | 2(0) | T151 | KDGRP | VKD | |||
CUSTOMERSUPPLIERCOUNTRY | Country Key | LAND1_GP | CHAR | 3(0) | T005 | LAND1 | C_LAND1 | LAND1 | ||
CUSTOMERSUPPLIERINDUSTRY | Industry key | BRSCH | CHAR | 4(0) | T016 | BRSCH | ||||
SALESDISTRICT | Sales District | BZIRK | CHAR | 6(0) | T171 | BZIRK | BZI | |||
BILLTOPARTY | Bill-to party | KUNRE | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | KUN | ||
SHIPTOPARTY | Ship-to party | KUNWE | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | |||
CUSTOMERSUPPLIERCORPORATEGROUP | Group key | KONZS | CHAR | 10(0) | KONZS |
Search for further information about these or an SAP related objects