I_AnalyzeAccrualPosting

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_AnalyzeAccrualPosting.
-- 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: IANALACCRPOSTG

CREATE VIEW I_AnalyzeAccrualPosting AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  AccountingDocumentType,
  AccountingDocCreatedByUser,
  PostingDate,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  BusinessTransactionType,
  CompanyCodeCurrency,
  AmountInGlobalCurrency,
  GlobalCurrency,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency1,
  _CurrencyRoles.GlobalCurrencyRole AS GlobalCurrencyRole,
  _CurrencyRoles.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  cast( _CurrencyRoles._GlobalCurrencyRole._Text[1: Language = $session.system_language].CurrencyRoleName as fis_gc_currole_name preserving type) AS GlobalCurrencyRoleName,
  cast( _CurrencyRoles._FreeDefinedCurrency1Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc1_currole_name preserving type ) AS FreeDefinedCurrency1RoleName,
  CreationDate,
  TransactionCurrency,
  SenderCompanyCode,
  FiscalPeriod,
  DocumentDate,
  AccountingDocumentCategory,
  ReferenceDocumentType,
  ReferenceDocument,
  IsReversal,
  IsReversed,
  ReversalReferenceDocument,
  OriginSenderObject,
  AccrualObjectLogicalSystem,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  GLAccount,
  _GLAccountInCompanyCode._Text[1: Language = $session.system_language].GLAccountName AS GLAccountName,
  OffsettingAccount,
  CostCenter,
  ProfitCenter,
  PostingKey,
  SubLedgerAcctLineItemType,
  ReferenceDocumentItemGroup,
  JrnlEntrShiftedFYConsecutiveID,
  FinancialAccrualTransacType,
  FinancialTransactionType,
  FinancialTransactionTypeName,
  FinancialAccrTransacTypeName,
  GLAccountLineItemIsAccrual,
  FinancialAccountType,
  FiscalYearPeriod,
  BusinessArea,
  Segment,
  Supplier,
  Customer,
  GLAccountType,
  _GLAccountInCompanyCode.AuthorizationGroup AS GLAccountAuthorizationGroup,
  _Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _AccountingDocumentType.AuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  FiscalYearVariant,
  FunctionalArea,
  LastChangeDateTime,
  CreationDateTime,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  PurchasingDocument,
  PurchasingDocumentItem,
  Product,
  Plant,
  TaxCode,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  AccountAssignmentNumber,
  DocumentItemText,
  AccountAssignment,
  AccountAssignmentType,
  cast(_AccountAssignment.SalesOrder as kdauf preserving type) AS SalesOrder,
  cast(_AccountAssignment.SalesOrderItem as kdpos preserving type) AS SalesOrderItem,
  cast(_AccountAssignment.SalesOrder as vbeln_va preserving type) AS SalesDocument,
  cast(_AccountAssignment.SalesOrderItem as posnr_va preserving type) AS SalesDocumentItem,
  CostOriginGroup,
  OrderID,
  OrderCategory,
  cast( _AccountAssignment.WBSElementInternalID as fis_wbsint_no_conv preserving type) AS WBSElementInternalID,
  Project,
  ProjectInternalID,
  WorkPackage,
  ProjectNetwork,
  RelatedNetworkActivity,
  ServiceDocument,
  ServiceDocumentType,
  BusinessProcess,
  CostObject,
  ChartOfAccounts,
  _AccountAssignment._WBSElement.WBSDescription AS WBSDescription,
  _AccountAssignment._WBSElement.WBSElementExternalID AS WBSElementExternalID,
  AccrualValueDate,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  AssignmentReference,
  _CurrentProfitCenter.ProfitCtrResponsibleUser AS ProfitCtrResponsibleUser,
  _CostCenter._Text[1: Language = $session.system_language].CostCenterName AS CostCenterName,
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  _AccrualSubobject.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  _AccrualSubobject.AccrualObjectInternalID AS AccrualObjectInternalID,
  _AccrualSubobject.AccrualSubobjectInternalID AS AccrualSubobjectInternalID,
  _AccrualSubobject.AccrSubobjPauseDate AS AccrSubobjPauseDate,
  _AccrualSubobject.AccrSubobjSuspensionDate AS AccrSubobjSuspensionDate,
  _AccrualSubobject.AccrSubobjPrematureFinishDate AS AccrSubobjPrematureFinishDate,
  _AccrualSubobject.AccrSubobjectLifeCycleStatus AS AccrSubobjectLifeCycleStatus,
  _AccrualSubobject.AccrSubobjHdrStartOfLifeDate AS AccrSubobjHdrStartOfLifeDate,
  _AccrualSubobject.AccrSubobjHdrEndOfLifeDate AS AccrSubobjHdrEndOfLifeDate,
  _AccrualSubobject.AccrualSubobjectCreatedByUser AS AccrualSubobjectCreatedByUser,
  _AccrualSubobject._CreatedByUser.UserDescription AS AccrSubobjectCreatedByUserName,
  _AccrualSubobject.AccrualSubobjectCreationDate AS AccrualSubobjectCreationDate,
  _AccrualSubobject.AccrualSubobjectCreationTime AS AccrualSubobjectCreationTime,
  _AccrualSubobject.AccrSubobjLastChangedByUser AS AccrSubobjLastChangedByUser,
  _AccrualSubobject._LastChangedByUser.UserDescription AS AccrSubobjLastChgdByUserName,
  _AccrualSubobject.AccrualSubobjectLastChangeDate AS AccrualSubobjectLastChangeDate,
  _AccrualSubobject.AccrualSubobjectLastChangeTime AS AccrualSubobjectLastChangeTime,
  cast( 0 as fac_ace_postg_subobj_timestamp ) AS AccrSubobjLastChangeDateTime,
  cast( '00000000' as ace_dateto) AS AccrSubobjectItmValdtyEndDte,
  cast( '00000000' as ace_datefrom) AS AccrSubobjectItmValdtyStrtDte,
  cast( '' as aceds_acrmethod) AS AccrualMethod,
  cast( '' as aceds_xobsolete preserving type) AS AccrualItemIsObsolete,
  cast( '' as ace_planned_itemtype) AS PlanAccrualItemType,
  cast( '' as aceds_acrmethod_plnd) AS PlanAccrualMethod,
  cast( '' as ace_actual_itemtype) AS ActualAccrualItemType,
  cast( '' as aceds_acrmethod_actl) AS ActualAccrualMethod,
  cast( 0 as ace_total_quantity) AS TotalAccrualQuantity,
  cast( '' as ace_unit) AS TotalAccrualQuantityUnit,
  cast( 0 as ace_total_per_accr_amnt_wcurr) AS TotalAccrAmountInTransCrcy,
  cast( 0 as ace_total_per_accr_amnt_hcurr) AS TotalAccrAmtInCompanyCodeCrcy,
  cast( 0 as ace_total_per_accr_amnt_kcurr) AS TotalAccrAmountInGlobalCrcy,
  cast( 0 as ace_total_per_accr_amnt_ocurr) AS TotalAccrAmountInFreeDfndCrcy1,
  cast( 0 as ace_total_per_accr_amnt_vcurr) AS TotalAccrAmountInFreeDfndCrcy2,
  cast( 0 as ace_total_per_accr_amnt_bcurr) AS TotalAccrAmountInFreeDfndCrcy3,
  cast( 0 as ace_total_per_accr_amnt_ccurr) AS TotalAccrAmountInFreeDfndCrcy4,
  cast( 0 as ace_total_per_accr_amnt_dcurr) AS TotalAccrAmountInFreeDfndCrcy5,
  cast( 0 as ace_total_per_accr_amnt_ecurr) AS TotalAccrAmountInFreeDfndCrcy6,
  cast( 0 as ace_total_per_accr_amnt_fcurr) AS TotalAccrAmountInFreeDfndCrcy7,
  cast( 0 as ace_total_per_accr_amnt_gcurr) AS TotalAccrAmountInFreeDfndCrcy8,
  cast( '' as fins_curr2) AS FreeDefinedCurrency2,
  cast( '' as fins_curr3) AS FreeDefinedCurrency3,
  cast( '' as fins_curr4) AS FreeDefinedCurrency4,
  cast( '' as fins_curr5) AS FreeDefinedCurrency5,
  cast( '' as fins_curr6) AS FreeDefinedCurrency6,
  cast( '' as fins_curr7) AS FreeDefinedCurrency7,
  cast( '' as fins_curr8) AS FreeDefinedCurrency8,
  cast ('' as aceps_inc_blart) AS AccrOpngPostgDocumentType,
  cast ('' as aceps_per_blart) AS AccrPerdcPostgDocumentType,
  cast ('' as aceps_fin_blart) AS AccrClsgPostgDocumentType,
  cast ('' as ace_accnt_inception_accrual) AS AccrOpngPostgAccrAccount,
  cast ('' as ace_accnt_inception_offsetting) AS AccrOpngPostgOffstgAccount,
  cast ('' as ace_accnt_periodic_accrual) AS AccrPerdcPostgAccrAccount,
  cast ('' as ace_accnt_periodic_offsetting) AS AccrPerdcPostgOffstgAcct,
  cast ('' as ace_accnt_final_accrual) AS AccrClsgPostgAccrAccount,
  cast ('' as ace_accnt_final_offsetting) AS AccrClsgPostgOffstgAccount,
  cast (0 as fac_ace_postg_accritm_timestmp) AS AccrualItemLastChangeDateTime
FROM P_AnalyzeAccrualPosting
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_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CurrentProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _CurrencyRoles ON CompanyCode = _CurrencyRoles.CompanyCode AND SourceLedger = _CurrencyRoles.Ledger  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON _Ledger.Ledger = SourceLedger  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON _CostCenter.ControllingArea = ControllingArea AND _CostCenter.CostCenter = CostCenter AND _CostCenter.ValidityStartDate <= $session.system_date AND _CostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrualSubobject AS _AccrualSubobject ON AccrualObjectType = _AccrualSubobject.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrualSubobject.AccrualObjectLogicalSystem AND CompanyCode = _AccrualSubobject.CompanyCode AND AccrualObject = _AccrualSubobject.AccrualObject AND AccrualSubobject = _AccrualSubobject.AccrualSubobject  -- association [0..1]
LEFT OUTER JOIN I_PurgDocAccountAssignment AS _AccountAssignment ON PurchasingDocument = _AccountAssignment.PurchasingDocument AND PurchasingDocumentItem = _AccountAssignment.PurchasingDocumentItem AND AccountAssignmentNumber = _AccountAssignment.AccountAssignmentNumber  -- association [0..1]
;