Sample Request, Development and Approval Tracking App
Short answer: A custom app that creates customer sample requests in SAP as sales inquiries and moves every colour or design item through lab, colour approval, design approval, cost approval, sample production and customer approval steps. The worklist shows who holds each step and for how many days; an approved sample is turned directly into a quotation or order.
- Estimated effort
- L · 12–18 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
VA11 creates the sales inquiry, but it does not track which development step a sample is in, whose approval it waits for or how long the step has taken. Sample tracking usually runs on email and Excel lists, and the approved colour and cost information gets lost on the way to the order. The app keeps the whole flow on the SAP document with authorized step transitions.
Who uses it? Customer representatives, product development and dye lab teams, sales managers.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| VBAKSales Document Header | Sample request header: customer, sales organization, requested date | Write | ECC + S/4 |
| VBAPSales Document Item | Sample item: quality, colour/design description, quantity, status object | Write | ECC + S/4 |
| JESTIndividual Object Status | Active user status of the item (development step) | Write | ECC + S/4 |
| JCDSChange Documents for System/User Statuses | Date and user of step changes (waiting time) | Read | ECC + S/4 |
| TJ30TTexts for User Status | User status (step) names | Read | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | Read | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Sample production order | Write | ECC + S/4 |
BAPIs and functions used
- BAPI_INQUIRY_CREATEFROMDATA2Create Customer Inquiry. Creates the sample request as a sales inquiry
- STATUS_CHANGE_EXTERNSet User Status. Changes the development step (user status) of the item
- BAPI_PRODORD_CREATECreate Production Order. Creates a production order for the sample
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | Yes | 1000 |
| S_KUNNR | Customer | Range / multiple | VBAK-KUNNR | No | 200145 |
| S_ERDAT | Request date | Range / multiple | VBAK-ERDAT | No | 01.10.2026 – 16.11.2026 |
| S_ESTAT | Development step | Range / multiple | TJ30T-ESTAT | No | E0003 |
| P_MINE | Only items waiting for my approval | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Customer | VBAK-KUNNR | Yes |
| 2 | Quality | VBAP-MATNR | Yes |
| 3 | Colour / design description | VBAP-ARKTX | Yes |
| 4 | Colour reference | By rule Colour code or swatch number given by the customer | No |
| 5 | Sample quantity | VBAP-KWMENG | Yes |
| 6 | Requested date | VBAK-VDATU | No |
Sample upload file
| 1 | Customer * | Quality * | Colour / design description * | Colour reference | Sample quantity * | Requested date |
|---|---|---|---|---|---|---|
| 2 | 200145 | KMS-24017 | Jacquard, navy ground | TCX 19-3933 | 5 | 12/04/2026 |
| 3 | 200145 | KMS-24017 | Jacquard, earth tone | TCX 17-1230 | 5 | 12/04/2026 |
| 4 | 200388 | HLI-400-120 | Design 120, grey | SW-0412 | 2 | 11/28/2026 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Sample request | VBAK-VBELN |
| 2 | Item | VBAP-POSNR |
| 3 | Customer | KNA1-NAME1 |
| 4 | Quality | VBAP-MATNR |
| 5 | Colour / design | VBAP-ARKTX |
| 6 | Current step | TJ30T-TXT30 |
| 7 | Step started | JCDS-UDATE |
| 8 | Days waiting | Calculated Today − step started |
| 9 | Requested date | VBAK-VDATU |
| 10 | Status | Calculated On time, at risk or overdue |
Sample result list
| Sample request | Item | Customer | Quality | Colour / design | Current step | Step started | Days waiting | Requested date | Status |
|---|---|---|---|---|---|---|---|---|---|
| 0010004418 | 000010 | Örnek Tekstil A.Ş. | KMS-24017 | Jacquard, navy ground | Colour approval | 11/12/2026 | 5 | 12/04/2026 | On time |
| 0010004418 | 000020 | Örnek Tekstil A.Ş. | KMS-24017 | Jacquard, earth tone | Lab dip | 11/06/2026 | 11 | 12/04/2026 | At risk |
| 0010004431 | 000010 | Demo Retail Ltd. | HLI-400-120 | Design 120, grey | Cost approval | 11/03/2026 | 14 | 11/28/2026 | Overdue |
| 0010004436 | 000010 | Nordic Home GmbH | KMS-24031 | Chenille, anthracite | Customer approval | 11/14/2026 | 3 | 12/11/2026 | On time |
How does the program work?
- The customer representative enters customer, quality, colour reference, quantity and requested date in the app; BAPI_INQUIRY_CREATEFROMDATA2 creates an inquiry (VBAK/VBAP) with a sales document type reserved for samples. Each item is one colour or design variant.
- The steps are tracked with a user status profile assigned to the sales document item (TJ30T): request received → lab dip → colour approval → design approval → cost approval → sample production → customer approval or rejection.
- Each step change is written to the item object (VBAP-OBJNR) with STATUS_CHANGE_EXTERN; who changed it and when is kept automatically in JCDS. A user can only move the step they are authorized for (B_USERSTAT).
- At the cost approval step the estimated cost per metre and the target price are kept in the item’s pricing conditions; if the margin is below the threshold, the step goes to the sales manager for approval.
- If a sample has to be produced, the app creates a sample production order with BAPI_PRODORD_CREATE and links the order number to the item.
- The worklist shows the user’s pending steps, days waiting and requested date; overdue items are marked red and the next approver receives an email. After customer approval the inquiry is copied with reference into a quotation (VA21) or order (VA01).
Performance notes
Read the worklist by the active user status in JEST and select only open requests. Read JCDS for the selected items with the OBJNR key via FOR ALL ENTRIES. Leave closed requests (approved/rejected) out of the worklist.
Features
- Send the result by email When a step changes the next approver is emailed; for overdue samples the representative is emailed.
- Double-click drill-down to the document The request number opens the inquiry; the sample production order number opens the order.
- Export to Excel
Authorization objects
- V_VBAK_AATCreate and change authorization by the sample sales document type
- B_USERSTATWho may set which step in the status profile
Frequently asked questions
Why use a sales inquiry instead of a separate table?
The inquiry is part of the standard document flow: an approved sample is copied with reference into a quotation and order, so customer and price data are not entered again. The status history is also kept in standard change records, so no separate data model is needed.
Where are lab dip results and photos kept?
Spectrophotometer values and photos are added to the item as attachments (object services). If required, measurement results from the lab system can be attached automatically; that integration is estimated separately.
Does it work on S/4HANA?
Yes. The inquiry, user status and production order BAPIs are the same on S/4HANA. The front end is built as a SAPUI5/Fiori app and added to the Fiori launchpad.
Related reports
Standard vs Current Cost Estimate Comparison by Cost Component
A custom ALV report that compares the released standard cost estimate of all materials in a plant with the current or modified cost estimate by cost …
Mass Production Order Creation from File Program
A custom program that creates production orders in bulk from material, quantity and date rows in an Excel or CSV file, and optionally releases them …
Sales Quotation Conversion Rate and Open Quotations Report
A custom ALV report that lists sales quotations per item with the value converted into orders, the value lost with a rejection reason and the …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.