SAP Test Certificate Logic

Logic and Table Details


User will Enter from to date and execute
in background get all deliveries no from table LIPS as per input date then against all deliveries found, go to Reference field for Sales order no,
Get SO No and Search Sales order no in table VBAK and Search Delivery Text for Word TEST
if word TEST found in Delivery text then display details as below

LIPS Get Delivery no reference field for SO No
VBAK Sales order Header Details
STXH Delivery text table
LIKP Delivery header data vehicle no field

TABLE FIELD FIELD NAME

LIPS VBELN Delivery No
LIPS ERDAT Date
LIPS VGBEL Reference Field ( For Sales Order No)
LIPS MATNR Material no
LIPS ARKTX Material Text
LIPS LFIMG Delivered Qty
LIPS ERNAM Created by

VBAK VBELN Sales Order No
VBAK KUNNR Sold to Party ( customer)



STXH Delivery text field
LIKP ZZVEHNO Vehical No