In this custom logic " YY1_LGC_PO_AGENT_DET " It says "BPidentificationNumber" is an unknown column

[SAPSupport]

In this custom logic " YY1_LGC_PO_AGENT_DET " CDS Entity I_BUSINESSUSER is deprecated and we replaced with CDS Entity I_BUSINESSUSERBASIC . But  in this custom logic we applied "WHERE BPIdentificationNumber" operation and it says "BPIdentificationNumber is an unknown column"

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

We have deprecated CDS view I_BusinessUser due to some architecture reason for performance. Since the I_BusinessUserBasic is using different architecture, some fields are not available, which could not be avoided.

The further option is to join the CDS view I_BusinessUserBasic as primary data source with cds view I_BuPaIdentification using join condition with Business Partner. For this option you can add further in the join condition for BPIdentificationType = HCM001 in case you want to have only Employees.

Note: Incase custom CDS view is created , create a separate Custom CDS view, i.e. YY1_Employees with I_BusinessUserBasic as primary data source with join condition to I_BPIdentification containing field BPIdentification using fields BusinessPartner and  I_BPIdentification-BPIdentificationType = HCM001 (Field as Constant value)