R_MANAGEJOURNALENTRYLEDGERVIEW
Journal Entry Ledger View
R_MANAGEJOURNALENTRYLEDGERVIEW is a CDS View in S/4HANA. Journal Entry Ledger View. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ManageJournalEntryLedgerView | view_entity | from | CONSUMPTION | Journal Entry Item with Ledger |
| C_MngJournalEntryTotalAmount | view_entity | from | CONSUMPTION | Journal Entry Total Amount |
| C_MngJrnlEntrPrdtnLedgerView | view_entity | from | CONSUMPTION | Predictive Journal Entry Item |
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Journal Entry Ledger View'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #XXL,
dataClass: #MIXED
}
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type:#SAP_INTERNAL_API
}
define view entity R_ManageJournalEntryLedgerView
as select from P_ManageJournalEntryLedgerView as _Item
association [1..1] to R_ManageJournalEntryItem as _BSEGItem on $projection.CompanyCode = _BSEGItem.CompanyCode
and $projection.FiscalYear = _BSEGItem.FiscalYear
and $projection.AccountingDocument = _BSEGItem.AccountingDocument
and $projection.AccountingDocumentItem = _BSEGItem.AccountingDocumentItem
association [1..1] to E_JournalEntryItem as _Extension on $projection.SourceLedger = _Extension.SourceLedger
and $projection.CompanyCode = _Extension.CompanyCode
and $projection.FiscalYear = _Extension.FiscalYear
and $projection.AccountingDocument = _Extension.AccountingDocument
and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem
association [1..1] to I_Ledger as _Ledger on $projection.SourceLedger = _Ledger.Ledger
association [1..1] to I_LedgerText as _LedgerText on $projection.SourceLedger = _LedgerText.Ledger
and _LedgerText.Language = $session.system_language
association [1..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [1..1] to I_CompanyCode as _PartnerCompanyCode on $projection.PartnerCompanyCode = _PartnerCompanyCode.CompanyCode
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_FinancialTransactionTypeT as _FinancialTransactionTypeT on $projection.FinancialTransactionType = _FinancialTransactionTypeT.FinancialTransactionType
and _FinancialTransactionTypeT.Language = $session.system_language
association [0..1] to I_GLAccountText as _GLAccountText on $projection.ChartOfAccounts = _GLAccountText.ChartOfAccounts
and $projection.GLAccount = _GLAccountText.GLAccount
and _GLAccountText.Language = $session.system_language
association [0..1] to I_CostCenterText as _CostCenterText on $projection.ControllingArea = _CostCenterText.ControllingArea
and $projection.CostCenter = _CostCenterText.CostCenter
and $projection.PostingDate <= _CostCenterText.ValidityEndDate
and $projection.PostingDate >= _CostCenterText.ValidityStartDate
and _CostCenterText.Language = $session.system_language
association [0..1] to I_CostCenterText as _OriginCostCenterText on $projection.ControllingArea = _OriginCostCenterText.ControllingArea
and $projection.OriginCostCenter = _OriginCostCenterText.CostCenter
and $projection.PostingDate <= _OriginCostCenterText.ValidityEndDate
and $projection.PostingDate >= _OriginCostCenterText.ValidityStartDate
and _OriginCostCenterText.Language = $session.system_language
association [0..1] to I_CostCenterText as _PartnerCostCenterText on $projection.ControllingArea = _PartnerCostCenterText.ControllingArea
and $projection.PartnerCostCenter = _PartnerCostCenterText.CostCenter
and $projection.PostingDate <= _PartnerCostCenterText.ValidityEndDate
and $projection.PostingDate >= _PartnerCostCenterText.ValidityStartDate
and _PartnerCostCenterText.Language = $session.system_language
association [0..1] to I_ProfitCenterText as _ProfitCenterText on $projection.ControllingArea = _ProfitCenterText.ControllingArea
and $projection.ProfitCenter = _ProfitCenterText.ProfitCenter
and $projection.PostingDate <= _ProfitCenterText.ValidityEndDate
and $projection.PostingDate >= _ProfitCenterText.ValidityStartDate
and _ProfitCenterText.Language = $session.system_language
association [0..1] to I_ProfitCenterText as _PartnerProfitCenterText on $projection.ControllingArea = _PartnerProfitCenterText.ControllingArea
and $projection.PartnerProfitCenter = _PartnerProfitCenterText.ProfitCenter
and $projection.PostingDate <= _PartnerProfitCenterText.ValidityEndDate
and $projection.PostingDate >= _PartnerProfitCenterText.ValidityStartDate
and _PartnerProfitCenterText.Language = $session.system_language
association [0..1] to I_FunctionalAreaText as _FunctionalAreaText on $projection.FunctionalArea = _FunctionalAreaText.FunctionalArea
and _FunctionalAreaText.Language = $session.system_language
association [0..1] to I_FunctionalAreaText as _PartnerFunctionalAreaText on $projection.PartnerFunctionalArea = _PartnerFunctionalAreaText.FunctionalArea
and _PartnerFunctionalAreaText.Language = $session.system_language
association [0..1] to I_BusinessAreaText as _BusinessAreaText on $projection.BusinessArea = _BusinessAreaText.BusinessArea
and _BusinessAreaText.Language = $session.system_language
association [0..1] to I_BusinessAreaText as _PartnerBusinessAreaText on $projection.PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea
and _PartnerBusinessAreaText.Language = $session.system_language
association [0..1] to I_SegmentText as _SegmentText on $projection.Segment = _SegmentText.Segment
and _SegmentText.Language = $session.system_language
association [0..1] to I_SegmentText as _PartnerSegmentText on $projection.PartnerSegment = _PartnerSegmentText.Segment
and _PartnerSegmentText.Language = $session.system_language
association [0..1] to I_Partnercompany as _PartnerCompany on $projection.PartnerCompany = _PartnerCompany.PartnerCompany
association [0..1] to I_PostingKeyText as _PostingKeyText on $projection.PostingKey = _PostingKeyText.PostingKey
and _PostingKeyText.Language = $session.system_language
association [0..1] to I_SubLedgerAccLineItemTypeT as _SubLedgerAccLineItemTypeT on $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemTypeT.SubLedgerAcctLineItemType
and _SubLedgerAccLineItemTypeT.Language = $session.system_language
association [0..1] to I_GLAccountText as _AlternativeGLAccountText on $projection.CountryChartOfAccounts = _AlternativeGLAccountText.ChartOfAccounts
and $projection.AlternativeGLAccount = _AlternativeGLAccountText.GLAccount
and _AlternativeGLAccountText.Language = $session.system_language
association [0..1] to I_Globalcompany as _Company on $projection.Company = _Company.Company
association [0..1] to I_CnsldtnSubItemCategoryText as _CnsldtnSubItemCategoryText on $projection.CnsldtnSubitemCategory = _CnsldtnSubItemCategoryText.SubItemCategory
and _CnsldtnSubItemCategoryText.Language = $session.system_language
association [0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
association [0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [0..1] to I_SpecialGLCodeText as _SpecialGLCodeText on $projection.FinancialAccountType = _SpecialGLCodeText.FinancialAccountType
and $projection.SpecialGLCode = _SpecialGLCodeText.SpecialGLCode
and _SpecialGLCodeText.Language = $session.system_language
association [0..1] to I_MasterFixedAsset as _MasterFixedAsset on $projection.CompanyCode = _MasterFixedAsset.CompanyCode
and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
association [0..1] to I_FixedAsset as _FixedAsset on $projection.CompanyCode = _FixedAsset.CompanyCode
and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
and $projection.FixedAsset = _FixedAsset.FixedAsset
association [0..1] to I_AssetTransactionTypeText as _AssetTransactionTypeText on $projection.AssetTransactionType = _AssetTransactionTypeText.AssetTransactionType
and _AssetTransactionTypeText.Language = $session.system_language
association [0..1] to I_AssetClassText as _AssetClassText on $projection.AssetClass = _AssetClassText.AssetClass
and _AssetClassText.Language = $session.system_language
association [0..1] to I_CostCenterActivityTypeText as _OriginCostCtrActivityTypeT on $projection.ControllingArea = _OriginCostCtrActivityTypeT.ControllingArea
and $projection.OriginCostCtrActivityType = _OriginCostCtrActivityTypeT.CostCtrActivityType
and $projection.PostingDate <= _OriginCostCtrActivityTypeT.ValidityEndDate
and $projection.PostingDate >= _OriginCostCtrActivityTypeT.ValidityStartDate
and _OriginCostCtrActivityTypeT.Language = $session.system_language
association [0..1] to I_CostCenterActivityTypeText as _CostCtrActivityTypeT on $projection.ControllingArea = _CostCtrActivityTypeT.ControllingArea
and $projection.CostCtrActivityType = _CostCtrActivityTypeT.CostCtrActivityType
and $projection.PostingDate <= _CostCtrActivityTypeT.ValidityEndDate
and $projection.PostingDate >= _CostCtrActivityTypeT.ValidityStartDate
and _CostCtrActivityTypeT.Language = $session.system_language
association [0..1] to I_CostCenterActivityTypeText as _PartnerCostCtrActivityTypeT on $projection.ControllingArea = _PartnerCostCtrActivityTypeT.ControllingArea
and $projection.PartnerCostCtrActivityType = _PartnerCostCtrActivityTypeT.CostCtrActivityType
and $projection.PostingDate <= _PartnerCostCtrActivityTypeT.ValidityEndDate
and $projection.PostingDate >= _PartnerCostCtrActivityTypeT.ValidityStartDate
and _PartnerCostCtrActivityTypeT.Language = $session.system_language
association [0..1] to I_ProductText as _ProductText on $projection.Product = _ProductText.Product
and _ProductText.Language = $session.system_language
association [0..1] to I_ProductText as _OriginProductText on $projection.OriginProduct = _OriginProductText.Product
and _OriginProductText.Language = $session.system_language
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_WBSElementBasicData as _PartnerWBSElementBasicData on $projection.PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID
association [0..1] to I_ProjectBasicData as _ProjectBasicData on $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
association [0..1] to I_ProjectBasicData as _PartnerProjectBasicData on $projection.PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID
association [0..1] to I_CountryText as _CustomerSupplierCountryText on $projection.CustomerSupplierCountry = _CustomerSupplierCountryText.Country
and _CustomerSupplierCountryText.Language = $session.system_language
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GlAccountTextInCompanycode as _CashLedgerAccountText on $projection.CashLedgerCompanyCode = _CashLedgerAccountText.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccountText.GLAccount
and _CashLedgerAccountText.Language = $session.system_language
association [0..1] to I_FundText as _FundText on $projection.FinancialManagementArea = _FundText.FinancialManagementArea
and $projection.Fund = _FundText.Fund
and _FundText.Language = $session.system_language
association [0..1] to I_GrantText as _GrantText on $projection.GrantID = _GrantText.GrantID
and _GrantText.Language = $session.system_language
association [0..1] to I_BudgetPeriodText as _BudgetPeriodText on $projection.BudgetPeriod = _BudgetPeriodText.BudgetPeriod
and _BudgetPeriodText.Language = $session.system_language
association [0..1] to I_FundText as _PartnerFundText on $projection.FinancialManagementArea = _PartnerFundText.FinancialManagementArea
and $projection.PartnerFund = _PartnerFundText.Fund
and _PartnerFundText.Language = $session.system_language
association [0..1] to I_GrantText as _PartnerGrantText on $projection.PartnerGrant = _PartnerGrantText.GrantID
and _PartnerGrantText.Language = $session.system_language
association [0..1] to I_BudgetPeriodText as _PartnerBudgetPeriodText on $projection.PartnerBudgetPeriod = _PartnerBudgetPeriodText.BudgetPeriod
and _PartnerBudgetPeriodText.Language = $session.system_language
association [0..1] to I_PubSecBudgetAccountText as _BudgetAccountText on $projection.PubSecBudgetAccount = _BudgetAccountText.PubSecBudgetAccount
and $projection.PubSecBudgetAccountCoCode = _BudgetAccountText.PubSecBudgetAccountCoCode
and _BudgetAccountText.Language = $session.system_language
association [0..1] to I_PubSecBdgtCnsmpnTypeText as _PubSecBdgtCnsmpnTypeText on $projection.PubSecBudgetCnsmpnType = _PubSecBdgtCnsmpnTypeText.PubSecBudgetCnsmpnType
and _PubSecBdgtCnsmpnTypeText.Language = $session.system_language
association [0..1] to I_PubSecBdgtCnsmpnAmtTypeText as _PubSecBdgtCnsmpnAmtTypeText on $projection.PubSecBudgetCnsmpnAmtType = _PubSecBdgtCnsmpnAmtTypeText.PubSecBudgetCnsmpnAmtType
and _PubSecBdgtCnsmpnAmtTypeText.Language = $session.system_language
association [0..1] to I_SponsoredProgramText as _SponsoredProgramText on $projection.SponsoredProgram = _SponsoredProgramText.SponsoredProgram
and _SponsoredProgramText.Language = $session.system_language
association [0..1] to I_SponsoredClassText as _SponsoredClassText on $projection.SponsoredClass = _SponsoredClassText.SponsoredClass
and _SponsoredClassText.Language = $session.system_language
association [0..1] to I_AccountAssignmentTypeT as _AccountAssignmentTypeT on $projection.AccountAssignmentType = _AccountAssignmentTypeT.AccountAssignmentType
and _AccountAssignmentTypeT.Language = $session.system_language
association [0..1] to I_AccountAssignmentTypeT as _PartnerAccountAssignmentTypeT on $projection.PartnerAccountAssignmentType = _PartnerAccountAssignmentTypeT.AccountAssignmentType
and _PartnerAccountAssignmentTypeT.Language = $session.system_language
association [0..1] to I_PaymentTermsText as _PaymentTermsText on $projection.paymentterms = _PaymentTermsText.PaymentTerms
and _PaymentTermsText.Language = $session.system_language
association [0..1] to I_PaymentBlockingReasonText as _PaymentBlockingReasonText on $projection.paymentblockingreason = _PaymentBlockingReasonText.PaymentBlockingReason
and _PaymentBlockingReasonText.Language = $session.system_language
association [0..1] to I_JrnlEntryItemObsltRsnT as _JrnlEntryItemObsltRsnText on $projection.JrnlEntryItemObsoleteReason = _JrnlEntryItemObsltRsnText.JrnlEntryItemObsoleteReason
and _JrnlEntryItemObsltRsnText.Language = $session.system_language
association [0..1] to I_DunningAreaText as _DunningAreaText on $projection.CompanyCode = _DunningAreaText.CompanyCode
and $projection.dunningarea = _DunningAreaText.DunningArea
and _DunningAreaText.Language = $session.system_language
association [0..1] to I_FinServicesProductGroupT as _FinServicesProductGroupT on $projection.FinancialServicesProductGroup = _FinServicesProductGroupT.FinancialServicesProductGroup
and _FinServicesProductGroupT.Language = $session.system_language
association [0..1] to I_FinancialServicesBranchT as _FinancialServicesBranchT on $projection.FinancialServicesBranch = _FinancialServicesBranchT.FinancialServicesBranch
and _FinancialServicesBranchT.Language = $session.system_language
association [0..1] to I_FinancialDataSourceT as _FinancialDataSourceT on $projection.FinancialDataSource = _FinancialDataSourceT.FinancialDataSource
and _FinancialDataSourceT.Language = $session.system_language
association [0..1] to I_CustomerSupplierIndustryText as _CustomerSupplierIndustryText on $projection.CustomerSupplierIndustry = _CustomerSupplierIndustryText.Industry
and _CustomerSupplierIndustryText.Language = $session.system_language
association [0..1] to I_CustomerGroupText as _CustomerGroupText on $projection.CustomerGroup = _CustomerGroupText.CustomerGroup
and _CustomerGroupText.Language = $session.system_language
association [0..1] to I_JournalEntryItemOneTimeData as _OneTimeData on $projection.CompanyCode = _OneTimeData.CompanyCode
and $projection.FiscalYear = _OneTimeData.FiscalYear
and $projection.AccountingDocument = _OneTimeData.AccountingDocument
and $projection.AccountingDocumentItem = _OneTimeData.AccountingDocumentItem
association [0..1] to I_HouseBankText as _HouseBankText on $projection.HouseBank = _HouseBankText.HouseBank
and $projection.CompanyCode = _HouseBankText.CompanyCode
and $projection.HouseBankAccount = _HouseBankText.HouseBankAccount
and _HouseBankText.Language = $session.system_language
association [0..1] to I_HouseBankAccountText as _HouseBankAccountText on $projection.HouseBank = _HouseBankAccountText.HouseBank
and $projection.CompanyCode = _HouseBankAccountText.CompanyCode
and $projection.HouseBankAccount = _HouseBankAccountText.HouseBankAccount
and _HouseBankAccountText.Language = $session.system_language
association [0..1] to I_FinancialManagementArea as _FinancialManagementArea on $projection.FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea
{
key _Item.SourceLedger,
key _Item.CompanyCode,
key _Item.FiscalYear,
key _Item.AccountingDocument,
key _Item.LedgerGLLineItem,
_Item.LedgerFiscalYear,
_Item.GLRecordType,
_Item.JrnlEntrAltvFYConsecutiveID,
_Item.ControllingArea,
_Item.BusinessTransactionCategory,
_Item.BusinessTransactionType,
_Item.ReferenceDocumentType,
_Item.ReferenceDocumentContext,
_Item.ReferenceDocument,
_Item.ReferenceDocumentItem,
_Item.ReferenceDocumentItemGroup,
_Item.FinancialTransactionType,
_Item.IsReversal,
_Item.IsReversed,
_Item.ReversalReferenceDocumentCntxt,
_Item.ReversalReferenceDocument,
_Item.IsSettlement,
_Item.IsSettled,
_Item.PredecessorReferenceDocCntxt,
_Item.PredecessorReferenceDocItem,
_Item.PredecessorReferenceDocType,
_Item.PredecessorReferenceDocument,
_Item.SourceReferenceDocument,
_Item.SourceReferenceDocumentType,
_Item.SourceReferenceDocumentItem,
_Item.SourceReferenceDocumentCntxt,
_Item.SourceLogicalSystem,
_Item.SourceReferenceDocSubitem,
_Item.IsCommitment,
_Item.JrnlEntryItemObsoleteReason,
_Item.GLBusinessTransactionType,
_Item.LogicalSystem,
_Item.GLAccount,
_Item.ChartOfAccounts,
_Item.CostCenter,
_Item.ProfitCenter,
_Item.FunctionalArea,
_Item.BusinessArea,
_Item.Segment,
_Item.PartnerCostCenter,
_Item.PartnerProfitCenter,
_Item.PartnerFunctionalArea,
_Item.PartnerBusinessArea,
_Item.PartnerCompany,
_Item.PartnerSegment,
_Item.BalanceTransactionCurrency,
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
_Item.AmountInBalanceTransacCrcy,
_Item.TransactionCurrency,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_Item.AmountInTransactionCurrency,
_Item.CompanyCodeCurrency,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
_Item.AmountInCompanyCodeCurrency,
_Item.GlobalCurrency,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
_Item.AmountInGlobalCurrency,
_Item.FunctionalCurrency,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
_Item.AmountInFunctionalCurrency,
_Item.FreeDefinedCurrency1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
_Item.AmountInFreeDefinedCurrency1,
_Item.FreeDefinedCurrency2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
_Item.AmountInFreeDefinedCurrency2,
_Item.FreeDefinedCurrency3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
_Item.AmountInFreeDefinedCurrency3,
_Item.FreeDefinedCurrency4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
_Item.AmountInFreeDefinedCurrency4,
_Item.FreeDefinedCurrency5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
_Item.AmountInFreeDefinedCurrency5,
_Item.FreeDefinedCurrency6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
_Item.AmountInFreeDefinedCurrency6,
_Item.FreeDefinedCurrency7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
_Item.AmountInFreeDefinedCurrency7,
_Item.FreeDefinedCurrency8,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
_Item.AmountInFreeDefinedCurrency8,
_Item.ControllingObjectCurrency,
@Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
_Item.AmountInObjectCurrency,
_Item.GrantCurrency,
@Semantics: { amount : {currencyCode: 'GrantCurrency'} }
_Item.AmountInGrantCurrency,
///
// Credit Amounts
///
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
_Item.CreditAmountInBalanceTransCrcy,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_Item.CreditAmountInTransCrcy,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
_Item.CreditAmountInCoCodeCrcy,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
_Item.CreditAmountInGlobalCrcy,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
_Item.CreditAmountInFunctionalCrcy,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
_Item.CreditAmountInFreeDfndCrcy1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
_Item.CreditAmountInFreeDfndCrcy2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
_Item.CreditAmountInFreeDfndCrcy3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
_Item.CreditAmountInFreeDfndCrcy4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
_Item.CreditAmountInFreeDfndCrcy5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
_Item.CreditAmountInFreeDfndCrcy6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
_Item.CreditAmountInFreeDfndCrcy7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
_Item.CreditAmountInFreeDfndCrcy8,
///
// Debit Amounts
///
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
_Item.DebitAmountInBalanceTransCrcy,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_Item.DebitAmountInTransCrcy,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
_Item.DebitAmountInCoCodeCrcy,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
_Item.DebitAmountInGlobalCrcy,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
_Item.DebitAmountInFunctionalCrcy,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
_Item.DebitAmountInFreeDfndCrcy1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
_Item.DebitAmountInFreeDfndCrcy2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
_Item.DebitAmountInFreeDfndCrcy3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
_Item.DebitAmountInFreeDfndCrcy4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
_Item.DebitAmountInFreeDfndCrcy5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
_Item.DebitAmountInFreeDfndCrcy6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
_Item.DebitAmountInFreeDfndCrcy7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
_Item.DebitAmountInFreeDfndCrcy8,
_Item.BaseUnit,
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
_Item.Quantity,
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
_Item.FixedQuantity,
_Item.CostSourceUnit,
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
_Item.ValuationQuantity,
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
_Item.ValuationFixedQuantity,
_Item.AdditionalQuantity1Unit,
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity1Unit'} }
_Item.AdditionalQuantity1,
_Item.AdditionalQuantity2Unit,
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity2Unit'} }
_Item.AdditionalQuantity2,
_Item.AdditionalQuantity3Unit,
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity3Unit'} }
_Item.AdditionalQuantity3,
_Item.DebitCreditCode,
_Item.ExchangeRateDate,
_Item.FiscalPeriod,
_Item.FiscalYearVariant,
_Item.FiscalYearPeriod,
_Item.PostingDate,
_Item.DocumentDate,
_Item.AccountingDocumentType,
_Item.AccountingDocumentItem,
_Item.AssignmentReference,
_Item.AccountingDocumentCategory,
_Item.PostingKey,
_Item.TransactionTypeDetermination,
_Item.SubLedgerAcctLineItemType,
_Item.AccountingDocCreatedByUser,
_Item.CreationDate,
_Item.CreationDateTime,
_Item.EliminationProfitCenter,
_Item.OriginObjectType,
_Item.GLAccountType,
_Item.AlternativeGLAccount,
_Item.CountryChartOfAccounts,
_Item.ConsolidationUnit,
_Item.InvoiceReference,
_Item.InvoiceReferenceFiscalYear,
_Item.FollowOnDocumentType,
_Item.InvoiceItemReference,
_Item.PartnerConsolidationUnit,
_Item.Company,
_Item.ConsolidationChartOfAccounts,
_Item.CnsldtnFinancialStatementItem,
_Item.CnsldtnSubitemCategory,
_Item.CnsldtnSubitem,
_Item.ReferencePurchaseOrderCategory,
_Item.PurchasingDocument,
_Item.PurchasingDocumentItem,
_Item.AccountAssignmentNumber,
_Item.DocumentItemText,
_Item.SalesDocument,
_Item.SalesDocumentItem,
_Item.Product,
_Item.ProductGroup,
_Item.Plant,
_Item.Supplier,
_Item.Customer,
_Item.ServicesRenderedDate,
_Item.PerformancePeriodStartDate,
_Item.PerformancePeriodEndDate,
_Item.FinancialAccountType,
_Item.SpecialGLCode,
_Item.TaxCode,
_Item.TaxCountry,
_Item.HouseBank,
_Item.HouseBankAccount,
@Semantics.booleanIndicator: true
_Item.IsOpenItemManaged,
_Item.ClearingDate,
_Item.ClearingJournalEntryFiscalYear,
_Item.ClearingJournalEntry,
_Item.IsCleared,
_Item.ValueDate,
_Item.AssetDepreciationArea,
_Item.MasterFixedAsset,
_Item.FixedAsset,
_Item.AssetValueDate,
cast( _Item.AssetTransactionType as fco_asset_transaction_type preserving type ) as AssetTransactionType,
_Item.AssetAcctTransClassfctn,
_Item.DepreciationFiscalPeriod,
_Item.GroupMasterFixedAsset,
_Item.GroupFixedAsset,
_Item.PartnerMasterFixedAsset,
_Item.PartnerFixedAsset,
_Item.AssetClass,
_Item.CostEstimate,
_Item.InventorySpecialStockValnType,
_Item.InventorySpecialStockType,
_Item.InventorySpclStkSalesDocument,
_Item.InventorySpclStkSalesDocItm,
_Item.InvtrySpclStockWBSElmntIntID,
_Item.InventorySpecialStockSupplier,
_Item.InventoryValuationType,
_Item.ValuationArea,
_Item.InvtrySpclStockWBSElmntExtID,
_Item.ProductPriceControl,
_Item.SenderGLAccount,
_Item.SenderAccountAssignment,
_Item.SenderAccountAssignmentType,
_Item.ControllingObject,
_Item.CostOriginGroup,
_Item.OriginSenderObject,
_Item.ControllingDebitCreditCode,
_Item.ControllingObjectDebitType,
_Item.QuantityIsIncomplete,
_Item.OffsettingAccount,
_Item.OffsettingAccountType,
_Item.OffsettingChartOfAccounts,
_Item.LineItemIsCompleted,
_Item.PersonnelNumber,
_Item.BillableControl,
_Item.ControllingObjectClass,
_Item.PartnerCompanyCode,
_Item.PartnerControllingObjectClass,
_Item.OriginCostCtrActivityType,
_Item.OriginCostCenter,
_Item.OriginProfitCenter,
_Item.OriginProduct,
_Item.VarianceOriginGLAccount,
_Item.AccountAssignment,
_Item.AccountAssignmentType,
_Item.CostCtrActivityType,
_Item.OrderID,
_Item.OrderCategory,
_Item.WBSElementInternalID,
_Item.WBSElementExternalID,
_Item.PartnerWBSElementInternalID,
_Item.PartnerWBSElementExternalID,
_Item.WorkPackage,
_Item.ProjectInternalID,
_Item.PartnerProjectInternalID,
_Item.PartnerProjectExternalID,
_Item.ProjectExternalID,
_Item.OperatingConcern,
_Item.ProjectNetwork,
_Item.RelatedNetworkActivity,
_Item.BusinessProcess,
_Item.CostObject,
_Item.CostAnalysisResource,
_Item.CustomerServiceNotification,
_Item.ServiceDocumentType,
_Item.ServiceDocument,
_Item.ServiceDocumentItem,
_Item.PartnerServiceDocumentType,
_Item.PartnerServiceDocument,
_Item.PartnerServiceDocumentItem,
_Item.ServiceContractType,
_Item.ServiceContract,
_Item.ServiceContractItem,
_Item.BusinessSolutionOrder,
_Item.BusinessSolutionOrderItem,
_Item.ProviderContract,
_Item.ProviderContractItem,
_Item.TimeSheetOvertimeCategory,
_Item.PartnerAccountAssignment,
_Item.PartnerAccountAssignmentType,
_Item.PartnerCostCtrActivityType,
_Item.PartnerOrder,
_Item.PartnerOrderCategory,
_Item.PartnerSalesDocument,
_Item.PartnerSalesDocumentItem,
_Item.PartnerProjectNetwork,
_Item.PartnerProjectNetworkActivity,
_Item.PartnerBusinessProcess,
_Item.PartnerCostObject,
_Item.WorkItem,
_Item.BillingDocumentType,
_Item.SalesOrganization,
_Item.DistributionChannel,
_Item.OrganizationDivision,
_Item.SoldProduct,
_Item.SoldProductGroup,
_Item.CustomerGroup,
_Item.CustomerSupplierCountry,
_Item.CustomerSupplierIndustry,
_Item.SalesDistrict,
_Item.BillToParty,
_Item.ShipToParty,
_Item.CustomerSupplierCorporateGroup,
_Item.CashLedgerCompanyCode,
_Item.CashLedgerAccount,
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
_Item.FinancialManagementArea,
_Item.FundsCenter,
_Item.FundedProgram,
_Item.Fund,
_Item.GrantID,
_Item.BudgetPeriod,
_Item.PartnerFund,
_Item.PartnerGrant,
_Item.PartnerBudgetPeriod,
_Item.PubSecBudgetAccount,
_Item.PubSecBudgetAccountCoCode,
_Item.PubSecBudgetCnsmpnDate,
_Item.PubSecBudgetCnsmpnFsclYear,
_Item.PubSecBudgetCnsmpnFsclPeriod,
_Item.PubSecBudgetIsRelevant,
_Item.PubSecBudgetCnsmpnType,
_Item.PubSecBudgetCnsmpnAmtType,
_Item.SponsoredProgram,
_Item.SponsoredClass,
_Item.GteeMBudgetValidityNumber,
_Item.CommitmentItem,
_Item.JointVenture,
_Item.JointVentureEquityGroup,
_Item.JointVentureCostRecoveryCode,
_Item.JointVenturePartner,
_Item.JointVentureBillingType,
_Item.JointVentureEquityType,
_Item.JointVentureProductionDate,
_Item.JointVentureBillingDate,
_Item.JointVentureOperationalDate,
//_Item.CutbackRun,
_Item.JointVentureAccountingActivity,
_Item.SettlementReferenceDate,
_Item.PartnerVenture,
_Item.PartnerEquityGroup,
_Item.SenderCostRecoveryCode,
_Item.CutbackAccount,
_Item.CutbackCostObject,
_Item.REBusinessEntity,
_Item.RealEstateBuilding,
_Item.RealEstateProperty,
_Item.RERentalObject,
_Item.RealEstateContract,
_Item.REServiceChargeKey,
_Item.RESettlementUnitID,
_Item.AccrualObjectType,
_Item.AccrualObjectLogicalSystem,
_Item.AccrualObject,
_Item.AccrualSubobject,
_Item.AccrualItemType,
_Item.AccrualReferenceObject,
_Item.AccrualValueDate,
_Item.FinancialValuationObjectType,
_Item.FinancialValuationObject,
_Item.FinancialValuationSubobject,
_Item.NetDueDate,
_Item.CreditRiskClass,
_Item.IsNegativePosting,
_Item.IsStatisticalOrder,
_Item.IsStatisticalCostCenter,
_Item.IsStatisticalSalesDocument,
_Item.WBSIsStatisticalWBSElement,
_Item.OrderOperation,
_Item.JrnlEntryItemMigrationSource,
_Item.FinancialServicesProductGroup,
_Item.FinancialServicesBranch,
_Item.FinancialDataSource,
_BSEGItem.AccountingDocument as SampleAccountingDocument,
_BSEGItem.WithholdingTaxCode,
_BSEGItem.BillingDocument,
_BSEGItem.ScheduleLine,
_BSEGItem.IsNotCashDiscountLiable,
_BSEGItem.BranchAccount,
_BSEGItem.SpecialGLAccountAssignment,
_BSEGItem.DueCalculationBaseDate,
_BSEGItem.PaymentTerms,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_BSEGItem.CashDiscountBaseAmount,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_BSEGItem.CashDiscountAmount,
_BSEGItem.CashDiscount1Days,
_BSEGItem.CashDiscount2Days,
_BSEGItem.NetPaymentDays,
_BSEGItem.CashDiscount1Percent,
_BSEGItem.CashDiscount2Percent,
_BSEGItem.PaymentMethod,
_BSEGItem.PaymentBlockingReason,
_BSEGItem.FixedCashDiscount,
_BSEGItem.BPBankAccountInternalID,
_BSEGItem.StateCentralBankPaymentReason,
_BSEGItem.SupplyingCountry,
_BSEGItem.InvoiceList,
_BSEGItem.DunningKey,
_BSEGItem.DunningBlockingReason,
_BSEGItem.LastDunningDate,
_BSEGItem.DunningLevel,
_BSEGItem.DunningArea,
_BSEGItem.WithholdingTaxCertificate,
_BSEGItem.VATRegistration,
_BSEGItem.PaymentDifferenceReason,
_BSEGItem.TaxJurisdiction,
_BSEGItem.IsEUTriangularDeal,
_BSEGItem.PaymentMethodSupplement,
_BSEGItem.Reference1IDByBusinessPartner,
_BSEGItem.Reference2IDByBusinessPartner,
_BSEGItem.Reference3IDByBusinessPartner,
_BSEGItem.DataExchangeInstruction1,
_BSEGItem.DataExchangeInstruction2,
_BSEGItem.DataExchangeInstruction3,
_BSEGItem.DataExchangeInstruction4,
_BSEGItem.Region,
_BSEGItem.HasPaymentOrder,
_BSEGItem.PaymentReference,
_BSEGItem.TaxDeterminationDate,
_BSEGItem.BusinessPlace,
_BSEGItem.SEPAMandate,
_BSEGItem.EarmarkedFundsDocument,
_BSEGItem.EarmarkedFundsDocumentItem,
_BSEGItem.TaxRateValidityStartDate,
_BSEGItem.PaymentReason,
_BSEGItem.BranchCode,
_BSEGItem.PaymentCurrency,
@Semantics: { amount : {currencyCode: 'PaymentCurrency'} }
_BSEGItem.NetPaymentAmount,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
_BSEGItem.TaxBaseAmountInCoCodeCrcy,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_BSEGItem.TaxBaseAmountInTransCrcy,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_BSEGItem.WithholdingTaxAmount,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_BSEGItem.WithholdingTaxExemptionAmt,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_BSEGItem.WithholdingTaxBaseAmount,
_BSEGItem.OplAcctgDocItmCntrySpcfcRef1,
@Semantics.booleanIndicator
_BSEGItem.AddressAndBankIsSetManually,
@Semantics.booleanIndicator
_OneTimeData.IsOneTimeAccount,
@Semantics.booleanIndicator
case
when _OneTimeData.AccountingDocument = _Item.AccountingDocument and _OneTimeData.IsOneTimeAccount = ''
then cast( 'X' as xzemp preserving type )
else cast( '' as xzemp preserving type )
end as AlternativePayeeIsAllowed,
@Semantics.booleanIndicator
cast( _Customer.AlternativePayeeIsAllowed as farp_isalternativepayer preserving type ) as PayerIsAlternativePayer,
@Semantics.booleanIndicator
cast( _Supplier.AlternativePayeeIsAllowed as farp_isalternativepayee preserving type ) as PayeeIsAlternativePayee,
_Item.ProfitabilitySegment,
_Ledger,
_LedgerText,
_CompanyCode,
_ControllingArea,
_FinancialTransactionTypeT,
_GLAccountText,
_CostCenterText,
_OriginCostCenterText,
_PartnerCostCenterText,
_ProfitCenterText,
_PartnerProfitCenterText,
_FunctionalAreaText,
_PartnerFunctionalAreaText,
_BusinessAreaText,
_PartnerBusinessAreaText,
_SegmentText,
_PartnerSegmentText,
_PartnerCompany,
_PostingKeyText,
_SubLedgerAccLineItemTypeT,
_AlternativeGLAccountText,
_Company,
_CnsldtnSubItemCategoryText,
_Plant,
_Customer,
_Supplier,
_SpecialGLCodeText,
_MasterFixedAsset,
_FixedAsset,
_AssetTransactionTypeText,
_AssetClassText,
_OriginCostCtrActivityTypeT,
_CostCtrActivityTypeT,
_PartnerCostCtrActivityTypeT,
_ProductText,
_OriginProductText,
_WBSElementBasicData,
_PartnerWBSElementBasicData,
_CustomerSupplierCountryText,
_CashLedgerCompanyCode,
_CashLedgerAccountText,
_FundText,
_GrantText,
_BudgetPeriodText,
_PartnerFundText,
_PartnerGrantText,
_PartnerBudgetPeriodText,
_BudgetAccountText,
_PubSecBdgtCnsmpnTypeText,
_PubSecBdgtCnsmpnAmtTypeText,
_SponsoredProgramText,
_SponsoredClassText,
_AccountAssignmentTypeT,
_PartnerAccountAssignmentTypeT,
_PaymentTermsText,
_PaymentBlockingReasonText,
_ProjectBasicData,
_PartnerProjectBasicData,
_PartnerCompanyCode,
_JrnlEntryItemObsltRsnText,
_DunningAreaText,
_FinServicesProductGroupT,
_FinancialServicesBranchT,
_FinancialDataSourceT,
_CustomerSupplierIndustryText,
_CustomerGroupText,
_HouseBankText,
_HouseBankAccountText,
_FinancialManagementArea,
//FOR DCL
_Item._GLAccountInCompanyCode,
_Item._Order,
_Item._AccountingDocumentType,
_Item._ServiceDocument,
_Item._SalesDocument
}
where _Item.Source = 'STANDARD'