Your spend dashboard undercounts capitalized costs; how do you root-cause the issue using SAP/BW data?
Use the supplied SAP FI, asset-posting, and BW spend data. Reconcile posted, non-reversed capitalized amounts by company code and fiscal period, then identify whether each discrepancy is caused by missing BW records, invalid BW inclusions, or both.
| Column | Type | Description |
|---|---|---|
| sap_doc_idPK | INT | SAP FI document identifier |
| company_code | VARCHAR(10) | SAP company code |
| fiscal_year | INT | Fiscal year |
| fiscal_period | INT | Fiscal period from 1 through 12 |
| doc_type | CHAR(2) | SAP FI document type |
| posting_date | DATE | FI posting date |
| reversal_doc_id | INT | Reversal document identifier when the document was reversed |
| Column | Type | Description |
|---|---|---|
| asset_posting_idPK | INT | Asset posting identifier |
| sap_doc_id | INT | Related SAP FI document |
| asset_id | INT | Fixed asset identifier |
| capitalization_amount | NUMERIC(14,2) | Amount posted to the asset |
| posting_status | VARCHAR(20) | Asset posting status |
| Column | Type | Description |
|---|---|---|
| bw_row_idPK | INT | BW fact row identifier |
| sap_doc_id | INT | SAP document identifier loaded into BW |
| company_code | VARCHAR(10) | BW company code |
| fiscal_year | INT | Fiscal year |
| fiscal_period | INT | Fiscal period |
| cost_center | INT | BW cost center |
| amount | NUMERIC(14,2) | Spend amount loaded into BW |
| capitalization_flag | CHAR(1) | BW indicator for capitalized spend |