ProjectDescription along with project details from S4 HANA cannot be retrieved using standard API

[AHMED786]

Hi Experts,

We need to extract all the project system data from s4 to send to 3rd party. But in a single API get call not getting all the fields as below.

API1: /sap/opu/odata/sap/API_OPLACCTGDOCITEMCUBE_SRV/A_OperationalAcctgDocItemCube
method: GET

<A_OperationalAcctgDocItemCubeType>
<Project>PRJ-000123</Project>
<GLAccount>134500000</GLAccount>
<PostingDate>2024-06-25T00:00:00.000</PostingDate>
<AccountingDocumentCreationDate>2024-06-25T00:00:00.000</AccountingDocumentCreationDate>
<AmountInCompanyCodeCurrency>56145.75</AmountInCompanyCodeCurrency>
.....
</A_OperationalAcctgDocItemCubeType>

missing field from above get call is

ProjectDescription

API2: http://cpisd1.aei.com:8000/sap/opu/odata4/sap/api_project_v3/srvd_a2x/sap/project/0001/Project
method: GET

<?xml version="1.0" encoding="UTF-8" ?>
<root>
<@odata.context>$metadata#Project/$entity</@odata.context>
<@odata.metadataEtag>W/"20240703141123"</@odata.metadataEtag>
<ProjectInternalID>16</ProjectInternalID>
<ProjectExternalID>PRJ-000123</ProjectExternalID>
<ProjectDescription>Unit Test Project 0108202401820240108202</ProjectDescription>
<ProjectLangBsdDescription></ProjectLangBsdDescription>
<ProjectProfileCode>000001</ProjectProfileCode>
<CompanyCode>1200</CompanyCode>
<ControllingArea>AB00</ControllingArea>
...
</root>

From the 2nd API we have the ProjectDescription but in order to pull that the primary key is projectinternalID which is not there in the complete list of the first API get call...

Please suggest for any direct API to retrieve the PROJECT DESCRIPTION or atleast 2 calls with the primary key of the second API should be present in the first API output. Any other open API which we can have to custom search the required details from S4.

All suggestions are welcomed.

Thanks,

Ahmed