A customer faced challenges using SAP's append-only transaction table for inflight orders, overlooking the complexities of multi-stage fulfillment, refunds, and corrections. Our team developed an upstream system that accounted for these intricacies, dynamically bridging with SAP’s storage. Additionally, we streamlined their order-item and multi-location inventory into a single table within SAP while preserving traceability, delivering a solution that enhanced efficiency and maintained data integrity.