@AbapCatalog.sqlViewName: 'FAC_DZGLLDGRITEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Audit Z3 G/L Accounts-Line Items'
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@AbapCatalog.preserveKey: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view FAC_DART_Z3_GL_LEDGER_ITEM
with parameters
P_FiscalYear : fins_gjahr,
@EndUserText.label: 'From Fiscal Period'
P_FromFiscalPeriod : fins_fagl_fiscper_from,
@EndUserText.label: 'To Fiscal Period'
P_ToFiscalPeriod : fins_fagl_fiscper_to,
@Consumption.hidden: true
@Environment.systemField: #SYSTEM_LANGUAGE
P_Language : sylangu
as select from I_GLAccountLineItemCube as I_GLAccountLineItemCube
left outer join P_Bset on I_GLAccountLineItemCube.CompanyCode = P_Bset.CompanyCode
and I_GLAccountLineItemCube.FiscalYear = P_Bset.FiscalYear
and I_GLAccountLineItemCube.AccountingDocument = P_Bset.AccountingDocument
and I_GLAccountLineItemCube.AccountingDocumentItem = P_Bset.TaxItem
inner join I_LedgerCompanyCodeCrcyRoles on I_GLAccountLineItemCube.CompanyCode = I_LedgerCompanyCodeCrcyRoles.CompanyCode
and I_GLAccountLineItemCube.Ledger = I_LedgerCompanyCodeCrcyRoles.Ledger
association [0..*] to I_GLAccountText as _GLAcctInChartOfAccountsText on $projection.ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts
and $projection.GLAccount = _GLAcctInChartOfAccountsText.GLAccount
association [0..1] to I_FiscalPeriodForVariant as _FromFiscalPeriodForVariant on _FromFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant
and _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear
and _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod
association [0..1] to I_FiscalPeriodForVariant as _ToFiscalPeriodForVariant on _ToFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant
and _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear
and _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod
association [0..1] to I_OperationalAcctgDocItem as _OperationalAcctgDocItem on $projection.CompanyCode = _OperationalAcctgDocItem.CompanyCode
and $projection.AccountingDocument = _OperationalAcctgDocItem.AccountingDocument
and $projection.FiscalYear = _OperationalAcctgDocItem.FiscalYear
and $projection.AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem
association [1..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [1..1] to I_FiscalYearVariant as _FiscalYearVariant on $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
association [1..1] to I_Ledger as _Ledger on $projection.Ledger = _Ledger.Ledger
association[0..*] to I_FunctionalAreaText as _FunctionAreaText on _FunctionAreaText.FunctionalArea = $projection.FunctionalArea
association[0..*] to I_AccountingDocumentTypeText as _AccountingDocumentTypeText on _AccountingDocumentTypeText.AccountingDocumentType = $projection.AccountingDocumentType
{
@ObjectModel.foreignKey.association: '_Ledger'
key I_GLAccountLineItemCube.Ledger,
@ObjectModel.foreignKey.association: '_SourceLedger'
key SourceLedger,
@ObjectModel.foreignKey.association: '_CompanyCode'
key I_GLAccountLineItemCube.CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
// @Semantics.fiscal.year: true
key I_GLAccountLineItemCube.FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key I_GLAccountLineItemCube.AccountingDocument,
key I_GLAccountLineItemCube.LedgerGLLineItem,
@EndUserText.label: 'System Client'
$session.client as system_client,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
I_GLAccountLineItemCube.GLAccount,
@ObjectModel.foreignKey.association: '_FiscalPeriodForVariant'
@Semantics.fiscal.period: true
FiscalPeriod,
PostingDate,
I_GLAccountLineItemCube._JournalEntry.AccountingDocumentHeaderText as AccountingDocumentHeaderText,
@EndUserText.label: 'Original Reference Document'
I_GLAccountLineItemCube._JournalEntry.OriginalReferenceDocument,
ReferenceDocument,
@ObjectModel.foreignKey.association: '_ReferenceDocumentType'
ReferenceDocumentType,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
// @EndUserText.label: 'Reconciliation Account Type'
// _GLAccountInCompanyCode._Reconciliationaccttype._Text[1: Language = $session.system_language ].ReconciliationAccountTypeName,
// @EndUserText.label: 'Customer Business Partner No.'
// _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner as CustomerBusinessPartner,
// @EndUserText.label: 'Customer Business Partner Name'
// _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName as CustomerBusinessPartnerName,
//
// @EndUserText.label: 'Supplier Business Partner No.'
// _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner as SupplierBusinessPartner,
// @EndUserText.label: 'Supplier Business Partner Name'
// _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartnerName as SupplierBusinessPartnerName,
@ObjectModel.foreignKey.association: '_Customer'
@EndUserText.label: 'Customer'
Customer,
@ObjectModel.foreignKey.association: '_Supplier'
Supplier,
@ObjectModel.foreignKey.association: '_OffsettingAccountWithBP'
@EndUserText.label: 'Offsetting Account'
OffsettingAccount,
OffsettingAccountName,
DocumentItemText,
I_GLAccountLineItemCube._JournalEntry.ReverseDocument,
I_GLAccountLineItemCube._JournalEntry.ReverseDocumentFiscalYear,
I_GLAccountLineItemCube.TaxCode,
I_GLAccountLineItemCube.TaxCountry,
// @EndUserText.label: 'Tax Base Amount Company Code Currency'
// I_TaxItem.TaxBaseAmountInCoCodeCrcy,
// @EndUserText.label: 'Tax Amount Company Code Currency'
// I_TaxItem.TaxAmountInCoCodeCrcy,
P_Bset.TaxDeterminationDate,
P_Bset.TaxRateValidityStartDate,
P_Bset.TaxItemGroup,
@ObjectModel.foreignKey.association: '_DebitCreditCode'
I_GLAccountLineItemCube.DebitCreditCode,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
@EndUserText.label: 'Debit Amt in CoCode Currency'
DebitAmountInCoCodeCrcy,
I_GLAccountLineItemCube.CompanyCodeCurrency as DebitCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
@EndUserText.label: 'Credit Amt in CoCode Currency'
cast( (-1) * CreditAmountInCoCodeCrcy as fis_cr_hsl) as CreditAmountInCoCodeCrcy,
I_GLAccountLineItemCube.CompanyCodeCurrency as CreditCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
@EndUserText.label: 'Bal. Amt in CoCode Currency'
case I_GLAccountLineItemCube.DebitCreditCode
when 'S'
then DebitAmountInCoCodeCrcy
else CreditAmountInCoCodeCrcy
end as BalanceAmountInCoCodeCrcy,
@ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
I_GLAccountLineItemCube.CompanyCodeCurrency,
_OperationalAcctgDocItem.AddressAndBankIsSetManually,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
@EndUserText.label: 'Debit Amt in Transac Currency'
AmountInTransactionCurrency as DebitAmountInTransCrcy,
I_GLAccountLineItemCube._JournalEntry.TransactionCurrency as DebitTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
@EndUserText.label: 'Credit Amt in Transac Currency'
cast( (-1) * CreditAmountInTransCrcy as fis_cr_wsl) as CreditAmountInTransCrcy,
I_GLAccountLineItemCube._JournalEntry.TransactionCurrency as CreditTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
@EndUserText.label: 'Bal. Amt in Transac Currency'
case I_GLAccountLineItemCube.DebitCreditCode
when 'S'
then DebitAmountInTransCrcy
else CreditAmountInTransCrcy
end as AmountInTransactionCurrency,
I_GLAccountLineItemCube._JournalEntry.TransactionCurrency as BalTransactionCurrency,
I_GLAccountLineItemCube._JournalEntry.IntercompanyTransaction,
@EndUserText.label: 'Translation date'
I_GLAccountLineItemCube._JournalEntry.ExchangeRateDate,
@EndUserText.label: 'Transaction Currency'
I_GLAccountLineItemCube._JournalEntry.TransactionCurrency,
I_GLAccountLineItemCube._JournalEntry.ExchangeRate,
@EndUserText.label: 'Business Transaction Type'
@ObjectModel.foreignKey.association: '_BusinessTransactionType'
I_GLAccountLineItemCube._JournalEntry.BusinessTransactionType,
@EndUserText.label: 'Business Transaction Type Name'
@ObjectModel.foreignKey.association: '_BusinessTransactionType'
_JournalEntry._BusinessTransactionType._Text[1: Language = $parameters.P_Language].BusinessTransactionTypeName,
I_GLAccountLineItemCube._JournalEntry.AccountingDocCreatedByUser,
I_GLAccountLineItemCube._JournalEntry.AccountingDocumentCreationDate,
I_GLAccountLineItemCube._JournalEntry.LedgerGroup,
I_GLAccountLineItemCube._JournalEntry.TaxReportingDate,
I_GLAccountLineItemCube._JournalEntry.TaxIsCalculatedAutomatically,
@EndUserText.label: 'Document Reference ID'
@ObjectModel.foreignKey.association: '_JournalEntry'
I_GLAccountLineItemCube._JournalEntry.DocumentReferenceID,
SourceReferenceDocument,
SourceReferenceDocumentType,
_OperationalAcctgDocItem.CorporateGroupAccount,
_OperationalAcctgDocItem.Reference1IDByBusinessPartner,
_OperationalAcctgDocItem.AdditionalCurrency1,
_OperationalAcctgDocItem.AdditionalCurrency2,
_OperationalAcctgDocItem.PaymentMethod,
_OperationalAcctgDocItem.PaymentMethodSupplement,
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
AccountingDocumentType,
@EndUserText.label: 'Accounting Document Type Name'
_AccountingDocumentTypeText[1: Language = $parameters.P_Language].AccountingDocumentTypeName,
CreationDate,
AssetValueDate,
SettlementReferenceDate,
InvoiceReference,
DocumentDate,
IsReversed,
ReversalReferenceDocument,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
@ObjectModel.foreignKey.association: '_OffsettingAccountType'
OffsettingAccountType,
ClearingDate,
@ObjectModel.foreignKey.association: '_ClearingAccountingDocument'
ClearingAccountingDocument,
@ObjectModel.foreignKey.association: '_PostingKey'
PostingKey,
FollowOnDocumentType,
@EndUserText.label: 'FunctionalArea Name'
_FunctionAreaText[1: Language = $parameters.P_Language].FunctionalAreaName,
//Start of new fields since 2011
I_GLAccountLineItemCube._JournalEntry.TransactionCode,
I_GLAccountLineItemCube._JournalEntry.RecurringAccountingDocument,
_OperationalAcctgDocItem.CostElement,
ControllingBusTransacType,
//End of new fields since 2011
@ObjectModel.foreignKey.association: '_LedgerFiscalYearForVariant'
@Semantics.fiscal.year: true
LedgerFiscalYear,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
///////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_00 Unified Journal Entry: Transaction, Currencies, Units
///////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_FinancialTransactionType'
FinancialTransactionType,
@ObjectModel.foreignKey.association: '_LogicalSystem'
LogicalSystem,
ReferenceDocumentContext,
ReferenceDocumentItem,
ReferenceDocumentItemGroup,
IsReversal,
ReversalReferenceDocumentCntxt,
IsSettlement,
IsSettled,
@ObjectModel.foreignKey.association: '_PredecessorReferenceDocType'
PredecessorReferenceDocType,
PredecessorReferenceDocCntxt,
PredecessorReferenceDocument,
PredecessorReferenceDocItem,
SourceReferenceDocumentCntxt,
SourceReferenceDocumentItem,
SourceReferenceDocSubitem,
IsCommitment,
JrnlEntryItemObsoleteReason,
////////////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_GL_ACCAS Unified Journal Entry: G/L additional account assignments
////////////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_CostCenter'
CostCenter,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
@ObjectModel.foreignKey.association: '_PartnerCostCenter'
PartnerCostCenter,
@ObjectModel.foreignKey.association: '_PartnerProfitCenter'
PartnerProfitCenter,
@ObjectModel.foreignKey.association: '_PartnerFunctionalArea'
PartnerFunctionalArea,
@ObjectModel.foreignKey.association: '_PartnerBusinessArea'
PartnerBusinessArea,
@ObjectModel.foreignKey.association: '_PartnerCompany'
PartnerCompany,
PartnerSegment,
/////////////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_VALUE_DATA Unified Journal Entry: Value Fields
/////////////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_BalanceTransactionCurrency'
@Semantics.currencyCode:true
BalanceTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
AmountInBalanceTransacCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
AmountInCompanyCodeCurrency,
////////////////////////////////////
// NEW
@ObjectModel.foreignKey.association: '_GlobalCurrency'
@Semantics.currencyCode:true
GlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
AmountInGlobalCurrency,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency1'
@Semantics.currencyCode:true
FreeDefinedCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
AmountInFreeDefinedCurrency1,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency2'
@Semantics.currencyCode:true
FreeDefinedCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
AmountInFreeDefinedCurrency2,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency3'
@Semantics.currencyCode:true
FreeDefinedCurrency3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
AmountInFreeDefinedCurrency3,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency4'
@Semantics.currencyCode:true
FreeDefinedCurrency4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
AmountInFreeDefinedCurrency4,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency5'
@Semantics.currencyCode:true
FreeDefinedCurrency5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
AmountInFreeDefinedCurrency5,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency6'
@Semantics.currencyCode:true
FreeDefinedCurrency6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
AmountInFreeDefinedCurrency6,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency7'
@Semantics.currencyCode:true
FreeDefinedCurrency7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
AmountInFreeDefinedCurrency7,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency8'
@Semantics.currencyCode:true
FreeDefinedCurrency8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
AmountInFreeDefinedCurrency8,
////////////////////////////////////
////////////////////////////////////
// NEW
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
FixedAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
GrpValnFixedAmtInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
PrftCtrValnFxdAmtInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
TotalPriceVarcInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
GrpValnTotPrcVarcInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
PrftCtrValnTotPrcVarcInGlbCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
FixedPriceVarcInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
GrpValnFixedPrcVarcInGlobCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
PrftCtrValnFxdPrcVarcInGlbCrcy,
////////////////////////////////////
@Semantics.currencyCode:true
ControllingObjectCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
AmountInObjectCurrency,
@ObjectModel.foreignKey.association: '_BaseUnit'
@Semantics.unitOfMeasure:true
BaseUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
Quantity,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
FixedQuantity,
@ObjectModel.foreignKey.association: '_CostSourceUnit'
@Semantics.unitOfMeasure:true
CostSourceUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
ValuationQuantity,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
ValuationFixedQuantity,
@ObjectModel.foreignKey.association: '_AdditionalQuantity1Unit'
@Semantics.unitOfMeasure:true
AdditionalQuantity1Unit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity1Unit'} }
AdditionalQuantity1,
@ObjectModel.foreignKey.association: '_AdditionalQuantity2Unit'
@Semantics.unitOfMeasure:true
AdditionalQuantity2Unit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity2Unit'} }
AdditionalQuantity2,
@ObjectModel.foreignKey.association: '_AdditionalQuantity3Unit'
@Semantics.unitOfMeasure:true
AdditionalQuantity3Unit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity3Unit'} }
AdditionalQuantity3,
/////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FIX Unified Journal Entry: Mandatory fields for G/L
////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_FiscalYearVariant'
@Semantics.fiscal.yearVariant: true
I_GLAccountLineItemCube.FiscalYearVariant,
@ObjectModel.foreignKey.association: '_FiscalYearPeriodForVariant'
@Semantics.fiscal.yearPeriod: true
FiscalYearPeriod,
I_GLAccountLineItemCube.AccountingDocumentItem,
AssignmentReference,
@ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
AccountingDocumentCategory,
I_GLAccountLineItemCube.TransactionTypeDetermination,
@ObjectModel.foreignKey.association: '_SubLedgerAccLineItemType'
SubLedgerAcctLineItemType,
LastChangeDateTime,
CreationDateTime,
@ObjectModel.foreignKey.association: '_EliminationProfitCenter'
EliminationProfitCenter,
OriginObjectType,
@ObjectModel.foreignKey.association: '_GLAccountType'
GLAccountType,
@ObjectModel.foreignKey.association: '_AlternativeGLAccount'
AlternativeGLAccount,
@ObjectModel.foreignKey.association: '_CountryChartOfAccounts'
CountryChartOfAccounts,
///////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_GEN Unified Journal Entry: Fields for several subledgers
//////////////////////////////////////////////////////////////////////////
InvoiceReferenceFiscalYear,
InvoiceItemReference,
ReferencePurchaseOrderCategory,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
PurchasingDocumentItem,
AccountAssignmentNumber,
@ObjectModel.foreignKey.association: '_SalesOrder'
SalesOrder,
@ObjectModel.foreignKey.association: '_SalesOrderItem'
SalesOrderItem,
@ObjectModel.foreignKey.association: '_SalesDocument'
SalesDocument,
@ObjectModel.foreignKey.association: '_SalesDocumentItem'
SalesDocumentItem,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'Product'
@ObjectModel.foreignKey.association: '_Material'
/*do not use any longer, use Product */ Material,
@ObjectModel.foreignKey.association: '_Product'
Product,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
ServicesRenderedDate,
@ObjectModel.foreignKey.association: '_ConditionContract'
ConditionContract,
/////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FI Unified Journal Entry: Fields for FI subledgers
/////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_SpecialGLCode'
SpecialGLCode,
@ObjectModel.foreignKey.association: '_HouseBank'
HouseBank,
@ObjectModel.foreignKey.association: '_HouseBankAccount'
HouseBankAccount,
IsOpenItemManaged,
ClearingDocFiscalYear,
/////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FAA Unified Journal Entry: Fields for Asset Accounting
/////////////////////////////////////////////////////////////////////////
AssetDepreciationArea,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
FixedAsset,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
AssetTransactionType,
@ObjectModel.foreignKey.association: '_MovementCategory'
AssetAcctTransClassfctn,
DepreciationFiscalPeriod,
@ObjectModel.foreignKey.association: '_GroupMasterFixedAsset'
GroupMasterFixedAsset,
@ObjectModel.foreignKey.association: '_GroupFixedAsset'
GroupFixedAsset,
AssetClass,
//////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_ML Unified Journal Entry: Fields for Material Ledger
//////////////////////////////////////////////////////////////////////////
CostEstimate,
@ObjectModel.foreignKey.association: '_InventorySpecialStockValnType'
InventorySpecialStockValnType,
//xobew,
@ObjectModel.foreignKey.association: '_InventorySpecialStockType'
InventorySpecialStockType,
@ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocument'
InventorySpclStkSalesDocument, // as InventorySpecialStockSalesDocument,
@ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocItm'
InventorySpclStkSalesDocItm, // as InventorySpecialStockSalesDocumentItem,
@ObjectModel.foreignKey.association: '_InvtrySpclStockWBSElmntIntID'
InvtrySpclStockWBSElmntIntID,
@ObjectModel.foreignKey.association: '_InventorySpclStockWBSElement'
InventorySpclStockWBSElement, // as InventorySpecialStockWBSElement,
@ObjectModel.foreignKey.association: '_InventorySpecialStockSupplier'
InventorySpecialStockSupplier,
@ObjectModel.foreignKey.association: '_InventoryValuationType'
InventoryValuationType,
@ObjectModel.foreignKey.association: '_Purreqvaluationarea'
ValuationArea,
////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_CFIN Unified Journal Entry: Fields for Central Finance
//////////////////////////////////////////////////////////////////////////////
//@ObjectModel.foreignKey.association: '_SenderGLAccount'
SenderGLAccount,
SenderAccountAssignment,
SenderAccountAssignmentType,
////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_CO Unified Journal Entry: CO fields
///////////////////////////////////////////////////////////////////////////
// @ObjectModel.foreignKey.association: '_CostOriginGroup'
CostOriginGroup,
@ObjectModel.foreignKey.association: '_OriginSenderObject'
OriginSenderObject,
@ObjectModel.foreignKey.association: '_ControllingDebitCreditCode'
ControllingDebitCreditCode,
ControllingObjectDebitType,
QuantityIsIncomplete,
@ObjectModel.foreignKey.association: '_OffsettingChartOfAccounts'
OffsettingChartOfAccounts,
LineItemIsCompleted,
PersonnelNumber,
@ObjectModel.foreignKey.association: '_ControllingObjectClass'
ControllingObjectClass,
@ObjectModel.foreignKey.association: '_PartnerCompanyCode'
PartnerCompanyCode,
@ObjectModel.foreignKey.association: '_PartnerControllingObjectClass'
PartnerControllingObjectClass,
@ObjectModel.foreignKey.association: '_OriginCostCenter'
OriginCostCenter,
@ObjectModel.foreignKey.association: '_OriginProfitCenter'
OriginProfitCenter,
@ObjectModel.foreignKey.association: '_OriginCostCtrActivityType'
OriginCostCtrActivityType,
AccountAssignment,
AccountAssignmentType,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
CostCtrActivityType,
@ObjectModel.foreignKey.association: '_Order'
OrderID,
@ObjectModel.foreignKey.association: '_OrderCategory'
OrderCategory,
@ObjectModel.foreignKey.association: '_WBSElementInternalID'
WBSElementInternalID,
@ObjectModel.foreignKey.association: '_PartnerWBSElementBasicData'
PartnerWBSElementInternalID,
@ObjectModel.foreignKey.association: '_WBSElement'
WBSElement,
@ObjectModel.foreignKey.association: '_ProjectInternalID'
ProjectInternalID,
@ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
PartnerProjectInternalID,
@ObjectModel.foreignKey.association: '_Project'
Project,
@ObjectModel.foreignKey.association: '_OperatingConcern'
OperatingConcern,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
RelatedNetworkActivity,
@ObjectModel.foreignKey.association: '_BusinessProcess'
BusinessProcess,
CostObject,
@ObjectModel.foreignKey.association: '_BillableControl'
BillableControl,
@ObjectModel.foreignKey.association: '_CostAnalysisResource'
CostAnalysisResource,
CustomerServiceNotification,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_AcctgServiceDocumentTypeVH',
element: 'ServiceDocumentType' }
}]
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ServiceDocumentType'
ServiceDocumentType,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_AcctgServiceDocumentVH',
element: 'ServiceDocument' }
}]
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ServiceDocument'
ServiceDocument,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_AcctgServiceDocumentItemVH',
element: 'ServiceDocumentItem' }
}]
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ServiceDocumentItem'
ServiceDocumentItem,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_AcctgServiceDocumentTypeVH',
element: 'PartnerServiceDocumentType' }
}]
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerServiceDocumentType'
PartnerServiceDocumentType,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_AcctgServiceDocumentVH',
element: 'PartnerServiceDocument' }
}]
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerServiceDocument'
PartnerServiceDocument,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_AcctgServiceDocumentItemVH',
element: 'PartnerServiceDocumentItem' }
}]
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerServiceDocumentItem'
PartnerServiceDocumentItem,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ServiceContractTypeStdVH',
element: 'ServiceContractType' }
}]
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ServiceContractType'
ServiceContractType,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_AcctgServiceContractVH',
element: 'ServiceContract' }
}]
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ServiceContract'
ServiceContract,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ServiceContractItem'
ServiceContractItem,
PartnerAccountAssignment,
PartnerAccountAssignmentType,
@ObjectModel.foreignKey.association: '_PartnerCostCtrActivityType'
PartnerCostCtrActivityType,
@ObjectModel.foreignKey.association: '_PartnerOrder'
PartnerOrder,
@ObjectModel.foreignKey.association: '_PartnerOrderCategory'
PartnerOrderCategory,
@ObjectModel.foreignKey.association: '_PartnerWBSElement'
PartnerWBSElement,
@ObjectModel.foreignKey.association: '_PartnerProject'
PartnerProject,
@ObjectModel.foreignKey.association: '_PartnerSalesDocument'
PartnerSalesDocument,
@ObjectModel.foreignKey.association: '_PartnerSalesDocumentItem'
PartnerSalesDocumentItem,
PartnerProjectNetwork,
PartnerProjectNetworkActivity,
@ObjectModel.foreignKey.association: '_PartnerBusinessProcess'
PartnerBusinessProcess,
PartnerCostObject,
//////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_COPA Unified Journal Entry: CO-PA fields
//////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_BillingDocumentType'
BillingDocumentType,
@ObjectModel.foreignKey.association: '_SalesOrganization'
SalesOrganization,
@ObjectModel.foreignKey.association: '_DistributionChannel'
DistributionChannel,
OrganizationDivision,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'SoldProduct'
@ObjectModel.foreignKey.association: '_SoldMaterial'
SoldMaterial,
@ObjectModel.foreignKey.association: '_SoldProduct'
SoldProduct,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'SoldProductGroup'
@ObjectModel.foreignKey.association: '_MaterialGroup'
MaterialGroup,
@ObjectModel.foreignKey.association: '_SoldProductGroup'
SoldProductGroup,
@ObjectModel.foreignKey.association: '_CustomerGroup'
CustomerGroup,
CustomerSupplierCountry,
CustomerSupplierIndustry,
SalesDistrict,
BillToParty,
ShipToParty,
CustomerSupplierCorporateGroup,
//////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_PS Unified Journal Entry: Fields for Public Sector
/////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
FinancialManagementArea,
@ObjectModel.foreignKey.association: '_Fund'
Fund,
GrantID,
@ObjectModel.foreignKey.association: '_BudgetPeriod'
BudgetPeriod,
@ObjectModel.foreignKey.association: '_PartnerFund'
PartnerFund,
PartnerGrant,
PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_FundsCenter'
FundsCenter,
FundedProgram,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_JVA Unified Journal Entry: Fields for Joint Venture Accounting
///////////////////////////////////////////////////////////////////////
JointVenture,
JointVentureEquityGroup,
JointVentureCostRecoveryCode,
JointVenturePartner,
JointVentureBillingType,
JointVentureEquityType,
JointVentureProductionDate,
JointVentureBillingDate,
JointVentureOperationalDate,
CutbackRun,
JointVentureAccountingActivity,
PartnerVenture,
PartnerEquityGroup,
SenderCostRecoveryCode,
CutbackAccount,
CutbackCostObject,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_ACR STRU 0 0 Universal Journal Entry: Fields for Accrual object
///////////////////////////////////////////////////////////////////////
// AccrualObject --(1:N)--> AccrualSubobject --(1:N)--> Accrual(Subobject)Item (this field is not stored in ACDOCA)
// AccrualObjectType AccrualItemType are the corresponding types
//@ObjectModel.foreignKey.association: '_AccrualObjectType'
AccrualObjectType,
//@ObjectModel.foreignKey.association: '_AccrualObject'
AccrualObject,
//@ObjectModel.foreignKey.association: '_AccrualSubobject'
AccrualSubobject,
//@ObjectModel.foreignKey.association: '_AccrualItemType'
AccrualItemType,
//////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_LOG Universal Journal Entry: Fields for Logistics
//////////////////////////////////////////////////////////////////////
WorkCenterInternalID,
OrderOperation,
OrderItem,
//////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_LOG_ACT: New Fields PM //
//////////////////////////////////////////////////
// @ObjectModel.foreignKey.association: '_MaintenanceOrderSubOperation' // Triangle Condition
OrderSuboperation,
@ObjectModel.foreignKey.association: '_Equipment'
Equipment,
@ObjectModel.foreignKey.association: '_FunctionalLocation'
FunctionalLocation,
@ObjectModel.foreignKey.association: '_Assembly'
Assembly,
@ObjectModel.foreignKey.association: '_MaintenanceActivityType'
MaintenanceActivityType,
@ObjectModel.foreignKey.association: '_MaintOrdPlngDegreeCode'
MaintenanceOrderPlanningCode,
@ObjectModel.foreignKey.association: '_PMNotificationPriorityType'
MaintPriorityType,
@ObjectModel.foreignKey.association: '_PMNotificationPriority'
MaintPriority,
@ObjectModel.foreignKey.association: '_SuperiorOrder'
SuperiorOrder,
@ObjectModel.foreignKey.association: '_ProductGroup'
ProductGroup,
MaintenanceOrderIsPlanned,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
DebitAmountInBalanceTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
(-1) * CreditAmountInBalanceTransCrcy as CreditAmountInBalanceTransCrcy,
////////////////////////////////////
// NEW
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
DebitAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
(-1) * CreditAmountInGlobalCrcy as CreditAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
DebitAmountInFreeDefinedCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
(-1) * CreditAmountInFreeDefinedCrcy1 as CreditAmountInFreeDefinedCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
DebitAmountInFreeDefinedCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
(-1) * CreditAmountInFreeDefinedCrcy2 as CreditAmountInFreeDefinedCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
DebitAmountInFreeDefinedCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
(-1) * CreditAmountInFreeDefinedCrcy3 as CreditAmountInFreeDefinedCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
DebitAmountInFreeDefinedCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
(-1) * CreditAmountInFreeDefinedCrcy4 as CreditAmountInFreeDefinedCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
DebitAmountInFreeDefinedCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
(-1) * CreditAmountInFreeDefinedCrcy5 as CreditAmountInFreeDefinedCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
DebitAmountInFreeDefinedCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
(-1) * CreditAmountInFreeDefinedCrcy6 as CreditAmountInFreeDefinedCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
DebitAmountInFreeDefinedCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
(-1) * CreditAmountInFreeDefinedCrcy7 as CreditAmountInFreeDefinedCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
DebitAmountInFreeDefinedCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
(-1) * CreditAmountInFreeDefinedCrcy8 as CreditAmountInFreeDefinedCrcy8,
IsStatisticalOrder,
IsStatisticalCostCenter,
IsStatisticalSalesDocument,
WBSIsStatisticalWBSElement,
///////////////////////////////////////////////////////////////////////////////
// Fields from associations
///////////////////////////////////////////////////////////////////////////////
CalendarYear,
CalendarQuarter,
CalendarYearQuarter,
CalendarMonth,
CalendarYearMonth,
CalendarWeek,
CalendarYearWeek,
///////////////////////////////////////////////////////////////////////////////
// Associations
///////////////////////////////////////////////////////////////////////////////
I_GLAccountLineItemCube._JournalEntry,
_CompanyCode,
_FiscalYear,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_FiscalPeriodForVariant'
_FiscalPeriod,
_FiscalPeriodForVariant,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_LedgerFiscalYearForVariant'
_LedgerFiscalYear,
_LedgerFiscalYearForVariant,
_FiscalYearVariant,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_FiscalYearPeriodForVariant'
_FiscalYearPeriod,
_FiscalYearPeriodForVariant,
_ControllingArea,
_BalanceTransactionCurrency,
I_GLAccountLineItemCube._JournalEntry._TransactionCurrency,
I_GLAccountLineItemCube._CompanyCodeCurrency,
_GlobalCurrency,
_FreeDefinedCurrency1,
_FreeDefinedCurrency2,
_FreeDefinedCurrency3,
_FreeDefinedCurrency4,
_FreeDefinedCurrency5,
_FreeDefinedCurrency6,
_FreeDefinedCurrency7,
_FreeDefinedCurrency8,
_BaseUnit,
_CostSourceUnit,
_AdditionalQuantity1Unit,
_AdditionalQuantity2Unit,
_AdditionalQuantity3Unit,
_Segment,
_ProfitCenter,
_CurrentProfitCenter,
_CostCenter,
@UI.hidden: true
_CurrentCostCenter,
_CostAnalysisResource,
_WBSElementInternalID,
_PartnerWBSElementBasicData,
_WBSElement,
_ProjectInternalID,
_Project,
_BusinessArea,
_FunctionalArea,
_GLAccountInChartOfAccounts,
_GLAccountInCompanyCode,
_ChartOfAccounts,
_AccountingDocumentType,
_AccountingDocumentTypeText,
_FinancialAccountType,
_DebitCreditCode,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_Product'
_Material,
_Product,
_Plant,
_Ledger,
_SourceLedger,
_Customer,
_CustomerGroup,
_Supplier,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_SoldProductGroup'
_MaterialGroup,
_ProductGroup,
_SoldProductGroup,
_SalesOrder,
_SalesOrderItem,
_SalesDocument,
_SalesDocumentItem,
// _Order,
_InternalOrder,
_Order,
_Employment,
_FinancialTransactionType,
I_GLAccountLineItemCube._JournalEntry._BusinessTransactionType,
_ReferenceDocumentType,
@UI.hidden: true
_PredecessorReferenceDocType,
_PartnerCostCenter,
_PartnerProfitCenter,
_PartnerBusinessArea,
_PartnerFunctionalArea,
_PartnerCompanyCode,
_PartnerSegment,
_AccountingDocumentCategory,
_PostingKey,
_SubLedgerAccLineItemType,
I_GLAccountLineItemCube._JournalEntry._User,
_EliminationProfitCenter,
//_ControllingObject,
_GLAccountType,
_OffsettingAccountType,
_OffsettingChartOfAccounts,
_OffsettingAccount,
_OffsettingAccountWithBP,
_AlternativeGLAccount,
//_SenderGLAccount,
_CountryChartOfAccounts,
_PurchasingDocument,
_PurchasingDocumentItem,
_SpecialGLCode,
_HouseBank,
_ClearingAccountingDocument,
_MasterFixedAsset,
_GroupMasterFixedAsset,
_FixedAsset,
_GroupFixedAsset,
_InventorySpecialStockValnType,
_InventorySpecialStockType,
_InventorySpclStkSalesDocument,
_InventorySpclStkSalesDocItm,
_InvtrySpclStockWBSElmntIntID,
_InventorySpclStockWBSElement,
_InventorySpecialStockSupplier,
_InventoryValuationType,
_ControllingDebitCreditCode,
_OriginSenderObject,
_ControllingObjectClass,
_PartnerControllingObjectClass,
_OriginCostCenter,
_OriginProfitCenter,
_CostCtrActivityType,
_OriginCostCtrActivityType,
_OrderCategory,
//_RelatedNetworkActivity,
//_PartnerProjectNetworkActivity,
_BusinessProcess,
_PartnerCostCtrActivityType,
_PartnerOrder,
_PartnerOrderCategory,
_PartnerWBSElement,
_PartnerProject,
_PartnerSalesDocument,
_PartnerSalesDocumentItem,
_PartnerBusinessProcess,
_BillingDocumentType,
_SalesOrganization,
_DistributionChannel,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_SoldProduct'
_SoldMaterial,
_SoldProduct,
_Fund,
_PartnerFund,
_FundsCenter,
_MovementCategory,
_AssetTransactionType,
_BudgetPeriod,
_CostOriginGroup,
_CustomerSupplierCountry,
_SalesDistrict,
_BillToParty,
_ShipToParty,
_FinancialManagementArea,
//_FundedProgram
_HouseBankAccount,
_LogicalSystem,
_OperatingConcern,
_PartnerCompany,
_ProjectNetwork,
_PurReqValuationArea,
_WorkCenter,
_BillableControl,
_ServiceDocumentType,
_ServiceDocument,
_ServiceDocumentItem,
_ServiceContract,
_ServiceContractItem,
_ServiceContractType,
_PartnerServiceDocumentType,
_PartnerServiceDocument,
_PartnerServiceDocumentItem,
_ConditionContract,
_Equipment,
_FunctionalLocation,
_MaintenanceActivityType,
_MaintOrdPlngDegreeCode,
_PMNotificationPriorityType,
_PMNotificationPriority,
_Assembly,
_SuperiorOrder,
_WBSElementBasicData,
_WBSElementBasicDataText,
_ProjectBasicData,
_ProjectBasicDataText,
_PartnerProjectBasicData,
_PartnerProjectBasicDataText,
_FunctionAreaText,
//_BusTransactionTypeText,
_AccrualObjectType,
_AccrualObject,
_AccrualSubobject,
_AccrualItemType,
_OperationalAcctgDocItem
//_Extension Extensions must be local
}
where
AccountingDocumentCategory <> 'D'
and AccountingDocumentCategory <> 'M'
and AccountingDocumentCategory <> 'S'
and AccountingDocumentCategory <> 'V'
and AccountingDocumentCategory <> 'W'
and AccountingDocumentCategory <> 'Z'
and AccountingDocumentCategory <> 'T'
and PostingDate <= _ToFiscalPeriodForVariant.FiscalPeriodEndDate
and PostingDate >= _FromFiscalPeriodForVariant.FiscalPeriodStartDate