P_MANAGEJOURNALENTRYLEDGERVIEW
P_MANAGEJOURNALENTRYLEDGERVIEW is a CDS View in S/4HANA. It contains 370 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_FAC_MJE_ITEM_UNITED | view_entity | from | COMPOSITE | |
| R_ManageJournalEntryLedgerView | view_entity | from | COMPOSITE | Journal Entry Ledger View |
| R_MngJrnlEntrTechLedgerView | view_entity | from | COMPOSITE | Journal Entry Technical Ledger View |
Fields (370)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 3 |
| KEY | CompanyCode | CompanyCode | 3 |
| KEY | FiscalYear | FiscalYear | 3 |
| KEY | LedgerGLLineItem | LedgerGLLineItem | 3 |
| KEY | SourceLedger | SourceLedger | 3 |
| _AccountingDocumentType | _AccountingDocumentType | 2 | |
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | 2 | |
| _Order | _Order | 2 | |
| _SalesDocument | _SalesDocument | 2 | |
| _ServiceDocument | _ServiceDocument | 2 | |
| AccountAssignment | AccountAssignment | 3 | |
| AccountAssignmentNumber | AccountAssignmentNumber | 3 | |
| AccountAssignmentType | AccountAssignmentType | 3 | |
| AccountingDocCreatedByUser | AccountingDocCreatedByUser | 3 | |
| AccountingDocumentCategory | AccountingDocumentCategory | 3 | |
| AccountingDocumentItem | AccountingDocumentItem | 3 | |
| AccountingDocumentType | AccountingDocumentType | 3 | |
| AccrualItemType | AccrualItemType | 3 | |
| AccrualObject | AccrualObject | 3 | |
| AccrualObjectLogicalSystem | AccrualObjectLogicalSystem | 3 | |
| AccrualObjectType | AccrualObjectType | 3 | |
| AccrualReferenceObject | AccrualReferenceObject | 3 | |
| AccrualSubobject | AccrualSubobject | 3 | |
| AccrualValueDate | AccrualValueDate | 3 | |
| AdditionalQuantity1 | AdditionalQuantity1 | 3 | |
| AdditionalQuantity1Unit | AdditionalQuantity1Unit | 3 | |
| AdditionalQuantity2 | AdditionalQuantity2 | 3 | |
| AdditionalQuantity2Unit | AdditionalQuantity2Unit | 3 | |
| AdditionalQuantity3 | AdditionalQuantity3 | 3 | |
| AdditionalQuantity3Unit | AdditionalQuantity3Unit | 3 | |
| AlternativeGLAccount | AlternativeGLAccount | 3 | |
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | 3 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 3 | |
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | 3 | |
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | 3 | |
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | 3 | |
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | 3 | |
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | 3 | |
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | 3 | |
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | 3 | |
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | 3 | |
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | 3 | |
| AmountInGlobalCurrency | AmountInGlobalCurrency | 3 | |
| AmountInGrantCurrency | AmountInGrantCurrency | 3 | |
| AmountInObjectCurrency | AmountInObjectCurrency | 3 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 3 | |
| AssetAcctTransClassfctn | AssetAcctTransClassfctn | 3 | |
| AssetClass | AssetClass | 3 | |
| AssetDepreciationArea | AssetDepreciationArea | 3 | |
| AssetValueDate | AssetValueDate | 3 | |
| AssignmentReference | AssignmentReference | 3 | |
| BalanceTransactionCurrency | BalanceTransactionCurrency | 3 | |
| BaseUnit | BaseUnit | 3 | |
| BillableControl | BillableControl | 3 | |
| BillingDocumentType | BillingDocumentType | 3 | |
| BillToParty | BillToParty | 3 | |
| BudgetPeriod | BudgetPeriod | 3 | |
| BusinessArea | BusinessArea | 3 | |
| BusinessProcess | BusinessProcess | 3 | |
| BusinessSolutionOrder | BusinessSolutionOrder | 3 | |
| BusinessSolutionOrderItem | BusinessSolutionOrderItem | 3 | |
| BusinessTransactionCategory | BusinessTransactionCategory | 3 | |
| BusinessTransactionType | BusinessTransactionType | 3 | |
| CashLedgerAccount | CashLedgerAccount | 3 | |
| CashLedgerCompanyCode | CashLedgerCompanyCode | 3 | |
| ChartOfAccounts | ChartOfAccounts | 3 | |
| ClearingDate | ClearingDate | 3 | |
| ClearingJournalEntry | ClearingJournalEntry | 3 | |
| ClearingJournalEntryFiscalYear | ClearingJournalEntryFiscalYear | 3 | |
| CnsldtnFinancialStatementItem | CnsldtnFinancialStatementItem | 3 | |
| CnsldtnSubitem | CnsldtnSubitem | 3 | |
| CnsldtnSubitemCategory | CnsldtnSubitemCategory | 3 | |
| CommitmentItem | CommitmentItem | 3 | |
| Company | Company | 3 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 3 | |
| CompBreakdownScaleNumerator | CompBreakdownScaleNumerator | 1 | |
| ComponentBreakdown | ComponentBreakdown | 1 | |
| ConsolidationChartOfAccounts | ConsolidationChartOfAccounts | 3 | |
| ConsolidationUnit | ConsolidationUnit | 3 | |
| ControllingArea | ControllingArea | 3 | |
| ControllingDebitCreditCode | ControllingDebitCreditCode | 3 | |
| ControllingObject | ControllingObject | 3 | |
| ControllingObjectClass | ControllingObjectClass | 3 | |
| ControllingObjectCurrency | ControllingObjectCurrency | 3 | |
| ControllingObjectDebitType | ControllingObjectDebitType | 3 | |
| CostAnalysisResource | CostAnalysisResource | 3 | |
| CostCenter | CostCenter | 3 | |
| CostCtrActivityType | CostCtrActivityType | 3 | |
| CostEstimate | CostEstimate | 3 | |
| CostObject | CostObject | 3 | |
| CostOriginGroup | CostOriginGroup | 3 | |
| CostSourceUnit | CostSourceUnit | 3 | |
| CountryChartOfAccounts | CountryChartOfAccounts | 3 | |
| CreationDate | CreationDate | 3 | |
| CreationDateTime | CreationDateTime | 3 | |
| CreditAmountInBalanceTransCrcy | CreditAmountInBalanceTransCrcy | 3 | |
| CreditAmountInCoCodeCrcy | CreditAmountInCoCodeCrcy | 3 | |
| CreditAmountInFreeDfndCrcy1 | CreditAmountInFreeDfndCrcy1 | 3 | |
| CreditAmountInFreeDfndCrcy2 | CreditAmountInFreeDfndCrcy2 | 3 | |
| CreditAmountInFreeDfndCrcy3 | CreditAmountInFreeDfndCrcy3 | 3 | |
| CreditAmountInFreeDfndCrcy4 | CreditAmountInFreeDfndCrcy4 | 3 | |
| CreditAmountInFreeDfndCrcy5 | CreditAmountInFreeDfndCrcy5 | 3 | |
| CreditAmountInFreeDfndCrcy6 | CreditAmountInFreeDfndCrcy6 | 3 | |
| CreditAmountInFreeDfndCrcy7 | CreditAmountInFreeDfndCrcy7 | 3 | |
| CreditAmountInFreeDfndCrcy8 | CreditAmountInFreeDfndCrcy8 | 3 | |
| CreditAmountInFunctionalCrcy | CreditAmountInFunctionalCrcy | 3 | |
| CreditAmountInGlobalCrcy | CreditAmountInGlobalCrcy | 3 | |
| CreditAmountInTransCrcy | CreditAmountInTransCrcy | 3 | |
| CreditRiskClass | CreditRiskClass | 3 | |
| Customer | Customer | 3 | |
| CustomerGroup | CustomerGroup | 3 | |
| CustomerServiceNotification | CustomerServiceNotification | 3 | |
| CustomerSupplierCorporateGroup | CustomerSupplierCorporateGroup | 3 | |
| CustomerSupplierCountry | CustomerSupplierCountry | 3 | |
| CustomerSupplierIndustry | CustomerSupplierIndustry | 3 | |
| CutbackAccount | CutbackAccount | 3 | |
| CutbackCostObject | CutbackCostObject | 3 | |
| CutbackRun | CutbackRun | 1 | |
| DebitAmountInBalanceTransCrcy | DebitAmountInBalanceTransCrcy | 3 | |
| DebitAmountInCoCodeCrcy | DebitAmountInCoCodeCrcy | 3 | |
| DebitAmountInFreeDfndCrcy1 | DebitAmountInFreeDfndCrcy1 | 3 | |
| DebitAmountInFreeDfndCrcy2 | DebitAmountInFreeDfndCrcy2 | 3 | |
| DebitAmountInFreeDfndCrcy3 | DebitAmountInFreeDfndCrcy3 | 3 | |
| DebitAmountInFreeDfndCrcy4 | DebitAmountInFreeDfndCrcy4 | 3 | |
| DebitAmountInFreeDfndCrcy5 | DebitAmountInFreeDfndCrcy5 | 3 | |
| DebitAmountInFreeDfndCrcy6 | DebitAmountInFreeDfndCrcy6 | 3 | |
| DebitAmountInFreeDfndCrcy7 | DebitAmountInFreeDfndCrcy7 | 3 | |
| DebitAmountInFreeDfndCrcy8 | DebitAmountInFreeDfndCrcy8 | 3 | |
| DebitAmountInFunctionalCrcy | DebitAmountInFunctionalCrcy | 3 | |
| DebitAmountInGlobalCrcy | DebitAmountInGlobalCrcy | 3 | |
| DebitAmountInTransCrcy | DebitAmountInTransCrcy | 3 | |
| DebitCreditCode | DebitCreditCode | 3 | |
| DepreciationFiscalPeriod | DepreciationFiscalPeriod | 3 | |
| DistributionChannel | DistributionChannel | 3 | |
| DocumentDate | DocumentDate | 3 | |
| DocumentItemText | DocumentItemText | 3 | |
| EliminationProfitCenter | EliminationProfitCenter | 3 | |
| ExchangeRateDate | ExchangeRateDate | 3 | |
| FinancialAccountType | FinancialAccountType | 3 | |
| FinancialDataSource | FinancialDataSource | 3 | |
| FinancialManagementArea | FinancialManagementArea | 3 | |
| FinancialServicesBranch | FinancialServicesBranch | 3 | |
| FinancialServicesProductGroup | FinancialServicesProductGroup | 3 | |
| FinancialTransactionType | FinancialTransactionType | 3 | |
| FinancialValuationObject | FinancialValuationObject | 3 | |
| FinancialValuationObjectType | FinancialValuationObjectType | 3 | |
| FinancialValuationSubobject | FinancialValuationSubobject | 3 | |
| FiscalPeriod | FiscalPeriod | 3 | |
| FiscalYearPeriod | FiscalYearPeriod | 3 | |
| FiscalYearVariant | FiscalYearVariant | 3 | |
| FixedAsset | FixedAsset | 3 | |
| FixedQuantity | FixedQuantity | 3 | |
| FollowOnDocumentType | FollowOnDocumentType | 3 | |
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | 3 | |
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | 3 | |
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | 3 | |
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | 3 | |
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | 3 | |
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | 3 | |
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | 3 | |
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | 3 | |
| FunctionalArea | FunctionalArea | 3 | |
| FunctionalCurrency | FunctionalCurrency | 3 | |
| Fund | Fund | 3 | |
| FundedProgram | FundedProgram | 3 | |
| FundsCenter | FundsCenter | 3 | |
| GLAccount | GLAccount | 3 | |
| GLAccountType | GLAccountType | 3 | |
| GLBusinessTransactionType | GLBusinessTransactionType | 3 | |
| GlobalCurrency | GlobalCurrency | 3 | |
| GLRecordType | GLRecordType | 3 | |
| GrantCurrency | GrantCurrency | 3 | |
| GrantID | GrantID | 3 | |
| GroupFixedAsset | GroupFixedAsset | 3 | |
| GroupMasterFixedAsset | GroupMasterFixedAsset | 3 | |
| GteeMBudgetValidityNumber | GteeMBudgetValidityNumber | 3 | |
| HouseBank | HouseBank | 3 | |
| HouseBankAccount | HouseBankAccount | 3 | |
| IncmpltSummableValnFxdQty | IncmpltSummableValnFxdQty | 1 | |
| IncmpltSummableValnQty | IncmpltSummableValnQty | 1 | |
| IncmpltSummableValnQtyUnt | IncmpltSummableValnQtyUnt | 1 | |
| InventorySpclStkSalesDocItm | InventorySpclStkSalesDocItm | 3 | |
| InventorySpclStkSalesDocument | InventorySpclStkSalesDocument | 3 | |
| InventorySpecialStockSupplier | InventorySpecialStockSupplier | 3 | |
| InventorySpecialStockType | InventorySpecialStockType | 3 | |
| InventorySpecialStockValnType | InventorySpecialStockValnType | 3 | |
| InventoryValuationType | InventoryValuationType | 3 | |
| InvoiceItemReference | InvoiceItemReference | 3 | |
| InvoiceReference | InvoiceReference | 3 | |
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | 3 | |
| InvtrySpclStockWBSElmntExtID | InvtrySpclStockWBSElmntExtID | 2 | |
| InvtrySpclStockWBSElmntIntID | InvtrySpclStockWBSElmntIntID | 3 | |
| IsCleared | IsCleared | 3 | |
| IsCommitment | IsCommitment | 3 | |
| IsNegativePosting | IsNegativePosting | 3 | |
| IsOpenItemManaged | IsOpenItemManaged | 3 | |
| IsReversal | IsReversal | 3 | |
| IsReversed | IsReversed | 3 | |
| IsSettled | IsSettled | 3 | |
| IsSettlement | IsSettlement | 3 | |
| IsStatisticalCostCenter | IsStatisticalCostCenter | 3 | |
| IsStatisticalOrder | IsStatisticalOrder | 3 | |
| IsStatisticalSalesDocument | IsStatisticalSalesDocument | 3 | |
| JointVenture | JointVenture | 3 | |
| JointVentureAccountingActivity | JointVentureAccountingActivity | 3 | |
| JointVentureBillingDate | JointVentureBillingDate | 3 | |
| JointVentureBillingType | JointVentureBillingType | 3 | |
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | 3 | |
| JointVentureEquityGroup | JointVentureEquityGroup | 3 | |
| JointVentureEquityType | JointVentureEquityType | 3 | |
| JointVentureOperationalDate | JointVentureOperationalDate | 3 | |
| JointVenturePartner | JointVenturePartner | 3 | |
| JointVentureProductionDate | JointVentureProductionDate | 3 | |
| JrnlEntrAltvFYConsecutiveID | JrnlEntrAltvFYConsecutiveID | 3 | |
| JrnlEntryItemMigrationSource | JrnlEntryItemMigrationSource | 3 | |
| JrnlEntryItemObsoleteReason | JrnlEntryItemObsoleteReason | 3 | |
| Ledger | Ledger | 1 | |
| LedgerFiscalYear | LedgerFiscalYear | 3 | |
| LineItemIsCompleted | LineItemIsCompleted | 3 | |
| LogicalSystem | LogicalSystem | 3 | |
| MasterFixedAsset | MasterFixedAsset | 3 | |
| NetDueDate | NetDueDate | 3 | |
| OffsettingAccount | OffsettingAccount | 3 | |
| OffsettingAccountType | OffsettingAccountType | 3 | |
| OffsettingChartOfAccounts | OffsettingChartOfAccounts | 3 | |
| OperatingConcern | OperatingConcern | 3 | |
| OrderCategory | OrderCategory | 3 | |
| OrderID | OrderID | 3 | |
| OrderOperation | OrderOperation | 3 | |
| OrganizationDivision | OrganizationDivision | 3 | |
| OriginCostCenter | OriginCostCenter | 3 | |
| OriginCostCtrActivityType | OriginCostCtrActivityType | 3 | |
| OriginObjectType | OriginObjectType | 3 | |
| OriginProduct | OriginProduct | 3 | |
| OriginProfitCenter | OriginProfitCenter | 3 | |
| OriginSenderObject | OriginSenderObject | 3 | |
| PartnerAccountAssignment | PartnerAccountAssignment | 3 | |
| PartnerAccountAssignmentType | PartnerAccountAssignmentType | 3 | |
| PartnerBudgetPeriod | PartnerBudgetPeriod | 3 | |
| PartnerBusinessArea | PartnerBusinessArea | 3 | |
| PartnerBusinessProcess | PartnerBusinessProcess | 3 | |
| PartnerCompany | PartnerCompany | 3 | |
| PartnerCompanyCode | PartnerCompanyCode | 3 | |
| PartnerConsolidationUnit | PartnerConsolidationUnit | 3 | |
| PartnerControllingObjectClass | PartnerControllingObjectClass | 3 | |
| PartnerCostCenter | PartnerCostCenter | 3 | |
| PartnerCostCtrActivityType | PartnerCostCtrActivityType | 3 | |
| PartnerCostObject | PartnerCostObject | 3 | |
| PartnerEquityGroup | PartnerEquityGroup | 3 | |
| PartnerFixedAsset | PartnerFixedAsset | 2 | |
| PartnerFunctionalArea | PartnerFunctionalArea | 3 | |
| PartnerFund | PartnerFund | 3 | |
| PartnerGrant | PartnerGrant | 3 | |
| PartnerMasterFixedAsset | PartnerMasterFixedAsset | 2 | |
| PartnerOrder | PartnerOrder | 3 | |
| PartnerOrderCategory | PartnerOrderCategory | 3 | |
| PartnerProfitCenter | PartnerProfitCenter | 3 | |
| PartnerProjectExternalID | PartnerProjectExternalID | 2 | |
| PartnerProjectInternalID | PartnerProjectInternalID | 3 | |
| PartnerProjectNetwork | PartnerProjectNetwork | 3 | |
| PartnerProjectNetworkActivity | PartnerProjectNetworkActivity | 3 | |
| PartnerSalesDocument | PartnerSalesDocument | 3 | |
| PartnerSalesDocumentItem | PartnerSalesDocumentItem | 3 | |
| PartnerSegment | PartnerSegment | 3 | |
| PartnerServiceDocument | PartnerServiceDocument | 3 | |
| PartnerServiceDocumentItem | PartnerServiceDocumentItem | 3 | |
| PartnerServiceDocumentType | PartnerServiceDocumentType | 3 | |
| PartnerVenture | PartnerVenture | 3 | |
| PartnerWBSElementExternalID | PartnerWBSElementExternalID | 2 | |
| PartnerWBSElementInternalID | PartnerWBSElementInternalID | 3 | |
| PerformanceObligation | PerformanceObligation | 1 | |
| PerformancePeriodEndDate | PerformancePeriodEndDate | 3 | |
| PerformancePeriodStartDate | PerformancePeriodStartDate | 3 | |
| PersonnelNumber | PersonnelNumber | 3 | |
| Plant | Plant | 3 | |
| PostingDate | PostingDate | 3 | |
| PostingKey | PostingKey | 3 | |
| PrdcssrJournalEntryCompanyCode | PrdcssrJournalEntryCompanyCode | 1 | |
| PrdcssrJournalEntryFiscalYear | PrdcssrJournalEntryFiscalYear | 1 | |
| PredecessorJournalEntry | PredecessorJournalEntry | 1 | |
| PredecessorJournalEntryItem | PredecessorJournalEntryItem | 1 | |
| PredecessorReferenceDocCntxt | PredecessorReferenceDocCntxt | 3 | |
| PredecessorReferenceDocItem | PredecessorReferenceDocItem | 3 | |
| PredecessorReferenceDocType | PredecessorReferenceDocType | 3 | |
| PredecessorReferenceDocument | PredecessorReferenceDocument | 3 | |
| Product | Product | 3 | |
| ProductGroup | ProductGroup | 3 | |
| ProductPriceControl | ProductPriceControl | 3 | |
| ProfitabilitySegment | ProfitabilitySegment | 2 | |
| ProfitCenter | ProfitCenter | 3 | |
| ProjectExternalID | ProjectExternalID | 2 | |
| ProjectInternalID | ProjectInternalID | 3 | |
| ProjectNetwork | ProjectNetwork | 3 | |
| ProviderContract | ProviderContract | 3 | |
| ProviderContractItem | ProviderContractItem | 3 | |
| PubSecBudgetAccount | PubSecBudgetAccount | 3 | |
| PubSecBudgetAccountCoCode | PubSecBudgetAccountCoCode | 3 | |
| PubSecBudgetCnsmpnAmtType | PubSecBudgetCnsmpnAmtType | 3 | |
| PubSecBudgetCnsmpnDate | PubSecBudgetCnsmpnDate | 3 | |
| PubSecBudgetCnsmpnFsclPeriod | PubSecBudgetCnsmpnFsclPeriod | 3 | |
| PubSecBudgetCnsmpnFsclYear | PubSecBudgetCnsmpnFsclYear | 3 | |
| PubSecBudgetCnsmpnType | PubSecBudgetCnsmpnType | 3 | |
| PubSecBudgetIsRelevant | PubSecBudgetIsRelevant | 3 | |
| PurchasingDocument | PurchasingDocument | 3 | |
| PurchasingDocumentItem | PurchasingDocumentItem | 3 | |
| Quantity | Quantity | 3 | |
| QuantityIsIncomplete | QuantityIsIncomplete | 3 | |
| RealEstateBuilding | RealEstateBuilding | 3 | |
| RealEstateContract | RealEstateContract | 3 | |
| RealEstateProperty | RealEstateProperty | 3 | |
| REBusinessEntity | REBusinessEntity | 3 | |
| ReferenceDocument | ReferenceDocument | 3 | |
| ReferenceDocumentContext | ReferenceDocumentContext | 3 | |
| ReferenceDocumentItem | ReferenceDocumentItem | 3 | |
| ReferenceDocumentItemGroup | ReferenceDocumentItemGroup | 3 | |
| ReferenceDocumentType | ReferenceDocumentType | 3 | |
| ReferencePurchaseOrderCategory | ReferencePurchaseOrderCategory | 3 | |
| RelatedNetworkActivity | RelatedNetworkActivity | 3 | |
| RERentalObject | RERentalObject | 3 | |
| REServiceChargeKey | REServiceChargeKey | 3 | |
| RESettlementUnitID | RESettlementUnitID | 3 | |
| RevenueAccountingContract | RevenueAccountingContract | 1 | |
| ReversalReferenceDocument | ReversalReferenceDocument | 3 | |
| ReversalReferenceDocumentCntxt | ReversalReferenceDocumentCntxt | 3 | |
| SalesDistrict | SalesDistrict | 3 | |
| SalesDocument | SalesDocument | 3 | |
| SalesDocumentItem | SalesDocumentItem | 3 | |
| SalesOrganization | SalesOrganization | 3 | |
| Segment | Segment | 3 | |
| SenderAccountAssignment | SenderAccountAssignment | 3 | |
| SenderAccountAssignmentType | SenderAccountAssignmentType | 3 | |
| SenderCostRecoveryCode | SenderCostRecoveryCode | 3 | |
| SenderGLAccount | SenderGLAccount | 3 | |
| ServiceContract | ServiceContract | 3 | |
| ServiceContractItem | ServiceContractItem | 3 | |
| ServiceContractType | ServiceContractType | 3 | |
| ServiceDocument | ServiceDocument | 3 | |
| ServiceDocumentItem | ServiceDocumentItem | 3 | |
| ServiceDocumentType | ServiceDocumentType | 3 | |
| ServicesRenderedDate | ServicesRenderedDate | 3 | |
| SettlementReferenceDate | SettlementReferenceDate | 3 | |
| ShipToParty | ShipToParty | 3 | |
| SoldProduct | SoldProduct | 3 | |
| SoldProductGroup | SoldProductGroup | 3 | |
| SourceLogicalSystem | SourceLogicalSystem | 3 | |
| SourceReferenceDocSubitem | SourceReferenceDocSubitem | 3 | |
| SourceReferenceDocument | SourceReferenceDocument | 3 | |
| SourceReferenceDocumentCntxt | SourceReferenceDocumentCntxt | 3 | |
| SourceReferenceDocumentItem | SourceReferenceDocumentItem | 3 | |
| SourceReferenceDocumentType | SourceReferenceDocumentType | 3 | |
| SpecialGLCode | SpecialGLCode | 3 | |
| SponsoredClass | SponsoredClass | 3 | |
| SponsoredProgram | SponsoredProgram | 3 | |
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | 3 | |
| Supplier | Supplier | 3 | |
| TaxCode | TaxCode | 3 | |
| TaxCountry | TaxCountry | 3 | |
| TimeSheetOvertimeCategory | TimeSheetOvertimeCategory | 3 | |
| TransactionCurrency | TransactionCurrency | 3 | |
| TransactionTypeDetermination | TransactionTypeDetermination | 3 | |
| ValuationArea | ValuationArea | 3 | |
| ValuationFixedQuantity | ValuationFixedQuantity | 3 | |
| ValuationQuantity | ValuationQuantity | 3 | |
| ValueDate | ValueDate | 3 | |
| VarianceOriginGLAccount | VarianceOriginGLAccount | 3 | |
| WBSElementExternalID | WBSElementExternalID | 2 | |
| WBSElementInternalID | WBSElementInternalID | 3 | |
| WBSIsStatisticalWBSElement | WBSIsStatisticalWBSElement | 3 | |
| WorkItem | WorkItem | 3 | |
| WorkPackage | WorkPackage | 3 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MANAGEJOURNALENTRYLEDGERVIEW (
ACCOUNTINGDOCUMENT,
COMPANYCODE,
FISCALYEAR,
LEDGERGLLINEITEM,
SOURCELEDGER,
_ACCOUNTINGDOCUMENTTYPE,
_GLACCOUNTINCOMPANYCODE,
_ORDER,
_SALESDOCUMENT,
_SERVICEDOCUMENT,
ACCOUNTASSIGNMENT,
ACCOUNTASSIGNMENTNUMBER,
ACCOUNTASSIGNMENTTYPE,
ACCOUNTINGDOCCREATEDBYUSER,
ACCOUNTINGDOCUMENTCATEGORY,
ACCOUNTINGDOCUMENTITEM,
ACCOUNTINGDOCUMENTTYPE,
ACCRUALITEMTYPE,
ACCRUALOBJECT,
ACCRUALOBJECTLOGICALSYSTEM,
ACCRUALOBJECTTYPE,
ACCRUALREFERENCEOBJECT,
ACCRUALSUBOBJECT,
ACCRUALVALUEDATE,
ADDITIONALQUANTITY1,
ADDITIONALQUANTITY1UNIT,
ADDITIONALQUANTITY2,
ADDITIONALQUANTITY2UNIT,
ADDITIONALQUANTITY3,
ADDITIONALQUANTITY3UNIT,
ALTERNATIVEGLACCOUNT,
AMOUNTINBALANCETRANSACCRCY,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINFREEDEFINEDCURRENCY1,
AMOUNTINFREEDEFINEDCURRENCY2,
AMOUNTINFREEDEFINEDCURRENCY3,
AMOUNTINFREEDEFINEDCURRENCY4,
AMOUNTINFREEDEFINEDCURRENCY5,
AMOUNTINFREEDEFINEDCURRENCY6,
AMOUNTINFREEDEFINEDCURRENCY7,
AMOUNTINFREEDEFINEDCURRENCY8,
AMOUNTINFUNCTIONALCURRENCY,
AMOUNTINGLOBALCURRENCY,
AMOUNTINGRANTCURRENCY,
AMOUNTINOBJECTCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
ASSETACCTTRANSCLASSFCTN,
ASSETCLASS,
ASSETDEPRECIATIONAREA,
ASSETVALUEDATE,
ASSIGNMENTREFERENCE,
BALANCETRANSACTIONCURRENCY,
BASEUNIT,
BILLABLECONTROL,
BILLINGDOCUMENTTYPE,
BILLTOPARTY,
BUDGETPERIOD,
BUSINESSAREA,
BUSINESSPROCESS,
BUSINESSSOLUTIONORDER,
BUSINESSSOLUTIONORDERITEM,
BUSINESSTRANSACTIONCATEGORY,
BUSINESSTRANSACTIONTYPE,
CASHLEDGERACCOUNT,
CASHLEDGERCOMPANYCODE,
CHARTOFACCOUNTS,
CLEARINGDATE,
CLEARINGJOURNALENTRY,
CLEARINGJOURNALENTRYFISCALYEAR,
CNSLDTNFINANCIALSTATEMENTITEM,
CNSLDTNSUBITEM,
CNSLDTNSUBITEMCATEGORY,
COMMITMENTITEM,
COMPANY,
COMPANYCODECURRENCY,
COMPBREAKDOWNSCALENUMERATOR,
COMPONENTBREAKDOWN,
CONSOLIDATIONCHARTOFACCOUNTS,
CONSOLIDATIONUNIT,
CONTROLLINGAREA,
CONTROLLINGDEBITCREDITCODE,
CONTROLLINGOBJECT,
CONTROLLINGOBJECTCLASS,
CONTROLLINGOBJECTCURRENCY,
CONTROLLINGOBJECTDEBITTYPE,
COSTANALYSISRESOURCE,
COSTCENTER,
COSTCTRACTIVITYTYPE,
COSTESTIMATE,
COSTOBJECT,
COSTORIGINGROUP,
COSTSOURCEUNIT,
COUNTRYCHARTOFACCOUNTS,
CREATIONDATE,
CREATIONDATETIME,
CREDITAMOUNTINBALANCETRANSCRCY,
CREDITAMOUNTINCOCODECRCY,
CREDITAMOUNTINFREEDFNDCRCY1,
CREDITAMOUNTINFREEDFNDCRCY2,
CREDITAMOUNTINFREEDFNDCRCY3,
CREDITAMOUNTINFREEDFNDCRCY4,
CREDITAMOUNTINFREEDFNDCRCY5,
CREDITAMOUNTINFREEDFNDCRCY6,
CREDITAMOUNTINFREEDFNDCRCY7,
CREDITAMOUNTINFREEDFNDCRCY8,
CREDITAMOUNTINFUNCTIONALCRCY,
CREDITAMOUNTINGLOBALCRCY,
CREDITAMOUNTINTRANSCRCY,
CREDITRISKCLASS,
CUSTOMER,
CUSTOMERGROUP,
CUSTOMERSERVICENOTIFICATION,
CUSTOMERSUPPLIERCORPORATEGROUP,
CUSTOMERSUPPLIERCOUNTRY,
CUSTOMERSUPPLIERINDUSTRY,
CUTBACKACCOUNT,
CUTBACKCOSTOBJECT,
CUTBACKRUN,
DEBITAMOUNTINBALANCETRANSCRCY,
DEBITAMOUNTINCOCODECRCY,
DEBITAMOUNTINFREEDFNDCRCY1,
DEBITAMOUNTINFREEDFNDCRCY2,
DEBITAMOUNTINFREEDFNDCRCY3,
DEBITAMOUNTINFREEDFNDCRCY4,
DEBITAMOUNTINFREEDFNDCRCY5,
DEBITAMOUNTINFREEDFNDCRCY6,
DEBITAMOUNTINFREEDFNDCRCY7,
DEBITAMOUNTINFREEDFNDCRCY8,
DEBITAMOUNTINFUNCTIONALCRCY,
DEBITAMOUNTINGLOBALCRCY,
DEBITAMOUNTINTRANSCRCY,
DEBITCREDITCODE,
DEPRECIATIONFISCALPERIOD,
DISTRIBUTIONCHANNEL,
DOCUMENTDATE,
DOCUMENTITEMTEXT,
ELIMINATIONPROFITCENTER,
EXCHANGERATEDATE,
FINANCIALACCOUNTTYPE,
FINANCIALDATASOURCE,
FINANCIALMANAGEMENTAREA,
FINANCIALSERVICESBRANCH,
FINANCIALSERVICESPRODUCTGROUP,
FINANCIALTRANSACTIONTYPE,
FINANCIALVALUATIONOBJECT,
FINANCIALVALUATIONOBJECTTYPE,
FINANCIALVALUATIONSUBOBJECT,
FISCALPERIOD,
FISCALYEARPERIOD,
FISCALYEARVARIANT,
FIXEDASSET,
FIXEDQUANTITY,
FOLLOWONDOCUMENTTYPE,
FREEDEFINEDCURRENCY1,
FREEDEFINEDCURRENCY2,
FREEDEFINEDCURRENCY3,
FREEDEFINEDCURRENCY4,
FREEDEFINEDCURRENCY5,
FREEDEFINEDCURRENCY6,
FREEDEFINEDCURRENCY7,
FREEDEFINEDCURRENCY8,
FUNCTIONALAREA,
FUNCTIONALCURRENCY,
FUND,
FUNDEDPROGRAM,
FUNDSCENTER,
GLACCOUNT,
GLACCOUNTTYPE,
GLBUSINESSTRANSACTIONTYPE,
GLOBALCURRENCY,
GLRECORDTYPE,
GRANTCURRENCY,
GRANTID,
GROUPFIXEDASSET,
GROUPMASTERFIXEDASSET,
GTEEMBUDGETVALIDITYNUMBER,
HOUSEBANK,
HOUSEBANKACCOUNT,
INCMPLTSUMMABLEVALNFXDQTY,
INCMPLTSUMMABLEVALNQTY,
INCMPLTSUMMABLEVALNQTYUNT,
INVENTORYSPCLSTKSALESDOCITM,
INVENTORYSPCLSTKSALESDOCUMENT,
INVENTORYSPECIALSTOCKSUPPLIER,
INVENTORYSPECIALSTOCKTYPE,
INVENTORYSPECIALSTOCKVALNTYPE,
INVENTORYVALUATIONTYPE,
INVOICEITEMREFERENCE,
INVOICEREFERENCE,
INVOICEREFERENCEFISCALYEAR,
INVTRYSPCLSTOCKWBSELMNTEXTID,
INVTRYSPCLSTOCKWBSELMNTINTID,
ISCLEARED,
ISCOMMITMENT,
ISNEGATIVEPOSTING,
ISOPENITEMMANAGED,
ISREVERSAL,
ISREVERSED,
ISSETTLED,
ISSETTLEMENT,
ISSTATISTICALCOSTCENTER,
ISSTATISTICALORDER,
ISSTATISTICALSALESDOCUMENT,
JOINTVENTURE,
JOINTVENTUREACCOUNTINGACTIVITY,
JOINTVENTUREBILLINGDATE,
JOINTVENTUREBILLINGTYPE,
JOINTVENTURECOSTRECOVERYCODE,
JOINTVENTUREEQUITYGROUP,
JOINTVENTUREEQUITYTYPE,
JOINTVENTUREOPERATIONALDATE,
JOINTVENTUREPARTNER,
JOINTVENTUREPRODUCTIONDATE,
JRNLENTRALTVFYCONSECUTIVEID,
JRNLENTRYITEMMIGRATIONSOURCE,
JRNLENTRYITEMOBSOLETEREASON,
LEDGER,
LEDGERFISCALYEAR,
LINEITEMISCOMPLETED,
LOGICALSYSTEM,
MASTERFIXEDASSET,
NETDUEDATE,
OFFSETTINGACCOUNT,
OFFSETTINGACCOUNTTYPE,
OFFSETTINGCHARTOFACCOUNTS,
OPERATINGCONCERN,
ORDERCATEGORY,
ORDERID,
ORDEROPERATION,
ORGANIZATIONDIVISION,
ORIGINCOSTCENTER,
ORIGINCOSTCTRACTIVITYTYPE,
ORIGINOBJECTTYPE,
ORIGINPRODUCT,
ORIGINPROFITCENTER,
ORIGINSENDEROBJECT,
PARTNERACCOUNTASSIGNMENT,
PARTNERACCOUNTASSIGNMENTTYPE,
PARTNERBUDGETPERIOD,
PARTNERBUSINESSAREA,
PARTNERBUSINESSPROCESS,
PARTNERCOMPANY,
PARTNERCOMPANYCODE,
PARTNERCONSOLIDATIONUNIT,
PARTNERCONTROLLINGOBJECTCLASS,
PARTNERCOSTCENTER,
PARTNERCOSTCTRACTIVITYTYPE,
PARTNERCOSTOBJECT,
PARTNEREQUITYGROUP,
PARTNERFIXEDASSET,
PARTNERFUNCTIONALAREA,
PARTNERFUND,
PARTNERGRANT,
PARTNERMASTERFIXEDASSET,
PARTNERORDER,
PARTNERORDERCATEGORY,
PARTNERPROFITCENTER,
PARTNERPROJECTEXTERNALID,
PARTNERPROJECTINTERNALID,
PARTNERPROJECTNETWORK,
PARTNERPROJECTNETWORKACTIVITY,
PARTNERSALESDOCUMENT,
PARTNERSALESDOCUMENTITEM,
PARTNERSEGMENT,
PARTNERSERVICEDOCUMENT,
PARTNERSERVICEDOCUMENTITEM,
PARTNERSERVICEDOCUMENTTYPE,
PARTNERVENTURE,
PARTNERWBSELEMENTEXTERNALID,
PARTNERWBSELEMENTINTERNALID,
PERFORMANCEOBLIGATION,
PERFORMANCEPERIODENDDATE,
PERFORMANCEPERIODSTARTDATE,
PERSONNELNUMBER,
PLANT,
POSTINGDATE,
POSTINGKEY,
PRDCSSRJOURNALENTRYCOMPANYCODE,
PRDCSSRJOURNALENTRYFISCALYEAR,
PREDECESSORJOURNALENTRY,
PREDECESSORJOURNALENTRYITEM,
PREDECESSORREFERENCEDOCCNTXT,
PREDECESSORREFERENCEDOCITEM,
PREDECESSORREFERENCEDOCTYPE,
PREDECESSORREFERENCEDOCUMENT,
PRODUCT,
PRODUCTGROUP,
PRODUCTPRICECONTROL,
PROFITABILITYSEGMENT,
PROFITCENTER,
PROJECTEXTERNALID,
PROJECTINTERNALID,
PROJECTNETWORK,
PROVIDERCONTRACT,
PROVIDERCONTRACTITEM,
PUBSECBUDGETACCOUNT,
PUBSECBUDGETACCOUNTCOCODE,
PUBSECBUDGETCNSMPNAMTTYPE,
PUBSECBUDGETCNSMPNDATE,
PUBSECBUDGETCNSMPNFSCLPERIOD,
PUBSECBUDGETCNSMPNFSCLYEAR,
PUBSECBUDGETCNSMPNTYPE,
PUBSECBUDGETISRELEVANT,
PURCHASINGDOCUMENT,
PURCHASINGDOCUMENTITEM,
QUANTITY,
QUANTITYISINCOMPLETE,
REALESTATEBUILDING,
REALESTATECONTRACT,
REALESTATEPROPERTY,
REBUSINESSENTITY,
REFERENCEDOCUMENT,
REFERENCEDOCUMENTCONTEXT,
REFERENCEDOCUMENTITEM,
REFERENCEDOCUMENTITEMGROUP,
REFERENCEDOCUMENTTYPE,
REFERENCEPURCHASEORDERCATEGORY,
RELATEDNETWORKACTIVITY,
RERENTALOBJECT,
RESERVICECHARGEKEY,
RESETTLEMENTUNITID,
REVENUEACCOUNTINGCONTRACT,
REVERSALREFERENCEDOCUMENT,
REVERSALREFERENCEDOCUMENTCNTXT,
SALESDISTRICT,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESORGANIZATION,
SEGMENT,
SENDERACCOUNTASSIGNMENT,
SENDERACCOUNTASSIGNMENTTYPE,
SENDERCOSTRECOVERYCODE,
SENDERGLACCOUNT,
SERVICECONTRACT,
SERVICECONTRACTITEM,
SERVICECONTRACTTYPE,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
SERVICESRENDEREDDATE,
SETTLEMENTREFERENCEDATE,
SHIPTOPARTY,
SOLDPRODUCT,
SOLDPRODUCTGROUP,
SOURCELOGICALSYSTEM,
SOURCEREFERENCEDOCSUBITEM,
SOURCEREFERENCEDOCUMENT,
SOURCEREFERENCEDOCUMENTCNTXT,
SOURCEREFERENCEDOCUMENTITEM,
SOURCEREFERENCEDOCUMENTTYPE,
SPECIALGLCODE,
SPONSOREDCLASS,
SPONSOREDPROGRAM,
SUBLEDGERACCTLINEITEMTYPE,
SUPPLIER,
TAXCODE,
TAXCOUNTRY,
TIMESHEETOVERTIMECATEGORY,
TRANSACTIONCURRENCY,
TRANSACTIONTYPEDETERMINATION,
VALUATIONAREA,
VALUATIONFIXEDQUANTITY,
VALUATIONQUANTITY,
VALUEDATE,
VARIANCEORIGINGLACCOUNT,
WBSELEMENTEXTERNALID,
WBSELEMENTINTERNALID,
WBSISSTATISTICALWBSELEMENT,
WORKITEM,
WORKPACKAGE,
PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGERGLLINEITEM, SOURCELEDGER)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA