PP Program Custom development Fiori app Textile and Apparel

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

  • VA11 Create Inquiry. Creates the sales inquiry; no development steps, approval sequence or waiting time tracking.
  • VA15 Inquiries List. Lists inquiries; does not provide a worklist by step and days waiting.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
VBAKSales Document HeaderSample request header: customer, sales organization, requested dateWriteECC + S/4
VBAPSales Document ItemSample item: quality, colour/design description, quantity, status objectWriteECC + S/4
JESTIndividual Object StatusActive user status of the item (development step)WriteECC + S/4
JCDSChange Documents for System/User StatusesDate and user of step changes (waiting time)ReadECC + S/4
TJ30TTexts for User StatusUser status (step) namesReadECC + S/4
KNA1Customer Master (General Section)Customer nameReadECC + S/4
AFKOOrder Header Data for PP OrdersSample production orderWriteECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_VKORGSales organizationRange / multipleVBAK-VKORGYes1000
S_KUNNRCustomerRange / multipleVBAK-KUNNRNo200145
S_ERDATRequest dateRange / multipleVBAK-ERDATNo01.10.2026 – 16.11.2026
S_ESTATDevelopment stepRange / multipleTJ30T-ESTATNoE0003
P_MINEOnly items waiting for my approvalCheckbox—NoX

Input file columns

The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.

#ColumnTarget fieldRequired
1CustomerVBAK-KUNNRYes
2QualityVBAP-MATNRYes
3Colour / design descriptionVBAP-ARKTXYes
4Colour referenceBy rule Colour code or swatch number given by the customerNo
5Sample quantityVBAP-KWMENGYes
6Requested dateVBAK-VDATUNo

Sample upload file

1Customer *Quality *Colour / design description *Colour referenceSample quantity *Requested date
2200145KMS-24017Jacquard, navy groundTCX 19-3933512/04/2026
3200145KMS-24017Jacquard, earth toneTCX 17-1230512/04/2026
4200388HLI-400-120Design 120, greySW-0412211/28/2026
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1Sample requestVBAK-VBELN
2ItemVBAP-POSNR
3CustomerKNA1-NAME1
4QualityVBAP-MATNR
5Colour / designVBAP-ARKTX
6Current stepTJ30T-TXT30
7Step startedJCDS-UDATE
8Days waitingCalculated Today − step started
9Requested dateVBAK-VDATU
10StatusCalculated On time, at risk or overdue

Sample result list

Sample requestItemCustomerQualityColour / designCurrent stepStep startedDays waitingRequested dateStatus
0010004418000010Örnek Tekstil A.Ş.KMS-24017Jacquard, navy groundColour approval11/12/2026512/04/2026On time
0010004418000020Örnek Tekstil A.Ş.KMS-24017Jacquard, earth toneLab dip11/06/20261112/04/2026At risk
0010004431000010Demo Retail Ltd.HLI-400-120Design 120, greyCost approval11/03/20261411/28/2026Overdue
0010004436000010Nordic Home GmbHKMS-24031Chenille, anthraciteCustomer approval11/14/2026312/11/2026On time
A view built with fictional sample data; not real system data.

How does the program work?

  1. 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.
  2. 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.
  3. 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).
  4. 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.
  5. 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.
  6. 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

PP Program Custom Mass upload

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 …

MARC · T399X · MKAL · AUFK

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.

Related report: Sample Request, Development and Approval Tracking App