Track SAP sales scheduling agreements, with their schedule lines and billing plans, straight from...
Customer Master Financial by Tables
Previous
Next
Financial data from the SAP customer master, covering company code data, bank details, payment history and dunning, is modeled here on SAP tables for SAP ECC & SAP S/4HANA. It reads KNB1 (company code data), KNBK (bank details), KNB4 (payment history) and KNB5 (dunning data), all linked to the general customer record.
New, changed and blocked customers are captured in real time through RAP event I_BUSINESSPARTNERTP_2 or BOR event BUS1006. The ready-to-use Excel template maps these relationships and can be extended with your own Z tables.
TECHNICAL SPECIFICATIONS
| Business Area | Sales |
|---|---|
| Compatible with | SAP ECC & SAP S/4HANA |
| Integration Mode | Real-Time |
| Triggering Event | BOR Event BUS1006 RAP Event I_BUSINESSPARTNERTP_2 |
| Actions | Create/Update/Block |
| Data Type | Master 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 Customer Master Financial 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 Customer Master Financial tables and their definitions, helping you assess data availability upfront to streamline your customization and deployment strategy.
|
Table Name |
Table Description |
|
KNA1 |
General Data in Customer Master |
|
KNB1 |
Customer Master (Company Code) |
|
KNBK |
Customer Master (Bank Details) |
|
KNB4 |
Customer Payment History |
|
KNB5 |
Customer master (dunning data) |
PRODUCT DOCUMENTS
OTHER PRODUCTS FROM SAME CATEGORY
Get delivery notes out of SAP ECC and SAP S/4HANA in real time, read directly from the physical...
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...