@AbapCatalog.sqlViewName: 'PSEMTAGSLITP'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'LedgerGLLineItem'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'G/L Account Line Item Union by SemTag and SLALITTYPE'
define view P_SemTagAndSubLedgerItem
with parameters
@Consumption.defaultValue: 'YPS2'
P_GLAccountHierarchy : fins_sem_tag_hryid
as select from I_GLAcctLineItmSubLdgrItmTypeC
association [0..1] to I_ProjectBasicData as _ProjectBasicData on $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
association [0..1] to I_ProjectByExternalID as _ProjectExternalID on $projection.projectexternalid = _ProjectExternalID.ProjectExternalID
{
key Ledger,
key SourceLedger,
key CompanyCode,
key FiscalYear,
key FiscalPeriod,
key AccountingDocument,
key LedgerGLLineItem,
key SemanticTag,
ProfitCenter,
SoldProduct,
SoldProductGroup,
Customer,
CustomerGroup,
SalesOrder,
SalesOrderItem,
SalesDocument,
SalesDocumentItem,
OrderID,
OrderCategory,
ConditionContract,
@AnalyticsDetails.query.display: #KEY
FiscalYearPeriod,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
GLAccount,
@ObjectModel.foreignKey.association: '_SalesOrganization'
@AnalyticsDetails.query.display: #KEY_TEXT
SalesOrganization,
@ObjectModel.foreignKey.association: '_CustomerSupplierCountry'
@AnalyticsDetails.query.display: #KEY_TEXT
CustomerSupplierCountry,
@AnalyticsDetails.query.display: #KEY_TEXT
CustomerSupplierIndustry,
@ObjectModel.foreignKey.association: '_SalesDistrict'
@AnalyticsDetails.query.display: #KEY_TEXT
SalesDistrict,
@ObjectModel.foreignKey.association: '_ShipToParty'
@AnalyticsDetails.query.display: #KEY_TEXT
ShipToParty,
@ObjectModel.foreignKey.association: '_BillToParty'
@AnalyticsDetails.query.display: #KEY_TEXT
BillToParty,
@AnalyticsDetails.query.display: #KEY
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@ObjectModel.foreignKey.association: '_CostSourceUnit'
CostSourceUnit,
BusinessTransactionType,
SubLedgerAcctLineItemType,
@ObjectModel.foreignKey.association: '_DistributionChannel'
DistributionChannel,
OrganizationDivision,
@ObjectModel.foreignKey.association: '_BaseUnit'
@Semantics.unitOfMeasure:true
BaseUnit,
OrderType,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
//@ObjectModel.foreignKey.association: '_Project'
Project,
//@ObjectModel.foreignKey.association: '_WBSElement'
WBSElement,
//@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
FiscalYearVariant,
ServiceContract,
ServiceContractItem,
BusinessSolutionOrder,
BusinessSolutionOrderItem,
ProviderContract,
ProviderContractItem,
ServiceContractType,
AccountAssignmentType,
ServiceDocument,
ServiceDocumentItem,
ServiceDocumentType,
ProjectInternalID,
_ProjectExternalID,
_ProjectBasicData,
@ObjectModel.foreignKey.association: '_ProjectExternalID'
_ProjectBasicData.ProjectExternalID,
cast(cast( '' as abap.char( 1 ) ) as fins_xsemtag_calculated) as LineIsSemTagCalculated,
@Semantics.currencyCode:true
GlobalCurrency,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@Semantics.currencyCode:true
FreeDefinedCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
AmountInCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
AmountInFreeDefinedCurrency1,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
AmountInGlobalCurrency,
// Key Figures in Global Currency
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2) ) as fins_trr_actrevn preserving type ) as BilledRevenueAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_sales_deduction) as SalesDeductionAmountInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_trr_revnadjust) as RevenueAdjustAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2) ) as fins_trr_recrevn preserving type ) as RecognizedRevnAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_cogs_variable ) as VarblCOGSAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_contribution_margin_i ) as ContrbnMargin1AmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_cogs_fixed) as FxdCOGSAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_price_differences) as PriceDifferenceAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_contribution_margin_ii) as ContrbnMargin2AmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_administration_overhead) as AdminOverheadAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_sales_overhead) as SalesOverheadAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_marketing_overhead) as MarketingOverheadAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_research_and_dev_overhead) as RnDOverheadAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_contribution_margin_iii) as ContrbnMargin3AmtInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
InptPriceVarcAmtInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
InptQtyVarcAmtInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
RsceUsgeVarcAmtInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
LotSizeVarcAmtInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics.amount.currencyCode: 'GlobalCurrency'
InputRmngVarcAmtInGlobCrcy,
// Key Figures in Company Code Currency
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_billed_revenue_cccrcy) as BilledRevenueAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_sales_deduction_cccrcy) as SalesDeductionAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fis_adj_rev_hsl) as RevenueAdjustmentAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fis_reco_rev_hsl) as RecognizedRevnAmtInCCCrcy, //GrossRevenue,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_variable_cccrcy) as VarblCOGSAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_contribmarg_1_cccrcy) as ContrbnMargin1AmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_fixed_ccrcy) as FxdCOGSAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_price_differences_cccrcy) as PriceDifferenceAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_contribmarg_2_cccrcy) as ContrbnMargin2AmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_admin_overhead_cccrcy) as AdminOverheadAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_sales_overhead_cccrcy) as SalesOverheadAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_marketing_overhead_cccrcy) as MarketingOvhdAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_resear_dev_overhead_ccrcy) as RnDOverheadAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_contribmarg_3_cccrcy) as ContrbnMargin3AmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
InptPriceVarcAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
InptQtyVarcAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
RsceUsgeVarcAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
LotSizeVarcAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
InputRmngVarcAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
cast( cast ('0' as abap.curr( 23,2)) as fins_billed_quantity) as BilledValnQtyInCostSourceUnit,
_Ledger,
_SourceLedger,
_JournalEntry,
_CompanyCode,
_SemanticTag,
_FiscalYear,
_Customer,
_CustomerGroup,
_SoldProduct,
_SoldProductGroup,
_ProfitCenter,
_ControllingArea,
_CostSourceUnit,
_SalesDocument,
_SalesOrder,
_SalesOrderItem,
_Order,
_DistributionChannel,
_BaseUnit,
_Segment,
_ChartOfAccounts,
_GLAccountInChartOfAccounts,
//_WBSElement,
//_Project,
//_ProjectNetwork,
_FunctionalArea,
_Plant,
_SalesOrganization,
_SalesDistrict,
_CustomerSupplierCountry,
_ShipToParty,
_BillToParty
}
//where
// AccountAssignmentType = 'EO'
union all select from I_GLAccountLineItemSemTag
association [0..1] to I_ProjectBasicData as _ProjectBasicData on $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
association [0..1] to I_ProjectByExternalID as _ProjectExternalID on $projection.projectexternalid = _ProjectExternalID.ProjectExternalID
{
key Ledger,
key SourceLedger,
key CompanyCode,
key FiscalYear,
key FiscalPeriod,
key AccountingDocument,
key LedgerGLLineItem,
key SemanticTag,
ProfitCenter,
SoldProduct,
SoldProductGroup,
Customer,
CustomerGroup,
SalesOrder,
SalesOrderItem,
SalesDocument,
SalesDocumentItem,
OrderID,
OrderCategory,
ConditionContract,
@AnalyticsDetails.query.display: #KEY
FiscalYearPeriod,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
GLAccount,
@ObjectModel.foreignKey.association: '_SalesOrganization'
@AnalyticsDetails.query.display: #KEY_TEXT
SalesOrganization,
@ObjectModel.foreignKey.association: '_CustomerSupplierCountry'
@AnalyticsDetails.query.display: #KEY_TEXT
CustomerSupplierCountry,
@AnalyticsDetails.query.display: #KEY_TEXT
CustomerSupplierIndustry,
@ObjectModel.foreignKey.association: '_SalesDistrict'
@AnalyticsDetails.query.display: #KEY_TEXT
SalesDistrict,
@ObjectModel.foreignKey.association: '_ShipToParty'
@AnalyticsDetails.query.display: #KEY_TEXT
ShipToParty,
@ObjectModel.foreignKey.association: '_BillToParty'
@AnalyticsDetails.query.display: #KEY_TEXT
BillToParty,
@AnalyticsDetails.query.display: #KEY
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@ObjectModel.foreignKey.association: '_CostSourceUnit'
CostSourceUnit,
BusinessTransactionType,
SubLedgerAcctLineItemType,
@ObjectModel.foreignKey.association: '_DistributionChannel'
DistributionChannel,
OrganizationDivision,
@ObjectModel.foreignKey.association: '_BaseUnit'
@Semantics.unitOfMeasure:true
BaseUnit,
OrderType,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
//@ObjectModel.foreignKey.association: '_Project'
Project,
//@ObjectModel.foreignKey.association: '_WBSElement'
WBSElement,
//@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
FiscalYearVariant,
ServiceContract,
ServiceContractItem,
BusinessSolutionOrder,
BusinessSolutionOrderItem,
ProviderContract,
ProviderContractItem,
ServiceContractType,
AccountAssignmentType,
ServiceDocument,
ServiceDocumentItem,
ServiceDocumentType,
ProjectInternalID,
_ProjectExternalID,
_ProjectBasicData,
@ObjectModel.foreignKey.association: '_ProjectExternalID'
_ProjectBasicData.ProjectExternalID,
cast( cast( 'X' as abap.char( 1 ) ) as fins_xsemtag_calculated) as LineIsSemTagCalculated,
@Semantics.currencyCode:true
GlobalCurrency,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@Semantics.currencyCode:true
FreeDefinedCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
AmountInCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
AmountInFreeDefinedCurrency1,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
AmountInGlobalCurrency,
// Key Figures in Global Currency
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
BilledRevenueAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
SalesDeductionAmountInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
RevenueAdjustAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
RecognizedRevnAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
VarblCOGSAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
ContrbnMargin1AmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
FxdCOGSAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
PriceDifferenceAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
ContrbnMargin2AmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
AdminOverheadAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
SalesOverheadAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
MarketingOverheadAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
RnDOverheadAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
ContrbnMargin3AmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
// cast( cast ('0' as abap.curr( 23,2)) as fin_inptprvarcamt_in_globcrcy ) as InptPriceVarcAmtInGlobCrcy,
case when SemanticTag = 'INPTPRCVAR' then cast (AmountInGlobalCurrency * (-1) as fin_inptprvarcamt_in_globcrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_inptprvarcamt_in_globcrcy) end as InptPriceVarcAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
// cast( cast ('0' as abap.curr( 23,2)) as fin_inptqtyvarcamt_in_globcrcy ) as InptQtyVarcAmtInGlobCrcy,
case when SemanticTag = 'INPTQTYVAR' then cast (AmountInGlobalCurrency * (-1) as fin_inptqtyvarcamt_in_globcrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_inptqtyvarcamt_in_globcrcy) end as InptQtyVarcAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
//cast( cast ('0' as abap.curr( 23,2)) as fin_rsceusgevarcamt_in_glbcrcy ) as RsceUsgeVarcAmtInGlobCrcy,
case when SemanticTag = 'RSCUSGEVAR' then cast (AmountInGlobalCurrency * (-1) as fin_rsceusgevarcamt_in_glbcrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_rsceusgevarcamt_in_glbcrcy) end as RsceUsgeVarcAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
// cast( cast ('0' as abap.curr( 23,2)) as fin_lotsizevarcamt_in_globcrcy ) as LotSizeVarcAmtInGlobCrcy,
case when SemanticTag = 'LOSSIZEVAR' then cast (AmountInGlobalCurrency * (-1) as fin_lotsizevarcamt_in_globcrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_lotsizevarcamt_in_globcrcy) end as LotSizeVarcAmtInGlobCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
@DefaultAggregation: #SUM
//cast( cast ('0' as abap.curr( 23,2)) as fin_inptrmngvarcamt_in_glbcrcy ) as InputRmngVarcAmtInGlobCrcy,
case when SemanticTag = 'INPTREMVAR' then cast (AmountInGlobalCurrency * (-1) as fin_inptrmngvarcamt_in_glbcrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_inptrmngvarcamt_in_glbcrcy) end as InputRmngVarcAmtInGlobCrcy,
// Key Figures in Company Code Currency
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(BilledRevenueAmtInCoCodeCrcy as fins_billed_revenue_cccrcy preserving type ) as BilledRevenueAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(SalesDeductionAmtInCoCodeCrcy as fins_sales_deduction_cccrcy preserving type ) as SalesDeductionAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(RevenueAdjustmentAmtInCCCrcy as fis_adj_rev_hsl preserving type ) as RevenueAdjustmentAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(RecognizedRevnAmtInCCCrcy as fis_reco_rev_hsl preserving type ) as RecognizedRevnAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(VarblCOGSAmtInCCCrcy as fins_cogs_variable_cccrcy preserving type ) as VarblCOGSAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(ContrbnMargin1AmtInCoCodeCrcy as fins_cogs_contribmarg_1_cccrcy preserving type ) as ContrbnMargin1AmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(FxdCOGSAmtInCCCrcy as fins_cogs_fixed_ccrcy preserving type ) as FxdCOGSAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(PriceDifferenceAmtInCCCrcy as fins_price_differences_cccrcy preserving type ) as PriceDifferenceAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(ContrbnMargin2AmtInCoCodeCrcy as fins_cogs_contribmarg_2_cccrcy preserving type ) as ContrbnMargin2AmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(AdminOverheadAmtInCoCodeCrcy as fins_admin_overhead_cccrcy preserving type ) as AdminOverheadAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(SalesOverheadAmtInCoCodeCrcy as fins_sales_overhead_cccrcy preserving type ) as SalesOverheadAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(MarketingOvhdAmtInCoCodeCrcy as fins_marketing_overhead_cccrcy preserving type ) as MarketingOvhdAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(RnDOverheadAmtInCCCrcy as fins_resear_dev_overhead_ccrcy preserving type ) as RnDOverheadAmtInCCCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
cast(ContrbnMargin3AmtInCoCodeCrcy as fins_cogs_contribmarg_3_cccrcy preserving type ) as ContrbnMargin3AmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
//cast( cast ('0' as abap.curr( 23,2)) as fin_inptprvarcamt_in_cccrcy preserving type ) as InptPriceVarcAmtInCoCodeCrcy,
case when SemanticTag = 'INPTPRCVAR' then cast (AmountInCompanyCodeCurrency * (-1) as fin_inptprvarcamt_in_cccrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_inptprvarcamt_in_cccrcy) end as InptPriceVarcAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
//cast( cast ('0' as abap.curr( 23,2)) as fin_inptqtyvarcamt_in_cccrcy preserving type ) as InptQtyVarcAmtInCoCodeCrcy,
case when SemanticTag = 'INPTQTYVAR' then cast (AmountInCompanyCodeCurrency * (-1) as fin_inptqtyvarcamt_in_cccrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_inptqtyvarcamt_in_cccrcy) end as InptQtyVarcAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
//cast( cast ('0' as abap.curr( 23,2)) as fin_rsceusgevarcamt_in_cccrcy preserving type ) as RsceUsgeVarcAmtInCoCodeCrcy,
case when SemanticTag = 'RSCUSGEVAR' then cast (AmountInCompanyCodeCurrency * (-1) as fin_rsceusgevarcamt_in_cccrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_rsceusgevarcamt_in_cccrcy) end as RsceUsgeVarcAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
//cast( cast ('0' as abap.curr( 23,2)) as fin_lotsizevarcamt_in_cccrcy preserving type ) as LotSizeVarcAmtInCoCodeCrcy,
case when SemanticTag = 'LOSSIZEVAR' then cast (AmountInCompanyCodeCurrency * (-1) as fin_lotsizevarcamt_in_cccrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_lotsizevarcamt_in_cccrcy) end as LotSizeVarcAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
//cast( cast ('0' as abap.curr( 23,2)) as fin_inptrmngvarcamt_in_cccrcy preserving type ) as InputRmngVarcAmtInCoCodeCrcy,
case when SemanticTag = 'INPTREMVAR' then cast (AmountInCompanyCodeCurrency * (-1) as fin_inptrmngvarcamt_in_cccrcy)
else cast ( cast ('0' as abap.curr( 23,2)) as fin_inptrmngvarcamt_in_cccrcy) end as InputRmngVarcAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
BilledValnQtyInCostSourceUnit,
_Ledger,
_SourceLedger,
_JournalEntry,
_CompanyCode,
_SemanticTag,
_FiscalYear,
_Customer,
_CustomerGroup,
_SoldProduct,
_SoldProductGroup,
_ProfitCenter,
_ControllingArea,
_CostSourceUnit,
_SalesDocument,
_SalesOrder,
_SalesOrderItem,
_Order,
_DistributionChannel,
_BaseUnit,
_Segment,
_ChartOfAccounts,
_GLAccountInChartOfAccounts,
//_WBSElement,
//_Project,
//_ProjectNetwork,
_FunctionalArea,
_Plant,
_SalesOrganization,
_SalesDistrict,
_CustomerSupplierCountry,
_ShipToParty,
_BillToParty
}
where
I_GLAccountLineItemSemTag.GLAccountHierarchy = $parameters.P_GLAccountHierarchy
// and SoldProduct <> ''
// and AccountAssignmentType = 'EO'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMSEMTAG",
"I_GLACCTLINEITMSUBLDGRITMTYPEC",
"I_PROJECTBASICDATA"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COUNTRY",
"I_CUSTOMER",
"I_CUSTOMERGROUP",
"I_DISTRIBUTIONCHANNEL",
"I_FISCALYEARFORCOMPANYCODE",
"I_FUNCTIONALAREA",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_JOURNALENTRY",
"I_LEDGER",
"I_ORDER",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTGROUP",
"I_PROFITCENTER",
"I_PROJECTBASICDATA",
"I_PROJECTBYEXTERNALID",
"I_SALESDISTRICT",
"I_SALESDOCUMENT",
"I_SALESORDER",
"I_SALESORDERITEM",
"I_SALESORGANIZATION",
"I_SEGMENT",
"I_SEMANTICTAG",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_GLACCTLINEITMSUBLDGRITMTYPEC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/