C_PaRealignment

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 C_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: CPAREALGNMT

CREATE VIEW C_PaRealignment AS
SELECT
  SourceLedger,
  Ledger,
  FiscalYear,
  CompanyCode,
  AccountingDocument,
  LedgerGLLineItem,
  RealignmentRun,
  cast ( RealignmentRunEndDate as fins_realignment_date preserving type ) AS RealignmentRunEndDate,
  cast ( RealignmentRunEndTime as fins_realignment_time preserving type ) AS RealignmentRunEndTime,
  cast ( substring( RealignmentRunEndDate, 1, 4 ) as fins_realignment_year) AS RealignmentRunEndYear,
  cast ( substring( RealignmentRunEndDate, 5, 2 ) as fins_realignment_month) AS RealignmentRunEndMonth,
  FiscalPeriod,
  PostingDate,
  ProfitCenter,
  GLAccount,
  BusinessTransactionType,
  AmountInBalanceTransacCrcy,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  BalanceTransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  Segment,
  MaterialGroup,
  cast ( RealgnmtPrevMaterialGroup as fins_prev_matkl preserving type) AS RealgnmtPrevMaterialGroup,
  CustomerGroup,
  cast ( RealgnmtPrevCustomerGroup as fins_prev_kdgrp preserving type) AS RealgnmtPrevCustomerGroup,
  FunctionalArea,
  ControllingArea,
  SoldMaterial,
  cast ( RealgnmtPrevSoldMaterial as fins_prev_matnr_pa preserving type) AS RealgnmtPrevSoldMaterial,
  BillingDocumentType,
  cast ( RealgnmtPrevBillgDocType as fins_prev_fkart preserving type) AS RealgnmtPrevBillgDocType,
  CustomerSupplierCountry,
  cast ( RealgnmtPrevCustSuplrCntry as fins_prev_land1 preserving type) AS RealgnmtPrevCustSuplrCntry,
  SalesOrganization,
  cast ( RealgnmtPrevSalesOrganization as fins_prev_vkorg preserving type) AS RealgnmtPrevSalesOrganization,
  DistributionChannel,
  cast ( RealgnmtPrevDistrChannel as fins_prev_vtweg preserving type) AS RealgnmtPrevDistrChannel,
  Plant,
  cast ( RealgnmtPrevPlant as fins_prev_werks preserving type) AS RealgnmtPrevPlant,
  SalesOrder,
  cast ( RealgnmtPrevSalesOrder as fins_prev_kdauf preserving type) AS RealgnmtPrevSalesOrder,
  SalesOrderItem,
  cast ( RealgnmtPrevSalesOrderItem as fins_prev_kdpos preserving type) AS RealgnmtPrevSalesOrderItem,
  Customer,
  cast ( RealgnmtPrevCustomer as fins_prev_kunnr preserving type ) AS RealgnmtPrevCustomer,
  cast ( _PreviousCustomerText.CustomerName as fins_prev_customername preserving type ) AS RealgnmtPrevCustomerName,
  cast ( OrderID as fins_int_aufnr preserving type ) AS OrderID,
  cast ( RealgnmtPrevOrderID as fins_prev_aufnr preserving type ) AS RealgnmtPrevOrderID,
  SalesDistrict,
  cast ( RealgnmtPrevSalesDistrict as fins_prev_bzirk preserving type) AS RealgnmtPrevSalesDistrict,
  ShipToParty,
  cast ( RealgnmtPrevShipToParty as fins_prev_kunwe preserving type) AS RealgnmtPrevShipToParty,
  BillToParty,
  cast ( RealgnmtPrevBillToParty as fins_prev_kunre preserving type) AS RealgnmtPrevBillToParty,
  OrganizationDivision,
  cast ( RealgnmtPrevOrgDivision as fins_prev_spart preserving type) AS RealgnmtPrevOrgDivision,
  WBSElement,
  cast ( RealgnmtPrevWBSElement as fins_prev_ps_posid preserving type) AS RealgnmtPrevWBSElement,
  CostObject,
  cast ( RealgnmtPrevCostObject as fins_prev_kstrg preserving type) AS RealgnmtPrevCostObject,
  CostCenter,
  cast ( RealgnmtPrevCostCenter as fins_prev_rcntr preserving type) AS RealgnmtPrevCostCenter,
  Supplier,
  AccountingDocumentType,
  cast ( NmbrOfRealignedJrnlEntryItems as fins_je_counter ) AS NmbrOfRealignedJrnlEntryItems,
  _GLAccountInCompanyCode.AuthorizationGroup AS GLAccountAuthorizationGroup,
  _Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp,
  _AccountingDocumentType.AuthorizationGroup AS AcctgDocTypeAuthorizationGroup
FROM I_PaRealignment
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PreviousCustomerText ON RealgnmtPrevCustomer = _PreviousCustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _SourceLedgerText ON SourceLedger = _SourceLedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_GLAccountLineItem AS _GLAccountLineItem ON Ledger = _GLAccountLineItem.Ledger AND SourceLedger = _GLAccountLineItem.SourceLedger AND CompanyCode = _GLAccountLineItem.CompanyCode AND FiscalYear = _GLAccountLineItem.FiscalYear AND AccountingDocument = _GLAccountLineItem.AccountingDocument AND LedgerGLLineItem = _GLAccountLineItem.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_Material AS _SoldMaterial ON SoldMaterial = _SoldMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Material AS _SoldMaterialPrevious ON RealgnmtPrevSoldMaterial = _SoldMaterialPrevious.Material  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND _ProfitCenter.ValidityStartDate <= $session.system_date AND _ProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerPrevious ON RealgnmtPrevCustomer = _CustomerPrevious.Customer  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
;