2 weeks ago - last edited a week ago
Hello Experts,
Building a consumption view to display Supplier invoice data with workflow details. In that, the requirement is to build below inputs with a default value as
1) Net value date : last day of the current month (calendar as VH)
2) Fiscal year : Current year (it has all years in the drop down/VH but must have the current year)
3) PR block reason key : = !blank (it has all values but must be equal to blank)
4) Document date : multiple range selection input with (first day of the current month and current day of the current month)
Please help how to achieve it with the code.
Thank you for your time and any help is highly appreciated.
Request clarification before answering.
`You can use the below code snippet for reference.
Here I have created a copy for view "C_SglGregorianCalMonthToDate" and fixed the parameter P_DateFunction = 'MONTHTODATE'.
@Consumption.filter: {
mandatory: true,
selectionType: #INTERVAL,
multipleSelections: false }
@Consumption.derivation: {
lookupEntity: 'ZC_SglGregorianCalMonthToDate',
resultElement: 'StartDate',
resultElementHigh: 'CurrentDate' }
fkdat as BillingDate,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use the below example.
https://community.sap.com/t5/application-development-discussions/how-to-use-a-cds-view-with-paramete...
my code is to just let you know how can you derive values. Might not be the exact solution for your requirement.
User | Count |
---|---|
54 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.