LBASE Online |
Purpose |
Configuration
|
Further properties |
The following properties are available for status entry purposes:
Note: if you use the property status.lauid to enter status codes other than ZU please note that you must also integrate these into the workflow - for example by creating a separate display mode. |
Note on separate display modes |
In the Shipment - selection mask, the configuration sdgauswahl.stati.lauids is used and the following is also stored in the WHERE: AND Spod.get_max_pod_code(sdg_sdgid,'AB,ZU')= '012' AND '40' IN ( SELECT DISTINCT pog_pogid FROM spog_pocgrp, SPOC_T_PODCODE WHERE poc_pocid = Spod.get_max_pod_code(sdg_sdgid,'AB,ZU') AND poc_pogid = pog_pogid ) …
By using the restriction in the SQL statement spod.get_max_pod_code(sdg_sdgid,'ZU'), only the type ZU is considered in the table through the default display mode 467. Irrespective of the selection criteria, only the maximum POD code of the delivery is displayed in the final row, for example. You should therefore consider every code that is stored in a separate display mode in the property status.lauid. Example: …,spod.get_max_pod_code(sdg_sdgid,'ZU,AB,XSD')
You can display the maximum POD code for the own type as follows: Example: …case when spod.get_max_pod(sdg_sdgid,'XSD') is not null then 'XSD- '|| (select pod_code from SPOD_POD where pod_sdgid = sdg_sdgid and pod_lafid = spod.get_max_pod(sdg_sdgid,'XSD')) else '' end pod_code_last… |
|