@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PFIOPACCTGDCBRWS'
@VDM.viewType: #COMPOSITE
@VDM.private:true
//@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Operational Accounting Document Header and Item'
//@ObjectModel.representativeKey: 'AccountingDocumentItem'
//@ObjectModel.usageType.sizeCategory: #XXL
//@ObjectModel.usageType.dataClass: #TRANSACTIONAL
//@ObjectModel.usageType.serviceQuality: #D
//@Analytics: { dataCategory: #CUBE, dataExtraction.enabled: true }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
define view P_OperationalAcctgDocBrowser
with parameters P_ClearingStatusSelection : fis_clearingstatusselection
as select from I_OperationalAcctgDocItem
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association [0..1] to I_SalesDocumentItem as _SalesDocumentItem on $projection.SalesDocument = _SalesDocumentItem.SalesDocument
and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
and _CurrentCostCenter.ValidityStartDate <= $session.system_date
and _CurrentCostCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_AdditionalCurrencyRoles as _AdditionalCurrencyRoles on $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode
and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup
and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_Fund as _Fund on $projection.FinancialManagementArea = _Fund.FinancialManagementArea
and $projection.Fund = _Fund.Fund
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
{
@Consumption.hidden: true
key cast( cast( '1' as abap.char(1)) as fis_bstat_grp preserving type ) as AccountingDocumentCatGroup,
@ObjectModel.foreignKey.association: '_CompanyCode'
key CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
key FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key AccountingDocument,
key AccountingDocumentItem,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
ClearingDate,
ClearingCreationDate,
ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
ClearingAccountingDocument,
PostingKey,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
SpecialGLCode,
SpecialGLTransactionType,
DebitCreditCode,
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
PartnerBusinessArea,
TaxCode,
WithholdingTaxCode,
TaxType,
TransactionTypeDetermination,
ValueDate,
AssignmentReference,
DocumentItemText,
PartnerCompany,
FinancialTransactionType,
CorporateGroupAccount,
PlanningLevel,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@ObjectModel.foreignKey.association: '_CostCenter'
CostCenter,
//ProjectInternalID, -- to be retrieved later from WBS Element
@ObjectModel.foreignKey.association: '_Order'
OrderID,
BillingDocument,
SalesDocument,
SalesDocumentItem,
ScheduleLine,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
FixedAsset,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
AssetTransactionType,
AssetValueDate,
PersonnelNumber,
IsSalesRelated,
//xhres,
LineItemDisplayIsEnabled,
IsOpenItemManaged,
IsNotCashDiscountLiable,
IsAutomaticallyCreated,
IsUsedInPaymentTransaction,
OperationalGLAccount,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
GLAccount,
Customer,
Supplier,
BranchAccount,
IsBalanceSheetAccount,
ProfitLossAccountType,
SpecialGLAccountAssignment,
DueCalculationBaseDate,
PaymentTerms,
CashDiscount1Days,
CashDiscount2Days,
NetPaymentDays,
CashDiscount1Percent, // ?????????
CashDiscount2Percent, // ??????
PaymentMethod,
PaymentBlockingReason,
FixedCashDiscount,
HouseBank,
BPBankAccountInternalID,
TaxDistributionCode1,
TaxDistributionCode2,
TaxDistributionCode3,
InvoiceReference,
InvoiceReferenceFiscalYear,
InvoiceItemReference,
FollowOnDocumentType,
StateCentralBankPaymentReason,
SupplyingCountry,
InvoiceList,
BillOfExchangeUsage,
DunningKey,
DunningBlockingReason,
LastDunningDate,
DunningLevel,
DunningArea,
WithholdingTaxCertificate,
@ObjectModel.foreignKey.association: '_Product'
Product,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
PurchasingDocumentItem,
AccountAssignmentNumber,
IsCompletelyDelivered,
MaterialPriceControl,
@ObjectModel.foreignKey.association: '_ValuationArea'
ValuationArea,
InventoryValuationType,
VATRegistration,
DelivOfGoodsDestCountry,
PaymentDifferenceReason,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
JointVenturePartner,
TreasuryContractType,
AssetContract,
CashFlowType,
//depot,
TaxJurisdiction,
REInternalFinNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REInternalFinNumber'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
RealEstateObject,
SettlementReferenceDate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'CommitmentItemShortID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'CommitmentItemShortID'
CommitmentItem,
CommitmentItemShortID,
CostObject,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
OrderInternalBillOfOperations,
OrderIntBillOfOperationsItem,
cast( WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
@API.element.releaseState: #DECOMMISSIONED
@API.element.successor: 'ProfitabilitySegment_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProfitabilitySegment_2'
cast( case when ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) as ProfitabilitySegment,
ProfitabilitySegment_2,
JointVentureEquityType,
IsEUTriangularDeal,
CostOriginGroup,
CompanyCodeCurrencyDetnMethod,
ClearingIsReversed,
PaymentMethodSupplement,
AlternativeGLAccount,
PartnerProfitCenter,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
IsNegativePosting,
PaymentCardItem,
PaymentCardPaymentSettlement,
CreditControlArea,
Reference3IDByBusinessPartner,
DataExchangeInstruction1,
DataExchangeInstruction2,
DataExchangeInstruction3,
DataExchangeInstruction4,
Region,
HasPaymentOrder,
PaymentReference,
TaxDeterminationDate,
ClearingItem,
BusinessPlace,
TaxSection,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
CostCtrActivityType,
AccountsReceivableIsPledged,
AcctsReceivablePledgingCode,
@ObjectModel.foreignKey.association: '_BusinessProcess'
BusinessProcess,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
CustomerIsInExecution,
ClearingJournalEntryFiscalYear,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
ClearingDocFiscalYear,
LedgerGLLineItem,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
PartnerSegment,
PartnerFunctionalArea,
HouseBankAccount,
CostElement,
PaymentServiceProvider,
PaymentRefByPaytSrvcProvider,
SEPAMandate,
ReferenceDocumentType,
OriginalReferenceDocument,
ReferenceDocumentLogicalSystem,
AccountingDocumentItemRef,
FiscalPeriod,
AccountingDocumentCategory,
PostingDate,
DocumentDate,
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
AccountingDocumentType,
NetDueDate,
CashDiscount1DueDate,
CashDiscount2DueDate,
OffsettingAccount,
OffsettingAccountType,
OffsettingChartOfAccounts,
@ObjectModel.foreignKey.association: '_CashLedgerCompanyCode'
CashLedgerCompanyCode,
@ObjectModel.foreignKey.association: '_CashLedgerAccount'
CashLedgerAccount,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FinMgmtAreaStdVH',
element: 'FinancialManagementArea' }
}]
// @ObjectModel.text.association: '_FinancialManagementAreaText'
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
_JournalEntry.FinancialManagementArea as FinancialManagementArea,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundsCenterStdVH',
element: 'FundsCenter' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
@ObjectModel.foreignKey.association: '_FundsCenter'
FundsCenter,
@ObjectModel.foreignKey.association: '_FundedProgram'
FundedProgram,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_FundText'
@ObjectModel.foreignKey.association: '_Fund'
Fund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_Grant'
GrantID,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BudgetPeriodStdVH',
element: 'BudgetPeriod' }
}]
// @ObjectModel.text.association: '_BudgetPeriodText'
@ObjectModel.foreignKey.association: '_BudgetPeriod'
BudgetPeriod,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_PartnerFundText'
@ObjectModel.foreignKey.association: '_PartnerFund'
PartnerFund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerGrant'
PartnerGrant,
@ObjectModel.foreignKey.association: '_PartnerBudgetPeriod'
PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccount'
PubSecBudgetAccount,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccountCoCode'
PubSecBudgetAccountCoCode,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } AmountInCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }TaxAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } TaxBaseAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } ValuationDiffAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( CashDiscountAmtInCoCodeCrcy as fis_sknto preserving type ) as CashDiscountAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } InvoiceAmtInCoCodeCrcy,
@Semantics.currencyCode:true
FunctionalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
AmountInFunctionalCurrency,
@ObjectModel.foreignKey.association: '_TransactionCurrency'
@Semantics.currencyCode:true
TransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } AmountInTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } OriginalTaxBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } TaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } TaxBaseAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } PlannedAmtInTransactionCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( CashDiscountBaseAmount as fis_skfbt preserving type ) as CashDiscountBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } CashDiscountAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } NetPaymentAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxExemptionAmt,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } InvoiceAmountInFrgnCurrency,
@Semantics.currencyCode:true
BalanceTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } AmountInBalanceTransacCrcy,
@Semantics.currencyCode:true
AdditionalCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } ValuationDiffAmtInAddlCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } AmountInAdditionalCurrency1,
@Semantics.currencyCode:true
AdditionalCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } AmountInAdditionalCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } ValuationDiffAmtInAddlCrcy2,
@Semantics.currencyCode:true
PaymentCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'PaymentCurrency'} } AmountInPaymentCurrency,
@Semantics.currencyCode:true
CreditControlAreaCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} } HedgedAmount,
@ObjectModel.foreignKey.association: '_BaseUnit'
@Semantics.unitOfMeasure:true
BaseUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
case IsNegativePosting when 'X' then case DebitCreditCode when 'S' then cast(-Quantity as quan1_12)
when 'H' then cast( Quantity as quan1_12)
end
when ' ' then case DebitCreditCode when 'H' then cast(-Quantity as quan1_12)
when 'S' then cast( Quantity as quan1_12)
end
else cast( Quantity as quan1_12)
end as Quantity,
/*cast( case IsNegativePosting when 'X' then case DebitCreditCode when 'S' then -Quantity
when 'H' then Quantity
end
when ' ' then case DebitCreditCode when 'H' then -Quantity
when 'S' then Quantity
end
else Quantity
end as quan1_12) as Quantity,*/
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} } cast( Quantity as fis_absolute_quantity ) as AbsoluteQuantity,
@Semantics.unitOfMeasure:true
GoodsMovementEntryUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} } QuantityInEntryUnit,
@Semantics.unitOfMeasure:true
PurchasingDocumentPriceUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} } PurchaseOrderQty,
MaterialPriceUnitQty,
_JournalEntry.Ledger as Ledger,
_JournalEntry.LedgerGroup as LedgerGroup,
NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
_CompanyCode,
_FiscalYear,
_JournalEntry,
_GLAccountInChartOfAccounts,
_ChartOfAccounts,
_PostingKey,
_FinancialAccountType,
_DebitCreditCode,
_BusinessArea,
_PartnerBusinessArea,
_TaxType,
// _PartnerCompany,
_ControllingArea,
_ProfitCenter,
_CostCenter,
_SupplyingCountry,
_Product,
_Plant,
_BaseUnit,
_InventoryValuationType,
_PaymentDifferenceReason,
_Segment,
_PartnerSegment,
_WBSElementBasicData,
_AccountingDocumentType,
_TransactionCurrency,
_InternalOrder,
_Order,
_MasterFixedAsset,
_FixedAsset,
_AssetTransactionType,
_PurchasingDocument,
_PurchasingDocumentItem,
//@API.element.releaseState: #DEPRECATED
//@API.element.successor: ''
//@VDM.lifecycle.status: #DEPRECATED
//@VDM.lifecycle.successor: ''
_ValuationArea,
_ProjectNetwork,
_CostCtrActivityType,
_BusinessProcess,
_FunctionalArea,
_AdditionalCurrencyRoles,
_CurrentCostCenter,
_CurrentProfitCenter,
_Customer,
_CustomerCompany,
_GLAccountInCompanyCode,
_SalesDocument,
_ServiceDocument,
_Supplier,
_SupplierCompany,
_JournalEntry._FinancialManagementArea,
_FundsCenter,
_Fund,
_PartnerFund,
_FundedProgram,
_CashLedgerCompanyCode,
_CashLedgerAccount,
_BudgetPeriod,
_PartnerBudgetPeriod,
_Grant,
_PartnerGrant,
_PubSecBudgetAccountCoCode,
_PubSecBudgetAccount
// _REObjectByIntFinNumber
}
//where AccountingDocumentCategory <> 'S'
where ( AccountingDocumentCategory = ' ' and SpecialGLCode = ' ' ) or
( SpecialGLCode <> ' ' and AccountingDocumentCategory <> 'S' and AccountingDocumentCategory <> 'V' and
AccountingDocumentCategory <> 'W' and AccountingDocumentCategory <> 'Z' )
union all
select from I_OperationalAcctgDocItem
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association [0..1] to I_SalesDocumentItem as _SalesDocumentItem on $projection.SalesDocument = _SalesDocumentItem.SalesDocument
and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
and _CurrentCostCenter.ValidityStartDate <= $session.system_date
and _CurrentCostCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_AdditionalCurrencyRoles as _AdditionalCurrencyRoles on $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode
and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup
and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_Fund as _Fund on $projection.FinancialManagementArea = _Fund.FinancialManagementArea
and $projection.Fund = _Fund.Fund
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
{
@Consumption.hidden: true
key cast( cast( '2' as abap.char(1)) as fis_bstat_grp preserving type ) as AccountingDocumentCatGroup,
@ObjectModel.foreignKey.association: '_CompanyCode'
key CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
key FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key AccountingDocument,
key AccountingDocumentItem,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
ClearingDate,
ClearingCreationDate,
ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
ClearingAccountingDocument,
PostingKey,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
SpecialGLCode,
SpecialGLTransactionType,
DebitCreditCode,
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
PartnerBusinessArea,
TaxCode,
WithholdingTaxCode,
TaxType,
TransactionTypeDetermination,
ValueDate,
AssignmentReference,
DocumentItemText,
PartnerCompany,
FinancialTransactionType,
CorporateGroupAccount,
PlanningLevel,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@ObjectModel.foreignKey.association: '_CostCenter'
CostCenter,
//ProjectInternalID, -- to be retrieved later from WBS Element
@ObjectModel.foreignKey.association: '_Order'
OrderID,
BillingDocument,
SalesDocument,
SalesDocumentItem,
ScheduleLine,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
FixedAsset,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
AssetTransactionType,
AssetValueDate,
PersonnelNumber,
IsSalesRelated,
//xhres,
LineItemDisplayIsEnabled,
IsOpenItemManaged,
IsNotCashDiscountLiable,
IsAutomaticallyCreated,
IsUsedInPaymentTransaction,
OperationalGLAccount,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
GLAccount,
Customer,
Supplier,
BranchAccount,
IsBalanceSheetAccount,
ProfitLossAccountType,
SpecialGLAccountAssignment,
DueCalculationBaseDate,
PaymentTerms,
CashDiscount1Days,
CashDiscount2Days,
NetPaymentDays,
CashDiscount1Percent, // ?????????
CashDiscount2Percent, // ??????
PaymentMethod,
PaymentBlockingReason,
FixedCashDiscount,
HouseBank,
BPBankAccountInternalID,
TaxDistributionCode1,
TaxDistributionCode2,
TaxDistributionCode3,
InvoiceReference,
InvoiceReferenceFiscalYear,
InvoiceItemReference,
FollowOnDocumentType,
StateCentralBankPaymentReason,
SupplyingCountry,
InvoiceList,
BillOfExchangeUsage,
DunningKey,
DunningBlockingReason,
LastDunningDate,
DunningLevel,
DunningArea,
WithholdingTaxCertificate,
@ObjectModel.foreignKey.association: '_Product'
Product,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
PurchasingDocumentItem,
AccountAssignmentNumber,
IsCompletelyDelivered,
MaterialPriceControl,
@ObjectModel.foreignKey.association: '_ValuationArea'
ValuationArea,
InventoryValuationType,
VATRegistration,
DelivOfGoodsDestCountry,
PaymentDifferenceReason,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
JointVenturePartner,
TreasuryContractType,
AssetContract,
CashFlowType,
//depot,
TaxJurisdiction,
REInternalFinNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REInternalFinNumber'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
RealEstateObject,
SettlementReferenceDate,
CommitmentItem,
CommitmentItemShortID,
CostObject,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
OrderInternalBillOfOperations,
OrderIntBillOfOperationsItem,
cast( WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ProfitabilitySegment_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProfitabilitySegment_2'
ProfitabilitySegment,
ProfitabilitySegment_2,
JointVentureEquityType,
IsEUTriangularDeal,
CostOriginGroup,
CompanyCodeCurrencyDetnMethod,
ClearingIsReversed,
PaymentMethodSupplement,
AlternativeGLAccount,
PartnerProfitCenter,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
IsNegativePosting,
PaymentCardItem,
PaymentCardPaymentSettlement,
CreditControlArea,
Reference3IDByBusinessPartner,
DataExchangeInstruction1,
DataExchangeInstruction2,
DataExchangeInstruction3,
DataExchangeInstruction4,
Region,
HasPaymentOrder,
PaymentReference,
TaxDeterminationDate,
ClearingItem,
BusinessPlace,
TaxSection,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
CostCtrActivityType,
AccountsReceivableIsPledged,
AcctsReceivablePledgingCode,
@ObjectModel.foreignKey.association: '_BusinessProcess'
BusinessProcess,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
CustomerIsInExecution,
ClearingJournalEntryFiscalYear,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
ClearingDocFiscalYear,
LedgerGLLineItem,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
PartnerSegment,
PartnerFunctionalArea,
HouseBankAccount,
CostElement,
PaymentServiceProvider,
PaymentRefByPaytSrvcProvider,
SEPAMandate,
ReferenceDocumentType,
OriginalReferenceDocument,
ReferenceDocumentLogicalSystem,
AccountingDocumentItemRef,
FiscalPeriod,
AccountingDocumentCategory,
PostingDate,
DocumentDate,
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
AccountingDocumentType,
NetDueDate,
CashDiscount1DueDate,
CashDiscount2DueDate,
OffsettingAccount,
OffsettingAccountType,
OffsettingChartOfAccounts,
@ObjectModel.foreignKey.association: '_CashLedgerCompanyCode'
CashLedgerCompanyCode,
@ObjectModel.foreignKey.association: '_CashLedgerAccount'
CashLedgerAccount,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FinMgmtAreaStdVH',
element: 'FinancialManagementArea' }
}]
// @ObjectModel.text.association: '_FinancialManagementAreaText'
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
_JournalEntry.FinancialManagementArea as FinancialManagementArea,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundsCenterStdVH',
element: 'FundsCenter' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
@ObjectModel.foreignKey.association: '_FundsCenter'
FundsCenter,
@ObjectModel.foreignKey.association: '_FundedProgram'
FundedProgram,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_FundText'
@ObjectModel.foreignKey.association: '_Fund'
Fund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_Grant'
GrantID,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BudgetPeriodStdVH',
element: 'BudgetPeriod' }
}]
// @ObjectModel.text.association: '_BudgetPeriodText'
@ObjectModel.foreignKey.association: '_BudgetPeriod'
BudgetPeriod,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_PartnerFundText'
@ObjectModel.foreignKey.association: '_PartnerFund'
PartnerFund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerGrant'
PartnerGrant,
@ObjectModel.foreignKey.association: '_PartnerBudgetPeriod'
PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccount'
PubSecBudgetAccount,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccountCoCode'
PubSecBudgetAccountCoCode,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } AmountInCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }TaxAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } TaxBaseAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } ValuationDiffAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( CashDiscountAmtInCoCodeCrcy as fis_sknto preserving type ) as CashDiscountAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } InvoiceAmtInCoCodeCrcy,
@Semantics.currencyCode:true
FunctionalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
AmountInFunctionalCurrency,
@ObjectModel.foreignKey.association: '_TransactionCurrency'
@Semantics.currencyCode:true
TransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } AmountInTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } OriginalTaxBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } TaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } TaxBaseAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } PlannedAmtInTransactionCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( CashDiscountBaseAmount as fis_skfbt preserving type ) as CashDiscountBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } CashDiscountAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } NetPaymentAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxExemptionAmt,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } InvoiceAmountInFrgnCurrency,
@Semantics.currencyCode:true
BalanceTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } AmountInBalanceTransacCrcy,
@Semantics.currencyCode:true
AdditionalCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } ValuationDiffAmtInAddlCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } AmountInAdditionalCurrency1,
@Semantics.currencyCode:true
AdditionalCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } AmountInAdditionalCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } ValuationDiffAmtInAddlCrcy2,
@Semantics.currencyCode:true
PaymentCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'PaymentCurrency'} } AmountInPaymentCurrency,
@Semantics.currencyCode:true
CreditControlAreaCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} } HedgedAmount,
@ObjectModel.foreignKey.association: '_BaseUnit'
@Semantics.unitOfMeasure:true
BaseUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
case IsNegativePosting when 'X' then case DebitCreditCode when 'S' then cast(-Quantity as quan1_12)
when 'H' then cast( Quantity as quan1_12)
end
when ' ' then case DebitCreditCode when 'H' then cast(-Quantity as quan1_12)
when 'S' then cast( Quantity as quan1_12)
end
else cast( Quantity as quan1_12)
end as Quantity,
/*cast( case IsNegativePosting when 'X' then case DebitCreditCode when 'S' then -Quantity
when 'H' then Quantity
end
when ' ' then case DebitCreditCode when 'H' then -Quantity
when 'S' then Quantity
end
else Quantity
end as quan1_12) as Quantity,*/
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} } cast( Quantity as fis_absolute_quantity ) as AbsoluteQuantity,
@Semantics.unitOfMeasure:true
GoodsMovementEntryUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} } QuantityInEntryUnit,
@Semantics.unitOfMeasure:true
PurchasingDocumentPriceUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} } PurchaseOrderQty,
MaterialPriceUnitQty,
_JournalEntry.Ledger as Ledger,
_JournalEntry.LedgerGroup as LedgerGroup,
NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
_CompanyCode,
_FiscalYear,
_JournalEntry,
_GLAccountInChartOfAccounts,
_ChartOfAccounts,
_PostingKey,
_FinancialAccountType,
_DebitCreditCode,
_BusinessArea,
_PartnerBusinessArea,
_TaxType,
// _PartnerCompany,
_ControllingArea,
_ProfitCenter,
_CostCenter,
_SupplyingCountry,
_Product,
_Plant,
_BaseUnit,
_InventoryValuationType,
_PaymentDifferenceReason,
_Segment,
_PartnerSegment,
_WBSElementBasicData,
_AccountingDocumentType,
_TransactionCurrency,
_InternalOrder,
_Order,
_MasterFixedAsset,
_FixedAsset,
_AssetTransactionType,
_PurchasingDocument,
_PurchasingDocumentItem,
//@API.element.releaseState: #DEPRECATED
//@API.element.successor: ''
//@VDM.lifecycle.status: #DEPRECATED
//@VDM.lifecycle.successor: ''
_ValuationArea,
_ProjectNetwork,
_CostCtrActivityType,
_BusinessProcess,
_FunctionalArea,
_AdditionalCurrencyRoles,
_CurrentCostCenter,
_CurrentProfitCenter,
_Customer,
_CustomerCompany,
_GLAccountInCompanyCode,
_SalesDocument,
_ServiceDocument,
_Supplier,
_SupplierCompany,
_JournalEntry._FinancialManagementArea,
_FundsCenter,
_Fund,
_PartnerFund,
_FundedProgram,
_CashLedgerCompanyCode,
_CashLedgerAccount,
_BudgetPeriod,
_PartnerBudgetPeriod,
_Grant,
_PartnerGrant,
_PubSecBudgetAccountCoCode,
_PubSecBudgetAccount
// _REObjectByIntFinNumber
}
where AccountingDocumentCategory = 'S'
union all
select from I_ParkedOplAcctgDocItem
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_JournalEntry as _JournalEntry on $projection.CompanyCode = _JournalEntry.CompanyCode
and $projection.FiscalYear = _JournalEntry.FiscalYear
and $projection.AccountingDocument = _JournalEntry.AccountingDocument
association [0..1] to I_InternalOrder as _InternalOrder on $projection.OrderID = _InternalOrder.InternalOrder
association [0..1] to I_Purreqvaluationarea as _ValuationArea on $projection.ValuationArea = _ValuationArea.ValuationArea
association [0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
and _CurrentCostCenter.ValidityStartDate <= $session.system_date
and _CurrentCostCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_AdditionalCurrencyRoles as _AdditionalCurrencyRoles on $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode
and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup
and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_Fund as _Fund on $projection.FinancialManagementArea = _Fund.FinancialManagementArea
and $projection.Fund = _Fund.Fund
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
association [0..1] to I_FinancialManagementArea as _FinancialManagementArea on $projection.FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea
association [0..1] to I_FiscalYearForCompanyCode as _FiscalYear on $projection.FiscalYear = _FiscalYear.FiscalYear
and $projection.CompanyCode = _FiscalYear.CompanyCode
{
@Consumption.hidden: true
key cast( cast( '3' as abap.char(1)) as fis_bstat_grp preserving type ) as AccountingDocumentCatGroup,
@ObjectModel.foreignKey.association: '_CompanyCode'
key CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
key SourceFiscalYear as FiscalYear,//key FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key SourceAccountingDocument as AccountingDocument, //key AccountingDocument,
key SourceAccountingDocumentItem as AccountingDocumentItem, //key AccountingDocumentItem,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
//buzid,
cast( '00000000' as abap.dats( 8)) as ClearingDate,
cast( '00000000' as abap.dats( 8)) as ClearingCreationDate,
cast( '' as abap.char(10)) as ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
cast( '' as abap.char(10)) as ClearingAccountingDocument,
PostingKey,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
SpecialGLCode,
SpecialGLTransactionType,
DebitCreditCode,
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
PartnerBusinessArea,
TaxCode,
WithholdingTaxCode,
TaxType,
cast( '' as abap.char(3)) as TransactionTypeDetermination,
ValueDate,
AssignmentReference,
DocumentItemText,
PartnerCompany,
FinancialTransactionType,
cast( '' as abap.char(10)) as CorporateGroupAccount,
PlanningLevel,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@ObjectModel.foreignKey.association: '_CostCenter'
CostCenter,
//ProjectInternalID, -- to be retrieved later from WBS Element
@ObjectModel.foreignKey.association: '_Order'
OrderID,
cast( '' as abap.char(10)) as BillingDocument,
cast( '' as abap.char(10)) as SalesDocument,
cast( '000000' as abap.numc(6)) as SalesDocumentItem,
cast( '0000' as abap.numc(4)) as ScheduleLine,
cast( '' as abap.char(4)) as ServiceDocumentType,
cast( '' as abap.char(10)) as ServiceDocument,
cast( '000000' as abap.numc(6)) as ServiceDocumentItem,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
FixedAsset,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
AssetTransactionType,
AssetValueDate,
PersonnelNumber,
IsSalesRelated,
cast( '' as abap.char(1)) as LineItemDisplayIsEnabled,
cast( '' as abap.char(1)) as IsOpenItemManaged,
IsNotCashDiscountLiable,
cast( '' as abap.char(1)) as IsAutomaticallyCreated,
cast( '' as abap.char(1)) as IsUsedInPaymentTransaction,
cast( '' as abap.char(10)) as OperationalGLAccount,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
GLAccount,
cast( Customer as kunnr preserving type ) as Customer,
cast( Supplier as md_supplier preserving type ) as Supplier,
BranchAccount, //cast( '' as abap.char(10)) as BranchAccount,
cast( '' as abap.char(1)) as IsBalanceSheetAccount,
cast( '' as abap.char(2)) as ProfitLossAccountType,
SpecialGLAccountAssignment,
DueCalculationBaseDate,
PaymentTerms,
CashDiscount1Days,
CashDiscount2Days,
NetPaymentDays, //cast( '000' as abap.dec(3,0)) as NetPaymentDays,
cast( CashDiscount1Percent as dzbd1p_farp preserving type ) as CashDiscount1Percent,
cast( CashDiscount2Percent as dzbd2p_farp preserving type ) as CashDiscount2Percent,
PaymentMethod,
cast( PaymentBlockingReason as fis_dzlspr preserving type ) as PaymentBlockingReason,
FixedCashDiscount,
HouseBank,
BPBankAccountInternalID, //cast( '' as abap.char(4)) as BPBankAccountInternalID,
cast( '' as abap.char(2)) as TaxDistributionCode1,
cast( '' as abap.char(2)) as TaxDistributionCode2,
cast( '' as abap.char(2)) as TaxDistributionCode3,
cast( InvoiceReference as fis_rebzg preserving type ) as InvoiceReference,
cast( InvoiceReferenceFiscalYear as fis_rebzj_no_conv preserving type ) as InvoiceReferenceFiscalYear,
InvoiceItemReference,
FollowOnDocumentType, //cast( '' as abap.char(1)) as FollowOnDocumentType,
StateCentralBankPaymentReason, //cast( '' as abap.char(3)) as StateCentralBankPaymentReason,
SupplyingCountry,
cast( InvoiceList as fis_samnr preserving type ) as InvoiceList,
cast( '' as abap.char(1)) as BillOfExchangeUsage,
DunningKey, //cast( '' as abap.char(1)) as DunningKey,
DunningBlockingReason, //cast( '' as abap.char(1)) as DunningBlockingReason,
LastDunningDate, //cast( '00000000' as abap.dats( 8)) as LastDunningDate,
DunningLevel, //cast( '' as abap.numc(1)) as DunningLevel,
DunningArea, //cast( '' as abap.char(2)) as DunningArea,
cast( '' as abap.char(10)) as WithholdingTaxCertificate,
@ObjectModel.foreignKey.association: '_Product'
Product,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
PurchasingDocumentItem,
AccountAssignmentNumber,
cast( '' as abap.char(1)) as IsCompletelyDelivered,
MaterialPriceControl, //cast( '' as abap.char(1)) as MaterialPriceControl,
@ObjectModel.foreignKey.association: '_ValuationArea'
ValuationArea,
InventoryValuationType,
VATRegistration,
cast( '' as abap.char(3)) as DelivOfGoodsDestCountry,
PaymentDifferenceReason,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
JointVenturePartner,
TreasuryContractType,
AssetContract,
CashFlowType,
TaxJurisdiction,
REInternalFinNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REInternalFinNumber'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
cast( '' as fis_imkey ) as RealEstateObject, //RealEstateObject,
SettlementReferenceDate,
cast( '' as fis_fipos ) as CommitmentItem, //cast(CommitmentItemShortID as fis_fipos preserving type ) as CommitmentItem,
CommitmentItemShortID,
CostObject,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
OrderInternalBillOfOperations, //cast( '0000000000' as abap.numc(10)) as OrderInternalBillOfOperations,
cast( '00000000' as abap.numc(8)) as OrderIntBillOfOperationsItem,
//@ObjectModel.foreignKey.association: '_WBSElementInternalID'
cast( WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ProfitabilitySegment_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProfitabilitySegment_2'
cast(ProfitabilitySegment as rkeobjnr_numc) as ProfitabilitySegment,
ProfitabilitySegment as ProfitabilitySegment_2,
JointVentureEquityType,
IsEUTriangularDeal, //cast( '' as abap.char(1)) as IsEUTriangularDeal,
CostOriginGroup,
CompanyCodeCurrencyDetnMethod, //cast( '' as abap.char(1)) as CompanyCodeCurrencyDetnMethod,
cast( '' as abap.char(1)) as ClearingIsReversed,
PaymentMethodSupplement,
cast( '' as abap.char(10)) as AlternativeGLAccount,
//stbuk,
cast( '' as abap.char(10)) as PartnerProfitCenter,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
cast( '' as abap.char(1)) as IsNegativePosting,
cast( '000' as abap.numc(3)) as PaymentCardItem,
PaymentCardPaymentSettlement,
CreditControlArea, //cast( '' as abap.char(4)) as CreditControlArea,
Reference3IDByBusinessPartner,
DataExchangeInstruction1, //cast( '00' as abap.numc(2)) as DataExchangeInstruction1,
DataExchangeInstruction2, //cast( '00' as abap.numc(2)) as DataExchangeInstruction2,
DataExchangeInstruction3, //cast( '00' as abap.numc(2)) as DataExchangeInstruction3,
DataExchangeInstruction4, //cast( '00' as abap.numc(2)) as DataExchangeInstruction4,
Region,
cast( '' as abap.char(1)) as HasPaymentOrder,
PaymentReference,
cast( '00000000' as abap.dats( 8)) as TaxDeterminationDate,
cast( '00000' as abap.dec(5,0)) as ClearingItem,
BusinessPlace,
cast( TaxSection as fis_secco preserving type ) as TaxSection,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
CostCtrActivityType,
cast( '' as abap.char(2)) as AccountsReceivableIsPledged,
cast( '' as abap.char(2)) as AcctsReceivablePledgingCode,
@ObjectModel.foreignKey.association: '_BusinessProcess'
BusinessProcess,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
cast( '' as abap.char(1)) as CustomerIsInExecution,
cast( '0000' as abap.numc(4)) as ClearingJournalEntryFiscalYear,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
cast( '0000' as abap.numc(4)) as ClearingDocFiscalYear,
cast( '' as abap.char(6)) as LedgerGLLineItem,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
PartnerSegment,
cast( '' as abap.char(16)) as PartnerFunctionalArea,
cast( HouseBankAccount as fac_hktid preserving type ) as HouseBankAccount,
cast( '' as abap.char(10)) as CostElement,
cast( '' as abap.char(4)) as PaymentServiceProvider,
cast( '' as abap.char(35)) as PaymentRefByPaytSrvcProvider,
cast( '' as abap.char(35)) as SEPAMandate,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.ReferenceDocumentType,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.OriginalReferenceDocument,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.ReferenceDocumentLogicalSystem,
cast( '0000000000' as abap.numc(10)) as AccountingDocumentItemRef,
FiscalPeriod, //_AccountingDocument.FiscalPeriod as FiscalPeriod,
AccountingDocumentCategory,
PostingDate,
cast( DocumentDate as fis_bldat) as DocumentDate, //cast( _AccountingDocument.DocumentDate as fis_bldat) as DocumentDate,
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
AccountingDocumentType,
NetDueDate,
CashDiscount1DueDate,
CashDiscount2DueDate,
cast( '' as abap.char(10)) as OffsettingAccount,
cast( '' as abap.char(1)) as OffsettingAccountType,
cast( '' as abap.char(4)) as OffsettingChartOfAccounts,
@ObjectModel.foreignKey.association: '_CashLedgerCompanyCode'
cast( '' as abap.char(4)) as CashLedgerCompanyCode,
@ObjectModel.foreignKey.association: '_CashLedgerAccount'
cast( '' as abap.char(10)) as CashLedgerAccount,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FinMgmtAreaStdVH',
element: 'FinancialManagementArea' }
}]
// @ObjectModel.text.association: '_FinancialManagementAreaText'
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
FinancialManagementArea, //_AccountingDocument.FinancialManagementArea as FinancialManagementArea,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundsCenterStdVH',
element: 'FundsCenter' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
@ObjectModel.foreignKey.association: '_FundsCenter'
FundsCenter,
@ObjectModel.foreignKey.association: '_FundedProgram'
FundedProgram,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_FundText'
@ObjectModel.foreignKey.association: '_Fund'
Fund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_Grant'
GrantID,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BudgetPeriodStdVH',
element: 'BudgetPeriod' }
}]
// @ObjectModel.text.association: '_BudgetPeriodText'
@ObjectModel.foreignKey.association: '_BudgetPeriod'
BudgetPeriod,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_PartnerFundText'
@ObjectModel.foreignKey.association: '_PartnerFund'
PartnerFund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerGrant'
PartnerGrant,
@ObjectModel.foreignKey.association: '_PartnerBudgetPeriod'
PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccount'
cast( '' as abap.char(10)) as PubSecBudgetAccount,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccountCoCode'
cast( '' as abap.char(4)) as PubSecBudgetAccountCoCode,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } AmountInCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( '0' as abap.curr( 23,2)) as TaxAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } TaxBaseAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( '0' as abap.curr( 23,2)) as ValuationDiffAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } CashDiscountAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } InvoiceAmtInCoCodeCrcy,
@Semantics.currencyCode:true
cast( ' ' as abap.cuky( 5 ) ) as FunctionalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
cast( '0' as abap.curr( 23,2)) as AmountInFunctionalCurrency,
@ObjectModel.foreignKey.association: '_TransactionCurrency'
@Semantics.currencyCode:true
TransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } AmountInTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as OriginalTaxBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } TaxAmount, //cast( '0' as abap.curr( 23,2)) as TaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } TaxBaseAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxBaseAmount, //cast( '0' as abap.curr( 23,2)) as WithholdingTaxBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } PlannedAmtInTransactionCrcy, //cast( '0' as abap.curr( 23,2)) as PlannedAmtInTransactionCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } CashDiscountBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( CashDiscountAmount as fis_wskto preserving type ) as CashDiscountAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as NetPaymentAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxAmount, //cast( '0' as abap.curr( 23,2)) as WithholdingTaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } WithholdingTaxExemptionAmt, //cast( '0' as abap.curr( 23,2)) as WithholdingTaxExemptionAmt,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } InvoiceAmountInFrgnCurrency,
@Semantics.currencyCode:true
cast( ' ' as abap.cuky(5)) as BalanceTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as AmountInBalanceTransacCrcy,
@Semantics.currencyCode:true
AdditionalCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } cast( '0' as abap.curr( 23,2)) as ValuationDiffAmtInAddlCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } AmountInAdditionalCurrency1,
@Semantics.currencyCode:true
AdditionalCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } AmountInAdditionalCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } cast( '0' as abap.curr( 23,2)) as ValuationDiffAmtInAddlCrcy2,
@Semantics.currencyCode:true
PaymentCurrency, //cast( ' ' as abap.cuky(5)) as PaymentCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'PaymentCurrency'} } cast( '0' as abap.curr( 23,2)) as AmountInPaymentCurrency,
@Semantics.currencyCode:true
cast( ' ' as abap.cuky(5)) as CreditControlAreaCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} } cast( '0' as abap.curr( 23,2)) as HedgedAmount,
@ObjectModel.foreignKey.association: '_BaseUnit'
@Semantics.unitOfMeasure:true
BaseUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
case DebitCreditCode when 'H' then cast(-Quantity as quan1_12)
when 'S' then cast( Quantity as quan1_12)
else cast( Quantity as quan1_12)
end as Quantity,
/*cast( case DebitCreditCode when 'H' then -Quantity
when 'S' then Quantity
else Quantity
end as quan1_12) as Quantity,*/
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} } cast( Quantity as fis_absolute_quantity ) as AbsoluteQuantity,
@Semantics.unitOfMeasure:true
cast( '' as abap.unit( 3 ) ) as GoodsMovementEntryUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} } cast( 0 as abap.quan( 23, 3 ) ) as QuantityInEntryUnit,
@Semantics.unitOfMeasure:true
cast( '' as abap.unit( 3 ) ) as PurchasingDocumentPriceUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} } cast( 0 as abap.quan( 23, 3 ) ) as PurchaseOrderQty,
MaterialPriceUnitQty, //cast( '0' as abap.dec(5)) as MaterialPriceUnitQty,
cast( '' as abap.char(2)) as Ledger,
LedgerGroup, //_AccountingDocument.LedgerGroup as LedgerGroup,
@DefaultAggregation: #SUM
cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) as NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
_CompanyCode,
_FiscalYear,
_JournalEntry,
_GLAccountInChartOfAccounts,
_ChartOfAccounts,
_PostingKey,
_FinancialAccountType,
_DebitCreditCode,
_BusinessArea,
_PartnerBusinessArea,
_TaxType,
// _PartnerCompany,
_ControllingArea,
_ProfitCenter,
_CostCenter,
_SupplyingCountry,
_Product,
_Plant,
_BaseUnit,
_InventoryValuationType,
_PaymentDifferenceReason,
_Segment,
_PartnerSegment,
_WBSElementBasicData,
_AccountingDocumentType,
_TransactionCurrency,
_InternalOrder,
_Order,
_MasterFixedAsset,
_FixedAsset,
_AssetTransactionType,
_PurchasingDocument,
_PurchasingDocumentItem,
//@API.element.releaseState: #DEPRECATED
//@API.element.successor: ''
//@VDM.lifecycle.status: #DEPRECATED
//@VDM.lifecycle.successor: ''
_ValuationArea,
_ProjectNetwork,
_CostCtrActivityType,
_BusinessProcess,
_FunctionalArea,
_AdditionalCurrencyRoles,
_CurrentCostCenter,
_CurrentProfitCenter,
_Customer,
_CustomerCompany,
_GLAccountInCompanyCode,
_SalesDocument,
_ServiceDocument,
_Supplier,
_SupplierCompany,
_FinancialManagementArea,
_FundsCenter,
_Fund,
_PartnerFund,
_FundedProgram,
_CashLedgerCompanyCode,
_CashLedgerAccount,
_BudgetPeriod,
_PartnerBudgetPeriod,
_Grant,
_PartnerGrant,
_PubSecBudgetAccountCoCode,
_PubSecBudgetAccount
// _REObjectByIntFinNumber
}
union all
select from I_AddlLedgerOplAcctgDocItem
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_JournalEntry as _JournalEntry on $projection.CompanyCode = _JournalEntry.CompanyCode
and $projection.FiscalYear = _JournalEntry.FiscalYear
and $projection.AccountingDocument = _JournalEntry.AccountingDocument
association [0..1] to I_TaxType as _TaxType on $projection.TaxType = _TaxType.TaxType
association [0..1] to I_Country as _SupplyingCountry on $projection.SupplyingCountry = _SupplyingCountry.Country
association [0..1] to I_Product as _Product on $projection.Product = _Product.Product
association [0..1] to I_PaymentDifferenceReason as _PaymentDifferenceReason on $projection.PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason
and $projection.CompanyCode = _PaymentDifferenceReason.CompanyCode
association [0..1] to I_Order as _Order on $projection.OrderID = _Order.OrderID
association [0..1] to I_PurchasingDocument as _PurchasingDocument on $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
association [0..1] to I_PurchasingDocumentItem as _PurchasingDocumentItem on $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument
and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
association [0..1] to I_Currency as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency
association [0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
and _CurrentCostCenter.ValidityStartDate <= $session.system_date
and _CurrentCostCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [0..1] to I_SupplierCompany as _SupplierCompany on $projection.Supplier = _SupplierCompany.Supplier
and $projection.CompanyCode = _SupplierCompany.CompanyCode
association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
association [0..1] to I_CustomerCompany as _CustomerCompany on $projection.Customer = _CustomerCompany.Customer
and $projection.CompanyCode = _CustomerCompany.CompanyCode
association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
association [0..1] to I_GLAccountInCompanyCode as _GLAccountInCompanyCode on $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode
and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount
association [0..1] to I_AccountingDocumentType as _AccountingDocumentType on $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType
association [0..1] to I_AdditionalCurrencyRoles as _AdditionalCurrencyRoles on $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode
and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup
and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_Fund as _Fund on $projection.FinancialManagementArea = _Fund.FinancialManagementArea
and $projection.Fund = _Fund.Fund
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
{
@Consumption.hidden: true
key cast( cast( '4' as abap.char(1)) as fis_bstat_grp preserving type ) as AccountingDocumentCatGroup,
@ObjectModel.foreignKey.association: '_CompanyCode'
key CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
key FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key AccountingDocument,
//key cast( substring( AccountingDocumentItem, 1, 3 ) as fis_buzei ) as AccountingDocumentItem0,
key cast( substring( AccountingDocumentItem, 4, 3 ) as fis_buzei ) as AccountingDocumentItem,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
ClearingDate,
ClearingCreationDate,
ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
ClearingAccountingDocument,
PostingKey,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
cast( ' ' as fac_umskz preserving type ) as SpecialGLCode,
cast( ' ' as farp_umsks preserving type ) as SpecialGLTransactionType,
DebitCreditCode,
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
PartnerBusinessArea,
TaxCode,
WithholdingTaxCode,
cast( ' ' as abap.char(1) ) as TaxType,
TransactionTypeDetermination,
ValueDate,
AssignmentReference,
DocumentItemText,
PartnerCompany,
FinancialTransactionType,
CorporateGroupAccount,
cast( ' ' as abap.char(2) ) as PlanningLevel,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@ObjectModel.foreignKey.association: '_CostCenter'
CostCenter,
//ProjectInternalID, -- to be retrieved later from WBS Element
@ObjectModel.foreignKey.association: '_Order'
OrderID,
cast( '' as abap.char(10)) as BillingDocument,
cast( '' as abap.char(10)) as SalesDocument,
cast( '000000' as abap.numc(6)) as SalesDocumentItem,
cast( '0000' as abap.numc(4)) as ScheduleLine,
cast( '' as abap.char(4)) as ServiceDocumentType,
cast( '' as abap.char(10)) as ServiceDocument,
cast( '000000' as abap.numc(6)) as ServiceDocumentItem,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
FixedAsset,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
AssetTransactionType,
cast ('00000000' as bzdat ) as AssetValueDate,
cast( '00000000' as abap.numc(8)) as PersonnelNumber,
cast( '' as abap.char(1)) as IsSalesRelated,
cast( '' as abap.char(1)) as LineItemDisplayIsEnabled,
IsOpenItemManaged,
cast( '' as abap.char(1)) as IsNotCashDiscountLiable,
IsAutomaticallyCreated,
cast( '' as abap.char(1)) as IsUsedInPaymentTransaction,
cast( '' as abap.char(10)) as OperationalGLAccount,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
GLAccount,
cast( '' as abap.char(10)) as Customer,
cast( '' as abap.char(10)) as Supplier,
cast( '' as abap.char(10)) as BranchAccount,
IsBalanceSheetAccount,
ProfitLossAccountType,
cast( '' as abap.char(18)) as SpecialGLAccountAssignment,
DueCalculationBaseDate,
cast( '' as abap.char(4)) as PaymentTerms,
cast( '0' as abap.dec(3,0)) as CashDiscount1Days,
cast( '0' as abap.dec(3,0)) as CashDiscount2Days,
cast( '000' as abap.dec(3,0)) as NetPaymentDays,
cast( '0' as abap.dec(5,3)) as CashDiscount1Percent,
cast( '0' as abap.dec(5,3)) as CashDiscount2Percent,
cast( '' as abap.char(1)) as PaymentMethod,
cast( '' as abap.char(1)) as PaymentBlockingReason,
cast( '' as abap.char(1)) as FixedCashDiscount,
cast( '' as abap.char(5)) as HouseBank,
cast( '' as abap.char(4)) as BPBankAccountInternalID,
cast( '' as abap.char(2)) as TaxDistributionCode1,
cast( '' as abap.char(2)) as TaxDistributionCode2,
cast( '' as abap.char(2)) as TaxDistributionCode3,
InvoiceReference,
InvoiceReferenceFiscalYear,
InvoiceItemReference,
FollowOnDocumentType,
cast( '' as abap.char(3)) as StateCentralBankPaymentReason,
cast( '' as abap.char(3)) as SupplyingCountry,
cast( '' as abap.numc(8)) as InvoiceList,
BillOfExchangeUsage,
cast( '' as abap.char(1)) as DunningKey,
cast( '' as abap.char(1)) as DunningBlockingReason,
cast( '00000000' as abap.dats( 8)) as LastDunningDate,
cast( '' as abap.numc(1)) as DunningLevel,
cast( '' as abap.char(2)) as DunningArea,
cast( '' as abap.char(10)) as WithholdingTaxCertificate,
@ObjectModel.foreignKey.association: '_Product'
Material as Product,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
cast( '' as abap.char(10)) as PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
cast( '' as abap.numc(5)) as PurchasingDocumentItem,
cast( '' as abap.numc(2)) as AccountAssignmentNumber,
cast( '' as abap.char(1)) as IsCompletelyDelivered,
cast( '' as abap.char(1)) as MaterialPriceControl,
@ObjectModel.foreignKey.association: '_ValuationArea'
ValuationArea,
InventoryValuationType,
cast( '' as abap.char(20)) as VATRegistration,
cast( '' as abap.char(3)) as DelivOfGoodsDestCountry,
//eglld,
cast( '' as abap.char(3)) as PaymentDifferenceReason,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
JointVenturePartner,
TreasuryContractType,
AssetContract,
CashFlowType,
cast( '' as abap.char(15)) as TaxJurisdiction,
REInternalFinNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REInternalFinNumber'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
RealEstateObject,
SettlementReferenceDate,
CommitmentItem,
cast( CommitmentItem as fis_fipos_shortid preserving type ) as CommitmentItemShortID,
CostObject,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
OrderInternalBillOfOperations,
OrderIntBillOfOperationsItem,
cast( WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ProfitabilitySegment_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProfitabilitySegment_2'
ProfitabilitySegment,
ProfitabilitySegment_2,
cast( '' as abap.char(3)) as JointVentureEquityType,
cast( '' as abap.char(1)) as IsEUTriangularDeal,
cast( '' as abap.char(4)) as CostOriginGroup,
cast( '' as abap.char(1)) as CompanyCodeCurrencyDetnMethod,
ClearingIsReversed,
PaymentMethodSupplement,
AlternativeGLAccount,
PartnerProfitCenter,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
cast( '' as abap.char(1)) as IsNegativePosting,
PaymentCardItem,
PaymentCardPaymentSettlement,
cast( '' as abap.char(4)) as CreditControlArea,
Reference3IDByBusinessPartner,
cast( '00' as abap.numc(2)) as DataExchangeInstruction1,
cast( '00' as abap.numc(2)) as DataExchangeInstruction2,
cast( '00' as abap.numc(2)) as DataExchangeInstruction3,
cast( '00' as abap.numc(2)) as DataExchangeInstruction4,
cast( '' as abap.char(3)) as Region,
cast( '' as abap.char(1)) as HasPaymentOrder,
cast( '' as abap.char(30)) as PaymentReference,
cast( '00000000' as abap.dats( 8)) as TaxDeterminationDate,
ClearingItem,
BusinessPlace,
TaxSection,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
CostCtrActivityType,
cast( '' as abap.char(2)) as AccountsReceivableIsPledged,
cast( '' as abap.char(2)) as AcctsReceivablePledgingCode,
@ObjectModel.foreignKey.association: '_BusinessProcess'
BusinessProcess,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
cast( '' as abap.char(1)) as CustomerIsInExecution,
ClearingJournalEntryFiscalYear,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
ClearingDocFiscalYear,
cast( '' as abap.char(6)) as LedgerGLLineItem,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
PartnerSegment,
PartnerFunctionalArea,
cast( '' as abap.char(5)) as HouseBankAccount,
CostElement,
cast( '' as abap.char(4)) as PaymentServiceProvider,
cast( '' as abap.char(35)) as PaymentRefByPaytSrvcProvider,
cast( '' as abap.char(35)) as SEPAMandate,
I_AddlLedgerOplAcctgDocItem._JournalEntry.ReferenceDocumentType,
I_AddlLedgerOplAcctgDocItem._JournalEntry.OriginalReferenceDocument,
I_AddlLedgerOplAcctgDocItem._JournalEntry.ReferenceDocumentLogicalSystem,
cast( '0000000000' as abap.numc(10)) as AccountingDocumentItemRef,
_JournalEntry.FiscalPeriod as FiscalPeriod,
AccountingDocumentCategory, // BSTAT directly from BSEG_ADD and not from BKPF
_JournalEntry.PostingDate,
cast( _JournalEntry.DocumentDate as fis_bldat) as DocumentDate,
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
_JournalEntry.AccountingDocumentType as AccountingDocumentType,
NetDueDate,
cast( '00000000' as abap.dats) as CashDiscount1DueDate,
cast( '00000000' as abap.dats) as CashDiscount2DueDate,
OffsettingAccount,
OffsettingAccountType,
OffsettingChartOfAccounts,
@ObjectModel.foreignKey.association: '_CashLedgerCompanyCode'
CashLedgerCompanyCode,
@ObjectModel.foreignKey.association: '_CashLedgerAccount'
CashLedgerAccount,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FinMgmtAreaStdVH',
element: 'FinancialManagementArea' }
}]
// @ObjectModel.text.association: '_FinancialManagementAreaText'
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
_JournalEntry.FinancialManagementArea as FinancialManagementArea,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundsCenterStdVH',
element: 'FundsCenter' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
@ObjectModel.foreignKey.association: '_FundsCenter'
FundsCenter,
@ObjectModel.foreignKey.association: '_FundedProgram'
FundedProgram,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_FundText'
@ObjectModel.foreignKey.association: '_Fund'
Fund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_Grant'
GrantID,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BudgetPeriodStdVH',
element: 'BudgetPeriod' }
}]
// @ObjectModel.text.association: '_BudgetPeriodText'
@ObjectModel.foreignKey.association: '_BudgetPeriod'
BudgetPeriod,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_PartnerFundText'
@ObjectModel.foreignKey.association: '_PartnerFund'
PartnerFund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerGrant'
PartnerGrant,
@ObjectModel.foreignKey.association: '_PartnerBudgetPeriod'
PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccount'
PubSecBudgetAccount,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccountCoCode'
PubSecBudgetAccountCoCode,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } AmountInCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }TaxAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( '0' as abap.curr( 23,2)) as TaxBaseAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } ValuationDiffAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( '0' as abap.curr( 23,2)) as CashDiscountAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( '0' as abap.curr( 23,2)) as InvoiceAmtInCoCodeCrcy,
@Semantics.currencyCode:true
FunctionalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
AmountInFunctionalCurrency,
@ObjectModel.foreignKey.association: '_TransactionCurrency'
@Semantics.currencyCode:true
TransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } AmountInTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as OriginalTaxBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } TaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as TaxBaseAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as WithholdingTaxBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as PlannedAmtInTransactionCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as CashDiscountBaseAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as CashDiscountAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as NetPaymentAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as WithholdingTaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as WithholdingTaxExemptionAmt,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( '0' as abap.curr( 23,2)) as InvoiceAmountInFrgnCurrency,
@Semantics.currencyCode:true
BalanceTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } AmountInBalanceTransacCrcy,
@Semantics.currencyCode:true
AdditionalCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } ValuationDiffAmtInAddlCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } AmountInAdditionalCurrency1,
@Semantics.currencyCode:true
AdditionalCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } AmountInAdditionalCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } ValuationDiffAmtInAddlCrcy2,
@Semantics.currencyCode:true
cast( ' ' as abap.cuky(5)) as PaymentCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'PaymentCurrency'} } cast( '0' as abap.curr( 23,2)) as AmountInPaymentCurrency,
@Semantics.currencyCode:true
cast( ' ' as abap.cuky(5)) as CreditControlAreaCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} } cast( '0' as abap.curr( 23,2)) as HedgedAmount,
@ObjectModel.foreignKey.association: '_BaseUnit'
@Semantics.unitOfMeasure:true
BaseUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
case DebitCreditCode when 'H' then cast(-Quantity as quan1_12)
when 'S' then cast( Quantity as quan1_12)
else cast( Quantity as quan1_12)
end as Quantity,
/*cast( case DebitCreditCode when 'H' then -Quantity
when 'S' then Quantity
else Quantity
end as quan1_12) as Quantity,*/
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} } cast( Quantity as fis_absolute_quantity ) as AbsoluteQuantity,
@Semantics.unitOfMeasure:true
cast( '' as abap.unit( 3 ) ) as GoodsMovementEntryUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} } cast( 0 as abap.quan( 23, 3 ) ) as QuantityInEntryUnit,
@Semantics.unitOfMeasure:true
cast( '' as abap.unit( 3 ) ) as PurchasingDocumentPriceUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} } cast( 0 as abap.quan( 23, 3 ) ) as PurchaseOrderQty,
cast( '0' as abap.dec(5)) as MaterialPriceUnitQty,
_JournalEntry.Ledger as Ledger,
_JournalEntry.LedgerGroup as LedgerGroup,
NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
_CompanyCode,
_FiscalYear,
_JournalEntry,
_GLAccountInChartOfAccounts,
_ChartOfAccounts,
_PostingKey,
_FinancialAccountType,
_DebitCreditCode,
_BusinessArea,
_PartnerBusinessArea,
_TaxType,
// _PartnerCompany,
_ControllingArea,
_ProfitCenter,
_CostCenter,
_SupplyingCountry,
_Product,
_Plant,
_BaseUnit,
_InventoryValuationType,
_PaymentDifferenceReason,
_Segment,
_PartnerSegment,
_WBSElementBasicData,
_AccountingDocumentType,
_TransactionCurrency,
_InternalOrder,
_Order,
_MasterFixedAsset,
_FixedAsset,
_AssetTransactionType,
_PurchasingDocument,
_PurchasingDocumentItem,
//@API.element.releaseState: #DEPRECATED
//@API.element.successor: ''
//@VDM.lifecycle.status: #DEPRECATED
//@VDM.lifecycle.successor: ''
_ValuationArea,
_ProjectNetwork,
_CostCtrActivityType,
_BusinessProcess,
_FunctionalArea,
_AdditionalCurrencyRoles,
_CurrentCostCenter,
_CurrentProfitCenter,
_Customer,
_CustomerCompany,
_GLAccountInCompanyCode,
_SalesDocument,
_ServiceDocument,
_Supplier,
_SupplierCompany,
_JournalEntry._FinancialManagementArea,
_FundsCenter,
_Fund,
_PartnerFund,
_FundedProgram,
_CashLedgerCompanyCode,
_CashLedgerAccount,
_BudgetPeriod,
_PartnerBudgetPeriod,
_Grant,
_PartnerGrant,
_PubSecBudgetAccountCoCode,
_PubSecBudgetAccount
// _REObjectByIntFinNumber
}