C_PurOrdAccrualForReview

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_PurOrdAccrualForReview.
-- 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: CPOACCRRVW

CREATE VIEW C_PurOrdAccrualForReview AS
SELECT
  AccrualEngineApplication,
  CompanyCode,
  cast (AccrualObject as fac_poac_rvw_wf_ace_obj_id) AS AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  _itemtypel.LedgerGroup AS LedgerGroup,
  AccrualPeriodEndDate,
  ProposedAccrAmtIsExisting,
  _purord.Supplier AS Supplier,
  _purord._Supplier.SupplierName AS SupplierName,
  _purord.CreatedByUser AS CreatedByUser,
  _purord._UserContactCard.FullName AS FullName,
  _purord.CreationDate AS CreationDate,
  cast(_purord.PurchaseOrderItemNetAmount as fac_poac_rvw_wf_bwert) AS PurchaseOrderItemNetAmount,
  cast(_purord.PurchasingGroup as fac_poac_rvw_wf_bkgrp) AS PurchasingGroup,
  _purord._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  cast(_purord.PurchasingOrganization as fac_poac_rvw_wf_ekorg) AS PurchasingOrganization,
  _purord._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  cast(ProposedAccrAmtAdjmtReason as fac_poac_rvw_wf_adjmt_rsn_code) AS ProposedAccrAmtAdjmtReason,
  cast(ReviewComment as fac_poac_rvw_wf_adjmt_comment) AS ReviewComment,
  cast(_purord.TotalAccrAmountInTransCrcy as fac_poac_rvw_wf_ttl_accr_wcurr) AS TotalAccrAmountInTransCrcy,
  _purord.AccrSubobjHdrStartOfLifeDate AS AccrSubobjHdrStartOfLifeDate,
  _purord.AccrSubobjHdrEndOfLifeDate AS AccrSubobjHdrEndOfLifeDate,
  cast(PlannedCostInTransCrcy as fac_poac_rvw_wf_plnd_cost_wcur) AS PlannedCostInTransCrcy,
  cast(AdjustedCostInTransCrcy as fac_poac_rvw_wf_adjstd_cost) AS AdjustedCostInTransCrcy,
  ActualCostInTransCrcy,
  DeferredCostInTransCrcy,
  RecognizedCostInTransCrcy,
  DeferralItemType,
  AccrualAmtInTransCrcy,
  cast(_purord.PurchasingDocumentItem as fac_poac_rvw_wf_ebelp) AS PurchasingDocumentItem,
  _purord.ProductType AS ProductType,
  _purord.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  _purord.MaterialGroup AS MaterialGroup,
  _purord.Material AS Material,
  cast(_purord.TotalAccrualQuantity as fac_poac_rvw_wf_total_quantity) AS TotalAccrualQuantity,
  cast(_purord.NetPriceQuantity as fac_poac_rvw_wf_epein) AS NetPriceQuantity,
  _purord.ServicePerformer AS ServicePerformer,
  cast (_purord.AccountAssignmentNumber as fac_poac_rvw_wf_dzekkn) AS AccountAssignmentNumber,
  _purord.StandardPurchaseOrderQuantity AS StandardPurchaseOrderQuantity,
  cast(_purord.MultipleAcctAssgmtDistrPercent as multipleacctassgmtdistrpercent) AS MultipleAcctAssgmtDistrPercent,
  _purord.CostCenter AS CostCenter,
  _purord.GLAccount AS GLAccount,
  _purord.InternalOrder AS InternalOrder,
  _purord._WBSElement.WBSElement AS WBSElement,
  _purord.UnloadingWarehouseStagingArea AS UnloadingWarehouseStagingArea,
  _purord.GoodsRecipientName AS GoodsRecipientName,
  _purord.UnitOfMeasure AS UnitOfMeasure,
  _purord.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _purord.PurchaseOrderItemCurrency AS PurchaseOrderItemCurrency,
  _purord.TransactionCurrency AS TransactionCurrency,
  _purord.CompanyCodeCurrency AS CompanyCodeCurrency,
  _purord.AccrObjectLastChangeDateTime AS AccrObjectLastChangeDateTime,
  _purord._PurgDocTypeTxt[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _FiscalYearPeriod.FiscalPeriod AS FiscalPeriod,
  _FiscalYearPeriod.FiscalYear AS FiscalYear,
  _purord._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _purord._Supplier.AuthorizationGroup AS AuthorizationGroup,
  AdjmtAccrAmtInTransCrcy,
  cast(1 as ace_per_accr_amnt_wcurr) AS OriginalAccrAmtInTransCrcy,
  AccrualItemETag,
  PlannedAccrualItemETag,
  ActualAccrualItemETag,
  AccrualAmountAdjustedByUser,
  AccrualAmountAdjustmentDate,
  AccrualAmountAdjustmentTime,
  AccrualAmountReviewStatus,
  AccrualAmountIsReviewed,
  AccrualPostingReviewType,
  ReviewedByUser,
  cast (concat(AmountReviewDate,AmountReviewTime) as abap.char(14) ) AS AmountReviewDate
FROM I_PurchaseOrderAccrual
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccrualItemType AS _ItemType ON AccrualEngineApplication = _ItemType.AccrualObjectType AND AccrualItemType = _ItemType.AccrualItemType  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalYearPeriod ON CompanyCode = _FiscalYearPeriod.CompanyCode AND AccrualPeriodEndDate > _FiscalYearPeriod.FiscalPeriodStartDate AND AccrualPeriodEndDate <= _FiscalYearPeriod.FiscalPeriodEndDate  -- association [1..1]
LEFT OUTER JOIN I_AccrItemTypeForLedgerGroup AS _itemtypel ON AccrualEngineApplication = _itemtypel.AccrualEngineApplication AND CompanyCode = _itemtypel.CompanyCode AND AccrualItemType = _itemtypel.AccrualItemType AND Ledger = _itemtypel.Ledger  -- association [1..1]
;