0FI_AP_4

Vendors: Line Items with Delta Extrcation

Datasource Function Module : BWFID_GET_FIAP_ITEM

Delta Trigger Fields
Regular update                         Minute Based Update
CPUDT ; AEDAT ;                  CPUTM ; AETIM

In the FM BWFID_GET_FIAP_ITEM, data is fetched based on CPUDT and AEDAT.
CPUDT is a field in both BSIK and BSAK, but system does not fetch data from these tables. Instead if uses tables BKPF_BSIK and BKPF_BSAK for fetching data.

AEDAT is not present in the tables. So for this field, it fetches data from BKPF_BSIK_AEDAT and BKPF_BSAK_AEDAT.

Delta Process 
AIE
Only after images are passed through this extractor. No RECORDMODE present. All entries come with new values and data gets overwritten in DSO. ( Not to be needed to be loaded to Cube directly )



Tables
BSIK : Accounting: Secondary Index for Vendors
BSAK : Accounting: Secondary Index for Vendors (Cleared Items)

Delta Pointer Table
BWOM2_TIMEST
- Do 'Initialize with Data Transfer' for delta init.

0FI_AR_4

Accounts Recievable : Line Items - Customers: Items

Tables
BSAD ( Cleared Items )
BSID ( Open Items )


Delta Pointer Table
BWOM2_TIMEST

Related T-codes :
FBL5N : This gives the data for Customer Line Item

Source Fields Link from SAP
https://help.sap.com/saphelp_nw70/helpdata/en/2f/ea8953d7363d58e10000000a174cb4/frameset.htm

0FI_AA_12

FI-AA: Posted Depreciations

It is part of Asset Accounting.
This DataSource supplies the values of depreciation postings by period. Depreciation values are simulated for periods that were not yet posted.

Base Tables
ANLP

TCode
AS03
AW01N

Delta DataTable
BWFIAA_AEDAT_TR

Delta Pointer Table
BWOM2_TIMEST
Delta for this extractor is dependent on the successful delta triggers for 0ASSET_ATTR_TEXT and 0ASSET_AFAB_ATTR. If the deltas do not get any records/pointers not updated in delta pointer table, there will be no delta records for this datasource and also, 0fi_aa_11 datasource.



Help.SAP.com : Link

ASSET extraction

SIM / FIAA_SIM field
It is the simulated field.The type of simulation depends on the following parameter maintained in the system.

Table : BWOM_SETTINGS
Param_Name : BWFIAASIM

This datasource gives the asset depreciations till current month along with simulations for the rest of the year.The simulation values get calculated on run time.

SIM = 'X' - Simulated values.
SIM = <blank> -  Real Values
SIM = 'N'. - real values -> no carryforward

When the datasource is run FULL - We get 'BLANK' values for existing values and 'X' for simulated ones.

When run DELTA, - we get  'BLANK' and 'N' values for existing and new records and 'X' for simulated. Right now, not sure on what exact difference is between the <blank> and N values, however, in the standard BI content flow given for this extractor which goes to DSO 0FIA_DS13, the N values are filtered out in the start routine.

Internal Function Modules
BWFIAA_GET_DEPR_DELTA

InfoCubes

Activating Infocubes
When data is already present in the infocube and a new field is added, data in the infocube has to be dropped and loaded ( as the cube has to adjust the dimension tables data according to the new changes). if not done , DTP would fail.

also check activation
Try RSD1 and press infocube option at the top then proceed with utilities of infocube and go for activation of infocube. A program will appear try to run that program in background which will help you in getting the infocube activation.

Or Try running the program RSDB_CUBE_ACTIVATE in background. Foreground sometimes go for time out hence it is difficult to activate in foreground.

If some error persists try using RSRV and correct the cube inconsistencies then proceed with activation of cube.

Flat Files

Points to Remember
- When loading data from a flat file, the datasource will take the default lenghts from the file. If a particular field is not populated in the flat file, it might take 1 as length , which will cause

Error
Overflow converting from on assignment field
Error 'Overflow converting from '12345'' on assignment field zfield record 9 value 12345

Reason : The type of the flat file and BW are different. change type / increase the length of the fields.
Eg : the field length is 6, but in your datasource it is type INT2 which is max of 5. Change it to INT10 or CHAR