P_EngmntProjGLAcctRawData

@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":""
}
}*/