Price-Restricted Invoice Reporting in SAP.
A controlled operational invoice view that separates document visibility from commercial price visibility — giving operational users access to invoice, export and e-document data while keeping net values, FOB/CIF amounts and pricing fields completely out of view.
Five reports, one order-to-export chain.
ZSD_041
Sales & FOB Report — order, FOB, USD. Authorized users.
ZSD_042
Delivery & E-Doc Report — delivery, batch, e-documents.
ZSD_043
Invoice & Export Report — billing, CIF/FOB. Authorized users.
ZSD_044
Export Logistics Report — shipment, ports, weight, freight.
ZSD_045
Price-Restricted Invoice Report — invoice & e-docs without pricing. All operational users.
Controlled invoice visibility for operational users.
The Price-Restricted Invoice Report was developed for users who need to follow the invoice and export documentation process but must not have access to sensitive commercial pricing data. The report provides invoice, sales order, delivery, customer, material, e-invoice, e-delivery note, export file, GTIP, customs, due date, packaging, crop, lot and agency information — without any net value, FOB/CIF, freight, insurance, unit price or currency amount fields.
With this development, commercial sensitivity in the full invoice report was separated by user group. Finance and authorized sales users continue using the detailed priced report, while operational, export, document tracking or logistics users can follow the invoice process without accessing pricing fields.
User-level access is determined via the ZSD_010_T_UNAME
authorization table, which controls the mv_run
flag at runtime. The same invoice data foundation is reused,
but all commercial amount columns are excluded from the
operational user view — making this controlled invoice
visibility by design, not just by hiding columns.
What operational users see vs. what they don't.
- Billing document & item
- Sales order & delivery document
- E-fatura number
- E-irsaliye number
- Export file & customs office
- GTIP & customs declaration number
- Customer, country & segment
- Material, design, fabric, packaging
- Quantity & unit of measure
- Crop, lot, contract, agency
- Billing type, billing date
- Due date & days remaining
- Net value
- Unit price
- FOB amount & FOB USD
- CIF amount
- Freight amount
- Insurance amount
- Tax amount
- Currency amounts (USD / EUR / TRY)
- Gross value
- Margin-derivable price fields
Why it was built.
Not every user who needs invoice data should see pricing.
Operational, export, document tracking and logistics users need to work with the invoice and e-document process daily — checking e-fatura numbers, export file status, GTIP, customs info, delivery links and due dates. But giving these users access to the full invoice report also exposes net values, FOB/CIF amounts, freight, insurance and currency values they have no business need to see. One report was doing two jobs it shouldn't be doing together.
A separate operational invoice view with pricing by design excluded.
A dedicated report built on the same invoice data foundation — but with all commercial amount and pricing fields removed from the output. User-level access is controlled via ZSD_010_T_UNAME authorization table. Operational users get full document, e-document, export and logistics visibility. Finance and authorized users continue using the full priced report. Two reports, two roles, clean separation.
What the report does.
Invoice & e-document tracking, export compliance visibility, authorization control and document flow navigation — without commercial pricing exposure.
User-level authorization
ZSD_010_T_UNAME table-based access control — mv_run flag determines view mode at runtime, separating operational from commercial user access.
E-Fatura & E-İrsaliye
Electronic invoice and delivery note numbers visible to operational users — e-document compliance tracking without price exposure.
Export & customs fields
Export file number, GTIP, customs office and declaration number visible — operational export compliance without commercial value data.
Material & logistics detail
Material, design, fabric, packaging, crop, lot, contract and agency information — full operational context without commercial pricing fields.
Due date tracking
Due date and remaining days visible — allowing operational users to flag upcoming payment obligations without accessing commercial invoice values.
Document flow navigation
Hotspot links from invoice → VF03, delivery → VL03N and sales order → VA03 — same document navigation as the full report, no pricing trade-off needed.
I created a price-restricted operational invoice view to separate document visibility from commercial price visibility — two reports, two roles, clean separation.
— Project summaryWhat I built.
Authorization-controlled reporting with shared data foundation, clean field separation and role-based visibility by design.
- Price-restricted SAP invoice report — developed operational invoice tracking without commercial pricing exposure.
- User-level authorization — ZSD_010_T_UNAME table controls mv_run flag to determine view mode at runtime.
- Shared data foundation — reused the invoice reporting data model while separating commercial visibility from operational visibility.
- Selection screen — company code, sales org, billing document, delivery, sales order, billing type, billing date, e-invoice, customer, material, goods issue date.
- Non-price field consolidation — quantity, unit, customer, material, export declaration, due date, e-document numbers, packaging, crop, lot, agency.
- E-Fatura & E-İrsaliye — electronic document numbers linked to invoice items for e-document compliance tracking.
- Export & customs fields — export file, GTIP and customs declaration number included without commercial values.
- Document navigation — hotspot links to VF03, VL03N and VA03 for full document flow access.
- Summary popup & editable fields — invoice summary for selected rows, controlled description field save with authorization logic.
- ALV output — layout variants, optimized field catalog labels and controlled toolbar behavior.
The impact.
Sensitive pricing fields are no longer accessible to user groups who have no business need for them. Operational, export, document tracking and logistics users can follow the invoice and e-document process completely — e-fatura, e-irsaliye, export file, GTIP, customs, delivery, material and due date — without seeing net value, FOB/CIF, freight, insurance or any commercial amount. The full priced invoice report remains for authorized finance and sales users. Two reports, two roles, clean separation — role-based data visibility built into the reporting architecture.
See the full Osman Akça suite.
This price-restricted report is the fifth piece of the Osman Akça SD reporting suite — an end-to-end SAP SD reporting package covering sales orders, deliveries, invoices, e-documents, export documentation, shipment logistics and role-based data access.