I_PaRealignment

DDL: I_PAREALIGNMENT SQL: IPAREALGNMT Type: view COMPOSITE
67 Fields 3 Data Sources 1 Associations

CO-PA Realignment

I_PaRealignment is a Composite CDS View that provides data about "CO-PA Realignment" in SAP S/4HANA. It reads from 3 data sources (I_GLAccountLineItem, I_PaRealignmentHistory, I_PaRealignmentLog) and exposes 67 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem inner
I_PaRealignmentHistory I_PaRealignmentHistory inner
I_PaRealignmentLog I_PaRealignmentLog from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WBSElement _WBSElement $projection.WBSElement = _WBSElement.WBSElement

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPAREALGNMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label CO-PA Realignment view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_GLAccountLineItem SourceLedger Source Ledger
KEY Ledger I_GLAccountLineItem Ledger Ledger
KEY CompanyCode I_GLAccountLineItem CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem Journal Entry Item
KEY RealignmentRun I_PaRealignmentLog RealignmentRun Realign.run
ProfitCenter I_GLAccountLineItem ProfitCenter Profit Center
RealignmentRunEndDate I_PaRealignmentLog RealignmentRunEndDate Term to
RealignmentRunEndTime I_PaRealignmentLog RealignmentRunEndTime Time Stamp
FiscalPeriod I_GLAccountLineItem FiscalPeriod Tax period
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
BusinessTransactionType I_GLAccountLineItem BusinessTransactionType Bus.transaction
AmountInBalanceTransacCrcy I_GLAccountLineItem AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
BalanceTransactionCurrency I_GLAccountLineItem BalanceTransactionCurrency Currency
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
AmountInGlobalCurrency I_GLAccountLineItem AmountInGlobalCurrency Amount in Global Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
GLAccount I_GLAccountLineItem GLAccount General Ledger
FunctionalArea I_GLAccountLineItem FunctionalArea Sendr Fctl Area
Segment I_GLAccountLineItem Segment Segment number
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
Supplier I_GLAccountLineItem Supplier Supplier
ControllingArea I_GLAccountLineItem ControllingArea Controlling Area
RealgnmtPrevSoldMaterial I_PaRealignmentHistory RealgnmtPrevSoldMaterial Product Sold
SoldMaterial I_GLAccountLineItem SoldProduct Product Sold
RealgnmtPrevBillgDocType I_PaRealignmentHistory RealgnmtPrevBillgDocType Ship. cost type
BillingDocumentType I_GLAccountLineItem BillingDocumentType Billing Type
RealgnmtPrevCustomerGroup I_PaRealignmentHistory RealgnmtPrevCustomerGroup Customer group
CustomerGroup I_GLAccountLineItem CustomerGroup Customer Group
RealgnmtPrevCustSuplrCntry I_PaRealignmentHistory RealgnmtPrevCustSuplrCntry Trip Ctry/Reg
CustomerSupplierCountry I_GLAccountLineItem CustomerSupplierCountry Customer or Supplier Country/Region
RealgnmtPrevMaterialGroup I_PaRealignmentHistory RealgnmtPrevMaterialGroup Product Sold Group
MaterialGroup I_GLAccountLineItem SoldProductGroup Product Sold Group
RealgnmtPrevSalesOrganization I_PaRealignmentHistory RealgnmtPrevSalesOrganization SD Sales Org.
SalesOrganization I_GLAccountLineItem SalesOrganization Sales Organization
RealgnmtPrevDistrChannel I_PaRealignmentHistory RealgnmtPrevDistrChannel RefDistCh-Cust/Mat.
DistributionChannel I_GLAccountLineItem DistributionChannel RefDistCh-Cust/Mat.
RealgnmtPrevPlant I_PaRealignmentHistory RealgnmtPrevPlant Receiving Plant
Plant I_GLAccountLineItem Plant Valuation Area
RealgnmtPrevSalesOrder I_PaRealignmentHistory RealgnmtPrevSalesOrder SD Document
SalesOrder I_GLAccountLineItem SalesOrder SD Document
RealgnmtPrevSalesOrderItem I_PaRealignmentHistory RealgnmtPrevSalesOrderItem Sales Ord. Item
SalesOrderItem I_GLAccountLineItem SalesOrderItem Sales Order Item
RealgnmtPrevCustomer I_PaRealignmentHistory RealgnmtPrevCustomer Stock customer
Customer I_GLAccountLineItem Customer Sold-to Party
RealgnmtPrevOrderID I_PaRealignmentHistory RealgnmtPrevOrderID SettlementOrder
OrderID I_GLAccountLineItem OrderID Order ID
RealgnmtPrevSalesDistrict I_PaRealignmentHistory RealgnmtPrevSalesDistrict Sales District
SalesDistrict I_GLAccountLineItem SalesDistrict Sales District
RealgnmtPrevShipToParty I_PaRealignmentHistory RealgnmtPrevShipToParty Ship-to Party
ShipToParty I_GLAccountLineItem ShipToParty Ship-To Party (obsolete)
RealgnmtPrevBillToParty I_PaRealignmentHistory RealgnmtPrevBillToParty Bill-to Party
BillToParty I_GLAccountLineItem BillToParty Inv. Recipient
RealgnmtPrevOrgDivision I_PaRealignmentHistory RealgnmtPrevOrgDivision Source supplier
OrganizationDivision I_GLAccountLineItem OrganizationDivision Org. Division
WBSElementInternalID I_GLAccountLineItem WBSElementInternalID WBS Internal ID
RealgnmtPrevWBSElement I_PaRealignmentHistory RealgnmtPrevWBSElement WBS Element
WBSElement _WBSElementInternalID WBSElement WBS Internal ID
RealgnmtPrevCostObject I_PaRealignmentHistory RealgnmtPrevCostObject Cost Objects
CostObject I_GLAccountLineItem CostObject Cost Object
RealgnmtPrevCostCenter I_PaRealignmentHistory RealgnmtPrevCostCenter Cost Center
CostCenter I_GLAccountLineItem CostCenter Cost Center
_WBSElementInternalID _WBSElementInternalID
_WBSElement _WBSElement
NmbrOfRealignedJrnlEntryItems 1

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_PaRealignment.
-- 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: IPAREALGNMT

CREATE VIEW I_PaRealignment AS
SELECT
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_PaRealignmentLog.RealignmentRun AS RealignmentRun,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_PaRealignmentLog.RealignmentRunEndDate AS RealignmentRunEndDate,
  I_PaRealignmentLog.RealignmentRunEndTime AS RealignmentRunEndTime,
  I_GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItem.PostingDate AS PostingDate,
  I_GLAccountLineItem.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountLineItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountLineItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.Segment AS Segment,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_PaRealignmentHistory.RealgnmtPrevSoldMaterial AS RealgnmtPrevSoldMaterial,
  I_GLAccountLineItem.SoldProduct AS SoldMaterial,
  I_PaRealignmentHistory.RealgnmtPrevBillgDocType AS RealgnmtPrevBillgDocType,
  I_GLAccountLineItem.BillingDocumentType AS BillingDocumentType,
  I_PaRealignmentHistory.RealgnmtPrevCustomerGroup AS RealgnmtPrevCustomerGroup,
  I_GLAccountLineItem.CustomerGroup AS CustomerGroup,
  I_PaRealignmentHistory.RealgnmtPrevCustSuplrCntry AS RealgnmtPrevCustSuplrCntry,
  I_GLAccountLineItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_PaRealignmentHistory.RealgnmtPrevMaterialGroup AS RealgnmtPrevMaterialGroup,
  I_GLAccountLineItem.SoldProductGroup AS MaterialGroup,
  I_PaRealignmentHistory.RealgnmtPrevSalesOrganization AS RealgnmtPrevSalesOrganization,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_PaRealignmentHistory.RealgnmtPrevDistrChannel AS RealgnmtPrevDistrChannel,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_PaRealignmentHistory.RealgnmtPrevPlant AS RealgnmtPrevPlant,
  I_GLAccountLineItem.Plant AS Plant,
  I_PaRealignmentHistory.RealgnmtPrevSalesOrder AS RealgnmtPrevSalesOrder,
  I_GLAccountLineItem.SalesOrder AS SalesOrder,
  I_PaRealignmentHistory.RealgnmtPrevSalesOrderItem AS RealgnmtPrevSalesOrderItem,
  I_GLAccountLineItem.SalesOrderItem AS SalesOrderItem,
  I_PaRealignmentHistory.RealgnmtPrevCustomer AS RealgnmtPrevCustomer,
  I_GLAccountLineItem.Customer AS Customer,
  I_PaRealignmentHistory.RealgnmtPrevOrderID AS RealgnmtPrevOrderID,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_PaRealignmentHistory.RealgnmtPrevSalesDistrict AS RealgnmtPrevSalesDistrict,
  I_GLAccountLineItem.SalesDistrict AS SalesDistrict,
  I_PaRealignmentHistory.RealgnmtPrevShipToParty AS RealgnmtPrevShipToParty,
  I_GLAccountLineItem.ShipToParty AS ShipToParty,
  I_PaRealignmentHistory.RealgnmtPrevBillToParty AS RealgnmtPrevBillToParty,
  I_GLAccountLineItem.BillToParty AS BillToParty,
  I_PaRealignmentHistory.RealgnmtPrevOrgDivision AS RealgnmtPrevOrgDivision,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.WBSElementInternalID AS WBSElementInternalID,
  I_PaRealignmentHistory.RealgnmtPrevWBSElement AS RealgnmtPrevWBSElement,
  _WBSElementInternalID.WBSElement AS WBSElement,
  I_PaRealignmentHistory.RealgnmtPrevCostObject AS RealgnmtPrevCostObject,
  I_GLAccountLineItem.CostObject AS CostObject,
  I_PaRealignmentHistory.RealgnmtPrevCostCenter AS RealgnmtPrevCostCenter,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  1 AS NmbrOfRealignedJrnlEntryItems
FROM I_PaRealignmentLog
INNER JOIN I_PaRealignmentHistory ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountLineItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
;

Learn More