Friday, May 8, 2009

SAP CML BI Transaction datasources

Transaction datasources: 0CML_INIT_BUDAT

You need to describe a position initialization date for the infosource with the extractor will be called. This is based on the extraction occupation module: fvd_bct_data_budat. This datasource us used ot create a position on the posting date. The system writes the positions ot the corresponding data targets.

In totalling to the position distinguishing characteristics, such as the position value date and the posting status, the local currency, position currency, nominal currency and profit/loss currency are loaded sa relating units. The postion are conclude onn the postion initial date defined iun the table bwfs-setting-oi. The position initial date is only dependent on the infosource used. This means that all selections are initialized on the same positon initial date. When generating the positions, the system only considers the flows that have a postiing date that is before or is the same as the position initial date.

The delta intilization also uses this datasource. During the delta intialization the system extracts all flows that are managed for the positon mentioned above. However, a delta initilalization is not absolutely necessary at this point. Delta update when the datasource generates a postion using delta prodedure. A delta test is possible. Delta update take place from the ods delta by entry date.

Thursday, May 7, 2009

BI_CML Functional Specifications

Overview:

The SAP CML Loans Management implementation and its component offers functions for mapping the complete loan process for loans given and loans taken, from entering data on a potential contract right through to contract disbursement and the data transfer to Financial Accounting. It incorporates complex collateral management functions, support for decision-making and a range of options for tailoring contracts.
The lifecycle of a loan is defined as the different stages a loan goes through, including loan creation, disbursements, payments, to loan closing. SAP provides status management in CML, giving the current loan status through the whole loan lifecycle. This provides the ability to track loans throughout their lifecycle.

The requirement is to get this information in a structured manner to analyze for business.

BW Objects for SAP CML:

Package-Infopackage and DTP’s will be created at the time of realization phase, but the FCC naming convention should be followed
InfoArea-0BA_CML: Core Banking Mortgage Loans
Application Component-0BA_CML: Core Banking Mortgage Loans

Data Extraction
SAP/Non SAP Datasources and source system details
· Only SAP Standard Datasource; hence the source system is SAP CML only
Master datasources: 0CHRT_ACCTS; 0COMP_CODE; 0FS_AC_REF; 0FS_CTR_NO; 0FS_FLW_TP;
Text datasources: 0CHRT_ACCTS; 0CML_PIND; 0COMP_CODE; 0FS_AC_REF; 0FS_CTR_TP; 0FS_FLW_TP
Transaction datasources: 0CML_INIT_BUDAT
This DataSource is based on the extraction function module: FVD_BCT_DATA_BUDAT