Access the CXSIntegration tables in SAPB1 Application Server : Screen Query Manager

Access the CXSIntegration tables in SAPB1 Application Server : Screen Query Manager

Environment : 

iVend 6.6 with SAPB1 10

Queries : 

CXSIntegration database tables can be accessed in SAPB1 Application Server : Screen Query Manager

Response : 

Below are steps :

Open the SAPB1 Application -->Tools-->Queries-->Query Generator 

It is applicable for SAPB1 SQL Server and SAPB1 HANA 




Example SQL Queries :

SELECT * from "CXSINTEGRATION"."RepIntegrationLog" where "DBName" ='SAPB1_DemoUS' and "Flag"='0' and "OperationType"='3'
Update "CXSINTEGRATION"."RepIntegrationLog"
set "Flag"='1', "Status"='0' 
where "DBName" ='SAPB1_DemoUS' and "Flag"='0' and "Status"='1' and "OperationType"='3'

    • Related Articles

    • Manager Override

      Manager Overrides Overview While carrying out normal day-to-day transactions at the POS terminal, there are many situations where an intervention from the Manager could be required to complete the transaction. Deciding on what particular actions ...

    • Displaying Manager Override Screen

      Introduction This knowledge base article will assist developers with how the Manager Override screen is displayed at the Point of Sale (POS). Purpose The Manager Override feature is used when the Manager's permission is required to carry out an ...

    • Displaying Manager Override Screen

      Introduction This knowledge base article will assist developers with how the Manager Override screen is displayed at the Point of Sale (POS). Purpose The Manager Override feature is used when the Manager's permission is required to carry out an ...

    • iVend Addon Started error : Cannot Access the table

      Environment iVend 6.6 with SAP Business One Problem Statement While started Citixsys iVend Addon through Addon manager screen we getting below error message :- Cannot access the table. Please check it is listed in the allowed list. For more ...

    • Store Manager Can't open the MC

      Environment : I-Vend 6.6 Patch 7747 Problem Description : Manager user can't open the MC even after assign login MC in roles assignment. Scenario : When user is logged with Manager account then below above mentioned error is coming. Solution: When we ...