I_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 I_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.
-- SQL view name: IACESOITEMTP

CREATE VIEW I_AccrEngineAccrSubobjItemTP AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrSubobjectItmValdtyEndDte,
  cast( _AccrItemType._Text[1:Language = $session.system_language].AccrualItemTypeName as ace_itemtype_txt ) AS AccrualItemTypeName,
  AccrualItemType AS AccrualItemTypeForEdit,
  _AccrLedgerGroup.LedgerGroup AS LedgerGroup,
  _AccrLedgerGroup.AccrPerdcPostingFrequency AS AccrPerdcPostingFrequency,
  _AccrLedgerGroup._PerdcPostgFrqcy._Text[1:Language=$session.system_language].AccrPerdcPostingFrequencyName AS AccrPerdcPostingFrequencyName,
  AccrSubobjectItmValdtyStrtDte,
  AccrualMethod,
  PlanAccrualItemType,
  cast( _PlanAccrItemType._Text[1:Language = $session.system_language].AccrualItemTypeName as ace_s4_plan_itemtype_name preserving type ) AS PlanAccrualItemTypeName,
  PlanAccrualMethod,
  ActualAccrualItemType,
  cast( _ActualAccrItemType._Text[1:Language = $session.system_language].AccrualItemTypeName as ace_s4_actual_itemtype_name preserving type ) AS ActualAccrualItemTypeName,
  ActualAccrualMethod,
  _AccrMethod._Text[1:Language = $session.system_language].AccrualMethodName AS AccrualMethodName,
  DeferralItemType,
  DeferralMethod,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  AccrualItemIsObsolete,
  _AccrItemType.AccrualItemTypeIsDerived AS AccrualItemTypeIsDerived,
  TotalAccrualQuantity,
  TotalAccrualQuantityUnit,
  TotalAccrAmountInTransCrcy,
  cast( 0 as ace_total_per_accr_amnt_hcurr ) AS TotalAccrAmtInCompanyCodeCrcy,
  cast ( 0 as ace_total_per_accr_amnt_kcurr ) AS TotalAccrAmountInGlobalCrcy,
  TransactionCurrency,
  cast( _AccrCompanyCode._CompanyCode.Currency as fins_currh preserving type ) AS CompanyCodeCurrency,
  cast(_AccrCompanyCode._ControllingArea.ControllingAreaCurrency as fins_currk preserving type ) AS GlobalCurrency,
  AccrOpngPostgDocumentType,
  cast( _OpngPostgDocumentType._Text[1:Language=$session.system_language].AccountingDocumentTypeName as ace_s4_inc_blart_text preserving type ) AS AccrOpngPostgDocumentTypeName,
  AccrPerdcPostgDocumentType,
  cast( _PerdcPostgDocumentType._Text[1:Language=$session.system_language].AccountingDocumentTypeName as ace_s4_per_blart_text preserving type ) AS AccrPerdcPostgDocumentTypeName,
  AccrClsgPostgDocumentType,
  cast( _ClsgPostgDocumentType._Text[1:Language=$session.system_language].AccountingDocumentTypeName as ace_s4_fin_blart_text preserving type ) AS AccrClsgPostgDocumentTypeName,
  AccrOpngPostgAccrAccount,
  cast( _OpngPostgAccrAccount._Text[1:Language=$session.system_language].GLAccountName as ace_s4_inc_accr_accnt_text preserving type ) AS AccrOpngPostgAccrAccountName,
  AccrOpngPostgOffstgAccount,
  cast( _OpngPostgOffstgAccount._Text[1:Language=$session.system_language].GLAccountName as ace_s4_inc_offstg_accnt_text preserving type ) AS AccrOpngPostgOffstgAccountName,
  AccrPerdcPostgAccrAccount,
  cast( _PerdcPostgAccrAccount._Text[1:Language=$session.system_language].GLAccountName as ace_s4_per_accr_accnt_text preserving type ) AS AccrPerdcPostgAccrAccountName,
  AccrPerdcPostgOffstgAcct,
  cast( _PerdcPostgOffstgAccount._Text[1:Language=$session.system_language].GLAccountName as ace_s4_per_offstg_accnt_text preserving type ) AS AccrPerdcPostgOffstgAcctName,
  AccrClsgPostgAccrAccount,
  cast( _ClsgPostgAccrAccount._Text[1:Language=$session.system_language].GLAccountName as ace_s4_fin_accr_accnt_text preserving type ) AS AccrClsgPostgAccrAccountName,
  AccrClsgPostgOffstgAccount,
  cast( _ClsgPostgOffstgAccount._Text[1:Language=$session.system_language].GLAccountName as ace_s4_fin_offstg_accnt_text preserving type ) AS AccrClsgPostgOffstgAccountName,
  _AccrLedgerGroup._PerdcPostgFrqcy AS _PerdcPostgFrqcy,
  _AccrCompanyCode._CompanyCode._Currency AS _CompanyCodeCurrency,
  _AccrCompanyCode._ControllingArea._Currency AS _GlobalCurrency
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_AccrEngineAccrualSubobjectTP AS _Subobj ON AccrualEngineAccrualObjectType = _Subobj.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _Subobj.AccrualObjectLogicalSystem AND CompanyCode = _Subobj.CompanyCode AND AccrualObject = _Subobj.AccrualObject AND AccrualSubobject = _Subobj.AccrualSubobject  -- association [1..1]
LEFT OUTER JOIN I_AccrEngineAccrualObject AS _AccrObj ON AccrualEngineAccrualObjectType = _AccrObj.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrObj.AccrualObjectLogicalSystem AND CompanyCode = _AccrObj.CompanyCode AND AccrualObject = _AccrObj.AccrualObject  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrualSubobject AS _AccrSubobj ON AccrualEngineAccrualObjectType = _AccrSubobj.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrSubobj.AccrualObjectLogicalSystem AND CompanyCode = _AccrSubobj.CompanyCode AND AccrualObject = _AccrSubobj.AccrualObject AND AccrualSubobject = _AccrSubobj.AccrualSubobject  -- association [0..1]
;