| Purpose |
Update the UPC program, so that printing by PO can read from table- 912 (SOrg / Distr. Chl / Division / Customer / Plant / VAS Matl. Grp.). |
| Release No |
001 |
| Submitted on |
08/18/2015 |
| Submitted by |
Siba Mohapatra |
| Environment |
NECNED to NECNEQ |
| Sent To |
Daniel Brennan |
| Object(s) created by |
Karthik |
| Object(s) tested by |
Siba |
| Transport Status |
Created in NECNED100 |
| Sl. |
Transport ID |
Description |
Object Name |
| 1 |
NEDK930084 |
SD:19505: Add KOTK912 table in UPC program for PO input |
ZRSD_UPC_LABELS |
| Test ID |
Test Scenarios |
Expected Results |
Actual Results |
P/F |
Document # |
Notes |
Tested By |
QA By |
||||||||
| SD0527-1 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As the valid condition record found from KOTK912 Table with 2000 Sorg combination. So it should be fetched and get printed. And UPC label should be printed correctly with the VAS code maintained in the table KOTK912. |
The condition record fetched from KOTK912 table with sales organisation 2000 combination. And UPC label printed correctly with the VAS code maintained in the table KOTK912. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
X |
KOTK912 |
LBJ |
S23 |
|||||||||
| SD0527-2 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record( Both L/S Codes invalid) Sorg 2200 combination is Valid condition record. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
The condition record should be fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label should be printed correctly with the VAS code maintained in the table KOTK912. |
The condition record fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label printed correctly with the VAS code maintained in the table KOTK912. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| SD0527-3 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record (Only L Code invalid) Sorg 2200 combination is Valid condition record. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
The condition record should be fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label should be printed correctly with the VAS code maintained in the table KOTK912. |
The condition record fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label printed correctly with the VAS code maintained in the table KOTK912. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S31 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| SD0527-4 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record (Only S Code invalid) Sorg 2200 combination is Valid condition record. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
The condition record should be fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label should be printed correctly with the VAS code maintained in the table KOTK912. |
The condition record fetched from KOTK912 table with sales organisation 2200 combination, which is valid. And UPC label printed correctly with the VAS code maintained in the table KOTK912. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L12 |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| SD0527-5 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record. (Invalid S code) Sorg 2200 combination is Invalid condition record. (Invalid L code) Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are invalid from KOTK912 table. And no other condition records maintained in other VAS tables i.e KOTK901, KOTK922. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L12 |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S23 |
X |
|||||||||
| SD0527-6 |
Maintain multiple condition record for Table KOTK901 i.e Sorg/DisCh/Div/Customer/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record. (Invalid S code) Sorg 2200 combination is Invalid condition record. (Invalid L code) Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are invalid from KOTK901 table. And no other condition records maintained in other VAS tables i.e KOTK912, KOTK922. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
|||||||||
| 2000/10/00 |
NEC0135 |
HDW |
KOTK901 |
L12 |
S41 |
X |
||||||||||
| 2200/10/00 |
NEC0135 |
HDW |
KOTK901 |
L07 |
S23 |
X |
||||||||||
| SD0527-7 |
Maintain multiple condition record for Table KOTK922 i.e Sorg/DisCh/Div/Plant. with below combination. Note: Sorg 2000 combination is Invalid Condition record. (Invalid S code) Sorg 2200 combination is Invalid condition record. (Invalid L code) Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are invalid from KOTK922 table. And no other condition records maintained in other VAS tables i.e KOTK912, KOTK901. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Plant |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||||
| 2000/10/00 |
0325 |
KOTK922 |
L12 |
S41 |
X |
|||||||||||
| 2200/10/00 |
0325 |
KOTK922 |
L07 |
S23 |
X |
|||||||||||
| SD0527-8 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Sorg 2000 combination is Invalid Condition record. (Invalid L&S code) Sorg 2200 combination is Invalid condition record. (Invalid L&S code) Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are invalid from KOTK912 table. And no other condition records maintained in other VAS tables i.e KOTK901, KOTK922. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
L07 |
S41 |
X |
|||||||||
| SD0527-9 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: Both condition record has same valid L code & S code. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are valid and same Lcode & Scode maintained from KOTK912 table. UPC label should be printed without any extra lines. |
The condition record fetched from KOTK912 table with sales organisation 2000 combination. And UPC label printed without any extra lines. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S23 |
||||||||||
| SD0527-10 |
Maintain multiple condition record for Table KOTK901 i.e Sorg/DisCh/Div/Customer/VAS Matgrp. with below combination. Note: Both condition record has same valid L code & S code. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are valid and same Lcode & Scode maintained from KOTK901 table. UPC label should be printed without any extra lines. |
The condition record fetched from KOTK901 table with sales organisation 2000 combination. And UPC label printed without any extra lines. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
|||||||||
| 2000/10/00 |
NEC0135 |
HDW |
KOTK901 |
L12 |
S31 |
|||||||||||
| 2200/10/00 |
NEC0135 |
HDW |
KOTK901 |
L12 |
S31 |
|||||||||||
| SD0527-11 |
Maintain multiple condition record for Table KOTK922 i.e Sorg/DisCh/Div/Plant. with below combination. Note: Both condition record has same valid L code & S code. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are valid and same Lcode & Scode maintained from KOTK922 table. UPC label should be printed without any extra lines. |
The condition record fetched from KOTK922 table with sales organisation 2000 combination. And UPC label printed without any extra lines. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Plant |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||||
| 2000/10/00 |
0325 |
KOTK922 |
L12 |
S23 |
||||||||||||
| 2200/10/00 |
0325 |
KOTK922 |
L12 |
S23 |
||||||||||||
| SD0527-12 |
Maintain multiple condition record for Table KOTK912 i.e Sorg/DisCh/Div/Customer/Plant/VAS Matgrp. with below combination. Note: All condition records are deleted. Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
As both condition records are deleted from KOTK912 table. And no other condition records maintained in other VAS tables i.e KOTK901, KOTK922. UPC label should not be printed and pop-up message 'No relevant Lcode or Scode found' should display. |
UPC label not printed and pop-up message 'No relevant Lcode or Scode found' displayed. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
X |
KOTK912 |
LBJ |
S23 |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
X |
KOTK912 |
L12 |
S31 |
|||||||||
| SD0527-13 |
Maintain multiple condition records for table KOTK912, 901 & 922 as below; Material should be extended to Sales organisation 2000 & 2200. Create a Purchase order with 2 materials from plant 0325 and execute in ZSD_UPCLBL T.code under UPC (stock items only) with print components unflagged. |
Program should check Tables sequentially like KOTK912, KOTK901 & KOTK922. UPC from KOTK922 with Sorg 2200 combination should be printed with the maintained VAS codes as it is found valid condtion record with non delition indicator. |
UPC label printed with the VAS code maintained in the KOTK922 table with Sorg 2200 combination. |
P |
PO # 4600008175 |
NA |
Siba |
Siba |
||||||||
| Sorg/DisCh/Div |
Customer |
Plant |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||
| 2000/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S41 |
X |
|||||||||
| 2200/10/00 |
NEC0135 |
0325 |
HDW |
KOTK912 |
LBJ |
S41 |
X |
|||||||||
| Sorg/DisCh/Div |
Customer |
VAS Matgrp. |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
|||||||||
| 2000/10/00 |
NEC0135 |
HDW |
X |
KOTK901 |
LBJ |
S23 |
||||||||||
| 2200/10/00 |
NEC0135 |
HDW |
KOTK901 |
L07 |
S31 |
X |
||||||||||
| Sorg/DisCh/Div |
Plant |
Con.Rec. Deleted |
Table |
L Code |
S Code |
Invalid Con.Rec |
||||||||||
| 2000/10/00 |
0325 |
X |
KOTK922 |
LBJ |
S23 |
|||||||||||
| 2200/10/00 |
0325 |
KOTK922 |
L12 |
S31 |
||||||||||||