FACRA_PURORDACCRSMASSREVIEW

DDL: FACRA_PURORDACCRSMASSREVIEW SQL: FACRAMASSRVW Type: view Package: FI_GL_RVW_APPRV_ACCRUALS
30 Fields 1 Data Sources 3 Associations

Purchase Order Accruals Mass Review

FACRA_PURORDACCRSMASSREVIEW is a CDS View that provides data about "Purchase Order Accruals Mass Review" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderAccrual) and exposes 30 fields with key fields AccrualEngineApplication, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject. It has 3 associations to related views. Part of development package FI_GL_RVW_APPRV_ACCRUALS.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderAccrual _PurchaseOrderAccrual from

Parameters (1)

NameTypeDefault
P_KeyDate ace_period_end_date

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_AccrualItemType _itemtype $projection.AccrualEngineApplication = _itemtype.AccrualObjectType and $projection.AccrualItemType = _itemtype.AccrualItemType
[1..1] I_FiscalYearPeriodForCmpnyCode _FiscalYearPeriod $projection.FiscalYearVariant = _FiscalYearPeriod.FiscalYearVariant and $projection.CompanyCode = _FiscalYearPeriod.CompanyCode and $projection.AccrualPeriodEndDate = _FiscalYearPeriod.FiscalPeriodEndDate and _FiscalYearPeriod.IsSpecialPeriod = ''
[1..1] I_AccrSubObjItemPostedAmt _Posted $projection.AccrualEngineApplication = _Posted.AccrualEngineApplication and $projection.AccrualObjectLogicalSystem = _Posted.AccrualObjectLogicalSystem and $projection.CompanyCode = _Posted.CompanyCode and $projection.AccrualObject = _Posted.AccrualObject and $projection.AccrualSubobject = _Posted.AccrualSubobject and $projection.AccrualItemType = _Posted.AccrualItemType and $projection.Ledger = _Posted.Ledger and $projection.AccrualPeriodEndDate = _Posted.AccrualPeriodEndDate

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACRAMASSRVW view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Purchase Order Accruals Mass Review view
AbapCatalog.preserveKey true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineApplication I_PurchaseOrderAccrual AccrualEngineApplication
KEY AccrualObjectLogicalSystem I_PurchaseOrderAccrual AccrualObjectLogicalSystem Logical System
KEY CompanyCode I_PurchaseOrderAccrual CompanyCode Receiver Company Code
KEY AccrualObject I_PurchaseOrderAccrual AccrualObject External Reference of Accrual Object
KEY AccrualSubobject I_PurchaseOrderAccrual AccrualSubobject External Reference of Accrual Subobject
KEY AccrualItemType I_PurchaseOrderAccrual AccrualItemType Accrual Item Type
KEY Ledger I_PurchaseOrderAccrual Ledger Ledger
KEY AccrualPeriodEndDate I_PurchaseOrderAccrual AccrualPeriodEndDate Last Day of Period
AccrualAmountReviewStatus I_PurchaseOrderAccrual AccrualAmountReviewStatus
ReviewedAccrualItemType I_PurchaseOrderAccrual ReviewedAccrualItemType
PrpsdAccrAmtMaxClProbability I_PurchaseOrderAccrual PrpsdAccrAmtMaxClProbability
PrpsdAccrAmtIsConfirmed I_PurchaseOrderAccrual PrpsdAccrAmtIsConfirmed
AccrPrpsdRlibtyClassfctn I_PurchaseOrderAccrual AccrPrpsdRlibtyClassfctn
FiscalYear _FiscalYearPeriod FiscalYear G/L Fiscal Year
FiscalPeriod _FiscalYearPeriod FiscalPeriod Tax period
CostCenterGroup
ProfitCenterGroup
PurchaseOrder
PurchaseOrderItem
SalesOrder _purord SalesOrder SD Document
SalesOrderItem _purord SalesOrderItem Sales Order Item
CostCenter _purord CostCenter Cost Center
ProfitCenter _purord ProfitCenter Profit Center
WBSElement
Supplier _purord Supplier Supplier
ProductType _purord ProductType Product Type Group
ControllingArea I_PurchaseOrderAccrual ControllingArea Controlling Area
FiscalYearVariant I_PurchaseOrderAccrual FiscalYearVariant FY Variant
AccrualPostingReviewType
_Posted _Posted

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 FACRA_PURORDACCRSMASSREVIEW.
-- 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: FACRAMASSRVW
-- Parameters: P_KeyDate : ace_period_end_date

CREATE VIEW FACRA_PURORDACCRSMASSREVIEW AS
SELECT
  _PurchaseOrderAccrual.AccrualEngineApplication AS AccrualEngineApplication,
  _PurchaseOrderAccrual.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  _PurchaseOrderAccrual.CompanyCode AS CompanyCode,
  _PurchaseOrderAccrual.AccrualObject AS AccrualObject,
  _PurchaseOrderAccrual.AccrualSubobject AS AccrualSubobject,
  _PurchaseOrderAccrual.AccrualItemType AS AccrualItemType,
  _PurchaseOrderAccrual.Ledger AS Ledger,
  _PurchaseOrderAccrual.AccrualPeriodEndDate AS AccrualPeriodEndDate,
  _PurchaseOrderAccrual.AccrualAmountReviewStatus AS AccrualAmountReviewStatus,
  _PurchaseOrderAccrual.ReviewedAccrualItemType AS ReviewedAccrualItemType,
  _PurchaseOrderAccrual.PrpsdAccrAmtMaxClProbability AS PrpsdAccrAmtMaxClProbability,
  _PurchaseOrderAccrual.PrpsdAccrAmtIsConfirmed AS PrpsdAccrAmtIsConfirmed,
  _PurchaseOrderAccrual.AccrPrpsdRlibtyClassfctn AS AccrPrpsdRlibtyClassfctn,
  _FiscalYearPeriod.FiscalYear AS FiscalYear,
  _FiscalYearPeriod.FiscalPeriod AS FiscalPeriod,
  cast( '' as facra_cost_center_group ) AS CostCenterGroup,
  cast( '' as facra_profit_center_group ) AS ProfitCenterGroup,
  cast ( _purord.PurchasingDocument as vdm_purchaseorder preserving type ) AS PurchaseOrder,
  cast ( _purord.PurchasingDocumentItem as vdm_purchaseorderitem preserving type ) AS PurchaseOrderItem,
  _purord.SalesOrder AS SalesOrder,
  _purord.SalesOrderItem AS SalesOrderItem,
  _purord.CostCenter AS CostCenter,
  _purord.ProfitCenter AS ProfitCenter,
  _purord._WBSElement.WBSElement AS WBSElement,
  _purord.Supplier AS Supplier,
  _purord.ProductType AS ProductType,
  _PurchaseOrderAccrual.ControllingArea AS ControllingArea,
  _PurchaseOrderAccrual.FiscalYearVariant AS FiscalYearVariant
FROM I_PurchaseOrderAccrual AS _PurchaseOrderAccrual
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 FiscalYearVariant = _FiscalYearPeriod.FiscalYearVariant AND CompanyCode = _FiscalYearPeriod.CompanyCode AND AccrualPeriodEndDate = _FiscalYearPeriod.FiscalPeriodEndDate AND _FiscalYearPeriod.IsSpecialPeriod = ''  -- association [1..1]
LEFT OUTER JOIN I_AccrSubObjItemPostedAmt AS _Posted ON AccrualEngineApplication = _Posted.AccrualEngineApplication AND AccrualObjectLogicalSystem = _Posted.AccrualObjectLogicalSystem AND CompanyCode = _Posted.CompanyCode AND AccrualObject = _Posted.AccrualObject AND AccrualSubobject = _Posted.AccrualSubobject AND AccrualItemType = _Posted.AccrualItemType AND Ledger = _Posted.Ledger AND AccrualPeriodEndDate = _Posted.AccrualPeriodEndDate  -- association [1..1]
;

Learn More