@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
sqlViewName: 'PEPGLACCTRDATA',
compiler.compareFilter: true,
preserveKey: true,
buffering.status: #NOT_ALLOWED
}
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ObjectModel: {
usageType.serviceQuality: #D,
usageType.sizeCategory: #XXL,
usageType.dataClass: #MIXED
}
@VDM: {
private: true,
viewType: #COMPOSITE,
lifecycle.contract.type: #NONE
}
@Metadata.ignorePropagatedAnnotations: true
define view P_EngmntProjGLAcctRawData
as select from I_GLAccountLineItemRawData {
key cast(SourceLedger as fis_rldnr) as SourceLedger,
key CompanyCode,
key FiscalYear,
key AccountingDocument,
key LedgerGLLineItem,
LedgerFiscalYear,
GLRecordType,
ChartOfAccounts,
ControllingArea,
FinancialTransactionType,
BusinessTransactionType,
ControllingBusTransacType,
ReferenceDocumentType,
LogicalSystem,
ReferenceDocumentContext,
ReferenceDocument,
ReferenceDocumentItem,
ReferenceDocumentItemGroup,
IsReversal,
IsReversed,
ReversalReferenceDocumentCntxt,
ReversalReferenceDocument,
IsSettlement,
IsSettled,
PredecessorReferenceDocType,
PredecessorReferenceDocCntxt,
PredecessorReferenceDocument,
PredecessorReferenceDocItem,
SourceReferenceDocumentType,
SourceLogicalSystem,
SourceReferenceDocumentCntxt,
SourceReferenceDocument,
SourceReferenceDocumentItem,
SourceReferenceDocSubitem,
IsCommitment,
JrnlEntryItemObsoleteReason,
GLAccount,
CostCenter,
ProfitCenter,
FunctionalArea,
BusinessArea,
Segment,
PartnerCostCenter,
PartnerProfitCenter,
PartnerFunctionalArea,
PartnerBusinessArea,
PartnerCompany,
PartnerSegment,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
TransactionCurrency,
AmountInTransactionCurrency,
CompanyCodeCurrency,
AmountInCompanyCodeCurrency,
GlobalCurrency,
AmountInGlobalCurrency,
FreeDefinedCurrency1,
AmountInFreeDefinedCurrency1,
FreeDefinedCurrency2,
AmountInFreeDefinedCurrency2,
FreeDefinedCurrency3,
AmountInFreeDefinedCurrency3,
FreeDefinedCurrency4,
AmountInFreeDefinedCurrency4,
FreeDefinedCurrency5,
AmountInFreeDefinedCurrency5,
FreeDefinedCurrency6,
AmountInFreeDefinedCurrency6,
FreeDefinedCurrency7,
AmountInFreeDefinedCurrency7,
FreeDefinedCurrency8,
AmountInFreeDefinedCurrency8,
FixedAmountInGlobalCrcy,
GrpValnFixedAmtInGlobCrcy,
PrftCtrValnFxdAmtInGlobCrcy,
TotalPriceVarcInGlobalCrcy,
GrpValnTotPrcVarcInGlobCrcy,
PrftCtrValnTotPrcVarcInGlbCrcy,
FixedPriceVarcInGlobalCrcy,
GrpValnFixedPrcVarcInGlobCrcy,
PrftCtrValnFxdPrcVarcInGlbCrcy,
ControllingObjectCurrency,
AmountInObjectCurrency,
BaseUnit,
Quantity,
FixedQuantity,
CostSourceUnit,
ValuationQuantity,
ValuationFixedQuantity,
AdditionalQuantity1Unit,
AdditionalQuantity1,
AdditionalQuantity2Unit,
AdditionalQuantity2,
AdditionalQuantity3Unit,
AdditionalQuantity3,
DebitCreditCode,
FiscalPeriod,
FiscalYearVariant,
FiscalYearPeriod,
PostingDate,
DocumentDate,
AccountingDocumentType,
AccountingDocumentItem,
AssignmentReference,
AccountingDocumentCategory,
PostingKey,
TransactionTypeDetermination,
SubLedgerAcctLineItemType,
AccountingDocCreatedByUser,
LastChangeDateTime,
CreationDateTime,
CreationDate,
EliminationProfitCenter,
OriginObjectType,
GLAccountType,
AlternativeGLAccount,
CountryChartOfAccounts,
InvoiceReference,
InvoiceReferenceFiscalYear,
FollowOnDocumentType,
InvoiceItemReference,
ReferencePurchaseOrderCategory,
PurchasingDocument,
PurchasingDocumentItem,
AccountAssignmentNumber,
DocumentItemText,
cast(SalesDocument as vdm_sales_order) as SalesDocument,
cast(SalesDocumentItem as sales_order_item ) as SalesDocumentItem,
Product,
Plant,
Supplier,
Customer,
ServicesRenderedDate,
ConditionContract,
ExchangeRateDate,
FinancialAccountType,
SpecialGLCode,
TaxCode,
HouseBank,
HouseBankAccount,
IsOpenItemManaged,
ClearingDate,
ClearingJournalEntry as ClearingAccountingDocument,
ClearingJournalEntryFiscalYear as ClearingDocFiscalYear,
AssetDepreciationArea,
MasterFixedAsset,
FixedAsset,
AssetValueDate,
AssetTransactionType,
AssetAcctTransClassfctn,
DepreciationFiscalPeriod,
GroupMasterFixedAsset,
GroupFixedAsset,
AssetClass,
CostEstimate,
InventorySpecialStockValnType,
InventorySpecialStockType,
InventorySpclStkSalesDocument,
InventorySpclStkSalesDocItm,
InvtrySpclStockWBSElmntIntID,
_InvtrySpclStkWBSElmntBscData.WBSElementInternalID as InventorySpclStockWBSElement,
InventorySpecialStockSupplier,
InventoryValuationType,
ValuationArea,
SenderCompanyCode,
SenderGLAccount,
SenderAccountAssignment,
SenderAccountAssignmentType,
ControllingObject,
CostOriginGroup,
OriginSenderObject,
ControllingDebitCreditCode,
ControllingObjectDebitType,
QuantityIsIncomplete,
OffsettingAccount,
OffsettingAccountType,
OffsettingChartOfAccounts,
LineItemIsCompleted,
PersonnelNumber,
ControllingObjectClass,
PartnerCompanyCode,
PartnerControllingObjectClass,
OriginCostCenter,
OriginProfitCenter,
OriginCostCtrActivityType,
AccountAssignment,
AccountAssignmentType,
CostCtrActivityType,
OrderID,
OrderCategory,
WBSElementInternalID,
_WBSElementBasicData.WBSElement as WBSElement,
PartnerWBSElementInternalID,
_PartnerWBSElementBasicData.WBSElementInternalID as PartnerWBSElement,
ProjectInternalID,
Project,
PartnerProjectInternalID,
_PartnerProjectBasicData.ProjectInternalID as PartnerProject,
OperatingConcern,
ProjectNetwork,
RelatedNetworkActivity,
BusinessProcess,
CostObject,
BillableControl,
CostAnalysisResource,
CustomerServiceNotification,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
PartnerServiceDocumentType,
PartnerServiceDocument,
PartnerServiceDocumentItem,
ServiceContractType,
ServiceContract,
ServiceContractItem,
TimeSheetOvertimeCategory,
PartnerAccountAssignment,
PartnerAccountAssignmentType,
WorkPackage,
WorkItem,
PartnerCostCtrActivityType,
PartnerOrder,
PartnerOrderCategory,
PartnerSalesDocument,
PartnerSalesDocumentItem,
PartnerProjectNetwork,
PartnerProjectNetworkActivity,
PartnerBusinessProcess,
PartnerCostObject,
BillingDocumentType,
SalesOrganization,
DistributionChannel,
OrganizationDivision,
SoldProduct,
SoldProductGroup,
CustomerGroup,
CustomerSupplierCountry,
CustomerSupplierIndustry,
SalesDistrict,
BillToParty,
ShipToParty,
CustomerSupplierCorporateGroup,
CashLedgerCompanyCode,
CashLedgerAccount,
FinancialManagementArea,
FundsCenter,
FundedProgram,
Fund,
GrantID,
BudgetPeriod,
PartnerFund,
PartnerGrant,
PartnerBudgetPeriod,
PubSecBudgetAccount,
PubSecBudgetAccountCoCode,
PubSecBudgetCnsmpnDate,
PubSecBudgetCnsmpnFsclPeriod,
PubSecBudgetCnsmpnFsclYear,
PubSecBudgetIsRelevant,
PubSecBudgetCnsmpnType,
PubSecBudgetCnsmpnAmtType,
JointVenture,
JointVentureEquityGroup,
JointVentureCostRecoveryCode,
JointVenturePartner,
JointVentureBillingType,
JointVentureEquityType,
JointVentureProductionDate,
JointVentureBillingDate,
JointVentureOperationalDate,
CutbackRun,
JointVentureAccountingActivity,
PartnerVenture,
PartnerEquityGroup,
SenderCostRecoveryCode,
CutbackAccount,
CutbackCostObject,
SettlementReferenceDate,
AccrualObjectType,
AccrualObject,
AccrualSubobject,
AccrualItemType,
AccrualValueDate,
FinancialValuationObjectType,
FinancialValuationObject,
FinancialValuationSubobject,
NetDueDate,
CreditRiskClass,
WorkCenterInternalID,
OrderOperation,
OrderItem,
OrderSuboperation,
Equipment,
FunctionalLocation,
Assembly,
MaintenanceActivityType,
MaintenanceOrderPlanningCode,
MaintPriorityType,
MaintPriority,
SuperiorOrder,
ProductGroup,
MaintenanceOrderIsPlanned,
_Product.ProductGroup as MaterialGroup
} where
BusinessTransactionType <> 'TBRR'
and BusinessTransactionType <> 'RFCV'
and AccountAssignmentType = 'PR'
and Product <> 'A001'
and Product <> 'A002'
and (
( FiscalPeriod > '000' )
or
( FiscalPeriod = '000' and AccountingDocumentCategory = 'J')
)
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMRAWDATA",
"I_PRODUCT",
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/