@AbapCatalog.sqlViewName: 'PFIGLACCTLITSTGL'
@EndUserText.label: 'GL Account Line Item with Semantic Tag for GLAcc'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'LedgerGLLineItem'
@AbapCatalog.preserveKey: true
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_GLAccountLineItemSemTagGLACC
as select from I_GLAccountLineItem
inner join I_SemTagGLAccount on I_SemTagGLAccount.GLAccount = I_GLAccountLineItem.GLAccount
and I_SemTagGLAccount.ChartOfAccounts = I_GLAccountLineItem.ChartOfAccounts
association [0..1] to I_SemanticTag as _SemanticTag on $projection.SemanticTag = _SemanticTag.SemanticTag
association [0..*] to I_GLAccountHierarchy as _Hierarchy on $projection.GLAccountHierarchy = _Hierarchy.GLAccountHierarchy
association [0..1] to I_WBSElement as _WBSElement on $projection.WBSElement = _WBSElement.WBSElement
association [0..1] to I_WBSElementByExternalID as _WBSElementExternalID on $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
association [0..1] to I_WBSElementByExternalID as _WBSElementExternalIDText on $projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID
association [0..1] to I_ProjectByExternalID as _ProjectExternalID on $projection.projectexternalid = _ProjectExternalID.ProjectExternalID
association [0..1] to I_ProjectByExternalID as _ProjectExternalIDText on $projection.projectexternalid = _ProjectExternalIDText.ProjectExternalID
association [0..1] to I_ProjectByExternalID as _PartnerProjectExternalID on $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID
association [0..1] to I_ProjectByExternalID as _PartnerProjctExtrnalIDText on $projection.PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID
association [0..1] to I_WBSElementBasicData as _InvtrySpclStockWBSElmntBD on $projection.InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntBD.WBSElementInternalID
association [0..1] to I_WBSElementByExternalID as _InvtrySpclStockWBSElmntExtID on $projection.InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID
association [0..1] to I_WBSElementByExternalID as _PartnerWBSElementExternalID on $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID
association [0..1] to I_WBSElementByExternalID as _PartnerWBSElemntExtrnalIDText on $projection.PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID
association [0..1] to I_ProjectBasicData as _ProjectBasicData on $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
association [0..1] to I_ProjectBasicData as _ProjectBasicDataText on $projection.ProjectInternalID = _ProjectBasicDataText.ProjectInternalID
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_WBSElementBasicData as _WBSElementBasicDataText on $projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID
association [0..1] to I_WBSElementBasicData as _PartnerWBSElementBasicData on $projection.PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID
association [0..1] to I_WBSElementBasicData as _PartnerWBSElemntBasicDataText on $projection.PartnerWBSElementInternalID = _PartnerWBSElemntBasicDataText.WBSElementInternalID
association [0..1] to I_ProjectBasicData as _PartnerProjectBasicData on $projection.PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID
association [0..1] to I_ProjectBasicData as _PartnerProjectBasicDataText on $projection.PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID
{
@ObjectModel.foreignKey.association: '_Ledger'
key Ledger,
@ObjectModel.foreignKey.association: '_SourceLedger'
key SourceLedger,
@ObjectModel.foreignKey.association: '_CompanyCode'
key CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
key FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key AccountingDocument,
key LedgerGLLineItem,
///////////////////////////////////////////////////////////////////////
// I_SemTagFuncArea
///////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_Hierarchy'
key GLAccountHierarchy,
@ObjectModel.foreignKey.association: '_SemanticTag'
key SemanticTag,
@Semantics.businessDate.from: true
key ValidityStartDate,
@Semantics.businessDate.to: true
key ValidityEndDate,
@ObjectModel.foreignKey.association: '_LedgerFiscalYearForVariant'
LedgerFiscalYear,
GLRecordType,
// Test workaround
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
I_GLAccountLineItem.ChartOfAccounts,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
///////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_00 Unified Journal Entry: Transaction, Currencies, Units
///////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_FinancialTransactionType'
FinancialTransactionType,
@ObjectModel.foreignKey.association: '_BusinessTransactionType'
BusinessTransactionType,
@ObjectModel.foreignKey.association: '_ReferenceDocumentType'
ReferenceDocumentType,
@ObjectModel.foreignKey.association: '_LogicalSystem'
LogicalSystem,
ReferenceDocumentContext,
ReferenceDocument,
ReferenceDocumentItem,
ReferenceDocumentItemGroup,
//SUBTA,
IsReversal,
IsReversed,
//XTRUEREV,
//AWTYP_REV,
ReversalReferenceDocumentCntxt,
ReversalReferenceDocument,
//SUBTA_REV,
IsSettlement,
IsSettled,
@ObjectModel.foreignKey.association: '_PredecessorReferenceDocType'
PredecessorReferenceDocType,
PredecessorReferenceDocCntxt,
PredecessorReferenceDocument,
PredecessorReferenceDocItem,
//PREC_SUBTA,
SourceReferenceDocumentType,
SourceLogicalSystem,
SourceReferenceDocumentCntxt,
SourceReferenceDocument,
SourceReferenceDocumentItem,
SourceReferenceDocSubitem,
IsCommitment,
JrnlEntryItemObsoleteReason,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
I_GLAccountLineItem.GLAccount,
////////////////////////////////////////////////////////////////////////////////////
// .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: '_FunctionalArea'
I_GLAccountLineItem.FunctionalArea,
@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,
@ObjectModel.foreignKey.association: '_TransactionCurrency'
@Semantics.currencyCode:true
TransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
AmountInTransactionCurrency,
@ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
@Semantics.currencyCode:true
CompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
I_GLAccountLineItem.AmountInCompanyCodeCurrency,
////////////////////////////////////
// NEW
@ObjectModel.foreignKey.association: '_GlobalCurrency'
@Semantics.currencyCode:true
GlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
AmountInGlobalCurrency,
// Functional Currency
@ObjectModel.foreignKey.association: '_FunctionalCurrency'
@Semantics.currencyCode:true
FunctionalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
AmountInFunctionalCurrency,
@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,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
FixedAmountInCoCodeCrcy,
////////////////////////////////////
@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: '_DebitCreditCode'
DebitCreditCode,
@ObjectModel.foreignKey.association: '_FiscalPeriodForVariant'
FiscalPeriod,
@ObjectModel.foreignKey.association: '_FiscalYearVariant'
FiscalYearVariant,
FiscalYearPeriod,
PostingDate,
DocumentDate,
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
AccountingDocumentType,
AccountingDocumentItem,
AssignmentReference,
@ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
AccountingDocumentCategory,
@ObjectModel.foreignKey.association: '_PostingKey'
PostingKey,
TransactionTypeDetermination,
@ObjectModel.foreignKey.association: '_SubLedgerAccLineItemType'
SubLedgerAcctLineItemType,
// @ObjectModel.foreignKey.association: '_User'
AccountingDocCreatedByUser,
LastChangeDateTime,
CreationDateTime,
CreationDate,
@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
//////////////////////////////////////////////////////////////////////////
InvoiceReference,
InvoiceReferenceFiscalYear,
FollowOnDocumentType,
InvoiceItemReference,
ReferencePurchaseOrderCategory,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
PurchasingDocumentItem,
AccountAssignmentNumber,
DocumentItemText,
@ObjectModel.foreignKey.association: '_SalesOrder'
SalesOrder,
@ObjectModel.foreignKey.association: '_SalesOrderItem'
SalesOrderItem,
@ObjectModel.foreignKey.association: '_SalesDocument'
SalesDocument,
@ObjectModel.foreignKey.association: '_SalesDocumentItem'
SalesDocumentItem,
@ObjectModel.foreignKey.association: '_Material'
Material,
@ObjectModel.foreignKey.association: '_Product'
Product,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_Supplier'
Supplier,
@ObjectModel.foreignKey.association: '_Customer'
Customer,
ServicesRenderedDate,
@ObjectModel.foreignKey.association: '_ConditionContract'
ConditionContract,
/////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FI Unified Journal Entry: Fields for FI subledgers
/////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
@ObjectModel.foreignKey.association: '_SpecialGLCode'
SpecialGLCode,
// @ObjectModel.foreignKey.association: '_TaxCode'
TaxCode,
@ObjectModel.foreignKey.association: '_HouseBank'
HouseBank,
@ObjectModel.foreignKey.association: '_HouseBankAccount'
HouseBankAccount,
IsOpenItemManaged,
ClearingDate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
@ObjectModel.foreignKey.association: '_ClearingAccountingDocument'
ClearingAccountingDocument,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
ClearingDocFiscalYear,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ClearingJournalEntry'
ClearingJournalEntry,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ClearingJrnlEntryFiscalYear'
ClearingJournalEntryFiscalYear,
/////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FAA Unified Journal Entry: Fields for Asset Accounting
/////////////////////////////////////////////////////////////////////////
AssetDepreciationArea,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
FixedAsset,
AssetValueDate,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
AssetTransactionType,
@ObjectModel.foreignKey.association: '_MovementCategory'
AssetAcctTransClassfctn,
DepreciationFiscalPeriod,
@ObjectModel.foreignKey.association: '_GroupMasterFixedAsset'
GroupMasterFixedAsset,
@ObjectModel.foreignKey.association: '_GroupFixedAsset'
GroupFixedAsset,
//////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_ML Unified Journal Entry: Fields for Material Ledger
//////////////////////////////////////////////////////////////////////////
CostEstimate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'InvtrySpecialStockValnType_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'InvtrySpecialStockValnType_2'
@ObjectModel.foreignKey.association: '_InventorySpecialStockValnType'
InventorySpecialStockValnType,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_InventorySpclStockValnType'
InvtrySpecialStockValnType_2,
//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: '_InvtrySpclStockWBSElmntExtID'
_InvtrySpclStockWBSElmntBD.WBSElementExternalID as InvtrySpclStockWBSElmntExtID,
@ObjectModel.foreignKey.association: '_InventorySpclStockWBSElement'
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'InvtrySpclStockWBSElmntIntID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'InvtrySpclStockWBSElmntIntID'
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: '_OffsettingAccountWithBP'
OffsettingAccount,
@ObjectModel.foreignKey.association: '_OffsettingAccountType'
OffsettingAccountType,
@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: '_WBSElementExternalID'
_WBSElementBasicData.WBSElementExternalID as WBSElementExternalID,
@ObjectModel.foreignKey.association: '_WBSElement'
_WBSElementInternalID.WBSElement as WBSElement,
@ObjectModel.foreignKey.association: '_PartnerWBSElementBasicData'
WBSElementInternalID as PartnerWBSElementInternalID,
@ObjectModel.foreignKey.association: '_PartnerWBSElementExternalID'
_PartnerWBSElementBasicData.WBSElementExternalID as PartnerWBSElementExternalID,
@ObjectModel.foreignKey.association: '_ProjectInternalID'
ProjectInternalID,
@ObjectModel.foreignKey.association: '_ProjectExternalID'
_ProjectBasicData.ProjectExternalID,
@ObjectModel.foreignKey.association: '_Project'
Project,
@ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
ProjectInternalID as PartnerProjectInternalID,
@ObjectModel.foreignKey.association: '_PartnerProjectExternalID'
_PartnerProjectBasicData.ProjectExternalID as PartnerProjectExternalID,
@ObjectModel.foreignKey.association: '_OperatingConcern'
OperatingConcern,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
// @ObjectModel.foreignKey.association: '_RelatedNetworkActivity'
RelatedNetworkActivity,
@ObjectModel.foreignKey.association: '_BusinessProcess'
BusinessProcess,
CostObject,
BillableControl,
//bemot,
@ObjectModel.foreignKey.association: '_CostAnalysisResource'
CostAnalysisResource,
CustomerServiceNotification,
@ObjectModel.foreignKey.association: '_ServiceDocumentType'
ServiceDocumentType,
@ObjectModel.foreignKey.association: '_ServiceDocument'
ServiceDocument,
@ObjectModel.foreignKey.association: '_ServiceDocumentItem'
ServiceDocumentItem,
@ObjectModel.foreignKey.association: '_ServiceContractType'
ServiceContractType,
@ObjectModel.foreignKey.association: '_ServiceContract'
ServiceContract,
@ObjectModel.foreignKey.association: '_ServiceContractItem'
ServiceContractItem,
BusinessSolutionOrder,
BusinessSolutionOrderItem,
@ObjectModel.foreignKey.association: '_ProviderContract'
ProviderContract,
@ObjectModel.foreignKey.association: '_ProviderContractItem'
ProviderContractItem,
// @ObjectModel.foreignKey.association: '_CAProviderContract'
// CAProviderContract,
// @ObjectModel.foreignKey.association: '_CAProviderContractItemNumber'
// CAProviderContractItemNumber,
PartnerAccountAssignment,
PartnerAccountAssignmentType,
WorkPackage,
WorkItem,
@ObjectModel.foreignKey.association: '_PartnerCostCtrActivityType'
PartnerCostCtrActivityType,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PartnerOrder_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'PartnerOrder_2'
@ObjectModel.foreignKey.association: '_PartnerOrder'
PartnerOrder,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerOrder_2'
PartnerOrder_2,
@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,
// @ObjectModel.foreignKey.association: '_PartnerProjectNetworkActivity'
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,
@ObjectModel.foreignKey.association: '_SoldMaterial'
SoldMaterial,
@ObjectModel.foreignKey.association: '_SoldProduct'
SoldProduct,
@ObjectModel.foreignKey.association: '_MaterialGroup'
MaterialGroup,
@ObjectModel.foreignKey.association: '_SoldProductGroup'
SoldProductGroup,
@ObjectModel.foreignKey.association: '_ProductGroup'
ProductGroup,
@ObjectModel.foreignKey.association: '_CustomerGroup'
CustomerGroup,
@ObjectModel.foreignKey.association: '_CustomerSupplierCountry'
CustomerSupplierCountry,
CustomerSupplierIndustry,
@ObjectModel.foreignKey.association: '_SalesDistrict'
SalesDistrict,
@ObjectModel.foreignKey.association: '_BillToParty'
BillToParty,
@ObjectModel.foreignKey.association: '_ShipToParty'
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,
//vptnr,
//btype,
JointVentureEquityType,
//prodper,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_RE STRU 0 0 Unified Journal Entry: Fields for Real Estate
///////////////////////////////////////////////////////////////////////
//swenr,
//sgenr,
//sgrnr,
//smenr,
//recnnr,
//snksl,
//sempsl,
SettlementReferenceDate,
//pswenr,
//psgenr,
//psgrnr,
//psmenr,
//precnnr,
//psnksl,
//psempsl,
//pdabrz
WorkCenterInternalID,
OrderOperation,
OrderItem,
//////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_LOG_ACT: New Fields PM //
//////////////////////////////////////////////////
//@ObjectModel.foreignKey.association: '_MaintenanceOrderSubOperation'
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,
MaintenanceOrderIsPlanned,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
DebitAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
CreditAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
DebitAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
CreditAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
DebitAmountInBalanceTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
CreditAmountInBalanceTransCrcy,
////////////////////////////////////
// NEW
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
DebitAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
CreditAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
DebitAmountInFunctionalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
CreditAmountInFunctionalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
DebitAmountInFreeDefinedCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
CreditAmountInFreeDefinedCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
DebitAmountInFreeDefinedCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
CreditAmountInFreeDefinedCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
DebitAmountInFreeDefinedCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
CreditAmountInFreeDefinedCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
DebitAmountInFreeDefinedCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
CreditAmountInFreeDefinedCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
DebitAmountInFreeDefinedCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
CreditAmountInFreeDefinedCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
DebitAmountInFreeDefinedCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
CreditAmountInFreeDefinedCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
DebitAmountInFreeDefinedCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
CreditAmountInFreeDefinedCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
DebitAmountInFreeDefinedCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
CreditAmountInFreeDefinedCrcy8,
//////////////////////////////////
IsStatisticalOrder,
IsStatisticalCostCenter,
IsStatisticalSalesDocument,
WBSIsStatisticalWBSElement,
///////////////////////////////////////////////////////////////////////
// Associations
///////////////////////////////////////////////////////////////////////
_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,
_CalendarDate,
_FiscalCalendarDate,
_ControllingArea,
_BalanceTransactionCurrency,
_TransactionCurrency,
_CompanyCodeCurrency,
_GlobalCurrency,
_FunctionalCurrency,
_FreeDefinedCurrency1,
_FreeDefinedCurrency2,
_FreeDefinedCurrency3,
_FreeDefinedCurrency4,
_FreeDefinedCurrency5,
_FreeDefinedCurrency6,
_FreeDefinedCurrency7,
_FreeDefinedCurrency8,
_BaseUnit,
_CostSourceUnit,
_AdditionalQuantity1Unit,
_AdditionalQuantity2Unit,
_AdditionalQuantity3Unit,
_Segment,
_ProfitCenter,
_CurrentProfitCenter,
_CostCenter,
_CurrentCostCenter,
_CostAnalysisResource,
_WBSElement,
_WBSElementInternalID,
_Project,
_BusinessArea,
I_GLAccountLineItem._FunctionalArea,
I_GLAccountLineItem._GLAccountInChartOfAccounts,
_GLAccountInCompanyCode,
I_GLAccountLineItem._ChartOfAccounts,
_AccountingDocumentType,
_FinancialAccountType,
_DebitCreditCode,
_Material,
_Product,
_Plant,
_Ledger,
_SourceLedger,
_Customer,
_CustomerGroup,
_Supplier,
_MaterialGroup,
_ProductGroup,
_SalesOrder,
_SalesOrderItem,
_SalesDocument,
_SalesDocumentItem,
_InternalOrder,
_Order,
_Employment,
_PersonWorkAgreement_1,
_FinancialTransactionType,
_BusinessTransactionType,
_ReferenceDocumentType,
_PredecessorReferenceDocType,
_PartnerCostCenter,
_PartnerProfitCenter,
_PartnerBusinessArea,
_PartnerFunctionalArea,
_PartnerCompanyCode,
_PartnerSegment,
_AccountingDocumentCategory,
_PostingKey,
_SubLedgerAccLineItemType,
_User,
_EliminationProfitCenter,
//_ControllingObject,
_GLAccountType,
_OffsettingAccountType,
_OffsettingChartOfAccounts,
_OffsettingAccount,
_OffsettingAccountWithBP,
_AlternativeGLAccount,
//_SenderGLAccount,
_CountryChartOfAccounts,
_PurchasingDocument,
_PurchasingDocumentItem,
_SpecialGLCode,
_TaxCode,
_HouseBank,
_ClearingJrnlEntryFiscalYear,
_ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_ClearingJournalEntry'
_ClearingAccountingDocument,
_FixedAsset,
_MasterFixedAsset,
_GroupMasterFixedAsset,
_GroupFixedAsset,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_InventorySpclStockValnType'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_InventorySpclStockValnType'
_InventorySpecialStockValnType,
_InventorySpclStockValnType,
_InventorySpecialStockType,
_InventorySpclStkSalesDocument,
_InventorySpclStkSalesDocItm,
_InvtrySpclStockWBSElmntIntID,
_InventorySpclStockWBSElement,
_InventorySpecialStockSupplier,
_InventoryValuationType,
_ControllingDebitCreditCode,
_OriginSenderObject,
_ControllingObjectClass,
_PartnerControllingObjectClass,
_OriginCostCenter,
_OriginProfitCenter,
_CostCtrActivityType,
_OriginCostCtrActivityType,
_OrderCategory,
//_RelatedNetworkActivity,
//_PartnerProjectNetworkActivity,
_BusinessProcess,
_PartnerCostCtrActivityType,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_PartnerOrder_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_PartnerOrder_2'
_PartnerOrder,
_PartnerOrder_2,
_PartnerOrderCategory,
_PartnerWBSElement,
_PartnerProject,
_PartnerSalesDocument,
_PartnerSalesDocumentItem,
_PartnerBusinessProcess,
_WorkPackage,
_WorkPackageWorkItem,
_BillingDocumentType,
_SalesOrganization,
_DistributionChannel,
_SoldMaterial,
_SoldProduct,
_Fund,
_PartnerFund,
_FundsCenter,
_MovementCategory,
_AssetTransactionType,
_BudgetPeriod,
_CostOriginGroup,
_CustomerSupplierCountry,
_SalesDistrict,
_BillToParty,
_ShipToParty,
_FinancialManagementArea,
//_FundedProgram
_HouseBankAccount,
_LogicalSystem,
_OperatingConcern,
_PartnerCompany,
_ProjectNetwork,
_PurReqValuationArea,
//_Extension Extensions must be local
_SemanticTag,
_Hierarchy,
_Equipment,
_FunctionalLocation,
_MaintenanceActivityType,
_MaintOrdPlngDegreeCode,
_PMNotificationPriorityType,
_PMNotificationPriority,
_MaintenanceOrderSubOperation,
_Assembly,
_SuperiorOrder,
_ProjectInternalID,
_ConditionContract,
_SoldProductGroup,
_ServiceDocumentType,
_ServiceDocument,
_ServiceDocumentItem,
_ServiceContract,
_ServiceContractItem,
_ServiceContractType,
_WBSElementExternalID,
_WBSElementExternalIDText,
_WBSElementBasicData,
_WBSElementBasicDataText,
_ProjectExternalID,
_ProjectExternalIDText,
_ProjectBasicData,
_ProjectBasicDataText,
_PartnerProjectExternalID,
_PartnerProjctExtrnalIDText,
_PartnerWBSElementExternalID,
_PartnerWBSElemntExtrnalIDText,
_PartnerProjectBasicData,
_PartnerProjectBasicDataText,
_PartnerWBSElementBasicData,
_PartnerWBSElemntBasicDataText,
_InvtrySpclStockWBSElmntBD,
_InvtrySpclStockWBSElmntExtID,
_ProviderContract,
_ProviderContractItem,
// _CAProviderContract,
// _CAProviderContractItemNumber,
GLAccountAuthorizationGroup,
SupplierBasicAuthorizationGrp,
CustomerBasicAuthorizationGrp,
AcctgDocTypeAuthorizationGroup,
OrderType,
SalesOrderType,
AssetClass
}
where
(
I_GLAccountLineItem.FunctionalArea = ''
and I_SemTagGLAccount.IsFunctionalAreaPermitted = 'X'
) // Only line items without functional area permitted
or(
I_SemTagGLAccount.IsFunctionalAreaPermitted = ''
)
or(
I_SemTagGLAccount.IsFunctionalAreaPermitted is null
)
or(
GLAccountType = 'X'
) // Balance Sheet Account
or(
GLAccountType = 'C'
) // Cash Account