Osman Akça Sales & FOB Analysis Report.
A SAP SD commercial sales analysis report that combines sales order data, delivery status, pricing conditions, currency conversion and FOB calculations into a single operational ALV view — turning raw SAP order data into a customer, crop and product-group-based commercial performance screen.
From raw order data to commercial intelligence.
The Osman Akça Sales Report was developed to track the commercial and operational performance of sales orders in a single screen. The report works with sales organization, distribution channel, division, sales office, sales group, sales document, document date, planned delivery date, customer, material, customer material number and material group criteria.
With this development, Osman Akça sales orders can be analyzed not just with basic order information, but with customer, crop, product group, order quantity, carton count, currency, net value, sales USD, FOB amount, FOB USD and average FOB per unit — all commercial indicators in one view.
The report's most important capability is that it does not leave the financial value of a sales order as raw SAP data. At item level, pricing conditions are read, net/gross values are calculated, freight and insurance conditions are separated, the FOB amount is derived and the relevant currency is converted to USD — giving the user a comparable commercial view across all orders.
Why it was built.
Sales orders existed in SAP, but commercial insight did not.
The business unit didn't just need to know "is there an order?" — they needed to see which customer, which crop, which product group is generating how much revenue. What's the net value? What's it in USD? What's the real FOB amount after freight and insurance deductions? Which orders are fully shipped and which have remaining balance? None of this was available in a single view — it required jumping between transactions and manual calculations.
A commercial analysis view inside SAP.
The report consolidates sales order, customer, material, delivery, pricing condition and exchange rate data into a single ALV screen. It calculates shipped and remaining quantities, net and gross values, sales USD, FOB amount, FOB USD and average FOB per unit — enabling customer-, crop- and product-group-based commercial performance analysis. Different currencies become comparable in USD, and the ALV supports grouping, subtotals and VA03 navigation.
What the report does.
Order consolidation, delivery tracking, pricing analysis, FOB calculation, currency conversion and authorization-aware commercial field control.
Sales order consolidation
VBAK/VBAP header and item data combined with customer, partner, material, payment term and shipping information into a unified dataset.
Delivery tracking
LIPS/LIKP-based shipped quantity, remaining quantity and delivery date tracking — with radio-button filters for fully shipped, partially shipped or all orders.
Pricing condition analysis
PRCD_ELEMENTS-based reading of list price, manual price, gross price, net price, net value and gross value — with freight and insurance condition separation.
FOB calculation
FOB amount derived by subtracting freight and insurance pricing conditions from the sales order item value — per line item, not as an aggregate estimate.
USD currency conversion
TCURR-based exchange rate conversion using customer reference date — EUR, TRY and other currencies converted to USD for management-level comparability.
Grouped ALV output
Material group subtotals in KG, USD, EUR and TRY. Layout variant support, highlighted columns, and sales document hotspot navigation to VA03.
Authorization control
Authorization-based hiding of sensitive commercial fields — pricing columns are only visible to users with the appropriate authorization objects.
Average FOB per unit
Per-item FOB USD divided by quantity — the $ FOB ORT. column gives an instant unit-level profitability indicator for each order line.
Multi-currency group totals
Material group subtotals across KG, EUR, TRY and USD — enabling direct management-level currency comparison without manual aggregation.
Selection screen, ALV output.
Selection screen — entry filters
SAP GUI
ALV output — commercial sales analysis
SAP GUIHow data becomes insight.
The report turns SAP sales order data into a commercial analysis view by combining order quantities, delivery status, pricing conditions, currency conversion and FOB profitability indicators in a single ALV screen.
— Project summaryWhat I built.
From selection screen and data consolidation through pricing analysis, FOB derivation, currency conversion and authorization-controlled ALV output.
- Custom SAP SD sales report — developed the full report for Osman Akça sales order commercial analysis.
- Selection screen — organization, sales document, customer, material, delivery date and layout variant filters.
- Data consolidation — sales order header/item data combined with customer, material, partner, payment term and shipping information.
- Delivery integration — shipped quantity, remaining quantity and delivery performance calculated from LIPS/LIKP data.
- Pricing condition reading — list price, manual price, gross price, net price, net value and gross value from PRCD_ELEMENTS.
- FOB calculation — freight and insurance conditions subtracted at item level to derive the true FOB amount.
- USD conversion — sales and FOB values converted to USD via TCURR exchange rate logic using customer reference date.
- Turnover & average FOB — balance turnover, actual turnover, FOB USD and average FOB per unit calculated per line.
- ALV output features — layout variants, grouped totals, highlighted columns and sales document hotspot navigation to VA03.
- Authorization control — sensitive commercial pricing fields hidden based on user authorization objects.
- Material group subtotals — KG, EUR, TRY and USD subtotals per material group with ALV subtotaling across all currency columns.
- Crop-level tracking — customer material reference and crop field integrated for product-level commercial breakdown across customers.
The impact.
Sales orders became trackable in a single screen by customer, crop and material group. Net value, sales USD, FOB amount and FOB USD eliminated the need for manual commercial calculations. Freight and insurance deductions are computed at item level, giving a more realistic FOB analysis. Orders in different currencies are comparable in USD. Shipped and remaining quantities are separated, making operational tracking straightforward. Users save their own ALV layouts, and VA03 hotspot navigation gives instant access to order details.
See the other flagship deliveries.
This is one of the featured SAP developments. Explore the Osman Akça logistics platform, IKEA SPI forecast suite, QM Power BI analytics, Terbiye Kalite quality report and the power of attorney lifecycle management system.