Skip to content

Instantly share code, notes, and snippets.

@ilyakaznacheev
Created February 25, 2019 19:24
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save ilyakaznacheev/f73d50064d49f5e41f1101368eec6f30 to your computer and use it in GitHub Desktop.
@AbapCatalog.sqlViewName: 'ZTEST_CPRODAMNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Available product amount'
define view Ztest_C_ProductAmount
as select from Ztest_I_ProductAmount
association [*] to Ztest_C_ProductReplenishment as _Replenishment on _Replenishment.Material = $projection.Material
{
key Material,
@EndUserText: {
label: 'Available Amount',
quickInfo: 'Amount available across all shops'
}
AvailableAmount,
_Replenishment,
_Material
}
@AbapCatalog.sqlViewName: 'ZTEST_CPRODREPL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Replenishment Dates'
define view Ztest_C_ProductReplenishment
as select from Ztest_I_ProductReplenishment(
p_horizon_days: 10,
p_current_date: $session.system_date
)
{
key Material,
@EndUserText.label: 'Shop'
key ShopID,
@EndUserText: {
label: 'Next Replenishment',
quickInfo: 'Latest replenishment date'
}
ReplenishmentDate,
_Shop,
_Material
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment