R_AccrEngineAccrSubobjItemTP

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 R_AccrEngineAccrSubobjItemTP.
-- 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.

CREATE VIEW R_AccrEngineAccrSubobjItemTP AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrSubobjectItmValdtyEndDte,
  AccrualItemType AS AccrualItemTypeForEdit,
  _AccrLedgerGroup.LedgerGroup AS LedgerGroup,
  _AccrLedgerGroup.AccrPerdcPostingFrequency AS AccrPerdcPostingFrequency,
  _AccrLedgerGroup._PerdcPostgFrqcy._Text[1:Language=$session.system_language].AccrPerdcPostingFrequencyName AS AccrPerdcPostingFrequencyName,
  AccrSubobjectItmValdtyStrtDte,
  AccrualMethod,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  AccrualItemIsObsolete,
  PlanAccrualItemType,
  PlanAccrualMethod,
  ActualAccrualItemType,
  ActualAccrualMethod,
  DeferralItemType,
  DeferralMethod,
  TotalAccrualQuantity,
  TotalAccrualQuantityUnit,
  TotalAccrAmountInTransCrcy,
  TotalAccrAmtInCompanyCodeCrcy,
  TotalAccrAmountInGlobalCrcy,
  TotalAccrAmountInFreeDfndCrcy1,
  TotalAccrAmountInFreeDfndCrcy2,
  TotalAccrAmountInFreeDfndCrcy3,
  TotalAccrAmountInFreeDfndCrcy4,
  TotalAccrAmountInFreeDfndCrcy5,
  TotalAccrAmountInFreeDfndCrcy6,
  TotalAccrAmountInFreeDfndCrcy7,
  TotalAccrAmountInFreeDfndCrcy8,
  TransactionCurrency,
  cast( _CompanyCode.Currency as fins_currh preserving type ) AS CompanyCodeCurrency,
  cast( _CompanyCode._ControllingArea.ControllingAreaCurrency as fins_currk preserving type ) AS GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AccrOpngPostgDocumentType,
  AccrPerdcPostgDocumentType,
  AccrClsgPostgDocumentType,
  AccrOpngPostgAccrAccount,
  AccrOpngPostgOffstgAccount,
  AccrPerdcPostgAccrAccount,
  AccrPerdcPostgOffstgAcct,
  AccrClsgPostgAccrAccount,
  AccrClsgPostgOffstgAccount,
  AccrualItemLastChangeDateTime,
  _AccrLedgerGroup._PerdcPostgFrqcy AS _PerdcPostgFrqcy
FROM I_AccrEngineAccrSubobjItem
LEFT OUTER JOIN I_AccrEngineAccrItemType AS _AccrItemTypeForEdit ON AccrualEngineAccrualObjectType = _AccrItemTypeForEdit.AccrualEngineAccrualObjectType AND AccrualItemTypeForEdit = _AccrItemTypeForEdit.AccrualItemType  -- association [0..1]
LEFT OUTER JOIN I_AccrItemTypeForLedgerGroup AS _AccrLedgerGroup ON AccrualEngineAccrualObjectType = _AccrLedgerGroup.AccrualEngineApplication AND CompanyCode = _AccrLedgerGroup.CompanyCode AND AccrualItemType = _AccrLedgerGroup.AccrualItemType AND Ledger = _AccrLedgerGroup.Ledger  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
;