0FI_GL_14

Base Tables

BKPF           - Accounting Document Header

BSEG          - Accounting Document Segment

FAGLFLEXA - General Ledger: Actual Line Items

TCode

FBL3N    - GL Account Line Item Display

FAGLF03 - Comparision : Documents/Transaction Figures ( not sure how to use )  

Notes

This extractor gets data from FAGLFLEXA and BSEG tables.

Below is the query used in the extractor to fetch data.

SELECT a~PPRCTR a~SFAREA a~RASSC a~PSEGMENT a~TSL a~HSL a~KSL a~OSL a~MSL a~WSL a~DRCRK a~POPER
a~RWCUR a~GJAHR a~BUDAT a~BELNR a~BUZEI a~BSCHL a~BSTAT a~TIMESTAMP 
b~BUKRS b~BLART b~BLDAT b~MONAT b~CPUDT b~XBLNR b~WAERS b~GLVOR b~AWKEY b~FIKRS b~HWAER
b~HWAE2 b~HWAE3 b~AWSYS b~LDGRP b~KURSF

( FAGLFLEXA AS a  INNER JOIN BKPF as b  
on b~bukrs = a~rbukrs 
and b~belnr  = a~belnr 
and b~gjahr  = a~gjahr 
and b~mandt  = a~rclnt )

and the items from selection screen - The RLDNR is always '0L'
    ( a~DOCNR                        EQ '2400018785' )
AND ( a~RLDNR                        EQ '0L' )
AND ( a~RCLNT                        EQ '100' )
AND ( b~MANDT                        EQ '100' )

Delta Pointer Table

ROOSGENDLM

The pointer in this table can be changed using FM

Points to consider

When the infopackage is run with the option 'Initialization with out data transfer' - the pointer in RSA7 is not set.The entry is present, but when the pointer is checked, it shows as blank. So, for this datasource, if we want to initializae, we need to check the option 'Initialization with data transfer' .