P_AllocRunJournalEntryItem1

DDL: P_ALLOCRUNJOURNALENTRYITEM1 SQL: PALLOCRUNJEI1 Type: view CONSUMPTION
324 Fields 2 Data Sources

P_AllocRunJournalEntryItem1 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_AllocRunJournalEntryItem, I_GLAccountLineItemRawData) and exposes 324 fields with key fields UniversalAllocationRun, AllocationCycle, AllocationCycleStartDate, FiscalYear, FiscalPeriod.

Data Sources (2)

SourceAliasJoin Type
P_AllocRunJournalEntryItem Document from
I_GLAccountLineItemRawData JournalEntryItem inner

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PALLOCRUNJEI1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (324)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun P_AllocRunJournalEntryItem UniversalAllocationRun
KEY AllocationCycle P_AllocRunJournalEntryItem AllocationCycle Cycle
KEY AllocationCycleStartDate P_AllocRunJournalEntryItem AllocationCycleStartDate Valid From
KEY FiscalYear P_AllocRunJournalEntryItem FiscalYear G/L Fiscal Year
KEY FiscalPeriod P_AllocRunJournalEntryItem FiscalPeriod Tax period
KEY AllocDocumentSequenceNumber P_AllocRunJournalEntryItem AllocDocumentSequenceNumber
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
AllocationType P_AllocRunJournalEntryItem AllocationType Table
AllocationActualPlanVariant P_AllocRunJournalEntryItem AllocationActualPlanVariant Actual/Plan
AllocationPostingType P_AllocRunJournalEntryItem AllocationPostingType Posting Type
AllocationCycleName P_AllocRunJournalEntryItem AllocationCycleName Allocation Cycle
ReferenceDocumentNumber P_AllocRunJournalEntryItem ReferenceDocumentNumber
ReversalReferenceDocument P_AllocRunJournalEntryItem ReversalReferenceDocument Reversal Reference Document
Ledger I_GLAccountLineItemRawData SourceLedger Source Ledger
CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
LedgerFiscalYear I_GLAccountLineItemRawData LedgerFiscalYear Ref. Year1
GLRecordType I_GLAccountLineItemRawData GLRecordType Record Type
FinancialTransactionType I_GLAccountLineItemRawData FinancialTransactionType Transact. Type
BusinessTransactionType I_GLAccountLineItemRawData BusinessTransactionType Bus.transaction
ReferenceDocumentType I_GLAccountLineItemRawData ReferenceDocumentType Reference Document Type
LogicalSystem I_GLAccountLineItemRawData LogicalSystem Logical System
ReferenceDocumentContext I_GLAccountLineItemRawData ReferenceDocumentContext Reference Document Context
ReferenceDocument I_GLAccountLineItemRawData ReferenceDocument Reference Document
ReferenceDocumentItem I_GLAccountLineItemRawData ReferenceDocumentItem Reference item
ReferenceDocumentItemGroup I_GLAccountLineItemRawData ReferenceDocumentItemGroup Reference Document Item Group
IsReversal I_GLAccountLineItemRawData IsReversal Reversal doc.
IsReversed I_GLAccountLineItemRawData IsReversed Reversed?
ReversalReferenceDocumentCntxt I_GLAccountLineItemRawData ReversalReferenceDocumentCntxt Reversal Reference Document Context
IsSettlement I_GLAccountLineItemRawData IsSettlement Is Settling
IsSettled I_GLAccountLineItemRawData IsSettled Is Settled
PredecessorReferenceDocType I_GLAccountLineItemRawData PredecessorReferenceDocType Predecessor Reference Document Type
PredecessorReferenceDocCntxt I_GLAccountLineItemRawData PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocument I_GLAccountLineItemRawData PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem I_GLAccountLineItemRawData PredecessorReferenceDocItem Prec. Ref. Doc. Item
SourceReferenceDocumentType I_GLAccountLineItemRawData SourceReferenceDocumentType Ref. procedure
SourceLogicalSystem I_GLAccountLineItemRawData SourceLogicalSystem
SourceReferenceDocumentCntxt I_GLAccountLineItemRawData SourceReferenceDocumentCntxt
SourceReferenceDocument I_GLAccountLineItemRawData SourceReferenceDocument Reference Doc.
SourceReferenceDocumentItem I_GLAccountLineItemRawData SourceReferenceDocumentItem Ref. Doc. Item
SourceReferenceDocSubitem I_GLAccountLineItemRawData SourceReferenceDocSubitem
IsCommitment I_GLAccountLineItemRawData IsCommitment
JrnlEntryItemObsoleteReason I_GLAccountLineItemRawData JrnlEntryItemObsoleteReason Obsolete Reason
BalanceTransactionCurrency I_GLAccountLineItemRawData BalanceTransactionCurrency Currency
TransactionCurrency I_GLAccountLineItemRawData TransactionCurrency Transaction Currency
CompanyCodeCurrency I_GLAccountLineItemRawData CompanyCodeCurrency Local Currency
GlobalCurrency I_GLAccountLineItemRawData GlobalCurrency GM Billing Element: Global Currency
FreeDefinedCurrency1 I_GLAccountLineItemRawData FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 I_GLAccountLineItemRawData FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 I_GLAccountLineItemRawData FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 I_GLAccountLineItemRawData FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 I_GLAccountLineItemRawData FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 I_GLAccountLineItemRawData FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 I_GLAccountLineItemRawData FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 I_GLAccountLineItemRawData FreeDefinedCurrency8 Freely Defined Currency 8
ControllingObjectCurrency I_GLAccountLineItemRawData ControllingObjectCurrency CO Object Currency
BaseUnit I_GLAccountLineItemRawData BaseUnit Unit of Measure
CostSourceUnit I_GLAccountLineItemRawData CostSourceUnit Valuation UoM
AdditionalQuantity1Unit I_GLAccountLineItemRawData AdditionalQuantity1Unit Add Unit Meas 1
AdditionalQuantity2Unit I_GLAccountLineItemRawData AdditionalQuantity2Unit Add Unit Meas 2
AdditionalQuantity3Unit I_GLAccountLineItemRawData AdditionalQuantity3Unit Add Unit Meas 3
GLAccount I_GLAccountLineItemRawData GLAccount General Ledger
CostCenter I_GLAccountLineItemRawData CostCenter Cost Center
ProfitCenter I_GLAccountLineItemRawData ProfitCenter Profit Center
FunctionalArea I_GLAccountLineItemRawData FunctionalArea Sendr Fctl Area
BusinessArea I_GLAccountLineItemRawData BusinessArea Business Area
ControllingArea I_GLAccountLineItemRawData ControllingArea Controlling Area
Segment I_GLAccountLineItemRawData Segment Segment number
PartnerCostCenter I_GLAccountLineItemRawData PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter I_GLAccountLineItemRawData PartnerProfitCenter Profit Center
PartnerFunctionalArea I_GLAccountLineItemRawData PartnerFunctionalArea Rec. Fntcl Area
PartnerBusinessArea I_GLAccountLineItemRawData PartnerBusinessArea Trdg Part.BA
PartnerCompany I_GLAccountLineItemRawData PartnerCompany Trading Partner
PartnerSegment I_GLAccountLineItemRawData PartnerSegment Partner Segment
AmountInBalanceTransacCrcy I_GLAccountLineItemRawData AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AmountInTransactionCurrency I_GLAccountLineItemRawData AmountInTransactionCurrency Pt Crcy Amt
AmountInCompanyCodeCurrency I_GLAccountLineItemRawData AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency I_GLAccountLineItemRawData AmountInGlobalCurrency Amount in Global Currency
AmountInFreeDefinedCurrency1 I_GLAccountLineItemRawData AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 I_GLAccountLineItemRawData AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 I_GLAccountLineItemRawData AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 I_GLAccountLineItemRawData AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 I_GLAccountLineItemRawData AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 I_GLAccountLineItemRawData AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 I_GLAccountLineItemRawData AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 I_GLAccountLineItemRawData AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
FixedAmountInGlobalCrcy I_GLAccountLineItemRawData FixedAmountInGlobalCrcy Fixed Amnt in GC
GrpValnFixedAmtInGlobCrcy I_GLAccountLineItemRawData GrpValnFixedAmtInGlobCrcy
PrftCtrValnFxdAmtInGlobCrcy I_GLAccountLineItemRawData PrftCtrValnFxdAmtInGlobCrcy
TotalPriceVarcInGlobalCrcy I_GLAccountLineItemRawData TotalPriceVarcInGlobalCrcy Price Variance
GrpValnTotPrcVarcInGlobCrcy I_GLAccountLineItemRawData GrpValnTotPrcVarcInGlobCrcy
PrftCtrValnTotPrcVarcInGlbCrcy I_GLAccountLineItemRawData PrftCtrValnTotPrcVarcInGlbCrcy
FixedPriceVarcInGlobalCrcy I_GLAccountLineItemRawData FixedPriceVarcInGlobalCrcy Price Var. Fxd
GrpValnFixedPrcVarcInGlobCrcy I_GLAccountLineItemRawData GrpValnFixedPrcVarcInGlobCrcy
PrftCtrValnFxdPrcVarcInGlbCrcy I_GLAccountLineItemRawData PrftCtrValnFxdPrcVarcInGlbCrcy
AmountInObjectCurrency I_GLAccountLineItemRawData AmountInObjectCurrency Amount in Obj Crcy
Quantity I_GLAccountLineItemRawData Quantity Value
FixedQuantity I_GLAccountLineItemRawData FixedQuantity Fixed Quantity
ValuationQuantity I_GLAccountLineItemRawData ValuationQuantity
ValuationFixedQuantity I_GLAccountLineItemRawData ValuationFixedQuantity
AdditionalQuantity1 I_GLAccountLineItemRawData AdditionalQuantity1
AdditionalQuantity2 I_GLAccountLineItemRawData AdditionalQuantity2
AdditionalQuantity3 I_GLAccountLineItemRawData AdditionalQuantity3
DebitCreditCode I_GLAccountLineItemRawData DebitCreditCode Single-Character Flag
FiscalYearVariant I_GLAccountLineItemRawData FiscalYearVariant FY Variant
FiscalYearPeriod I_GLAccountLineItemRawData FiscalYearPeriod Period/Year
PostingDate I_GLAccountLineItemRawData PostingDate Posting Date for GR
DocumentDate I_GLAccountLineItemRawData DocumentDate Journal Entry Date
AccountingDocumentType I_GLAccountLineItemRawData AccountingDocumentType Journal Entry Type
AccountingDocumentItem I_GLAccountLineItemRawData AccountingDocumentItem Posting View Item
AssignmentReference I_GLAccountLineItemRawData AssignmentReference Assignment Reference
PostingKey I_GLAccountLineItemRawData PostingKey Posting Key
AccountingDocumentCategory I_GLAccountLineItemRawData AccountingDocumentCategory Journal Entry Category
TransactionTypeDetermination I_GLAccountLineItemRawData TransactionTypeDetermination Transaction Key
SubLedgerAcctLineItemType I_GLAccountLineItemRawData SubLedgerAcctLineItemType SLALineItemType
AccountingDocCreatedByUser I_GLAccountLineItemRawData AccountingDocCreatedByUser User which created overhead document
CreationDateTime I_GLAccountLineItemRawData CreationDateTime Timestamp
EliminationProfitCenter I_GLAccountLineItemRawData EliminationProfitCenter
OriginObjectType I_GLAccountLineItemRawData OriginObjectType Origin
GLAccountType I_GLAccountLineItemRawData GLAccountType G/L Account Type
ChartOfAccounts I_GLAccountLineItemRawData ChartOfAccounts Node Class
AlternativeGLAccount I_GLAccountLineItemRawData AlternativeGLAccount Group Account
CountryChartOfAccounts I_GLAccountLineItemRawData CountryChartOfAccounts Chart of Accts
InvoiceReference I_GLAccountLineItemRawData InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_GLAccountLineItemRawData InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference I_GLAccountLineItemRawData InvoiceItemReference Item
FollowOnDocumentType I_GLAccountLineItemRawData FollowOnDocumentType Follow-On Document Type
ReferencePurchaseOrderCategory I_GLAccountLineItemRawData ReferencePurchaseOrderCategory PO Category
PurchasingDocument I_GLAccountLineItemRawData PurchasingDocument Purchasing Document
PurchasingDocumentItem I_GLAccountLineItemRawData PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber I_GLAccountLineItemRawData AccountAssignmentNumber Account Assgmt No.
DocumentItemText I_GLAccountLineItemRawData DocumentItemText Text
SalesOrder
SalesDocumentItem I_GLAccountLineItemRawData SalesDocumentItem Sales Document Item
Material
Plant I_GLAccountLineItemRawData Plant Valuation Area
Supplier I_GLAccountLineItemRawData Supplier Supplier
Customer I_GLAccountLineItemRawData Customer Sold-to Party
ServicesRenderedDate I_GLAccountLineItemRawData ServicesRenderedDate Services Rendered Date
ConditionContract I_GLAccountLineItemRawData ConditionContract Condition Contract
FinancialAccountType I_GLAccountLineItemRawData FinancialAccountType Fin. Account Type
SpecialGLCode I_GLAccountLineItemRawData SpecialGLCode Special G/L Ind
TaxCode I_GLAccountLineItemRawData TaxCode Tax Code
HouseBank I_GLAccountLineItemRawData HouseBank House Bank
HouseBankAccount I_GLAccountLineItemRawData HouseBankAccount House Bank Account
IsOpenItemManaged I_GLAccountLineItemRawData IsOpenItemManaged Open Item Management
ClearingDate I_GLAccountLineItemRawData ClearingDate Clearing Date
ClearingAccountingDocument I_GLAccountLineItemRawData ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear I_GLAccountLineItemRawData ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
AssetDepreciationArea I_GLAccountLineItemRawData AssetDepreciationArea Deprec. Area
MasterFixedAsset I_GLAccountLineItemRawData MasterFixedAsset Fixed Asset
FixedAsset I_GLAccountLineItemRawData FixedAsset Sub-number
AssetValueDate I_GLAccountLineItemRawData AssetValueDate Reference date
AssetTransactionType I_GLAccountLineItemRawData AssetTransactionType Trans.Type
AssetAcctTransClassfctn I_GLAccountLineItemRawData AssetAcctTransClassfctn Trans.Type Cat.
DepreciationFiscalPeriod I_GLAccountLineItemRawData DepreciationFiscalPeriod Deprec. Period
GroupMasterFixedAsset I_GLAccountLineItemRawData GroupMasterFixedAsset Group Asset
GroupFixedAsset I_GLAccountLineItemRawData GroupFixedAsset Subnumber
AssetClass I_GLAccountLineItemRawData AssetClass Asset Class
CostEstimate I_GLAccountLineItemRawData CostEstimate Cost EstimateNo
InventorySpecialStockValnType I_GLAccountLineItemRawData InventorySpecialStockValnType Valuation
InventorySpecialStockType I_GLAccountLineItemRawData InventorySpecialStockType Special Stock Type
InventorySpclStkSalesDocument I_GLAccountLineItemRawData InventorySpclStkSalesDocument
InventorySpclStkSalesDocItm I_GLAccountLineItemRawData InventorySpclStkSalesDocItm
InvtrySpclStockWBSElmntIntID I_GLAccountLineItemRawData InvtrySpclStockWBSElmntIntID
InventorySpclStockWBSElement I_GLAccountLineItemRawData InventorySpclStockWBSElement
InventorySpecialStockSupplier I_GLAccountLineItemRawData InventorySpecialStockSupplier Vendor of Inv.
InventoryValuationType I_GLAccountLineItemRawData InventoryValuationType Valuation Type
ValuationArea I_GLAccountLineItemRawData ValuationArea Valuation Area
SenderGLAccount I_GLAccountLineItemRawData SenderGLAccount Sender GL Account
SenderAccountAssignment I_GLAccountLineItemRawData SenderAccountAssignment
SenderAccountAssignmentType I_GLAccountLineItemRawData SenderAccountAssignmentType
ControllingObject I_GLAccountLineItemRawData ControllingObject Object number
CostOriginGroup I_GLAccountLineItemRawData CostOriginGroup Origin Group
OriginSenderObject I_GLAccountLineItemRawData OriginSenderObject Source Object
ControllingDebitCreditCode I_GLAccountLineItemRawData ControllingDebitCreditCode Dr/Cr ind. CO
ControllingObjectDebitType I_GLAccountLineItemRawData ControllingObjectDebitType
QuantityIsIncomplete I_GLAccountLineItemRawData QuantityIsIncomplete Qty Is Incomplete
OffsettingAccount I_GLAccountLineItemRawData OffsettingAccount Offsetting Acct
OffsettingAccountType I_GLAccountLineItemRawData OffsettingAccountType Offset Acct Type
LineItemIsCompleted I_GLAccountLineItemRawData LineItemIsCompleted Item Completed
PersonnelNumber I_GLAccountLineItemRawData PersonnelNumber Personnel No.
ControllingObjectClass I_GLAccountLineItemRawData ControllingObjectClass Object Class
PartnerCompanyCode I_GLAccountLineItemRawData PartnerCompanyCode Partner Company Code
PartnerControllingObjectClass I_GLAccountLineItemRawData PartnerControllingObjectClass PartnerObjClass
OriginCostCenter I_GLAccountLineItemRawData OriginCostCenter OrigCCtr
OriginCostCtrActivityType I_GLAccountLineItemRawData OriginCostCtrActivityType OrigAct.
OriginProfitCenter I_GLAccountLineItemRawData OriginProfitCenter Origin Profit Center
AccountAssignment I_GLAccountLineItemRawData AccountAssignment Sender Acct Assgmt
AccountAssignmentType I_GLAccountLineItemRawData AccountAssignmentType Sndr AcctAssgmt Type
CostCtrActivityType I_GLAccountLineItemRawData CostCtrActivityType Activity Type
OrderID I_GLAccountLineItemRawData OrderID Order ID
OrderCategory I_GLAccountLineItemRawData OrderCategory Order Category
WBSElementInternalID I_GLAccountLineItemRawData WBSElementInternalID WBS Internal ID
WBSElement I_GLAccountLineItemRawData WBSElement WBS Internal ID
ProjectInternalID I_GLAccountLineItemRawData ProjectInternalID Project Def.
Project I_GLAccountLineItemRawData Project WBS Element
ProjectNetwork I_GLAccountLineItemRawData ProjectNetwork Order
RelatedNetworkActivity I_GLAccountLineItemRawData RelatedNetworkActivity Netwk activity
BusinessProcess I_GLAccountLineItemRawData BusinessProcess Business Process
CostObject I_GLAccountLineItemRawData CostObject Cost Object
BillableControl I_GLAccountLineItemRawData BillableControl Billable Control
CostAnalysisResource I_GLAccountLineItemRawData CostAnalysisResource Resource
CustomerServiceNotification I_GLAccountLineItemRawData CustomerServiceNotification
ServiceDocumentType I_GLAccountLineItemRawData ServiceDocumentType Transaction Type
ServiceDocument I_GLAccountLineItemRawData ServiceDocument Transaction ID
ServiceDocumentItem I_GLAccountLineItemRawData ServiceDocumentItem Service Document
ServiceContractType I_GLAccountLineItemRawData ServiceContractType Serv. Contract Type
ServiceContract I_GLAccountLineItemRawData ServiceContract Transaction ID
ServiceContractItem I_GLAccountLineItemRawData ServiceContractItem Item Number in Doc.
BusinessSolutionOrder I_GLAccountLineItemRawData BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem I_GLAccountLineItemRawData BusinessSolutionOrderItem Solution Order Item
TimeSheetOvertimeCategory I_GLAccountLineItemRawData TimeSheetOvertimeCategory Overtime Category
WorkPackage I_GLAccountLineItemRawData WorkPackage Plan Item
WorkItem I_GLAccountLineItemRawData WorkItem Work Item ID
OperatingConcern I_GLAccountLineItemRawData OperatingConcern Operating concern
PartnerAccountAssignment I_GLAccountLineItemRawData PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType I_GLAccountLineItemRawData PartnerAccountAssignmentType Partner Account Assignment Type
PartnerCostCtrActivityType I_GLAccountLineItemRawData PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerOrder I_GLAccountLineItemRawData PartnerOrder Partner Order
PartnerOrderCategory I_GLAccountLineItemRawData PartnerOrderCategory Prtnr Ord. Cat.
PartnerWBSElementInternalID I_GLAccountLineItemRawData PartnerWBSElementInternalID Partner WBS Element Internal ID
PartnerWBSElement I_GLAccountLineItemRawData PartnerWBSElement WBS Element
PartnerProjectInternalID I_GLAccountLineItemRawData PartnerProjectInternalID
PartnerProject I_GLAccountLineItemRawData PartnerProject
PartnerSalesDocument I_GLAccountLineItemRawData PartnerSalesDocument Partner Sales Doc.
PartnerSalesDocumentItem I_GLAccountLineItemRawData PartnerSalesDocumentItem Partner Sales Document Item
PartnerProjectNetwork I_GLAccountLineItemRawData PartnerProjectNetwork Part. Proj. Network
PartnerProjectNetworkActivity I_GLAccountLineItemRawData PartnerProjectNetworkActivity Partner Project Network Activity
PartnerBusinessProcess I_GLAccountLineItemRawData PartnerBusinessProcess Part. Bus. Process
PartnerCostObject I_GLAccountLineItemRawData PartnerCostObject Partner Cost Object
BillingDocumentType I_GLAccountLineItemRawData BillingDocumentType Billing Type
SalesOrganization I_GLAccountLineItemRawData SalesOrganization Sales Organization
DistributionChannel I_GLAccountLineItemRawData DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_GLAccountLineItemRawData OrganizationDivision Org. Division
SoldProduct I_GLAccountLineItemRawData SoldProduct Product Sold
SoldProductGroup I_GLAccountLineItemRawData SoldProductGroup Product Sold Group
CustomerGroup I_GLAccountLineItemRawData CustomerGroup Customer Group
CustomerSupplierCountry I_GLAccountLineItemRawData CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry I_GLAccountLineItemRawData CustomerSupplierIndustry Industry
SalesDistrict I_GLAccountLineItemRawData SalesDistrict Sales District
BillToParty I_GLAccountLineItemRawData BillToParty Inv. Recipient
ShipToParty I_GLAccountLineItemRawData ShipToParty Ship-To Party (obsolete)
CustomerSupplierCorporateGroup I_GLAccountLineItemRawData CustomerSupplierCorporateGroup Group
FinancialManagementArea I_GLAccountLineItemRawData FinancialManagementArea FM Area
FundsCenter I_GLAccountLineItemRawData FundsCenter Funds Center
FundedProgram I_GLAccountLineItemRawData FundedProgram Funded Program
Fund I_GLAccountLineItemRawData Fund Sender Fund
GrantID I_GLAccountLineItemRawData GrantID Sender Grant
BudgetPeriod I_GLAccountLineItemRawData BudgetPeriod Budget Period
PartnerFund I_GLAccountLineItemRawData PartnerFund Receiver Fund
PartnerGrant I_GLAccountLineItemRawData PartnerGrant Receiver Grant
PartnerBudgetPeriod I_GLAccountLineItemRawData PartnerBudgetPeriod Partner Budget Period
JointVenture I_GLAccountLineItemRawData JointVenture Joint venture
JointVentureEquityGroup I_GLAccountLineItemRawData JointVentureEquityGroup Joint Venture Equity Group
JointVentureCostRecoveryCode I_GLAccountLineItemRawData JointVentureCostRecoveryCode Recovery Ind.
JointVenturePartner I_GLAccountLineItemRawData JointVenturePartner Joint Venture Partner
JointVentureBillingType I_GLAccountLineItemRawData JointVentureBillingType
JointVentureEquityType I_GLAccountLineItemRawData JointVentureEquityType Joint Venture Equity Type
JointVentureProductionDate I_GLAccountLineItemRawData JointVentureProductionDate
JointVentureBillingDate I_GLAccountLineItemRawData JointVentureBillingDate
JointVentureOperationalDate I_GLAccountLineItemRawData JointVentureOperationalDate
CutbackRun I_GLAccountLineItemRawData CutbackRun
JointVentureAccountingActivity I_GLAccountLineItemRawData JointVentureAccountingActivity
PartnerVenture
PartnerEquityGroup I_GLAccountLineItemRawData PartnerEquityGroup Partner EG (JVA)
SenderCostRecoveryCode I_GLAccountLineItemRawData SenderCostRecoveryCode Sender Cost Recovery Code
CutbackAccount I_GLAccountLineItemRawData CutbackAccount
CutbackCostObject I_GLAccountLineItemRawData CutbackCostObject
SettlementReferenceDate I_GLAccountLineItemRawData SettlementReferenceDate Reference date
ControllingBusTransacType I_GLAccountLineItemRawData ControllingBusTransacType CO Bus. Transaction
PrdcssrJournalEntryCompanyCode I_GLAccountLineItemRawData PrdcssrJournalEntryCompanyCode Predecessor Journal Entry Company Code
PrdcssrJournalEntryFiscalYear I_GLAccountLineItemRawData PrdcssrJournalEntryFiscalYear Predecessor Journal Entry Fiscal Year
PredecessorJournalEntry I_GLAccountLineItemRawData PredecessorJournalEntry Predecessor Journal Entry
PredecessorJournalEntryItem I_GLAccountLineItemRawData PredecessorJournalEntryItem Predecessor Journal Entry Item
OrganizationalChange I_GLAccountLineItemRawData OrganizationalChange Organizational Change
GrantCurrency I_GLAccountLineItemRawData GrantCurrency Grant Currency
AmountInGrantCurrency I_GLAccountLineItemRawData AmountInGrantCurrency Amount in Grant Crcy
ReferenceQuantityUnit I_GLAccountLineItemRawData ReferenceQuantityUnit Reference UoM
ReferenceQuantity I_GLAccountLineItemRawData ReferenceQuantity Comm Refer Quantity
LastChangeDateTime I_GLAccountLineItemRawData LastChangeDateTime Timestamp
SalesDocument I_GLAccountLineItemRawData SalesDocument SD Document
Product I_GLAccountLineItemRawData Product Product Sold
PerformancePeriodStartDate I_GLAccountLineItemRawData PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate I_GLAccountLineItemRawData PerformancePeriodEndDate End of Performance Period
TaxCountry I_GLAccountLineItemRawData TaxCountry Tax Ctry/Reg.
ValueDate I_GLAccountLineItemRawData ValueDate Value Date
SenderCompanyCode I_GLAccountLineItemRawData SenderCompanyCode Sender Company Code
OriginCtrlgDebitCreditCode I_GLAccountLineItemRawData OriginCtrlgDebitCreditCode Debit/CreditInd
OriginProduct I_GLAccountLineItemRawData OriginProduct Origin Material
VarianceOriginGLAccount I_GLAccountLineItemRawData VarianceOriginGLAccount Varc. Origin Account
PartnerServiceDocumentType I_GLAccountLineItemRawData PartnerServiceDocumentType Par. Service DocType
PartnerServiceDocument I_GLAccountLineItemRawData PartnerServiceDocument Partner Service Doc.
PartnerServiceDocumentItem I_GLAccountLineItemRawData PartnerServiceDocumentItem Par. Service DocItem
CashLedgerCompanyCode I_GLAccountLineItemRawData CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount I_GLAccountLineItemRawData CashLedgerAccount Cash Origin Account
PubSecBudgetAccount I_GLAccountLineItemRawData PubSecBudgetAccount Budget Account
PubSecBudgetAccountCoCode I_GLAccountLineItemRawData PubSecBudgetAccountCoCode Company Code for Budget Account
PubSecBudgetCnsmpnDate I_GLAccountLineItemRawData PubSecBudgetCnsmpnDate Budget Consumption Date
PubSecBudgetCnsmpnFsclPeriod I_GLAccountLineItemRawData PubSecBudgetCnsmpnFsclPeriod Posting Period for Budget Consumption
PubSecBudgetCnsmpnFsclYear I_GLAccountLineItemRawData PubSecBudgetCnsmpnFsclYear Year of Budget Consumption
PubSecBudgetIsRelevant I_GLAccountLineItemRawData PubSecBudgetIsRelevant Budget-Relevant
PubSecBudgetCnsmpnType I_GLAccountLineItemRawData PubSecBudgetCnsmpnType Budget Consumption Type
PubSecBudgetCnsmpnAmtType I_GLAccountLineItemRawData PubSecBudgetCnsmpnAmtType Amount Type for Budget Consumption
SponsoredProgram I_GLAccountLineItemRawData SponsoredProgram Sponsored Program
SponsoredClass I_GLAccountLineItemRawData SponsoredClass Sponsored Class
REBusinessEntity I_GLAccountLineItemRawData REBusinessEntity RE Business Entity
RealEstateBuilding I_GLAccountLineItemRawData RealEstateBuilding Building
RealEstateProperty I_GLAccountLineItemRawData RealEstateProperty Land
RERentalObject I_GLAccountLineItemRawData RERentalObject Rental Unit
RealEstateContract I_GLAccountLineItemRawData RealEstateContract Real Estate Contract
REServiceChargeKey I_GLAccountLineItemRawData REServiceChargeKey Srv. Charge Key
RESettlementUnitID I_GLAccountLineItemRawData RESettlementUnitID Settlement Unit
REPartnerBusinessEntity I_GLAccountLineItemRawData REPartnerBusinessEntity RE Partner Business Entity
RealEstatePartnerBuilding I_GLAccountLineItemRawData RealEstatePartnerBuilding Real Estate Partner Building
RealEstatePartnerProperty I_GLAccountLineItemRawData RealEstatePartnerProperty Real Estate Partner Property
REPartnerRentalObject I_GLAccountLineItemRawData REPartnerRentalObject RE Partner Rental Object
RealEstatePartnerContract I_GLAccountLineItemRawData RealEstatePartnerContract Real Estate Partner Contract
REPartnerServiceChargeKey I_GLAccountLineItemRawData REPartnerServiceChargeKey RE Partner Service Charge Key
REPartnerSettlementUnitID I_GLAccountLineItemRawData REPartnerSettlementUnitID RE Partner Settlement Unit
PartnerSettlementReferenceDate I_GLAccountLineItemRawData PartnerSettlementReferenceDate Ptnr. Reference Date
FunctionalCurrency I_GLAccountLineItemRawData FunctionalCurrency Functional Currency
AmountInFunctionalCurrency I_GLAccountLineItemRawData AmountInFunctionalCurrency Amount in Functional Currency
AllocationRunStartDateTime P_AllocRunJournalEntryItem AllocationRunStartDateTime

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_AllocRunJournalEntryItem1.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PALLOCRUNJEI1

CREATE VIEW P_AllocRunJournalEntryItem1 AS
SELECT
  Document.UniversalAllocationRun AS UniversalAllocationRun,
  Document.AllocationCycle AS AllocationCycle,
  Document.AllocationCycleStartDate AS AllocationCycleStartDate,
  Document.FiscalYear AS FiscalYear,
  Document.FiscalPeriod AS FiscalPeriod,
  Document.AllocDocumentSequenceNumber AS AllocDocumentSequenceNumber,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  Document.AllocationType AS AllocationType,
  Document.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  Document.AllocationPostingType AS AllocationPostingType,
  Document.AllocationCycleName AS AllocationCycleName,
  Document.ReferenceDocumentNumber AS ReferenceDocumentNumber,
  Document.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntryItem.SourceLedger AS Ledger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  JournalEntryItem.GLRecordType AS GLRecordType,
  JournalEntryItem.FinancialTransactionType AS FinancialTransactionType,
  JournalEntryItem.BusinessTransactionType AS BusinessTransactionType,
  JournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntryItem.LogicalSystem AS LogicalSystem,
  JournalEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  JournalEntryItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  JournalEntryItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  JournalEntryItem.IsReversal AS IsReversal,
  JournalEntryItem.IsReversed AS IsReversed,
  JournalEntryItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  JournalEntryItem.IsSettlement AS IsSettlement,
  JournalEntryItem.IsSettled AS IsSettled,
  JournalEntryItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  JournalEntryItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  JournalEntryItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  JournalEntryItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  JournalEntryItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  JournalEntryItem.SourceLogicalSystem AS SourceLogicalSystem,
  JournalEntryItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  JournalEntryItem.SourceReferenceDocument AS SourceReferenceDocument,
  JournalEntryItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  JournalEntryItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  JournalEntryItem.IsCommitment AS IsCommitment,
  JournalEntryItem.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  JournalEntryItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.GlobalCurrency AS GlobalCurrency,
  JournalEntryItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  JournalEntryItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  JournalEntryItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  JournalEntryItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  JournalEntryItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  JournalEntryItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  JournalEntryItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  JournalEntryItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  JournalEntryItem.ControllingObjectCurrency AS ControllingObjectCurrency,
  JournalEntryItem.BaseUnit AS BaseUnit,
  JournalEntryItem.CostSourceUnit AS CostSourceUnit,
  JournalEntryItem.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  JournalEntryItem.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  JournalEntryItem.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem.ProfitCenter AS ProfitCenter,
  JournalEntryItem.FunctionalArea AS FunctionalArea,
  JournalEntryItem.BusinessArea AS BusinessArea,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem.Segment AS Segment,
  JournalEntryItem.PartnerCostCenter AS PartnerCostCenter,
  JournalEntryItem.PartnerProfitCenter AS PartnerProfitCenter,
  JournalEntryItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  JournalEntryItem.PartnerBusinessArea AS PartnerBusinessArea,
  JournalEntryItem.PartnerCompany AS PartnerCompany,
  JournalEntryItem.PartnerSegment AS PartnerSegment,
  JournalEntryItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  JournalEntryItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  JournalEntryItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  JournalEntryItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  JournalEntryItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  JournalEntryItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  JournalEntryItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  JournalEntryItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  JournalEntryItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  JournalEntryItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  JournalEntryItem.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  JournalEntryItem.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  JournalEntryItem.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  JournalEntryItem.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  JournalEntryItem.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  JournalEntryItem.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  JournalEntryItem.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  JournalEntryItem.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  JournalEntryItem.AmountInObjectCurrency AS AmountInObjectCurrency,
  JournalEntryItem.Quantity AS Quantity,
  JournalEntryItem.FixedQuantity AS FixedQuantity,
  JournalEntryItem.ValuationQuantity AS ValuationQuantity,
  JournalEntryItem.ValuationFixedQuantity AS ValuationFixedQuantity,
  JournalEntryItem.AdditionalQuantity1 AS AdditionalQuantity1,
  JournalEntryItem.AdditionalQuantity2 AS AdditionalQuantity2,
  JournalEntryItem.AdditionalQuantity3 AS AdditionalQuantity3,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  JournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.DocumentDate AS DocumentDate,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItem.AssignmentReference AS AssignmentReference,
  JournalEntryItem.PostingKey AS PostingKey,
  JournalEntryItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntryItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  JournalEntryItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  JournalEntryItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  JournalEntryItem.CreationDateTime AS CreationDateTime,
  JournalEntryItem.EliminationProfitCenter AS EliminationProfitCenter,
  JournalEntryItem.OriginObjectType AS OriginObjectType,
  JournalEntryItem.GLAccountType AS GLAccountType,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  JournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  JournalEntryItem.InvoiceReference AS InvoiceReference,
  JournalEntryItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  JournalEntryItem.InvoiceItemReference AS InvoiceItemReference,
  JournalEntryItem.FollowOnDocumentType AS FollowOnDocumentType,
  JournalEntryItem.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  JournalEntryItem.PurchasingDocument AS PurchasingDocument,
  JournalEntryItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  JournalEntryItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  JournalEntryItem.DocumentItemText AS DocumentItemText,
  cast(JournalEntryItem.SalesDocument as vdm_sales_order preserving type ) AS SalesOrder,
  JournalEntryItem.SalesDocumentItem AS SalesDocumentItem,
  cast(JournalEntryItem.Product as matnr preserving type ) AS Material,
  JournalEntryItem.Plant AS Plant,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem.ServicesRenderedDate AS ServicesRenderedDate,
  JournalEntryItem.ConditionContract AS ConditionContract,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem.SpecialGLCode AS SpecialGLCode,
  JournalEntryItem.TaxCode AS TaxCode,
  JournalEntryItem.HouseBank AS HouseBank,
  JournalEntryItem.HouseBankAccount AS HouseBankAccount,
  JournalEntryItem.IsOpenItemManaged AS IsOpenItemManaged,
  JournalEntryItem.ClearingDate AS ClearingDate,
  JournalEntryItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  JournalEntryItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  JournalEntryItem.AssetDepreciationArea AS AssetDepreciationArea,
  JournalEntryItem.MasterFixedAsset AS MasterFixedAsset,
  JournalEntryItem.FixedAsset AS FixedAsset,
  JournalEntryItem.AssetValueDate AS AssetValueDate,
  JournalEntryItem.AssetTransactionType AS AssetTransactionType,
  JournalEntryItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  JournalEntryItem.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  JournalEntryItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  JournalEntryItem.GroupFixedAsset AS GroupFixedAsset,
  JournalEntryItem.AssetClass AS AssetClass,
  JournalEntryItem.CostEstimate AS CostEstimate,
  JournalEntryItem.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  JournalEntryItem.InventorySpecialStockType AS InventorySpecialStockType,
  JournalEntryItem.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  JournalEntryItem.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  JournalEntryItem.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  JournalEntryItem.InventorySpclStockWBSElement AS InventorySpclStockWBSElement,
  JournalEntryItem.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  JournalEntryItem.InventoryValuationType AS InventoryValuationType,
  JournalEntryItem.ValuationArea AS ValuationArea,
  JournalEntryItem.SenderGLAccount AS SenderGLAccount,
  JournalEntryItem.SenderAccountAssignment AS SenderAccountAssignment,
  JournalEntryItem.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  JournalEntryItem.ControllingObject AS ControllingObject,
  JournalEntryItem.CostOriginGroup AS CostOriginGroup,
  JournalEntryItem.OriginSenderObject AS OriginSenderObject,
  JournalEntryItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  JournalEntryItem.ControllingObjectDebitType AS ControllingObjectDebitType,
  JournalEntryItem.QuantityIsIncomplete AS QuantityIsIncomplete,
  JournalEntryItem.OffsettingAccount AS OffsettingAccount,
  JournalEntryItem.OffsettingAccountType AS OffsettingAccountType,
  JournalEntryItem.LineItemIsCompleted AS LineItemIsCompleted,
  JournalEntryItem.PersonnelNumber AS PersonnelNumber,
  JournalEntryItem.ControllingObjectClass AS ControllingObjectClass,
  JournalEntryItem.PartnerCompanyCode AS PartnerCompanyCode,
  JournalEntryItem.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  JournalEntryItem.OriginCostCenter AS OriginCostCenter,
  JournalEntryItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  JournalEntryItem.OriginProfitCenter AS OriginProfitCenter,
  JournalEntryItem.AccountAssignment AS AccountAssignment,
  JournalEntryItem.AccountAssignmentType AS AccountAssignmentType,
  JournalEntryItem.CostCtrActivityType AS CostCtrActivityType,
  JournalEntryItem.OrderID AS OrderID,
  JournalEntryItem.OrderCategory AS OrderCategory,
  JournalEntryItem.WBSElementInternalID AS WBSElementInternalID,
  JournalEntryItem.WBSElement AS WBSElement,
  JournalEntryItem.ProjectInternalID AS ProjectInternalID,
  JournalEntryItem.Project AS Project,
  JournalEntryItem.ProjectNetwork AS ProjectNetwork,
  JournalEntryItem.RelatedNetworkActivity AS RelatedNetworkActivity,
  JournalEntryItem.BusinessProcess AS BusinessProcess,
  JournalEntryItem.CostObject AS CostObject,
  JournalEntryItem.BillableControl AS BillableControl,
  JournalEntryItem.CostAnalysisResource AS CostAnalysisResource,
  JournalEntryItem.CustomerServiceNotification AS CustomerServiceNotification,
  JournalEntryItem.ServiceDocumentType AS ServiceDocumentType,
  JournalEntryItem.ServiceDocument AS ServiceDocument,
  JournalEntryItem.ServiceDocumentItem AS ServiceDocumentItem,
  JournalEntryItem.ServiceContractType AS ServiceContractType,
  JournalEntryItem.ServiceContract AS ServiceContract,
  JournalEntryItem.ServiceContractItem AS ServiceContractItem,
  JournalEntryItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  JournalEntryItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  JournalEntryItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  JournalEntryItem.WorkPackage AS WorkPackage,
  JournalEntryItem.WorkItem AS WorkItem,
  JournalEntryItem.OperatingConcern AS OperatingConcern,
  JournalEntryItem.PartnerAccountAssignment AS PartnerAccountAssignment,
  JournalEntryItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  JournalEntryItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  JournalEntryItem.PartnerOrder AS PartnerOrder,
  JournalEntryItem.PartnerOrderCategory AS PartnerOrderCategory,
  JournalEntryItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  JournalEntryItem.PartnerWBSElement AS PartnerWBSElement,
  JournalEntryItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  JournalEntryItem.PartnerProject AS PartnerProject,
  JournalEntryItem.PartnerSalesDocument AS PartnerSalesDocument,
  JournalEntryItem.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  JournalEntryItem.PartnerProjectNetwork AS PartnerProjectNetwork,
  JournalEntryItem.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  JournalEntryItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  JournalEntryItem.PartnerCostObject AS PartnerCostObject,
  JournalEntryItem.BillingDocumentType AS BillingDocumentType,
  JournalEntryItem.SalesOrganization AS SalesOrganization,
  JournalEntryItem.DistributionChannel AS DistributionChannel,
  JournalEntryItem.OrganizationDivision AS OrganizationDivision,
  JournalEntryItem.SoldProduct AS SoldProduct,
  JournalEntryItem.SoldProductGroup AS SoldProductGroup,
  JournalEntryItem.CustomerGroup AS CustomerGroup,
  JournalEntryItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  JournalEntryItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  JournalEntryItem.SalesDistrict AS SalesDistrict,
  JournalEntryItem.BillToParty AS BillToParty,
  JournalEntryItem.ShipToParty AS ShipToParty,
  JournalEntryItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  JournalEntryItem.FinancialManagementArea AS FinancialManagementArea,
  JournalEntryItem.FundsCenter AS FundsCenter,
  JournalEntryItem.FundedProgram AS FundedProgram,
  JournalEntryItem.Fund AS Fund,
  JournalEntryItem.GrantID AS GrantID,
  JournalEntryItem.BudgetPeriod AS BudgetPeriod,
  JournalEntryItem.PartnerFund AS PartnerFund,
  JournalEntryItem.PartnerGrant AS PartnerGrant,
  JournalEntryItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  JournalEntryItem.JointVenture AS JointVenture,
  JournalEntryItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  JournalEntryItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  JournalEntryItem.JointVenturePartner AS JointVenturePartner,
  JournalEntryItem.JointVentureBillingType AS JointVentureBillingType,
  JournalEntryItem.JointVentureEquityType AS JointVentureEquityType,
  JournalEntryItem.JointVentureProductionDate AS JointVentureProductionDate,
  JournalEntryItem.JointVentureBillingDate AS JointVentureBillingDate,
  JournalEntryItem.JointVentureOperationalDate AS JointVentureOperationalDate,
  JournalEntryItem.CutbackRun AS CutbackRun,
  JournalEntryItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  cast( JournalEntryItem.PartnerVenture as fco_alloc_run_partner_venture preserving type ) AS PartnerVenture,
  JournalEntryItem.PartnerEquityGroup AS PartnerEquityGroup,
  JournalEntryItem.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  JournalEntryItem.CutbackAccount AS CutbackAccount,
  JournalEntryItem.CutbackCostObject AS CutbackCostObject,
  JournalEntryItem.SettlementReferenceDate AS SettlementReferenceDate,
  JournalEntryItem.ControllingBusTransacType AS ControllingBusTransacType,
  JournalEntryItem.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  JournalEntryItem.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  JournalEntryItem.PredecessorJournalEntry AS PredecessorJournalEntry,
  JournalEntryItem.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  JournalEntryItem.OrganizationalChange AS OrganizationalChange,
  JournalEntryItem.GrantCurrency AS GrantCurrency,
  JournalEntryItem.AmountInGrantCurrency AS AmountInGrantCurrency,
  JournalEntryItem.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  JournalEntryItem.ReferenceQuantity AS ReferenceQuantity,
  JournalEntryItem.LastChangeDateTime AS LastChangeDateTime,
  JournalEntryItem.SalesDocument AS SalesDocument,
  JournalEntryItem.Product AS Product,
  JournalEntryItem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  JournalEntryItem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  JournalEntryItem.TaxCountry AS TaxCountry,
  JournalEntryItem.ValueDate AS ValueDate,
  JournalEntryItem.SenderCompanyCode AS SenderCompanyCode,
  JournalEntryItem.OriginCtrlgDebitCreditCode AS OriginCtrlgDebitCreditCode,
  JournalEntryItem.OriginProduct AS OriginProduct,
  JournalEntryItem.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  JournalEntryItem.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  JournalEntryItem.PartnerServiceDocument AS PartnerServiceDocument,
  JournalEntryItem.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  JournalEntryItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  JournalEntryItem.CashLedgerAccount AS CashLedgerAccount,
  JournalEntryItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  JournalEntryItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  JournalEntryItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  JournalEntryItem.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  JournalEntryItem.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  JournalEntryItem.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  JournalEntryItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  JournalEntryItem.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  JournalEntryItem.SponsoredProgram AS SponsoredProgram,
  JournalEntryItem.SponsoredClass AS SponsoredClass,
  JournalEntryItem.REBusinessEntity AS REBusinessEntity,
  JournalEntryItem.RealEstateBuilding AS RealEstateBuilding,
  JournalEntryItem.RealEstateProperty AS RealEstateProperty,
  JournalEntryItem.RERentalObject AS RERentalObject,
  JournalEntryItem.RealEstateContract AS RealEstateContract,
  JournalEntryItem.REServiceChargeKey AS REServiceChargeKey,
  JournalEntryItem.RESettlementUnitID AS RESettlementUnitID,
  JournalEntryItem.REPartnerBusinessEntity AS REPartnerBusinessEntity,
  JournalEntryItem.RealEstatePartnerBuilding AS RealEstatePartnerBuilding,
  JournalEntryItem.RealEstatePartnerProperty AS RealEstatePartnerProperty,
  JournalEntryItem.REPartnerRentalObject AS REPartnerRentalObject,
  JournalEntryItem.RealEstatePartnerContract AS RealEstatePartnerContract,
  JournalEntryItem.REPartnerServiceChargeKey AS REPartnerServiceChargeKey,
  JournalEntryItem.REPartnerSettlementUnitID AS REPartnerSettlementUnitID,
  JournalEntryItem.PartnerSettlementReferenceDate AS PartnerSettlementReferenceDate,
  JournalEntryItem.FunctionalCurrency AS FunctionalCurrency,
  JournalEntryItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  Document.AllocationRunStartDateTime AS AllocationRunStartDateTime
FROM P_AllocRunJournalEntryItem AS Document
INNER JOIN I_GLAccountLineItemRawData AS JournalEntryItem ON /* join condition not captured in parsed metadata */
;

Learn More