0% found this document useful (0 votes)
4 views10 pages

WIP File Structure and Database Overview

The document outlines a work-in-progress (WIP) file structure and database for managing supplier purchase orders (POs) and their associated details, including confirmation dates, quantities, and statuses. It includes information on supplier numbers, material numbers, and processing statuses, along with various actions related to confirmation sequences. Additionally, it highlights the status of items in stock and any deviations or delays in processing.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
4 views10 pages

WIP File Structure and Database Overview

The document outlines a work-in-progress (WIP) file structure and database for managing supplier purchase orders (POs) and their associated details, including confirmation dates, quantities, and statuses. It includes information on supplier numbers, material numbers, and processing statuses, along with various actions related to confirmation sequences. Additionally, it highlights the status of items in stock and any deviations or delays in processing.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

WIP FILE STRUCTURE

Supplier Number FL PO FL PO Line FL PN FL [Link]


New - suggested SAP PO SAP PO Line Fineline material Supplier
addition for validation number confirmed date

152 4500000479 10 FL555235_2_TG 02.07.2025


152 4500000479 20 FL555235_2_TG 05.07.2025

152 4500000479 20 FL555235_2_TG 11.07.2025

WIP DATABASE
File ID 🔑 PO 🔑 PO Item 🔑 Seq 🔑 Company Code

File ID on each file SAP PO SAP PO Item Sequence added at Company Code
upload time of file upload of the PO
to PO+Line split

3 4500000479 10 1 3710

3 4500000479 10 1 3710

3 4500000479 10 1 3710

3 4500000479 10 2 3710

3 4500000479 10 3 3710

3 4500000479 30 3 3710
[Link] UOM FL PO Supplier PO Supplier PN
Supplier confirmed qty Fineline PO UOM Supplier PO Supplier
material
number

70 EA 240108280-1 FLCAM-GINO1
300 EA 240108280-1 FLCAM-GINO1

500 EA 240108280-1 FLCAM-GINO1

Deviation Details Processing Status Previous Obsolete Reason Supplier Number


Processing Status
Processing status of Previous Processing The reason for New -
the Line Status of the line setting Obsolete suggested
processing addition for
status validation

Obsolete New SYS-Replaced by n152

Obsolete 152

Rejected 152

Qty Diff. Pending Approval 152

Approved 152

To be reviewed 152

Quantity Deviation Draft SYS-Replaced by new line


Date Deviation Draft-Error Cancelled
UOM Deviation - Error! To be Reviewed
Qty & Date Deviation Pending Approval
Approved
Rejected
Confirmed-OK
Confirmed-Warning
Confirmed-Error
Obsolete
Supplier Plant Delay Reason WIP Status WIP Prev. Status
Supplier Plant Text Text Text

SUNTAK_金州厂 In stock 500


SUNTAK_金州厂 Missing RM Inner Layer Drilling Inner Layer AOI(2)
6120 + Inner Layer 6090
AOI(2) 6090

SUNTAK_金州厂 Missing RM Inner Layer AOI(2)

PN [Link] [Link] UOM Supplier PO

Fineline material Supplier confirmed Supplier confirmed qty Fineline SAP UOM Supplier PO
number date

FL555235_2_TG 01.07.2025 700 EA 240108280-1

FL555235_2_TG 05.07.2025 700 EA 240108280-1

FL555235_2_TG 05.07.2025 700 EA 240108280-1

FL555235_2_TG 05.07.2025 300 EA 240108280-1

FL555235_2_TG 11.07.2025 200 EA 240108280-1

FL555235_2_TG 11.07.2025 500 EA 240108280-1


Supplier PN Supplier plant Delay reason WIP status WIP Prev. S

Supplier material number Supplier Plant Text Text Text

FLCAM-GINO1 SUNTAK_金州厂 In stock 500

FLCAM-GINO1 SUNTAK_金州厂 In stock 545 In stock 500

FLCAM-GINO1 SUNTAK_金州厂 In stock 545 In stock 500

FLCAM-GINO1 SUNTAK_金州厂 Missing RM Inner Layer Drilling Inner


6120 + Inner Layer Layer
AOI(2) 6090 AOI(2)
6090

FLCAM-GINO1 SUNTAK_金州厂 Missing RM Inner Layer AOI(2)

FLCAM-GINO1 SUNTAK_金州厂 Missing RM Inner Layer AOI(2)


Actions

Text

In stock 500

In stock 500
CONFIRMATION_EXISTS SAME_FILE INB_QTY GR_QTY
CONFIRMATION_EXISTS = TRUE SAME_FILE = TRUE INB_QTY = 0 GR_QTY = 0
CONFIRMATION_EXISTS = TRUE SAME_FILE = TRUE INB_QTY = 0 GR_QTY > 0
CONFIRMATION_EXISTS = TRUE SAME_FILE = TRUE INB_QTY > 0 GR_QTY = 0
CONFIRMATION_EXISTS = TRUE SAME_FILE = TRUE INB_QTY > 0 GR_QTY > 0
CONFIRMATION_EXISTS = TRUE SAME_FILE = FALSE INB_QTY = 0 GR_QTY = 0

CONFIRMATION_EXISTS = TRUE SAME_FILE = FALSE INB_QTY = 0 GR_QTY > 0

CONFIRMATION_EXISTS = TRUE SAME_FILE = FALSE INB_QTY > 0 GR_QTY = 0

CONFIRMATION_EXISTS = TRUE SAME_FILE = FALSE INB_QTY > 0 GR_QTY > 0

CONFIRMATION_EXISTS = FALSE SAME_FILE = FALSE INB_QTY = 0 GR_QTY = 0

CONFIRMATION_EXISTS = FALSE SAME_FILE = FALSE INB_QTY = 0 GR_QTY > 0

CONFIRMATION_EXISTS = FALSE SAME_FILE = FALSE INB_QTY > 0 GR_QTY = 0

CONFIRMATION_EXISTS = FALSE SAME_FILE = FALSE INB_QTY > 0 GR_QTY > 0


Actions
FUNCTION 3: Create Confirmation Sequence line
FUNCTION 3: Create Confirmation Sequence line
FUNCTION 3: Create Confirmation Sequence line
FUNCTION 3: Create Confirmation Sequence line
FUNCTION 6: Delete Confirmation Sequence line
FUNCTION 3: Create Confirmation Sequence line
FUNCTION 4: Consolidate Supplier Confirmation Lines - In case delete has failed.

FUNCTION 2: Create Confirmation Sequence Line for GR


FUNCTION 3: Create Confirmation Sequence line
FUNCTION 4: Consolidate Supplier Confirmation Lines

FUNCTION 2: Create Confirmation Sequence Line for Inbound Delivery


FUNCTION 3: Create Confirmation Sequence line
FUNCTION 4: Consolidate Supplier Confirmation Lines

FUNCTION 2: Create Confirmation Sequence Line for Inbound Delivery


FUNCTION 3: Create Confirmation Sequence line
FUNCTION 4: Consolidate Supplier Confirmation Lines

FUNCTION 3: Create Confirmation Sequence line


FUNCTION 5: Update “First Confirmed Date”
FUNCTION 2: Create Confirmation Sequence Line for GR
FUNCTION 3: Create Confirmation Sequence line
FUNCTION 5: Update “First Confirmed Date”

FUNCTION 1: Create Confirmation Sequence Line for Inbound Delivery


FUNCTION 3: Create Confirmation Sequence line
FUNCTION 5: Update “First Confirmed Date”

FUNCTION 1: Create Confirmation Sequence Line for Inbound Delivery


FUNCTION 3: Create Confirmation Sequence line
FUNCTION 5: Update “First Confirmed Date”
PO Item Qty [Link]
450000035 10 1000 01.07.2025

CONF-1 450000035 10 500 01.07.2025


450000035 10 500 05.07.2025

INB 450000035 10 200 18.06.2025

CONF-2 450000035 10 300 01.07.2025


450000035 10 500 05.07.2025
QTY REDUCED
450000035 10 200 15.06.2025 -200
450000035 10 300 01.07.2025
450000035 10 500 05.07.2025

You might also like