Track SAP sales scheduling agreements, with their schedule lines and billing plans, straight from...
Delivery Note by Tables
Previous
Next
Get delivery notes out of SAP ECC and SAP S/4HANA in real time, read directly from the physical delivery tables. The model links LIKP header data and LIPS items with sales document flow, warehouse quants, LTAP transfer order items, serial numbers, material valuation and MARD storage location stock.
Creates, updates and deletes are detected through BOR event LIKP or RAP event R_OUTBOUNDDELIVERYTP. The product ships as a ready-to-use Excel template that maps the delivery logic and table relationships, and you can extend it with Z tables or custom CDS views.
TECHNICAL SPECIFICATIONS
| Business Area | Sales |
|---|---|
| Compatible with | SAP ECC & SAP S/4HANA |
| Integration Mode | Real-Time |
| Triggering Event | BOR Event LIKP RAP Event R_OUTBOUNDDELIVERYTP |
| Actions | Create/Update/Delete |
| Data Type | Transactional Data |
DESCRIPTION
DATA PRODUCT ASSET DETAILS
Turn complex SAP structures into actionable data streams in minutes. Our Foundational Data Product provides a ready-to-use Excel template containing all necessary Delivery Document logic and table relationships.
Simply load, adjust, and save.
DATA PRODUCT SOURCE TABLES
Gain immediate visibility into the specific SAP tables included in this Data Product. This section outlines the core Delivery Note tables and their definitions, helping you assess data availability upfront to streamline your customization and deployment strategy.
|
Table Name |
Table Description |
|
LIKP |
SD Document: Delivery Header Data |
|
LIPS |
SD document: Delivery: Item data |
|
VBFA |
Sales Document Flow |
|
LQUA |
Quants |
|
LTAP |
Transfer order item |
|
SER01 |
Document Header for Serial Numbers for Delivery |
|
MBEW |
Material Valuation |
|
MARD |
Storage Location Data for Material |
PRODUCT DOCUMENTS
OTHER PRODUCTS FROM SAME CATEGORY
Sales contracts and their billing plans are captured in real time from the SAP ECC and SAP...
Move sales quotations from SAP ECC and SAP S/4HANA into your data pipelines in real time, read...
Billing documents and their accounting entries are extracted from SAP ECC and SAP S/4HANA tables...
For credit memo documents in SAP ECC & SAP S/4HANA, this model joins the billing tables VBRK and...
Read returns orders straight from the SAP sales document tables, on SAP ECC as well as SAP...
Based on the core customer tables of SAP ECC & SAP S/4HANA, the Customer Master data product...
Sales orders from SAP ECC and SAP S/4HANA, taken from the core sales document tables, reach...
From the sales document tables VBAK, VBAP, VBPA and VBKD, the Debit Memo Request data product...