Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

SAP BLOG AVL in SAP Central Finance

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,205
Tepki puanı
6
Screenshot-2021-03-28-at-18.21.00.png


In this blog i will be discussing about the AVL functionality in SAP Central Finance. AVL stands for “Accounting View of Logistics information”.

Accounting View of Logistics (AVL) is Central Finance-specific functionality in which logistical information is loaded and replicated from SAP source systems into Central Finance and stored in separate tables.

Benefits

  • AVL provides logistical insight in Central Finance without the need for extensive configuration and master data, customisation of data, or custom programs and tables
  • AVL helps to bridge the data gap between Finance and Logistics without the need for a custom approach or extensive configuration and helps in driving the reporting strategy
  • AVL also enables more detailed profitability analysis through the inclusion of partner functions such as Ship-to, Sold-to, and Bill-to
  • AVL facilitates Central Finance’s ability to link financial documents to their associated Purchase Orders, Sales Orders, Supplier Invoices, and Customer Invoices



Use Cases

  • Reporting integration across SD, MM, FI and CO data sets
  • Revenue Accounting
  • Central Purchase Order Accrual
  • Advanced Compliance Reporting (ACR for Tax Reporting)
  • Basis on which predictive accounting can be achieved via Central Finance



Restrictions

  • The AVL is only supported for source systems of SAP ERP 6.0 EhP3 and higher, including SAP S/4HANA systems. (Replication of purchase orders is only supported for source systems of SAP ERP 6.0 EhP4 and higher.)
  • Only one client per source system is supported in one SLT configuration.
  • Data in the AVL (except purchasing documents and data for which a mapping relationship has been maintained, for example CO-PA or WBS data) is not validated against the Customizing nor the master data in the Central Finance system, which is different from General Ledger entries in the Central Finance processing.



What is Replicated?

Document TypeTable
Customer InvoiceVBRK
Sales OrderVBAK
Supplier InvoiceRBKP
Purchase OrderEKKO



AVL Tables in SAP S/4HANA


The logistical data from the source system tables are brought into the Central Finance system and are accessible for data analysis and reporting through a series of “CFIN_AV” tables

P1-2.png


AIF Interfaces available

P2-2.png


SLT Tables & set up – EKKO, RBKP, VBAK and VBRK

P3-1.png


Now i will share end to end example of Sales order data replication and how it looks in CFIN AVL tables

Sales order created in SAP ECC (Order # 5)

P4-1.png


In ECC, VBAK table entry is visible

P5.png


Replication happens via SLT (VBLEN = 5)

P6-1.png


Item data visible in AIF

P8.png


Now we move to SAP S/4HANA 2020 and will see the data in AVL specific tables

CFIN_AV_SO_ROOT – Header Data table

P9.png


CFIN_AV_SO_ITEM – Item Data table

P10.png


CFIN_AV_SO_PART – Partner Data Table

P11.png


CFIN_AV_SO_BIZ – Business Data Table

P12.png


Now the Sales order is Delivered & billed in ECC

Document Flow is below

P13.png


Billing Document gets replicated to CFIN (VBELN = 90000001)

Interface – AV_CI (Customer Invoice)

Header Data

P14.png


Item Data

P15.png


Data in CFIN

CFIN_AV_CI_ROOT – Billing Document Header Data

P16.png


CFIN_AV_CI_ITEM – Billing Document Item Data

P17.png


CFIN_AV_CI_PART – Billing Document Partner Data

P18.png


Similarly it works for PO data and data of PO and Vendor invoice is replicated to below CFIN Tables

Replicated Business ObjectCentral Finance TableSource System Table
AVL Purchasing DocumentCFIN_AV_PO_ACCEKKN
CFIN_AV_PO_ITEMEKPO
CFIN_AV_PO_ROEKBE
CFIN_AV_PO_ROACCEKBE_MA
CFIN_AV_PO_ROOTEKKO
CFIN_AV_PO_SCHEKET
AVL Supplier InvoiceCFIN_AV_SI_ACCASRBCO
CFIN_AV_SI_GLACCRBCO
CFIN_AV_SI_ITEMRSEG
CFIN_AV_SI_ROOTRBKP



Reconciliation Reports

FINS_CFIN_DFV_AV_CI for AVL Billing Document

P19.png


P20.png


Similarly we have other reconciliation reports as below and you can see differences by field or by document numbers

  • FINS_CFIN_DFV_AV_CI for AVL Billing Document
  • FINS_CFIN_DFV_AV_SO for AVL Sales Document
  • FINS_CFIN_DFV_AV_SI for AVL Supplier Invoice
  • FINS_CFIN_DFV_AV_PO for AVL Purchasing Document

I hope this long blog gives clarity on AVL Functionality in SAP Central Finance.

Okumaya devam et...
 
Üst