I_AnalyzeAccrPostgVislFltr

DDL: I_ANALYZEACCRPOSTGVISLFLTR SQL: IANALACEVISFLT Type: view COMPOSITE
55 Fields 1 Data Sources 2 Associations

Analyze Accrual Posting Visual Filter

I_AnalyzeAccrPostgVislFltr is a Composite CDS View that provides data about "Analyze Accrual Posting Visual Filter" in SAP S/4HANA. It reads from 1 data source (I_AccrualLineItem) and exposes 55 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AccrualLineItem I_AccrualLineItem from

Parameters (3)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency
P_ExchangeRateType kurst
P_ProcessingStartDate vdm_v_key_date

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FiscCalendarDateForCompCode _FiscalPeriodEnd _FiscalPeriodEnd.CompanyCode = $projection.CompanyCode and _FiscalPeriodEnd.CalendarDate = $session.system_date
[1..1] I_FiscCalendarDateForCompCode _FiscalPeriodStart _FiscalPeriodStart.CompanyCode = $projection.CompanyCode and _FiscalPeriodStart.CalendarDate = :P_ProcessingStartDate

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IANALACEVISFLT view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Analyze Accrual Posting Visual Filter view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger Ledger Ledger
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
PostingDate PostingDate Posting Date for GR
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
BusinessTransactionType BusinessTransactionType Bus.transaction
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CreationDate CreationDate Time Stamp
TransactionCurrency TransactionCurrency Transaction Currency
SenderCompanyCode SenderCompanyCode Sender Company Code
FiscalPeriod FiscalPeriod Tax period
DocumentDate DocumentDate Journal Entry Date
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
OriginSenderObject OriginSenderObject
AccrualObjectType AccrualObjectType Accrual Object Type
AccrualObject AccrualObject External Reference of Accrual Object
AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
AccrualItemType AccrualItemType Accrual Item Type
GLAccount GLAccount General Ledger
OffsettingAccount OffsettingAccount Offsetting Acct
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
PostingKey PostingKey Posting Key
DisplayCurrency
CompanyCodeName
GLAccountType GLAccountType G/L Account Type
SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
GLAccountLineItemIsAccrual GLAccountLineItemIsAccrual
FiscalYearPeriod FiscalYearPeriod Period/Year
FinancialAccrualTransacType FinancialAccrualTransacType
FinancialAccrTransacTypeName FinancialAccrTransacTypeName
ReferenceDocumentItemGroup ReferenceDocumentItemGroup Reference Document Item Group
FinancialAccountType FinancialAccountType Fin. Account Type
BusinessArea BusinessArea Business Area
FunctionalArea FunctionalArea Sendr Fctl Area
Segment Segment Segment number
GLAccountAuthorizationGroup GLAccountAuthorizationGroup
SupplierFinsAuthorizationGrp SupplierFinsAuthorizationGrp
CustomerFinsAuthorizationGrp CustomerFinsAuthorizationGrp
SupplierAccountGroup SupplierAccountGroup Account group
CustomerAccountGroup CustomerAccountGroup Account group
AcctgDocTypeAuthorizationGroup AcctgDocTypeAuthorizationGroup
ControllingArea ControllingArea Controlling Area
ProfitCtrResponsibleUser ProfitCtrResponsibleUser User Responsible

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_AnalyzeAccrPostgVislFltr.
-- 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: IANALACEVISFLT
-- Parameters: P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst, P_ProcessingStartDate : vdm_v_key_date

CREATE VIEW I_AnalyzeAccrPostgVislFltr AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  AccountingDocumentType,
  AccountingDocCreatedByUser,
  PostingDate,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  BusinessTransactionType,
  CompanyCodeCurrency,
  CreationDate,
  TransactionCurrency,
  SenderCompanyCode,
  FiscalPeriod,
  DocumentDate,
  AccountingDocumentCategory,
  ReferenceDocumentType,
  ReferenceDocument,
  IsReversal,
  IsReversed,
  ReversalReferenceDocument,
  OriginSenderObject,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  GLAccount,
  OffsettingAccount,
  CostCenter,
  ProfitCenter,
  PostingKey,
  :P_DisplayCurrency AS DisplayCurrency,
  '' AS CompanyCodeName,
  GLAccountType,
  SubLedgerAcctLineItemType,
  GLAccountLineItemIsAccrual,
  FiscalYearPeriod,
  FinancialAccrualTransacType,
  FinancialAccrTransacTypeName,
  ReferenceDocumentItemGroup,
  FinancialAccountType,
  BusinessArea,
  FunctionalArea,
  Segment,
  GLAccountAuthorizationGroup,
  SupplierFinsAuthorizationGrp,
  CustomerFinsAuthorizationGrp,
  SupplierAccountGroup,
  CustomerAccountGroup,
  AcctgDocTypeAuthorizationGroup,
  ControllingArea,
  ProfitCtrResponsibleUser
FROM I_AccrualLineItem
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS _FiscalPeriodEnd ON _FiscalPeriodEnd.CompanyCode = CompanyCode AND _FiscalPeriodEnd.CalendarDate = $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS _FiscalPeriodStart ON _FiscalPeriodStart.CompanyCode = CompanyCode AND _FiscalPeriodStart.CalendarDate = :P_ProcessingStartDate  -- association [1..1]
;

Learn More