https://community.sap.com/t5/application-development-and-automation-discussions/how-to-code-for-this-scenario/m-p/12653904#M2015200 <P>Go in SE11 and se16 transactions, check the table content, the table key and how to make your SELECT statement</P> Fri, 09 Dec 2022 11:51:45 GMT FredericGirod 2022-12-09T11:51:45Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-code-for-this-scenario/m-p/12653903#M2015199 <P>(1) Pass selection Company Code=BUKRS, Document Type[s1] =BLART=DZ[s2] and selection date period=BUDAT in <STRONG>BKPF</STRONG> and fetch all the document numbers[s3] = BELNR and Fiscal Year= GJAHR. Pass them to BELNR in<STRONG> BSEG</STRONG> with Company Code=BUKRS, selection Bank GL= HKONT, Fiscal Year = GJAHR and fetch the resulting document numbers= BELNR.</P> <HR /> <P> [s1]document type is a key that is used to classify accounting documents and distinguish between business transactions</P> <P> [s2]Customer payment</P> <P> [s3]<STRONG>every document is assigned a number that identifies it uniquely within a fiscal year and company code</STRONG></P> Fri, 09 Dec 2022 11:03:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-code-for-this-scenario/m-p/12653903#M2015199 former_member1367630 2022-12-09T11:03:55Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-code-for-this-scenario/m-p/12653904#M2015200 <P>Go in SE11 and se16 transactions, check the table content, the table key and how to make your SELECT statement</P> Fri, 09 Dec 2022 11:51:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-code-for-this-scenario/m-p/12653904#M2015200 FredericGirod 2022-12-09T11:51:45Z