Flat File Upload Planning Function populates extra filed (information) without client input.
In BPC 10.1 Embedded version / SAP BW HANA (PAK), it is frequently required to upload data in Planning Cube. During runtime, we can populate more field comparing different logic. With a help of BADI, we can achieve the same. This document will describe the detail procedure.
I assume that the Flat File Upload planning Function is implemented. Those who have not implemented the functionality, they can implement the note 2053696 via basis team. Without note 2053696, this standard BADI will not be present in the system.
2053696 – How-to Load a File into BW-Integrated Planning (Version 3)
In our example, we are uploading data from flat file. The planning cube has Planning Version, Fiscal Year, and Planning Year filed besides others. User will provide input Planning Version and Planning Year information from flat file interface. We will populate Fiscal year information comparing Planning Version and Planning Year information.
- If the Planning version is budget (BUD) then fiscal year is same as planning year.
- If the Planning version is Planning Year 2 (PY2) then fiscal year is same as (planning year + 1).
- If the Planning version is Planning Year 3 (PY3) then fiscal year is same as (planning year + 2).
Solution: We will achieve the same via BADI.