I_PaRealignmentHistory

DDL: I_PAREALIGNMENTHISTORY SQL: IPAREALGNMTHIST Type: view BASIC Package: FINS_FIS_FICO
26 Fields 1 Data Sources

CO-PA Realignment History

I_PaRealignmentHistory is a Basic CDS View that provides data about "CO-PA Realignment History" in SAP S/4HANA. It reads from 1 data source (acdoca_kenc) and exposes 26 fields with key fields RealignmentRun, Ledger, CompanyCode, FiscalYear, AccountingDocument. Part of development package FINS_FIS_FICO.

Data Sources (1)

SourceAliasJoin Type
acdoca_kenc acdoca_kenc from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPAREALGNMTHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CO-PA Realignment History view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY RealignmentRun acdoca_kenc chgrun Realign.run
KEY Ledger acdoca_kenc rldnr Ledger (Compat.)
KEY CompanyCode acdoca_kenc rbukrs Company Code
KEY FiscalYear acdoca_kenc gjahr Settlement Year
KEY AccountingDocument acdoca_kenc belnr SD Document
KEY LedgerGLLineItem acdoca_kenc docln Matching Document Line Item
RealgnmtPrevSoldMaterial acdoca_kenc matnr_copa Product Sold
RealgnmtPrevBillgDocType acdoca_kenc fkart Ship. cost type
RealgnmtPrevCustomerGroup acdoca_kenc kdgrp Customer group
RealgnmtPrevCustSuplrCntry acdoca_kenc land1 Trip Ctry/Reg
RealgnmtPrevCustSuplrIndstry acdoca_kenc brsch Industry
RealgnmtPrevMaterialGroup acdoca_kenc matkl Product Sold Group
RealgnmtPrevSalesOrganization acdoca_kenc vkorg SD Sales Org.
RealgnmtPrevDistrChannel acdoca_kenc vtweg RefDistCh-Cust/Mat.
RealgnmtPrevPlant acdoca_kenc werks Receiving Plant
RealgnmtPrevSalesOrder acdoca_kenc kdauf SD Document
RealgnmtPrevCustomer acdoca_kenc kunnr Stock customer
RealgnmtPrevOrderID acdoca_kenc aufnr SettlementOrder
RealgnmtPrevSalesDistrict acdoca_kenc bzirk Sales District
RealgnmtPrevShipToParty acdoca_kenc kunwe Ship-to Party
RealgnmtPrevBillToParty acdoca_kenc kunre Bill-to Party
RealgnmtPrevOrgDivision acdoca_kenc spart Source supplier
RealgnmtPrevSalesOrderItem acdoca_kenc kdpos Sales Ord. Item
RealgnmtPrevWBSElement acdoca_kenc ps_posid WBS Element
RealgnmtPrevCostObject acdoca_kenc kstrg Cost Objects
RealgnmtPrevCostCenter acdoca_kenc rcntr Cost Center

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PaRealignmentHistory.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPAREALGNMTHIST

CREATE VIEW I_PaRealignmentHistory AS
SELECT
  acdoca_kenc.chgrun AS RealignmentRun,
  acdoca_kenc.rldnr AS Ledger,
  acdoca_kenc.rbukrs AS CompanyCode,
  acdoca_kenc.gjahr AS FiscalYear,
  acdoca_kenc.belnr AS AccountingDocument,
  acdoca_kenc.docln AS LedgerGLLineItem,
  acdoca_kenc.matnr_copa AS RealgnmtPrevSoldMaterial,
  acdoca_kenc.fkart AS RealgnmtPrevBillgDocType,
  acdoca_kenc.kdgrp AS RealgnmtPrevCustomerGroup,
  acdoca_kenc.land1 AS RealgnmtPrevCustSuplrCntry,
  acdoca_kenc.brsch AS RealgnmtPrevCustSuplrIndstry,
  acdoca_kenc.matkl AS RealgnmtPrevMaterialGroup,
  acdoca_kenc.vkorg AS RealgnmtPrevSalesOrganization,
  acdoca_kenc.vtweg AS RealgnmtPrevDistrChannel,
  acdoca_kenc.werks AS RealgnmtPrevPlant,
  acdoca_kenc.kdauf AS RealgnmtPrevSalesOrder,
  acdoca_kenc.kunnr AS RealgnmtPrevCustomer,
  acdoca_kenc.aufnr AS RealgnmtPrevOrderID,
  acdoca_kenc.bzirk AS RealgnmtPrevSalesDistrict,
  acdoca_kenc.kunwe AS RealgnmtPrevShipToParty,
  acdoca_kenc.kunre AS RealgnmtPrevBillToParty,
  acdoca_kenc.spart AS RealgnmtPrevOrgDivision,
  acdoca_kenc.kdpos AS RealgnmtPrevSalesOrderItem,
  acdoca_kenc.ps_posid AS RealgnmtPrevWBSElement,
  acdoca_kenc.kstrg AS RealgnmtPrevCostObject,
  acdoca_kenc.rcntr AS RealgnmtPrevCostCenter
FROM acdoca_kenc
;

Learn More