ACDOCA_KENC is a standard SAP table in SAP ECC (or) S/4HANA which stores History Table for Realignment on Table ACDOCA data. There are total 94 fields in ACDOCA_KENC table.This blog post provides key technical details of SAP table ACDOCA_KENC, including its availability across SAP S/4HANA versions and the list of CDS views for ACDOCA_KENC table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Management Accounting – Profitability Accounting (FINS_CO_COPA) |
| Technical Component | Profitability Analysis (CO-PA) |
SAP ACDOCA_KENC Table Fields
The following is the list of fields that are available in SAP ACDOCA_KENC table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| RCLNT | Client | MANDT | MANDT | CLNT (3) | |
| CHGRUN | Realignment run | RKENCCRUN | RKENCUNIFY | NUMC (10) | |
| RLDNR | Ledger in General Ledger Accounting | FINS_LEDGER | FINS_LEDGER | CHAR (2) | |
| RBUKRS | Company Code | BUKRS | BUKRS | CHAR (4) | |
| GJAHR | Fiscal Year | GJAHR | GJAHR | NUMC (4) | |
| BELNR | Accounting Document Number | BELNR_D | BELNR | CHAR (10) | |
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | DOCLN6 | CHAR (6) | |
| RCNTR | Cost Center | KOSTL | KOSTL | CHAR (10) | |
| PRCTR | Profit Center | PRCTR | PRCTR | CHAR (10) | |
| RFAREA | Functional Area | FKBER | FKBER | CHAR (16) | |
| RBUSA | Business Area | GSBER | GSBER | CHAR (4) | |
| KOKRS | Controlling Area | KOKRS | CACCD | CHAR (4) | |
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | FB_SEGMENT | CHAR (10) | |
| PPRCTR | Partner Profit Center | PPRCTR | PRCTR | CHAR (10) | |
| KDAUF | Sales Order Number | KDAUF | VBELN | CHAR (10) | |
| KDPOS | Item number in Sales Order | KDPOS | NUM06 | NUMC (6) | |
| WERKS | Plant | WERKS_D | WERKS | CHAR (4) | |
| KUNNR | Customer Number | KUNNR | KUNNR | CHAR (10) | |
| AUFNR | Order Number | AUFNR | AUFNR | CHAR (12) | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PS_POSNR | NUMC (8) | |
| PS_PSPID | Project definition | PS_PSPID | PS_PSPID | CHAR (24) | |
| PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | PS_POSID | CHAR (24) | |
| PRZNR | Business Process | CO_PRZNR | CO_PRZNR | CHAR (12) | |
| KSTRG | Cost Object | KSTRG | KSTRG | CHAR (12) | |
| UPRCTR | Origin Profit Center | FINS_ORIGIN_PRCTR | PRCTR | CHAR (10) | |
| SERVICE_DOC_TYPE | Service Document Type | FCO_SRVDOC_TYPE | CRM_PROCESS_TYPE | CRMC_PROC_TYPE | CHAR (4) |
| SERVICE_DOC_ID | Service Document ID | FCO_SRVDOC_ID | CRM_OBJECT_ID | FCOV_SRVDOC_TYID | CHAR (10) |
| SERVICE_DOC_ITEM_ID | Service Document Item ID | FCO_SRVDOC_ITEM_ID | FCO_SRVDOC_ITEM_ID | FCO_SRVDOC | NUMC (6) |
| FKART | Billing Type | FKART | FKART | TVFK | CHAR (4) |
| VKORG | Sales Organization | VKORG | VKORG | TVKO | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | VTWEG | TVTW | CHAR (2) |
| SPART | Division | SPART | SPART | TSPA | CHAR (2) |
| MATNR_COPA | Product Sold | FINS_MATNR_PA | MATNR | MARA | CHAR (40) |
| MATKL | Product Sold Group | FINS_MATKL_PA | MATKL | T023 | CHAR (9) |
| KDGRP | Customer Group | KDGRP | KDGRP | T151 | CHAR (2) |
| LAND1 | Country Key | LAND1_GP | LAND1 | T005 | CHAR (3) |
| BRSCH | Industry key | BRSCH | BRSCH | T016 | CHAR (4) |
| BZIRK | Sales District | BZIRK | BZIRK | T171 | CHAR (6) |
| KUNRE | Bill-to party | KUNRE | KUNNR | KNA1 | CHAR (10) |
| KUNWE | Ship-to party | KUNWE | KUNNR | KNA1 | CHAR (10) |
| KONZS | Group key | KONZS | KONZS | CHAR (10) | |
| ACDOC_COPA_EEW_DUMMY_PA | Dummy function in length 1 | DUMMY | DUMMY | CHAR (1) | |
| VKGRP_PA | Sales group | VKGRP | VKGRP | TVKGR | CHAR (3) |
| MAABC_PA | ABC Indicator | MAABC | MAABC | TMABC | CHAR (1) |
| BONUS_PA | Volume rebate group | BONUS | BONUS | TVBO | CHAR (2) |
| VKBUR_PA | Sales office | VKBUR | VKBUR | TVBUR | CHAR (4) |
| EFORM_PA | Form of manufacture | RKEG_EFORM | RKEG_EFORM | T2513 | CHAR (5) |
| GEBIE_PA | Area | RKEG_GEBIE | RKEG_GEBIE | T2538 | CHAR (4) |
| KMVKBU_PA | Sales office | VKBUR | VKBUR | TVBUR | CHAR (4) |
| KMVKGR_PA | Sales group | VKGRP | VKGRP | TVKGR | CHAR (3) |
| KMBRND_PA | Brand | RKESKMBRND | RKESKMBRND | T2249 | NUMC (2) |
| CRMELEM_PA | CRM Marketing Element | RKECRMELEM | PS_POSNR | PRPS | NUMC (8) |
| KMKDGR_PA | Customer Group | KDGRP | KDGRP | T151 | CHAR (2) |
| KMLAND_PA | Country Key | LAND1_GP | LAND1 | T005 | CHAR (3) |
| KMMAKL_PA | Material Group | MATKL | MATKL | T023 | CHAR (9) |
| KMVTNR_PA | Sales employee | VRTNR | PERNR | NUMC (8) | |
| WWTES_PA | Test Partner | RKEG_WWTES | CHAR10 | CHAR (10) | |
| KMHI01_PA | Customer hierarchy Level 1 | HIEZU01 | KUNNR | KNA1 | CHAR (10) |
| KMHI02_PA | Customer hierarchy Level 2 | HIEZU02 | KUNNR | KNA1 | CHAR (10) |
| KMHI03_PA | Customer hierarchy Level 3 | HIEZU03 | KUNNR | KNA1 | CHAR (10) |
| CRMCSTY_PA | CRM Cost Element | RKECRMCSTY | KSTAR | * | CHAR (10) |
| KMATYP_PA | Aircraft Type | RKESKMATYP | RKESKMATYP | T2209 | NUMC (2) |
| KMDEST_PA | Destination | RKESKMDEST | RKESKMDEST | T2211 | CHAR (5) |
| KMFLTN_PA | Flight Number | RKESKMFLTN | RKESKMFLTN | T2215 | CHAR (6) |
| KMFLTY_PA | Flight Type | RKESKMFLTY | RKESKMFLTY | T2216 | CHAR (4) |
| KMIATA_PA | IATA Season | RKESKMIATA | RKESKMIATA | T2207 | CHAR (5) |
| KMLEGS_PA | Route Segment | RKESKMLEGS | RKESKMLEGS | T2213 | CHAR (7) |
| KMOPDY_PA | Day of Operation | RKESKMOPDY | RKESKMOPDY | T2208 | CHAR (2) |
| KMORIG_PA | Departure Location | RKESKMORIG | RKESKMORIG | T2212 | CHAR (5) |
| KMROUT_PA | Rotation | RKESKMROUT | RKESKMROUT | T2210 | CHAR (5) |
| KMSTGE_PA | Strategic Business Unit | RKESKMSTGE | RKESKMSTGE | T2247 | NUMC (2) |
| KMWNHG_PA | Main Material Group | RKESKMWNHG | RKESKMWNHG | T2246 | NUMC (2) |
| KMZONE_PA | Zone | RKESKMZONE | RKESKMZONE | T2214 | CHAR (5) |
| PAPH1_PA | Prod.hierarchy01-1 | RKEG_PAPH1 | RKEG_PAPH1 | CHAR (5) | |
| PRODH_PA | Product hierarchy | PRODH_D | PRODH | T179 | CHAR (18) |
| WWACT_PA | Activity | RKEG_WWACT | RKEG_WWACT | T2500 | CHAR (2) |
| WWERM_PA | Shipping Point / Receiving Point | VSTEL | VSTEL | TVST | CHAR (4) |
| PAPH2_PA | Prod.hierarchy01-2 | RKEG_PAPH2 | RKEG_PAPH2 | CHAR (10) | |
| PAPH3_PA | Prod.hierarchy01-3 | RKEG_PAPH3 | RKEG_PAPH3 | CHAR (18) | |
| COLLE_PA | Fashion Collection | FSH_COLLECTION | FSH_COLLECTION | FSH_COLLECTIONS | CHAR (10) |
| CRMFIGR_PA | CRM Key Figure | RKECRMFIGR | RKECRMFIGR | TKECRMFIGR | CHAR (16) |
| KMCATG_PA | Business field | RKESKMCATG | RKESKMCATG | T2248 | NUMC (2) |
| KMNIEL_PA | Nielsen ID | NIELS | NIELS | TNLS | CHAR (2) |
| SAISJ_PA | Season Year | FSH_SAISJ | FSH_CJAHR | CHAR (4) | |
| SAISO_PA | Season | FSH_SAISO | RFM_SAISO | FSH_SEASONS | CHAR (10) |
| ARTNRG_PA | Generic Article | FSH_ARTNRG | MATNR | MARA | CHAR (40) |
| MATNR_PA | Material Number | MATNR | MATNR | MARA | CHAR (40) |
| PARTNER_PA | CO-PA Partner | RKEPARTNER | RKEPARTNER | TKEPARTNER | CHAR (10) |
| REGIO_PA | Region (State, Province, County) | REGIO | REGIO | T005S | CHAR (3) |
| WW001_PA | BRAND Reporting | RKEG_WW001 | RKEG_WW001 | T2501 | CHAR (5) |
| WW100_PA | Country/Region Key | LAND1 | LAND1 | T005 | CHAR (3) |
| WW101_PA | Country/Region Key | LAND1 | LAND1 | T005 | CHAR (3) |
| WWBU1_PA | Test Business Unit | RKEG_WWBU1 | RKEG_WWBU1 | T2508 | CHAR (10) |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATA_TEMPERATURE | DATS (8) |
Availability
The SAP table ACDOCA_KENC is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ACDOCA_KENC table
The following is the list of ACDOCA_KENC CDS views, which can also be used instead of ACDOCA_KENC table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_PAREALIGNMENTHISTORY | BASIC | CO-PA Realignment History |
| I_PAREALIGNMENT | COMPOSITE | CO-PA Realignment |
| C_PAREALIGNMENT | CONSUMPTION | CO-PA Realignment Results |
