ISU | FICA – BW Reports on BP Items and Open Items Data flow

Introduction

Few years back when I started with my SAP IS-U/BW support project, I was not aware of the Invoicing/ FICA process and the main use of special ISU/FICA specific ECC extractors (Business Partner Items and Open Items).

I have tried to depict a pictorial representation of how FICA document is generated and its underlying tables updated with FICA document and a few BW reports that can be created from the BP Items and Open Items Dataflow.

Functional Flow Chart – FICA document Creation

Technical Dataflow and TablesFI-CA Business Partner Items flow (0FC_BP_ITEMS) – Delta 

• AR by GL Account – Daily Report – AR balances is displayed for respective G/L Account and Clearing Period (Aging buckets) as on daily basis. Aging buckets basically shows the Open AR (Accounts Receivable) for days interval.Aging buckets are calculated based on Clearing Date and Net Due date with Offset

• • Report Filter:
    • Statistical Key = blank
    • Clear Date = blank
    • Report is executed for a system date (Current day)
  • Dimension:
    • G/L Account
  • Key Figure:
    • Aging Buckets – Current,1-30, 31-60, 61-90, 91-180, >=181
    • Total AR (sum of all Aging buckets)
  • Reconciliation – ECC vs BW/BI
    • Tcode – FPO2 – OI Balance
    • Report Field – Total AR

• Open A/R on Active Customer’s-Daily Report – AR balances is displayed for active contract account and AR Aging buckets.

  • Report Filter:
    • Statistical Key = blank
    • Clear Date = blank
    • Report is executed for a system date (Current day)
    • Contract Account Status = ‘Active’ (this is derived based on Contract Move Out Date)
  • Dimension:
    • Contract Account, ADID
  • Key Figure:
    • Current,1-30, 31-60, 61-90, 91-180, >=181
    • Total AR (sum of all Aging buckets)

• Open A/R on Final Customer’s – Daily Report – AR balances is displayed for Final CA and AR Aging buckets. Final Customers are move-out contracts.

  • Report Filter:
    • Statistical Key = blank
    • Clear Date = blank
    • Report is executed for a system date (Current day)
    • Contract Account Status = ‘Inactive’ (this is derived based on Contract Move Out Date)
  • Dimension:
    • Contract Account, ADID
  • Key Figure:
    • Current,1-30, 31-60, 61-90, 91-180, >=181
    • Total AR (sum of all Aging buckets)

FI-CA Open Items at Key Date flow (0FC_OP_01) – Full

• AR Detail at Key Date – Month End Report – AR balances is displayed for respective G/L Account and Clearing Period (Aging buckets).
  • Report Filter:
    • Statistical Key = blank
    • Report is executed for KeyDate (Snapshot Date)
  • Dimension:
    • G/L Account
    • Clearing Period (difference value derived by KeyDate (Extraction Date/Snapshot Date) and Due Date from DFKKOP)
  • Key Figure:
    • Amount

• AR Detail at Key Date by Customer – Month End Report– AR balances is displayed for Customer

  • Report Filter:
    • Statistical Key = blank
    • Report is executed for KeyDate (Snapshot Date)
  • Dimension:
    • G/L Account
    • Contract Account
    • Clearing Period (difference value derived by KeyDate (Extraction Date/Snapshot Date) and Due Date from DFKKOP)
  • Key Figure:
    • Amount

Conclusion

This post is helpful for BW consultants who are new to SAP ISU/FICA. This post not only displays the report layout and fields it also includes report objective, report filter, dimension and keyfigures.