C_SimulatedJournalEntryItem
Simulated Journal Entry Item
C_SimulatedJournalEntryItem is a Consumption CDS View that provides data about "Simulated Journal Entry Item" in SAP S/4HANA. It reads from 1 data source (R_ManageJournalEntryItem) and exposes 493 fields with key fields TemporaryAccountingDocument, TmpAccountingDocumentType, TmpAcctgDocSpecificationArea, TmpAcctgDocumentCreatedByUser, AccountingDocumentItem. It has 52 associations to related views. It is exposed through 1 OData service (UI_SMLTDJOURNALENTRY_DSP). It is used in 1 Fiori application: Display Simulated Journal Entries. Part of development package ODATA_DSP_SIMULATED_JRNL_ENTRY.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_ManageJournalEntryItem | R_ManageJournalEntryItem | from |
Associations (52)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_OperationalAcctgDocItem | _Extension | $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.AccountingDocumentItem = _Extension.AccountingDocumentItem |
| [0..*] | C_SmltdJrnlEntrWhldgTaxItem | _WithholdingTaxItem | $projection.TemporaryAccountingDocument = _WithholdingTaxItem.TemporaryAccountingDocument and $projection.TmpAccountingDocumentType = _WithholdingTaxItem.TmpAccountingDocumentType and $projection.TmpAcctgDocSpecificationArea = _WithholdingTaxItem.TmpAcctgDocSpecificationArea and $projection.TmpAcctgDocumentCreatedByUser = _WithholdingTaxItem.TmpAcctgDocumentCreatedByUser and $projection.AccountingDocumentItem = _WithholdingTaxItem.AccountingDocumentItem |
| [1..1] | I_CompanyCode | _CompanyCode | $projection.CompanyCode = _CompanyCode.CompanyCode |
| [0..1] | I_ControllingArea | _ControllingArea | $projection.ControllingArea = _ControllingArea.ControllingArea |
| [0..1] | I_FinancialTransactionTypeT | _FinancialTransactionTypeT | $projection.FinancialTransactionType = _FinancialTransactionTypeT.FinancialTransactionType and _FinancialTransactionTypeT.Language = $session.system_language |
| [0..1] | I_GLAccountText | _GLAccountText | $projection.ChartOfAccounts = _GLAccountText.ChartOfAccounts and $projection.GLAccount = _GLAccountText.GLAccount and _GLAccountText.Language = $session.system_language |
| [0..1] | I_CostCenterText | _CostCenterText | $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 |
| [0..1] | I_ProfitCenterText | _ProfitCenterText | $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 |
| [0..1] | I_ProfitCenterText | _PartnerProfitCenterText | $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 |
| [0..1] | I_FunctionalAreaText | _FunctionalAreaText | $projection.FunctionalArea = _FunctionalAreaText.FunctionalArea and _FunctionalAreaText.Language = $session.system_language |
| [0..1] | I_FunctionalAreaText | _PartnerFunctionalAreaText | $projection.PartnerFunctionalArea = _PartnerFunctionalAreaText.FunctionalArea and _PartnerFunctionalAreaText.Language = $session.system_language |
| [0..1] | I_BusinessAreaText | _BusinessAreaText | $projection.BusinessArea = _BusinessAreaText.BusinessArea and _BusinessAreaText.Language = $session.system_language |
| [0..1] | I_BusinessAreaText | _PartnerBusinessAreaText | $projection.PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea and _PartnerBusinessAreaText.Language = $session.system_language |
| [0..1] | I_SegmentText | _SegmentText | $projection.Segment = _SegmentText.Segment and _SegmentText.Language = $session.system_language |
| [0..1] | I_SegmentText | _PartnerSegmentText | $projection.PartnerSegment = _PartnerSegmentText.Segment and _PartnerSegmentText.Language = $session.system_language |
| [0..1] | I_Partnercompany | _PartnerCompany | $projection.PartnerCompany = _PartnerCompany.PartnerCompany |
| [0..1] | I_PostingKeyText | _PostingKeyText | $projection.PostingKey = _PostingKeyText.PostingKey and _PostingKeyText.Language = $session.system_language |
| [0..1] | I_Plant | _Plant | $projection.Plant = _Plant.Plant |
| [0..1] | I_Customer | _Customer | $projection.Customer = _Customer.Customer |
| [0..1] | I_Supplier | _Supplier | $projection.Supplier = _Supplier.Supplier |
| [0..1] | I_SpecialGLCodeText | _SpecialGLCodeText | $projection.FinancialAccountType = _SpecialGLCodeText.FinancialAccountType and $projection.SpecialGLCode = _SpecialGLCodeText.SpecialGLCode and _SpecialGLCodeText.Language = $session.system_language |
| [0..1] | I_MasterFixedAsset | _MasterFixedAsset | $projection.CompanyCode = _MasterFixedAsset.CompanyCode and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset |
| [0..1] | I_AssetTransactionTypeText | _AssetTransactionTypeText | $projection.AssetTransactionType = _AssetTransactionTypeText.AssetTransactionType and _AssetTransactionTypeText.Language = $session.system_language |
| [0..1] | I_CostCenterActivityTypeText | _CostCtrActivityTypeT | $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 |
| [0..1] | I_ProductText | _ProductText | $projection.Product = _ProductText.Product and _ProductText.Language = $session.system_language |
| [0..1] | I_WBSElementBasicData | _WBSElementBasicData | $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID |
| [0..1] | I_CompanyCode | _CashLedgerCompanyCode | $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode |
| [0..1] | I_GlAccountTextInCompanycode | _CashLedgerAccountText | $projection.CashLedgerCompanyCode = _CashLedgerAccountText.CompanyCode and $projection.CashLedgerAccount = _CashLedgerAccountText.GLAccount and _CashLedgerAccountText.Language = $session.system_language |
| [0..1] | I_FundText | _FundText | '' = _FundText.FinancialManagementArea and $projection.Fund = _FundText.Fund and _FundText.Language = $session.system_language |
| [0..1] | I_GrantText | _GrantText | $projection.GrantID = _GrantText.GrantID and _GrantText.Language = $session.system_language |
| [0..1] | I_BudgetPeriodText | _BudgetPeriodText | $projection.BudgetPeriod = _BudgetPeriodText.BudgetPeriod and _BudgetPeriodText.Language = $session.system_language |
| [0..1] | I_FundText | _PartnerFundText | '' = _PartnerFundText.FinancialManagementArea and $projection.PartnerFund = _PartnerFundText.Fund and _PartnerFundText.Language = $session.system_language |
| [0..1] | I_GrantText | _PartnerGrantText | $projection.PartnerGrant = _PartnerGrantText.GrantID and _PartnerGrantText.Language = $session.system_language |
| [0..1] | I_BudgetPeriodText | _PartnerBudgetPeriodText | $projection.PartnerBudgetPeriod = _PartnerBudgetPeriodText.BudgetPeriod and _PartnerBudgetPeriodText.Language = $session.system_language |
| [0..1] | I_PubSecBudgetAccountText | _BudgetAccountText | $projection.PubSecBudgetAccount = _BudgetAccountText.PubSecBudgetAccount and $projection.PubSecBudgetAccountCoCode = _BudgetAccountText.PubSecBudgetAccountCoCode and _BudgetAccountText.Language = $session.system_language |
| [0..1] | I_PaymentTermsText | _PaymentTermsText | $projection.PaymentTerms = _PaymentTermsText.PaymentTerms and _PaymentTermsText.Language = $session.system_language |
| [0..1] | I_PaymentBlockingReasonText | _PaymentBlockingReasonText | $projection.PaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason and _PaymentBlockingReasonText.Language = $session.system_language |
| [0..1] | I_DunningAreaText | _DunningAreaText | $projection.CompanyCode = _DunningAreaText.CompanyCode and $projection.DunningArea = _DunningAreaText.DunningArea and _DunningAreaText.Language = $session.system_language |
| [0..1] | I_FixedCashDiscountTypeText | _FixedCashDiscountTypeText | $projection.FixedCashDiscount = _FixedCashDiscountTypeText.FixedCashDiscount and _FixedCashDiscountTypeText.Language = $session.system_language |
| [0..1] | I_CountryText | _SupplyingCountryText | $projection.SupplyingCountry = _SupplyingCountryText.Country and _SupplyingCountryText.Language = $session.system_language |
| [0..1] | I_FinServicesProductGroupT | _FinServicesProductGroupT | $projection.FinancialServicesProductGroup = _FinServicesProductGroupT.FinancialServicesProductGroup and _FinServicesProductGroupT.Language = $session.system_language |
| [0..1] | I_FinancialServicesBranchT | _FinancialServicesBranchT | $projection.FinancialServicesBranch = _FinancialServicesBranchT.FinancialServicesBranch and _FinancialServicesBranchT.Language = $session.system_language |
| [0..1] | I_FinancialDataSourceT | _FinancialDataSourceT | $projection.FinancialDataSource = _FinancialDataSourceT.FinancialDataSource and _FinancialDataSourceT.Language = $session.system_language |
| [0..1] | I_CustomerSupplierIndustryText | _CustomerSupplierIndustryText | $projection.CustomerSupplierIndustry = _CustomerSupplierIndustryText.Industry and _CustomerSupplierIndustryText.Language = $session.system_language |
| [0..1] | I_CustomerGroupText | _CustomerGroupText | $projection.CustomerGroup = _CustomerGroupText.CustomerGroup and _CustomerGroupText.Language = $session.system_language |
| [0..1] | I_CountryText | _CustomerSupplierCountryText | $projection.CustomerSupplierCountry = _CustomerSupplierCountryText.Country and _CustomerSupplierCountryText.Language = $session.system_language |
| [0..1] | I_Housebank | _HouseBank | $projection.HouseBank = _HouseBank.HouseBank and $projection.CompanyCode = _HouseBank.CompanyCode |
| [0..1] | I_HouseBankAccountText | _HouseBankAccountText | $projection.HouseBank = _HouseBankAccountText.HouseBank and $projection.CompanyCode = _HouseBankAccountText.CompanyCode and $projection.HouseBankAccount = _HouseBankAccountText.HouseBankAccount and _HouseBankAccountText.Language = $session.system_language |
| [0..1] | I_CountryText | _TaxCountryText | $projection.TaxCountry = _TaxCountryText.Country and _TaxCountryText.Language = $session.system_language |
| [0..1] | I_TaxCodeText | _TaxCodeText | $projection.TaxCode = _TaxCodeText.TaxCode and _TaxCodeText.Language = $session.system_language |
| [0..1] | I_WorkforcePersonMappings_1 | _WorkForcePersonMappings | $projection.PersonnelNumber = _WorkForcePersonMappings.WorkAssignment |
| [0..1] | I_PaymentDifferenceReasonT | _PaymentDifferenceReasonText | $projection.CompanyCode = _PaymentDifferenceReasonText.CompanyCode and $projection.PaymentDifferenceReason = _PaymentDifferenceReasonText.PaymentDifferenceReason and _PaymentDifferenceReasonText.Language = $session.system_language |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| ObjectModel.query.implementedBy | ABAP:CL_SIMULATEDJOURNALENTRY_QUERY | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Metadata.allowExtensions | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| EndUserText.label | Simulated Journal Entry Item | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| UI.headerInfo.typeName | Line Item in Entry View | view | |
| UI.headerInfo.typeNamePlural | Line Items in Entry View | view | |
| UI.headerInfo.title.value | AccountingDocumentItem | view | |
| UI.headerInfo.title.label | Journal Entry Item | view | |
| UI.headerInfo.description.type | #STANDARD | view | |
| UI.headerInfo.description.value | DocumentItemText | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| UI_SMLTDJOURNALENTRY_DSP | UI_SMLTDJOURNALENTRY_DSP | V2 | C1 | NOT_RELEASED |
Fiori Apps (1)
| App ID | App Name | Type | Description |
|---|---|---|---|
| F7958 | Display Simulated Journal Entries | Transactional, Reuse Component | This application can be used to display simulated journal entries. |
Display Simulated Journal Entries
Business Role: General Ledger Accountant
The Simulate button simulates the posting of a journal entry. It is used in posting apps to show you the results of posting a journal entry without actually posting it. The button opens a simulated view of a posted journal entry, including a header and tabs for General Information and Line Items in Entry View.
Fields (493)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | TemporaryAccountingDocument | |||
| KEY | TmpAccountingDocumentType | |||
| KEY | TmpAcctgDocSpecificationArea | |||
| KEY | TmpAcctgDocumentCreatedByUser | |||
| KEY | AccountingDocumentItem | AccountingDocumentItem | ||
| CompanyCode | CompanyCode | |||
| FiscalYear | FiscalYear | |||
| AccountingDocument | AccountingDocument | |||
| CompanyCodeName | ||||
| Country | _CompanyCode | Country | ||
| ChartOfAccounts | ChartOfAccounts | |||
| ClearingDate | ClearingDate | |||
| ClearingCreationDate | ClearingCreationDate | |||
| ClearingJournalEntry | ClearingJournalEntry | |||
| PostingKey | PostingKey | |||
| PostingKeyName | _PostingKeyText | PostingKeyName | ||
| FinancialAccountType | FinancialAccountType | |||
| SpecialGLCode | SpecialGLCode | |||
| SpecialGLCodeName | ||||
| SpecialGLTransactionType | SpecialGLTransactionType | |||
| DebitCreditCode | DebitCreditCode | |||
| BusinessArea | BusinessArea | |||
| BusinessAreaName | _BusinessAreaText | BusinessAreaName | ||
| PartnerBusinessArea | PartnerBusinessArea | |||
| PartnerBusinessAreaName | ||||
| TaxCode | TaxCode | |||
| TaxCodeName | _TaxCodeText | TaxCodeName | ||
| WithholdingTaxCode | WithholdingTaxCode | |||
| TaxType | TaxType | |||
| TransactionTypeDetermination | TransactionTypeDetermination | |||
| ValueDate | ValueDate | |||
| AssignmentReference | AssignmentReference | |||
| DocumentItemText | DocumentItemText | |||
| PartnerCompany | PartnerCompany | |||
| PartnerCompanyName | ||||
| FinancialTransactionType | FinancialTransactionType | |||
| FinancialTransactionTypeName | ||||
| CorporateGroupAccount | CorporateGroupAccount | |||
| PlanningLevel | PlanningLevel | |||
| ControllingArea | ControllingArea | |||
| ControllingAreaName | _ControllingArea | ControllingAreaName | ||
| CostCenter | CostCenter | |||
| CostCenterName | _CostCenterText | CostCenterName | ||
| OrderID | OrderID | |||
| BillingDocument | BillingDocument | |||
| SalesDocument | SalesDocument | |||
| SalesDocumentItem | SalesDocumentItem | |||
| ScheduleLine | ScheduleLine | |||
| ServiceDocumentType | ServiceDocumentType | |||
| ServiceDocument | ServiceDocument | |||
| ServiceDocumentItem | ServiceDocumentItem | |||
| MasterFixedAsset | MasterFixedAsset | |||
| MasterFixedAssetDescription | _MasterFixedAsset | MasterFixedAssetDescription | ||
| FixedAsset | FixedAsset | |||
| AssetTransactionType | AssetTransactionType | |||
| AssetTransactionTypeName | ||||
| AssetValueDate | AssetValueDate | |||
| PersonnelNumber | PersonnelNumber | |||
| WorkAssignmentExternalID | _WorkForcePersonMappings | WorkAssignmentExternalID | ||
| IsSalesRelated | IsSalesRelated | |||
| LineItemDisplayIsEnabled | LineItemDisplayIsEnabled | |||
| IsOpenItemManaged | IsOpenItemManaged | |||
| IsNotCashDiscountLiable | IsNotCashDiscountLiable | |||
| IsAutomaticallyCreated | IsAutomaticallyCreated | |||
| IsUsedInPaymentTransaction | IsUsedInPaymentTransaction | |||
| OperationalGLAccount | OperationalGLAccount | |||
| GLAccount | GLAccount | |||
| GLAccountName | _GLAccountText | GLAccountName | ||
| GLAccountLongName | _GLAccountText | GLAccountLongName | ||
| Customer | Customer | |||
| CustomerName | ||||
| Supplier | Supplier | |||
| SupplierName | ||||
| BranchAccount | BranchAccount | |||
| IsBalanceSheetAccount | IsBalanceSheetAccount | |||
| ProfitLossAccountType | ProfitLossAccountType | |||
| SpecialGLAccountAssignment | SpecialGLAccountAssignment | |||
| DueCalculationBaseDate | DueCalculationBaseDate | |||
| PaymentTerms | PaymentTerms | |||
| PaymentTermsName | ||||
| CashDiscountBaseAmount | CashDiscountBaseAmount | |||
| CashDiscountAmount | CashDiscountAmount | |||
| CashDiscount1Days | CashDiscount1Days | |||
| CashDiscount2Days | CashDiscount2Days | |||
| NetPaymentDays | NetPaymentDays | |||
| CashDiscount1Percent | CashDiscount1Percent | |||
| CashDiscount2Percent | CashDiscount2Percent | |||
| PaymentMethod | PaymentMethod | |||
| PaymentBlockingReason | PaymentBlockingReason | |||
| PaymentBlockingReasonName | _PaymentBlockingReasonText | PaymentBlockingReasonName | ||
| FixedCashDiscount | FixedCashDiscount | |||
| UtilsDiscountTypeDescription | ||||
| HouseBank | HouseBank | |||
| HouseBankName | ||||
| BPBankAccountInternalID | BPBankAccountInternalID | |||
| InvoiceReference | InvoiceReference | |||
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | |||
| InvoiceItemReference | InvoiceItemReference | |||
| FollowOnDocumentType | FollowOnDocumentType | |||
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | |||
| SupplyingCountry | SupplyingCountry | |||
| SupplyingCountryName | ||||
| InvoiceList | InvoiceList | |||
| BillOfExchangeUsage | BillOfExchangeUsage | |||
| DunningKey | DunningKey | |||
| DunningBlockingReason | DunningBlockingReason | |||
| LastDunningDate | LastDunningDate | |||
| DunningLevel | DunningLevel | |||
| DunningArea | DunningArea | |||
| DunningAreaName | _DunningAreaText | DunningAreaName | ||
| WithholdingTaxCertificate | WithholdingTaxCertificate | |||
| Product | Product | |||
| ProductName | ||||
| Plant | Plant | |||
| PlantName | _Plant | PlantName | ||
| PurchasingDocument | PurchasingDocument | |||
| PurchasingDocumentItem | PurchasingDocumentItem | |||
| AccountAssignmentNumber | AccountAssignmentNumber | |||
| LineItemIsCompleted | LineItemIsCompleted | |||
| MaterialPriceControl | MaterialPriceControl | |||
| ValuationArea | ValuationArea | |||
| InventoryValuationType | InventoryValuationType | |||
| VATRegistration | VATRegistration | |||
| DelivOfGoodsDestCountry | DelivOfGoodsDestCountry | |||
| PaymentDifferenceReason | PaymentDifferenceReason | |||
| PaymentDifferenceReasonName | ||||
| ProfitCenter | ProfitCenter | |||
| ProfitCenterName | _ProfitCenterText | ProfitCenterName | ||
| JointVenture | JointVenture | |||
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | |||
| JointVentureEquityGroup | JointVentureEquityGroup | |||
| TreasuryContractType | TreasuryContractType | |||
| AssetContract | AssetContract | |||
| CashFlowType | CashFlowType | |||
| TaxJurisdiction | TaxJurisdiction | |||
| REInternalFinNumber | REInternalFinNumber | |||
| SettlementReferenceDate | SettlementReferenceDate | |||
| CommitmentItemShortID | CommitmentItemShortID | |||
| CostObject | CostObject | |||
| ProjectNetwork | ProjectNetwork | |||
| OrderInternalBillOfOperations | OrderInternalBillOfOperations | |||
| OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | |||
| WBSElementExternalID | _WBSElementBasicData | WBSElementExternalID | ||
| WBSElementInternalID | WBSElementInternalID | |||
| WBSDescription | _WBSElementBasicData | WBSDescription | ||
| ProfitabilitySegment | ProfitabilitySegment | |||
| JointVentureEquityType | JointVentureEquityType | |||
| IsEUTriangularDeal | IsEUTriangularDeal | |||
| CostOriginGroup | CostOriginGroup | |||
| CompanyCodeCurrencyDetnMethod | CompanyCodeCurrencyDetnMethod | |||
| ClearingIsReversed | ClearingIsReversed | |||
| PaymentMethodSupplement | PaymentMethodSupplement | |||
| AlternativeGLAccount | AlternativeGLAccount | |||
| PartnerProfitCenter | PartnerProfitCenter | |||
| PartnerProfitCenterName | ||||
| Reference1IDByBusinessPartner | Reference1IDByBusinessPartner | |||
| Reference2IDByBusinessPartner | Reference2IDByBusinessPartner | |||
| IsNegativePosting | IsNegativePosting | |||
| PaymentCardItem | PaymentCardItem | |||
| PaymentCardPaymentSettlement | PaymentCardPaymentSettlement | |||
| CreditControlArea | CreditControlArea | |||
| Reference3IDByBusinessPartner | Reference3IDByBusinessPartner | |||
| DataExchangeInstruction1 | DataExchangeInstruction1 | |||
| DataExchangeInstruction2 | DataExchangeInstruction2 | |||
| DataExchangeInstruction3 | DataExchangeInstruction3 | |||
| DataExchangeInstruction4 | DataExchangeInstruction4 | |||
| Region | Region | |||
| HasPaymentOrder | HasPaymentOrder | |||
| PaymentReference | PaymentReference | |||
| TaxDeterminationDate | TaxDeterminationDate | |||
| ClearingItem | ClearingItem | |||
| BusinessPlace | BusinessPlace | |||
| TaxSection | TaxSection | |||
| CostCtrActivityType | CostCtrActivityType | |||
| CostCtrActivityTypeName | _CostCtrActivityTypeT | CostCtrActivityTypeName | ||
| AccountsReceivableIsPledged | AccountsReceivableIsPledged | |||
| AcctsReceivablePledgingCode | AcctsReceivablePledgingCode | |||
| BusinessProcess | BusinessProcess | |||
| FunctionalArea | FunctionalArea | |||
| FunctionalAreaName | _FunctionalAreaText | FunctionalAreaName | ||
| CustomerIsInExecution | CustomerIsInExecution | |||
| ClearingJournalEntryFiscalYear | ClearingJournalEntryFiscalYear | |||
| LedgerGLLineItem | LedgerGLLineItem | |||
| Segment | Segment | |||
| SegmentName | _SegmentText | SegmentName | ||
| PartnerSegment | PartnerSegment | |||
| PartnerSegmentName | ||||
| PartnerFunctionalArea | PartnerFunctionalArea | |||
| PartnerFunctionalAreaName | ||||
| HouseBankAccount | HouseBankAccount | |||
| HouseBankAccountDescription | ||||
| CostElement | CostElement | |||
| PaymentServiceProvider | PaymentServiceProvider | |||
| PaymentRefByPaytSrvcProvider | PaymentRefByPaytSrvcProvider | |||
| SEPAMandate | SEPAMandate | |||
| ReferenceDocumentType | ReferenceDocumentType | |||
| OriginalReferenceDocument | OriginalReferenceDocument | |||
| ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | |||
| AccountingDocumentItemRef | AccountingDocumentItemRef | |||
| FiscalPeriod | FiscalPeriod | |||
| AccountingDocumentCategory | AccountingDocumentCategory | |||
| PostingDate | PostingDate | |||
| DocumentDate | DocumentDate | |||
| AccountingDocumentType | AccountingDocumentType | |||
| NetDueDate | NetDueDate | |||
| CashDiscount1DueDate | CashDiscount1DueDate | |||
| CashDiscount2DueDate | CashDiscount2DueDate | |||
| OffsettingAccount | OffsettingAccount | |||
| OffsettingAccountType | OffsettingAccountType | |||
| OffsettingChartOfAccounts | OffsettingChartOfAccounts | |||
| CashLedgerCompanyCode | CashLedgerCompanyCode | |||
| CashLedgerCompanyCodeName | ||||
| CashLedgerAccount | CashLedgerAccount | |||
| CashLedgerAccountName | ||||
| FinancialManagementArea | ||||
| FundsCenter | FundsCenter | |||
| FundedProgram | FundedProgram | |||
| Fund | Fund | |||
| FundName | _FundText | FundName | ||
| GrantID | GrantID | |||
| GrantName | ||||
| BudgetPeriod | BudgetPeriod | |||
| BudgetPeriodName | _BudgetPeriodText | BudgetPeriodName | ||
| PartnerFund | PartnerFund | |||
| ReceiverPostedFundName | ||||
| PartnerGrant | PartnerGrant | |||
| ReceiverPostedGrantName | ||||
| PartnerBudgetPeriod | PartnerBudgetPeriod | |||
| ReceiverPostedBudgetPeriodName | ||||
| PubSecBudgetAccount | PubSecBudgetAccount | |||
| BudgetAccountName | _BudgetAccountText | BudgetAccountName | ||
| PubSecBudgetAccountCoCode | PubSecBudgetAccountCoCode | |||
| CompanyCodeCurrency | CompanyCodeCurrency | |||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | |||
| CreditAmountInCoCodeCrcy | CreditAmountInCoCodeCrcy | |||
| DebitAmountInCoCodeCrcy | DebitAmountInCoCodeCrcy | |||
| FunctionalCurrency | FunctionalCurrency | |||
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | |||
| CreditAmountInFunctionalCrcy | CreditAmountInFunctionalCrcy | |||
| DebitAmountInFunctionalCrcy | DebitAmountInFunctionalCrcy | |||
| TransactionCurrency | TransactionCurrency | |||
| AmountInTransactionCurrency | AmountInTransactionCurrency | |||
| CreditAmountInTransCrcy | CreditAmountInTransCrcy | |||
| DebitAmountInTransCrcy | DebitAmountInTransCrcy | |||
| BalanceTransactionCurrency | BalanceTransactionCurrency | |||
| CreditAmountInBalanceTransCrcy | CreditAmountInBalanceTransCrcy | |||
| DebitAmountInBalanceTransCrcy | DebitAmountInBalanceTransCrcy | |||
| AdditionalCurrency1 | AdditionalCurrency1 | |||
| CreditAmountInAddlCrcy1 | CreditAmountInAddlCrcy1 | Credit Amount in Additional Currency 1 | ||
| DebitAmountInAddlCrcy1 | DebitAmountInAddlCrcy1 | Debit Amount in Additional Currency 1 | ||
| AdditionalCurrency2 | AdditionalCurrency2 | |||
| CreditAmountInAddlCrcy2 | CreditAmountInAddlCrcy2 | Credit Amount in Additional Currency 2 | ||
| DebitAmountInAddlCrcy2 | DebitAmountInAddlCrcy2 | Debit Amount in Additional Currency 2 | ||
| BaseUnit | BaseUnit | |||
| Quantity | Quantity | |||
| AbsoluteQuantity | AbsoluteQuantity | |||
| GoodsMovementEntryUnit | GoodsMovementEntryUnit | |||
| QuantityInEntryUnit | QuantityInEntryUnit | |||
| PurchasingDocumentPriceUnit | PurchasingDocumentPriceUnit | |||
| PurchaseOrderQty | PurchaseOrderQty | |||
| MaterialPriceUnitQty | MaterialPriceUnitQty | |||
| EarmarkedFundsDocument | EarmarkedFundsDocument | |||
| EarmarkedFundsDocumentItem | EarmarkedFundsDocumentItem | |||
| PaytSlipWthRefReference | PaytSlipWthRefReference | |||
| TaxRateValidityStartDate | TaxRateValidityStartDate | |||
| PaytSlipWthRefCheckDigit | PaytSlipWthRefCheckDigit | |||
| PaytSlipWthRefSubscriber | PaytSlipWthRefSubscriber | |||
| PaymentReason | PaymentReason | |||
| BranchCode | BranchCode | |||
| PaymentCurrency | PaymentCurrency | |||
| AmountInPaymentCurrency | AmountInPaymentCurrency | |||
| NetPaymentAmount | NetPaymentAmount | |||
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | |||
| TaxBaseAmountInTransCrcy | TaxBaseAmountInTransCrcy | |||
| WithholdingTaxAmount | WithholdingTaxAmount | |||
| WithholdingTaxExemptionAmt | WithholdingTaxExemptionAmt | |||
| WithholdingTaxBaseAmount | WithholdingTaxBaseAmount | |||
| TaxCountry | TaxCountry | |||
| TaxCountryName | ||||
| AddressAndBankIsSetManually | AddressAndBankIsSetManually | |||
| IsOneTimeAccount | ||||
| PayerIsAlternativePayer | ||||
| PayeeIsAlternativePayee | ||||
| OplAcctgDocItmCntrySpcfcRef1 | OplAcctgDocItmCntrySpcfcRef1 | |||
| CustomerGroup | CustomerGroup | |||
| CustomerGroupName | ||||
| CustomerSupplierCountry | CustomerSupplierCountry | |||
| CustomerSupplierCountryName | ||||
| CustomerSupplierIndustry | CustomerSupplierIndustry | |||
| CustomerSupplierIndustryName | _CustomerSupplierIndustryText | CustomerSupplierIndustryName | ||
| FinancialServicesProductGroup | FinancialServicesProductGroup | |||
| FinServicesProductGroupName | _FinServicesProductGroupT | FinServicesProductGroupName | ||
| FinancialServicesBranch | FinancialServicesBranch | |||
| FinancialServicesBranchName | _FinancialServicesBranchT | FinancialServicesBranchName | ||
| FinancialDataSource | FinancialDataSource | |||
| FinancialDataSourceName | _FinancialDataSourceT | FinancialDataSourceName | ||
| CashDiscountAmtInCoCodeCrcy | CashDiscountAmtInCoCodeCrcy | |||
| AccountingDocumentItemType | AccountingDocumentItemType | |||
| RecrrgSuplrInvcIsSrvcInvoice | RecrrgSuplrInvcIsSrvcInvoice | |||
| SuplrInvcIsCapitalGoodsRelated | SuplrInvcIsCapitalGoodsRelated | |||
| AcctgDocItmCustomsTariffNumber | AcctgDocItmCustomsTariffNumber | |||
| AcctgDocItmCstmsClearanceDate | AcctgDocItmCstmsClearanceDate | |||
| ClearingIsLedgerGroupSpecific | ClearingIsLedgerGroupSpecific | |||
| InvcItmIsExcldFrmPromptPaytAct | InvcItmIsExcldFrmPromptPaytAct | |||
| InterestCalculationBlockReason | InterestCalculationBlockReason | |||
| UICT_CreditAmount | ||||
| UICT_DebitAmount | ||||
| UICT_FinancialTransactionType | ||||
| UICT_PostingKey | ||||
| UICT_Customer | ||||
| UICT_Supplier | ||||
| UICT_BranchAccount | ||||
| UICT_PartnerCompany | ||||
| UICT_GLAccount | ||||
| UICT_DocumentItemText | ||||
| UICT_AssignmentReference | ||||
| UICT_Reference1IDByBizPartner | ||||
| UICT_Reference2IDByBizPartner | ||||
| UICT_Reference3IDByBizPartner | ||||
| UICT_ClearingJournalEntry | ||||
| UICT_ClearingDate | ||||
| UICT_BranchCode | ||||
| UICT_Quantity | ||||
| UICT_CompanyCode | ||||
| UICT_ControllingArea | ||||
| UICT_Product | ||||
| UICT_CostCenter | ||||
| UICT_OrderID | ||||
| UICT_WBSElementExternalID | ||||
| UICT_SalesDocument | ||||
| UICT_SalesDocumentItem | ||||
| UICT_ScheduleLine | ||||
| UICT_PersonnelNumber | ||||
| UICT_ProjectNetwork | ||||
| UICT_Plant | ||||
| UICT_BusinessArea | ||||
| UICT_PartnerBusinessArea | ||||
| UICT_ProfitCenter | ||||
| UICT_CostObject | ||||
| UICT_PartnerProfitCenter | ||||
| UICT_FunctionalArea | ||||
| UICT_CostCtrActivityType | ||||
| UICT_BusinessProcess | ||||
| UICT_Segment | ||||
| UICT_PartnerSegment | ||||
| UICT_EarmarkedFundsDocument | ||||
| UICT_EmrkdFundsDocumentItem | ||||
| UICT_LineItemIsCompleted | ||||
| UICT_ValueDate | ||||
| UICT_PaymentMethod | ||||
| UICT_PaymentMethodSupplement | ||||
| UICT_PaymentBlockingReason | ||||
| UICT_HouseBank | ||||
| UICT_HouseBankAccount | ||||
| UICT_BPBankAccountInternalID | ||||
| UICT_DataExchangeInstruction1 | ||||
| UICT_DataExchangeInstruction2 | ||||
| UICT_DataExchangeInstruction3 | ||||
| UICT_DataExchangeInstruction4 | ||||
| UICT_NetPaymentAmount | ||||
| UICT_PaymentReference | ||||
| UICT_AmountInPaymentCurrency | ||||
| UICT_SEPAMandate | ||||
| UICT_HasPaymentOrder | ||||
| UICT_PaymentReason | ||||
| UICT_CashDiscountBaseAmount | ||||
| UICT_CashDiscountAmount | ||||
| UICT_IsNotCashDiscountLiable | ||||
| UICT_DueCalculationBaseDate | ||||
| UICT_PaymentTerms | ||||
| UICT_CashDiscount1Days | ||||
| UICT_CashDiscount1Percent | ||||
| UICT_CashDiscount2Days | ||||
| UICT_CashDiscount2Percent | ||||
| UICT_NetPaymentDays | ||||
| UICT_FixedCashDiscount | ||||
| UICT_PurchasingDocument | ||||
| UICT_PurchasingDocumentItem | ||||
| UICT_BillingDocument | ||||
| UICT_InvoiceList | ||||
| UICT_InvoiceReference | ||||
| UICT_FollowOnDocumentType | ||||
| UICT_InvoiceRefFiscalYear | ||||
| UICT_InvoiceItemReference | ||||
| UICT_SpecialGLAcctAssignment | ||||
| UICT_SpecialGLCode | ||||
| UICT_DunningArea | ||||
| UICT_LastDunningDate | ||||
| UICT_DunningBlockingReason | ||||
| UICT_DunningLevel | ||||
| UICT_DunningKey | ||||
| UICT_PaymentDifferenceReason | ||||
| UICT_AssetClass | ||||
| UICT_MasterFixedAsset | ||||
| UICT_FixedAsset | ||||
| UICT_AssetTransactionType | ||||
| UICT_AssetValueDate | ||||
| UICT_TaxCode | ||||
| UICT_TaxJurisdiction | ||||
| UICT_TaxBaseAmountInCoCodeCrcy | ||||
| UICT_TaxBaseAmountInTransCrcy | ||||
| UICT_WithholdingTaxCode | ||||
| UICT_WithholdingTaxAmount | ||||
| UICT_WhgdTaxExemptionAmt | ||||
| UICT_WithholdingTaxCertificate | ||||
| UICT_WithholdingTaxBaseAmount | ||||
| UICT_IsEUTriangularDeal | ||||
| UICT_VATRegistration | ||||
| UICT_Region | ||||
| UICT_TaxDeterminationDate | ||||
| UICT_TaxRateValidityStartDate | ||||
| UICT_TaxCountry | ||||
| UICT_BusinessPlace | ||||
| UICT_SupplyingCountry | ||||
| UICT_StateCntrlBkPaymentReason | ||||
| UICT_CashLedgerCompanyCode | ||||
| UICT_CashLedgerAccount | ||||
| UICT_PubSecBudgetAccount | ||||
| UICT_JointVenture | ||||
| UICT_JointVentureEquityGroup | ||||
| UICT_JntVntrCostRecoveryCode | ||||
| UICT_JointVentureEquityType | ||||
| UICT_WithholdingTaxItem | ||||
| UICT_CreditAmountInAddlCrcy1 | ||||
| UICT_DebitAmountInAddlCrcy1 | ||||
| UICT_CreditAmountInAddlCrcy2 | ||||
| UICT_DebitAmountInAddlCrcy2 | ||||
| UICT_FinancialManagementArea | ||||
| UICT_FundsCenter | ||||
| UICT_FundedProgram | ||||
| UICT_Fund | ||||
| UICT_GrantID | ||||
| UICT_BudgetPeriod | ||||
| UICT_PartnerFund | ||||
| UICT_PartnerGrant | ||||
| UICT_PartnerBudgetPeriod | ||||
| UICT_PubSecBudgetAccountCoCode | ||||
| UICT_ProfitabilitySegment | ||||
| UICT_OplAcctgDocItmCSRef1 | ||||
| UICT_GloMetadata | ||||
| UICT_DelivOfGdsReportingCntry | ||||
| UICT_PaytSlipWthRefReference | ||||
| UICT_RecrrgSuplrInvcIsSrvcInvc | ||||
| UICT_AcctgDocItmCstmsTrifNmbr | ||||
| UICT_AcctgDocItmCstmsClrnceDte | ||||
| UICT_ClrgIsLdgrGroupSpecific | ||||
| UICT_InvcItmIsExcldFrmPromptPA | ||||
| UICT_IntrstCalcBlockReason | ||||
| UICT_CreditAmountInCoCodeCrcy | ||||
| UICT_DebitAmountInCoCodeCrcy | ||||
| UICT_CreditAmountInTransCrcy | ||||
| UICT_DebitAmountInTransCrcy | ||||
| UICT_CreditAmtInFunctionalCrcy | ||||
| UICT_DebitAmtInFunctionalCrcy | ||||
| UICT_CreditAmtInBalTransCrcy | ||||
| UICT_DebitAmtInBalTransCrcy | ||||
| CostElementIsHdn | ||||
| AlternativeGLAccountIsHdn | ||||
| ServiceDocumentTypeIsHdn | ||||
| ServiceDocumentIsHdn | ||||
| ServiceDocumentItemIsHdn | ||||
| OperationalGLAccountIsHdn | ||||
| CreditControlAreaIsHdn | ||||
| ARIsPledgedIsHdn | ||||
| AcctsRblPledgingCodeIsHdn | ||||
| CustomerIsInExecutionIsHdn | ||||
| CustomerGroupIsHdn | ||||
| CustomerSupplierCountryIsHdn | ||||
| CustomerSupplierIndustryIsHdn | ||||
| SuplrInvcIsCptlGdsReltdIsHdn | ||||
| AssetContractIsHdn | ||||
| BillOfExchangeUsageIsHdn | ||||
| ReferenceDocumentTypeIsHdn | ||||
| ChartOfAccountsIsHdn | ||||
| FiscalPeriodIsHdn | ||||
| PostingDateIsHdn | ||||
| DocumentDateIsHdn | ||||
| AccountingDocumentTypeIsHdn | ||||
| SpecialGLTransactionTypeIsHdn | ||||
| OriginalReferenceDocumentIsHdn | ||||
| NetDueDateIsHdn | ||||
| CashDiscount1DueDateIsHdn | ||||
| CashDiscount2DueDateIsHdn | ||||
| PaymentCardItemIsHdn | ||||
| PaytCardPaytSettlmtIsHdn | ||||
| PaymentServiceProviderIsHdn | ||||
| PaytRefByPaytSrvcPrvdrIsHdn | ||||
| TaxTypeIsHdn | ||||
| TaxSectionIsHdn | ||||
| PartnerFunctionalAreaIsHdn | ||||
| DynamicalMetadataString | ||||
| TaxCalculationProcedure | ||||
| _WithholdingTaxItem | _WithholdingTaxItem |
@ObjectModel.query.implementedBy: 'ABAP:CL_SIMULATEDJOURNALENTRY_QUERY'
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #NOT_REQUIRED
}
@Metadata.allowExtensions: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Simulated Journal Entry Item'
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #M,
dataClass: #MIXED
}
@UI.headerInfo: {
typeName: 'Line Item in Entry View',
typeNamePlural: 'Line Items in Entry View',
title: {
value: 'AccountingDocumentItem',
label: 'Journal Entry Item'
},
description: { type: #STANDARD, value: 'DocumentItemText' }
}
@UI.presentationVariant: [{
sortOrder: [{
by: 'AccountingDocumentItem',
direction: #ASC
}]
}]
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view entity C_SimulatedJournalEntryItem
as select from R_ManageJournalEntryItem
association [1..1] to E_OperationalAcctgDocItem as _Extension on $projection.CompanyCode = _Extension.CompanyCode
and $projection.FiscalYear = _Extension.FiscalYear
and $projection.AccountingDocument = _Extension.AccountingDocument
and $projection.AccountingDocumentItem = _Extension.AccountingDocumentItem
association [0..*] to C_SmltdJrnlEntrWhldgTaxItem as _WithholdingTaxItem on $projection.TemporaryAccountingDocument = _WithholdingTaxItem.TemporaryAccountingDocument
and $projection.TmpAccountingDocumentType = _WithholdingTaxItem.TmpAccountingDocumentType
and $projection.TmpAcctgDocSpecificationArea = _WithholdingTaxItem.TmpAcctgDocSpecificationArea
and $projection.TmpAcctgDocumentCreatedByUser = _WithholdingTaxItem.TmpAcctgDocumentCreatedByUser
and $projection.AccountingDocumentItem = _WithholdingTaxItem.AccountingDocumentItem
association [1..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.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_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_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_AssetTransactionTypeText as _AssetTransactionTypeText on $projection.AssetTransactionType = _AssetTransactionTypeText.AssetTransactionType
and _AssetTransactionTypeText.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_ProductText as _ProductText on $projection.Product = _ProductText.Product
and _ProductText.Language = $session.system_language
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
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 '' = _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 '' = _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_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_DunningAreaText as _DunningAreaText on $projection.CompanyCode = _DunningAreaText.CompanyCode
and $projection.DunningArea = _DunningAreaText.DunningArea
and _DunningAreaText.Language = $session.system_language
association [0..1] to I_FixedCashDiscountTypeText as _FixedCashDiscountTypeText on $projection.FixedCashDiscount = _FixedCashDiscountTypeText.FixedCashDiscount
and _FixedCashDiscountTypeText.Language = $session.system_language
association [0..1] to I_CountryText as _SupplyingCountryText on $projection.SupplyingCountry = _SupplyingCountryText.Country
and _SupplyingCountryText.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_CountryText as _CustomerSupplierCountryText on $projection.CustomerSupplierCountry = _CustomerSupplierCountryText.Country
and _CustomerSupplierCountryText.Language = $session.system_language
association [0..1] to I_Housebank as _HouseBank on $projection.HouseBank = _HouseBank.HouseBank
and $projection.CompanyCode = _HouseBank.CompanyCode
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_CountryText as _TaxCountryText on $projection.TaxCountry = _TaxCountryText.Country
and _TaxCountryText.Language = $session.system_language
association [0..1] to I_TaxCodeText as _TaxCodeText on $projection.TaxCode = _TaxCodeText.TaxCode
// and $projection.TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure
and _TaxCodeText.Language = $session.system_language
association [0..1] to I_WorkforcePersonMappings_1 as _WorkForcePersonMappings on $projection.PersonnelNumber = _WorkForcePersonMappings.WorkAssignment
association [0..1] to I_PaymentDifferenceReasonT as _PaymentDifferenceReasonText on $projection.CompanyCode = _PaymentDifferenceReasonText.CompanyCode
and $projection.PaymentDifferenceReason = _PaymentDifferenceReasonText.PaymentDifferenceReason
and _PaymentDifferenceReasonText.Language = $session.system_language
{
key cast('' as fdc_accdoc_tmp_doc_id) as TemporaryAccountingDocument,
key cast('' as fdc_accdoc_tmp_doc_type preserving type ) as TmpAccountingDocumentType,
key cast('' as indx_relid) as TmpAcctgDocSpecificationArea,
key cast('' as username) as TmpAcctgDocumentCreatedByUser,
@UI: {lineItem: [{ position: 10 }]}
key AccountingDocumentItem,
@ObjectModel.text.element: [ 'CompanyCodeName' ]
@UI.textArrangement: #TEXT_LAST
CompanyCode,
FiscalYear,
AccountingDocument,
@Semantics.text: true
cast(_CompanyCode.CompanyCodeName as fis_butxt preserving type) as CompanyCodeName,
_CompanyCode.Country,
ChartOfAccounts,
ClearingDate,
ClearingCreationDate,
ClearingJournalEntry,
@ObjectModel.text.element: [ 'PostingKeyName' ]
@UI.textArrangement: #TEXT_LAST
PostingKey,
@Semantics.text: true
_PostingKeyText.PostingKeyName,
FinancialAccountType,
@ObjectModel.text.element: [ 'SpecialGLCodeName' ]
@UI.textArrangement: #TEXT_LAST
SpecialGLCode,
@Semantics.text: true
cast(_SpecialGLCodeText.SpecialGLCodeLongName as specialglcodelongname preserving type) as SpecialGLCodeName,
SpecialGLTransactionType,
DebitCreditCode,
@ObjectModel.text.element: [ 'BusinessAreaName' ]
@UI.textArrangement: #TEXT_LAST
BusinessArea,
@Semantics.text: true
_BusinessAreaText.BusinessAreaName,
@ObjectModel.text.element: [ 'PartnerBusinessAreaName' ]
@UI.textArrangement: #TEXT_LAST
PartnerBusinessArea,
@Semantics.text: true
cast(_PartnerBusinessAreaText.BusinessAreaName as fis_partner_busarea_name preserving type) as PartnerBusinessAreaName,
@ObjectModel.text.element: [ 'TaxCodeName' ]
@UI.textArrangement: #TEXT_LAST
TaxCode,
@Semantics.text: true
_TaxCodeText.TaxCodeName,
@UI.hidden: true
WithholdingTaxCode,
TaxType,
TransactionTypeDetermination,
ValueDate,
AssignmentReference,
DocumentItemText,
@ObjectModel.text.element: [ 'PartnerCompanyName' ]
@UI.textArrangement: #TEXT_LAST
PartnerCompany,
@Semantics.text: true
cast(_PartnerCompany.CompanyName as fis_rassc_name preserving type) as PartnerCompanyName,
@ObjectModel.text.element: [ 'FinancialTransactionTypeName' ]
@UI.textArrangement: #TEXT_LAST
FinancialTransactionType,
@Semantics.text: true
cast(_FinancialTransactionTypeT.FinancialTransactionTypeName as fincs_fintransactiontypename preserving type) as FinancialTransactionTypeName,
CorporateGroupAccount,
PlanningLevel,
@ObjectModel.text.element: [ 'ControllingAreaName' ]
@UI.textArrangement: #TEXT_LAST
ControllingArea,
@Semantics.text: true
_ControllingArea.ControllingAreaName,
@ObjectModel.text.element: [ 'CostCenterName' ]
@UI.textArrangement: #TEXT_LAST
CostCenter,
@Semantics.text: true
_CostCenterText.CostCenterName,
//ProjectInternalID, -- to be retrieved later from WBS Element
OrderID,
BillingDocument,
SalesDocument,
SalesDocumentItem,
ScheduleLine,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
@ObjectModel.text.element: [ 'MasterFixedAssetDescription' ]
@UI.textArrangement: #TEXT_LAST
MasterFixedAsset,
@Semantics.text: true
_MasterFixedAsset.MasterFixedAssetDescription,
FixedAsset,
@ObjectModel.text.element: [ 'MasterFixedAssetDescription' ]
@UI.textArrangement: #TEXT_LAST
cast( case when FixedAsset = '0000' then concat(ltrim(MasterFixedAsset, '0'), '-0')
when FixedAsset = '' then ''
else concat(concat( ltrim(MasterFixedAsset, '0') , '-'), ltrim(FixedAsset, '0' ))
end as fis_fixedasset_ext_id ) as FixedAssetExternalID,
@ObjectModel.text.element: [ 'AssetTransactionTypeName' ]
@UI.textArrangement: #TEXT_LAST
AssetTransactionType,
@Semantics.text: true
cast(_AssetTransactionTypeText.AssetTransactionTypeName as assettransactiontypename preserving type) as AssetTransactionTypeName,
AssetValueDate,
PersonnelNumber,
_WorkForcePersonMappings.WorkAssignmentExternalID,
@Semantics.booleanIndicator
IsSalesRelated,
@Semantics.booleanIndicator
LineItemDisplayIsEnabled,
@Semantics.booleanIndicator
IsOpenItemManaged,
@Semantics.booleanIndicator
IsNotCashDiscountLiable,
@Semantics.booleanIndicator
IsAutomaticallyCreated,
@Semantics.booleanIndicator
IsUsedInPaymentTransaction,
OperationalGLAccount,
@UI: {
lineItem: [{ position: 20 }],
textArrangement: #TEXT_LAST
}
@ObjectModel.text.element: [ 'GLAccountName' ]
GLAccount,
@Semantics.text: true
_GLAccountText.GLAccountName,
_GLAccountText.GLAccountLongName,
@ObjectModel.text.element: [ 'CustomerName' ]
@UI.textArrangement: #TEXT_LAST
Customer,
@Semantics.text: true
cast(_Customer.CustomerName as fis_customer_name preserving type) as CustomerName,
@ObjectModel.text.element: [ 'SupplierName' ]
@UI.textArrangement: #TEXT_LAST
Supplier,
@Semantics.text: true
cast(_Supplier.SupplierName as suppliername preserving type) as SupplierName,
BranchAccount,
IsBalanceSheetAccount,
ProfitLossAccountType,
SpecialGLAccountAssignment,
DueCalculationBaseDate,
@ObjectModel.text.element: [ 'PaymentTermsName' ]
@UI.textArrangement: #TEXT_LAST
PaymentTerms,
@Semantics.text: true
cast(_PaymentTermsText.PaymentTermsName as paymenttermsname preserving type) as PaymentTermsName,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
CashDiscountBaseAmount,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
CashDiscountAmount,
CashDiscount1Days,
CashDiscount2Days,
NetPaymentDays,
CashDiscount1Percent,
CashDiscount2Percent,
PaymentMethod,
@ObjectModel.text.element: [ 'PaymentBlockingReasonName' ]
@UI.textArrangement: #TEXT_LAST
PaymentBlockingReason,
@Semantics.text: true
_PaymentBlockingReasonText.PaymentBlockingReasonName,
@ObjectModel.text.element: [ 'UtilsDiscountTypeDescription' ]
@UI.textArrangement: #TEXT_LAST
FixedCashDiscount,
@Semantics.text: true
cast(_FixedCashDiscountTypeText.UtilsDiscountTypeDescription as fixedcashdiscountname preserving type) as UtilsDiscountTypeDescription,
@ObjectModel.text.element: [ 'HouseBankName' ]
@UI.textArrangement: #TEXT_LAST
HouseBank,
@Semantics.text: true
cast( _HouseBank._Bank.BankName as farp_banka preserving type) as HouseBankName,
BPBankAccountInternalID,
// TaxDistributionCode1,
// TaxDistributionCode2,
// TaxDistributionCode3,
InvoiceReference,
InvoiceReferenceFiscalYear,
InvoiceItemReference,
FollowOnDocumentType,
StateCentralBankPaymentReason,
@ObjectModel.text.element: [ 'SupplyingCountryName' ]
@UI.textArrangement: #TEXT_LAST
SupplyingCountry,
@Semantics.text: true
cast(_SupplyingCountryText.CountryName as supplyingcountryname preserving type) as SupplyingCountryName,
InvoiceList,
BillOfExchangeUsage,
DunningKey,
DunningBlockingReason,
LastDunningDate,
DunningLevel,
@ObjectModel.text.element: [ 'DunningAreaName' ]
@UI.textArrangement: #TEXT_LAST
DunningArea,
@Semantics.text: true
_DunningAreaText.DunningAreaName,
@UI.hidden: true
WithholdingTaxCertificate,
@ObjectModel.text.element: [ 'ProductName' ]
@UI.textArrangement: #TEXT_LAST
Product,
@Semantics.text: true
cast(_ProductText.ProductName as productdescription preserving type ) as ProductName,
@ObjectModel.text.element: [ 'PlantName' ]
@UI.textArrangement: #TEXT_LAST
Plant,
@Semantics.text: true
_Plant.PlantName,
PurchasingDocument,
PurchasingDocumentItem,
AccountAssignmentNumber,
@Semantics.booleanIndicator
LineItemIsCompleted,
MaterialPriceControl,
ValuationArea,
InventoryValuationType,
VATRegistration,
DelivOfGoodsDestCountry,
@UI.textArrangement: #TEXT_LAST
@ObjectModel.text.element: [ 'PaymentDifferenceReasonName' ]
PaymentDifferenceReason,
@Semantics.text: true
cast(_PaymentDifferenceReasonText.PaymentDifferenceReasonName as paymentdifferencereasonname preserving type) as PaymentDifferenceReasonName,
@UI.textArrangement: #TEXT_LAST
@ObjectModel.text.element: [ 'ProfitCenterName' ]
ProfitCenter,
@Semantics.text: true
_ProfitCenterText.ProfitCenterName,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
TreasuryContractType,
AssetContract,
CashFlowType,
TaxJurisdiction,
REInternalFinNumber,
SettlementReferenceDate,
//CommitmentItem, conversion exit error
@UI.hidden: true
CommitmentItemShortID,
CostObject,
ProjectNetwork,
OrderInternalBillOfOperations,
OrderIntBillOfOperationsItem,
@ObjectModel.text.element: [ 'WBSDescription' ]
@UI.textArrangement: #TEXT_LAST
_WBSElementBasicData.WBSElementExternalID,
@UI.hidden: true
WBSElementInternalID,
@Semantics.text: true
_WBSElementBasicData.WBSDescription,
@UI.hidden: true
ProfitabilitySegment,
JointVentureEquityType,
IsEUTriangularDeal,
CostOriginGroup,
CompanyCodeCurrencyDetnMethod,
ClearingIsReversed,
PaymentMethodSupplement,
AlternativeGLAccount,
@ObjectModel.text.element: [ 'PartnerProfitCenterName' ]
@UI.textArrangement: #TEXT_LAST
PartnerProfitCenter,
@Semantics.text: true
cast(_PartnerProfitCenterText.ProfitCenterName as fis_partner_prctr_short_name preserving type) as PartnerProfitCenterName,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
IsNegativePosting,
PaymentCardItem,
PaymentCardPaymentSettlement,
CreditControlArea,
Reference3IDByBusinessPartner,
DataExchangeInstruction1,
DataExchangeInstruction2,
DataExchangeInstruction3,
DataExchangeInstruction4,
Region,
HasPaymentOrder,
PaymentReference,
TaxDeterminationDate,
ClearingItem,
BusinessPlace,
TaxSection,
@ObjectModel.text.element: [ 'CostCtrActivityTypeName' ]
@UI.textArrangement: #TEXT_LAST
CostCtrActivityType,
@Semantics.text: true
_CostCtrActivityTypeT.CostCtrActivityTypeName as CostCtrActivityTypeName,
@Semantics.booleanIndicator
AccountsReceivableIsPledged,
AcctsReceivablePledgingCode,
BusinessProcess,
@ObjectModel.text.element: [ 'FunctionalAreaName' ]
@UI.textArrangement: #TEXT_LAST
FunctionalArea,
@Semantics.text: true
_FunctionalAreaText.FunctionalAreaName,
CustomerIsInExecution,
ClearingJournalEntryFiscalYear,
LedgerGLLineItem,
@ObjectModel.text.element: [ 'SegmentName' ]
@UI.textArrangement: #TEXT_LAST
Segment,
@Semantics.text: true
_SegmentText.SegmentName,
@ObjectModel.text.element: [ 'PartnerSegmentName' ]
@UI.textArrangement: #TEXT_LAST
PartnerSegment,
@Semantics.text: true
cast(_PartnerSegmentText.SegmentName as fis_partner_segment_name preserving type) as PartnerSegmentName,
@ObjectModel.text.element: [ 'PartnerFunctionalAreaName' ]
@UI.textArrangement: #TEXT_LAST
PartnerFunctionalArea,
@Semantics.text: true
cast(_PartnerFunctionalAreaText.FunctionalAreaName as fis_pfkbtx preserving type) as PartnerFunctionalAreaName,
@ObjectModel.text.element: [ 'HouseBankAccountDescription' ]
@UI.textArrangement: #TEXT_LAST
HouseBankAccount,
@Semantics.text: true
cast(_HouseBankAccountText.HouseBankAccountDescription as /pf1/dte_housebank_acct_desc preserving type) as HouseBankAccountDescription,
CostElement,
PaymentServiceProvider,
PaymentRefByPaytSrvcProvider,
SEPAMandate,
ReferenceDocumentType,
OriginalReferenceDocument,
ReferenceDocumentLogicalSystem,
AccountingDocumentItemRef,
@Semantics.fiscal.period: true
FiscalPeriod,
AccountingDocumentCategory,
PostingDate,
DocumentDate,
AccountingDocumentType,
NetDueDate,
CashDiscount1DueDate,
CashDiscount2DueDate,
OffsettingAccount,
OffsettingAccountType,
OffsettingChartOfAccounts,
@ObjectModel.text.element: [ 'CashLedgerCompanyCodeName' ]
@UI.textArrangement: #TEXT_LAST
CashLedgerCompanyCode,
@Semantics.text: true
cast(_CashLedgerCompanyCode.CompanyCodeName as cashledgercompanycodename preserving type) as CashLedgerCompanyCodeName,
@ObjectModel.text.element: [ 'CashLedgerAccountName' ]
@UI.textArrangement: #TEXT_LAST
CashLedgerAccount,
@Semantics.text: true
cast(_CashLedgerAccountText.GLAccountName as fis_re_account_name preserving type) as CashLedgerAccountName,
@UI.hidden: true
cast('' as fikrs) as FinancialManagementArea,
@UI.hidden: true
FundsCenter,
@UI.hidden: true
FundedProgram,
@ObjectModel.text.element: [ 'FundName' ]
@UI.textArrangement: #TEXT_LAST
Fund,
@Semantics.text: true
_FundText.FundName,
@ObjectModel.text.element: [ 'GrantName' ]
@UI.textArrangement: #TEXT_LAST
GrantID,
@Semantics.text: true
cast(_GrantText.GrantName as ftr_gen_grant_name preserving type) as GrantName,
@ObjectModel.text.element: [ 'BudgetPeriodName' ]
@UI.textArrangement: #TEXT_LAST
BudgetPeriod,
@Semantics.text: true
_BudgetPeriodText.BudgetPeriodName,
@ObjectModel.text.element: [ 'ReceiverPostedFundName' ]
@UI.textArrangement: #TEXT_LAST
PartnerFund,
@Semantics.text: true
cast(_PartnerFundText.FundName as receiverpostedfundname preserving type) as ReceiverPostedFundName,
@ObjectModel.text.element: [ 'ReceiverPostedGrantName' ]
@UI.textArrangement: #TEXT_LAST
PartnerGrant,
@Semantics.text: true
cast(_PartnerGrantText.GrantName as receiverpostedgrantname preserving type) as ReceiverPostedGrantName,
@ObjectModel.text.element: [ 'ReceiverPostedBudgetPeriodName' ]
@UI.textArrangement: #TEXT_LAST
PartnerBudgetPeriod,
@Semantics.text: true
cast(_PartnerBudgetPeriodText.BudgetPeriodName as receiverpostedbudgetperiodname preserving type) as ReceiverPostedBudgetPeriodName,
@ObjectModel.text.element: [ 'BudgetAccountName' ]
@UI.textArrangement: #TEXT_LAST
PubSecBudgetAccount,
@Semantics.text: true
_BudgetAccountText.BudgetAccountName,
PubSecBudgetAccountCoCode,
CompanyCodeCurrency,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
@UI.hidden: true
AmountInCompanyCodeCurrency,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
CreditAmountInCoCodeCrcy,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
DebitAmountInCoCodeCrcy,
FunctionalCurrency,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
@UI.hidden: true
AmountInFunctionalCurrency,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
CreditAmountInFunctionalCrcy,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
DebitAmountInFunctionalCrcy,
TransactionCurrency,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
@UI.hidden: true
AmountInTransactionCurrency,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
CreditAmountInTransCrcy,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
DebitAmountInTransCrcy,
BalanceTransactionCurrency,
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
CreditAmountInBalanceTransCrcy,
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
DebitAmountInBalanceTransCrcy,
AdditionalCurrency1,
@EndUserText.label: 'Credit Amount in Additional Currency 1'
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
CreditAmountInAddlCrcy1,
@EndUserText.label: 'Debit Amount in Additional Currency 1'
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
DebitAmountInAddlCrcy1,
AdditionalCurrency2,
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
@EndUserText.label: 'Credit Amount in Additional Currency 2'
CreditAmountInAddlCrcy2,
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
@EndUserText.label: 'Debit Amount in Additional Currency 2'
DebitAmountInAddlCrcy2,
BaseUnit,
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
Quantity,
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
AbsoluteQuantity,
GoodsMovementEntryUnit,
@Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} }
QuantityInEntryUnit,
PurchasingDocumentPriceUnit,
@Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} }
PurchaseOrderQty,
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
MaterialPriceUnitQty,
EarmarkedFundsDocument,
EarmarkedFundsDocumentItem,
PaytSlipWthRefReference,
TaxRateValidityStartDate,
PaytSlipWthRefCheckDigit,
PaytSlipWthRefSubscriber,
PaymentReason,
BranchCode,
PaymentCurrency,
@Semantics: { amount : {currencyCode: 'PaymentCurrency'} }
AmountInPaymentCurrency,
@Semantics: { amount : {currencyCode: 'PaymentCurrency'} }
NetPaymentAmount,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
TaxBaseAmountInCoCodeCrcy,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
TaxBaseAmountInTransCrcy,
@UI.hidden: true
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
WithholdingTaxAmount,
@UI.hidden: true
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
WithholdingTaxExemptionAmt,
@UI.hidden: true
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
WithholdingTaxBaseAmount,
@ObjectModel.text.element: [ 'TaxCountryName' ]
@UI.textArrangement: #TEXT_LAST
TaxCountry,
@Semantics.text: true
cast(_TaxCountryText.CountryName as fot_tax_country_descr preserving type) as TaxCountryName,
@Semantics.booleanIndicator
@UI.hidden: true
AddressAndBankIsSetManually,
@Semantics.booleanIndicator
@UI.hidden: true
cast ( '' as xcpdk ) as IsOneTimeAccount,
// @Semantics.booleanIndicator
// @UI.hidden: true
// AlternativePayeeIsAllowed,
// @Semantics.booleanIndicator
// @UI.hidden: true
// AddressIsChangedManually,
@Semantics.booleanIndicator
@UI.hidden: true
cast( '' as farp_isalternativepayer preserving type ) as PayerIsAlternativePayer,
@Semantics.booleanIndicator
@UI.hidden: true
cast( '' as farp_isalternativepayee preserving type ) as PayeeIsAlternativePayee,
OplAcctgDocItmCntrySpcfcRef1,
@ObjectModel.text.element: [ 'CustomerGroupName' ]
@UI.textArrangement: #TEXT_LAST
CustomerGroup,
@Semantics.text: true
cast(_CustomerGroupText.CustomerGroupName as fincs_customergroupname preserving type) as CustomerGroupName,
@ObjectModel.text.element: [ 'CustomerSupplierCountryName' ]
@UI.textArrangement: #TEXT_LAST
CustomerSupplierCountry,
@Semantics.text: true
cast(_CustomerSupplierCountryText.CountryName as fincs_land1_t preserving type) as CustomerSupplierCountryName,
@ObjectModel.text.element: [ 'CustomerSupplierIndustryName' ]
@UI.textArrangement: #TEXT_LAST
CustomerSupplierIndustry,
@Semantics.text: true
_CustomerSupplierIndustryText.CustomerSupplierIndustryName as CustomerSupplierIndustryName,
@Feature: 'SW:FINS_FS_ACCDIM'
@ObjectModel.text.element: [ 'FinServicesProductGroupName' ]
@UI.textArrangement: #TEXT_LAST
FinancialServicesProductGroup,
@Feature: 'SW:FINS_FS_ACCDIM'
@Semantics.text: true
_FinServicesProductGroupT.FinServicesProductGroupName as FinServicesProductGroupName,
@Feature: 'SW:FINS_FS_ACCDIM'
@ObjectModel.text.element: [ 'FinancialServicesBranchName' ]
@UI.textArrangement: #TEXT_LAST
FinancialServicesBranch,
@Feature: 'SW:FINS_FS_ACCDIM'
@Semantics.text: true
_FinancialServicesBranchT.FinancialServicesBranchName as FinancialServicesBranchName,
@Feature: 'SW:FINS_FS_ACCDIM'
@ObjectModel.text.element: [ 'FinancialDataSourceName' ]
@UI.textArrangement: #TEXT_LAST
FinancialDataSource,
@Feature: 'SW:FINS_FS_ACCDIM'
@Semantics.text: true
_FinancialDataSourceT.FinancialDataSourceName as FinancialDataSourceName,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
CashDiscountAmtInCoCodeCrcy,
@UI.hidden: true
AccountingDocumentItemType,
// @ObjectModel.filter.enabled: false
// @ObjectModel.sort.enabled: false
// @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MJE_ITEM_FIELDS_CALC'
// @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CountryVH', element: 'Country' } }]
// @ObjectModel.text.element: [ 'DelivOfGoodsReportingCntryName' ]
// @UI.textArrangement: #TEXT_LAST
// DeliveryOfGoodsReportingCntry,
// @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MJE_ITEM_FIELDS_CALC'
// @Semantics.text: true
// @UI.hidden: true
// '' as DelivOfGoodsReportingCntryName : landx50,
@Semantics.booleanIndicator
RecrrgSuplrInvcIsSrvcInvoice,
@Semantics.booleanIndicator
SuplrInvcIsCapitalGoodsRelated,
AcctgDocItmCustomsTariffNumber,
AcctgDocItmCstmsClearanceDate,
@Semantics.booleanIndicator
ClearingIsLedgerGroupSpecific,
@Semantics.booleanIndicator
InvcItmIsExcldFrmPromptPaytAct,
InterestCalculationBlockReason,
@UI.hidden: true
'' as UICT_CreditAmount,
@UI.hidden: true
'' as UICT_DebitAmount,
@UI.hidden: true
'' as UICT_FinancialTransactionType,
@UI.hidden: true
'' as UICT_PostingKey,
@UI.hidden: true
'' as UICT_Customer,
@UI.hidden: true
'' as UICT_Supplier,
@UI.hidden: true
'' as UICT_BranchAccount,
@UI.hidden: true
'' as UICT_PartnerCompany,
@UI.hidden: true
'' as UICT_GLAccount,
@UI.hidden: true
'' as UICT_DocumentItemText,
@UI.hidden: true
'' as UICT_AssignmentReference,
@UI.hidden: true
'' as UICT_Reference1IDByBizPartner,
@UI.hidden: true
'' as UICT_Reference2IDByBizPartner,
@UI.hidden: true
'' as UICT_Reference3IDByBizPartner,
@UI.hidden: true
'' as UICT_ClearingJournalEntry,
@UI.hidden: true
'' as UICT_ClearingDate,
@UI.hidden: true
'' as UICT_BranchCode,
@UI.hidden: true
'' as UICT_Quantity,
@UI.hidden: true
'' as UICT_CompanyCode,
@UI.hidden: true
'' as UICT_ControllingArea,
@UI.hidden: true
'' as UICT_Product,
@UI.hidden: true
'' as UICT_CostCenter,
@UI.hidden: true
'' as UICT_OrderID,
@UI.hidden: true
'' as UICT_WBSElementExternalID,
@UI.hidden: true
'' as UICT_SalesDocument,
@UI.hidden: true
'' as UICT_SalesDocumentItem,
@UI.hidden: true
'' as UICT_ScheduleLine,
@UI.hidden: true
'' as UICT_PersonnelNumber,
@UI.hidden: true
'' as UICT_ProjectNetwork,
@UI.hidden: true
'' as UICT_Plant,
@UI.hidden: true
'' as UICT_BusinessArea,
@UI.hidden: true
'' as UICT_PartnerBusinessArea,
@UI.hidden: true
'' as UICT_ProfitCenter,
@UI.hidden: true
'' as UICT_CostObject,
@UI.hidden: true
'' as UICT_PartnerProfitCenter,
@UI.hidden: true
'' as UICT_FunctionalArea,
@UI.hidden: true
'' as UICT_CostCtrActivityType,
@UI.hidden: true
'' as UICT_BusinessProcess,
@UI.hidden: true
'' as UICT_Segment,
@UI.hidden: true
'' as UICT_PartnerSegment,
@UI.hidden: true
'' as UICT_EarmarkedFundsDocument,
@UI.hidden: true
'' as UICT_EmrkdFundsDocumentItem,
@UI.hidden: true
'' as UICT_LineItemIsCompleted,
@UI.hidden: true
'' as UICT_ValueDate,
@UI.hidden: true
'' as UICT_PaymentMethod,
@UI.hidden: true
'' as UICT_PaymentMethodSupplement,
@UI.hidden: true
'' as UICT_PaymentBlockingReason,
@UI.hidden: true
'' as UICT_HouseBank,
@UI.hidden: true
'' as UICT_HouseBankAccount,
@UI.hidden: true
'' as UICT_BPBankAccountInternalID,
@UI.hidden: true
'' as UICT_DataExchangeInstruction1,
@UI.hidden: true
'' as UICT_DataExchangeInstruction2,
@UI.hidden: true
'' as UICT_DataExchangeInstruction3,
@UI.hidden: true
'' as UICT_DataExchangeInstruction4,
@UI.hidden: true
'' as UICT_NetPaymentAmount,
@UI.hidden: true
'' as UICT_PaymentReference,
@UI.hidden: true
'' as UICT_AmountInPaymentCurrency,
@UI.hidden: true
'' as UICT_SEPAMandate,
@UI.hidden: true
'' as UICT_HasPaymentOrder,
@UI.hidden: true
'' as UICT_PaymentReason,
@UI.hidden: true
'' as UICT_CashDiscountBaseAmount,
@UI.hidden: true
'' as UICT_CashDiscountAmount,
@UI.hidden: true
'' as UICT_IsNotCashDiscountLiable,
@UI.hidden: true
'' as UICT_DueCalculationBaseDate,
@UI.hidden: true
'' as UICT_PaymentTerms,
@UI.hidden: true
'' as UICT_CashDiscount1Days,
@UI.hidden: true
'' as UICT_CashDiscount1Percent,
@UI.hidden: true
'' as UICT_CashDiscount2Days,
@UI.hidden: true
'' as UICT_CashDiscount2Percent,
@UI.hidden: true
'' as UICT_NetPaymentDays,
@UI.hidden: true
'' as UICT_FixedCashDiscount,
@UI.hidden: true
'' as UICT_PurchasingDocument,
@UI.hidden: true
'' as UICT_PurchasingDocumentItem,
@UI.hidden: true
'' as UICT_BillingDocument,
@UI.hidden: true
'' as UICT_InvoiceList,
@UI.hidden: true
'' as UICT_InvoiceReference,
@UI.hidden: true
'' as UICT_FollowOnDocumentType,
@UI.hidden: true
'' as UICT_InvoiceRefFiscalYear,
@UI.hidden: true
'' as UICT_InvoiceItemReference,
@UI.hidden: true
'' as UICT_SpecialGLAcctAssignment,
@UI.hidden: true
'' as UICT_SpecialGLCode,
@UI.hidden: true
'' as UICT_DunningArea,
@UI.hidden: true
'' as UICT_LastDunningDate,
@UI.hidden: true
'' as UICT_DunningBlockingReason,
@UI.hidden: true
'' as UICT_DunningLevel,
@UI.hidden: true
'' as UICT_DunningKey,
@UI.hidden: true
'' as UICT_PaymentDifferenceReason,
@UI.hidden: true
'' as UICT_AssetClass,
@UI.hidden: true
'' as UICT_MasterFixedAsset,
@UI.hidden: true
'' as UICT_FixedAsset,
@UI.hidden: true
'' as UICT_AssetTransactionType,
@UI.hidden: true
'' as UICT_AssetValueDate,
@UI.hidden: true
'' as UICT_TaxCode,
@UI.hidden: true
'' as UICT_TaxJurisdiction,
@UI.hidden: true
'' as UICT_TaxBaseAmountInCoCodeCrcy,
@UI.hidden: true
'' as UICT_TaxBaseAmountInTransCrcy,
@UI.hidden: true
'' as UICT_WithholdingTaxCode,
@UI.hidden: true
'' as UICT_WithholdingTaxAmount,
@UI.hidden: true
'' as UICT_WhgdTaxExemptionAmt,
@UI.hidden: true
'' as UICT_WithholdingTaxCertificate,
@UI.hidden: true
'' as UICT_WithholdingTaxBaseAmount,
@UI.hidden: true
'' as UICT_IsEUTriangularDeal,
@UI.hidden: true
'' as UICT_VATRegistration,
@UI.hidden: true
'' as UICT_Region,
@UI.hidden: true
'' as UICT_TaxDeterminationDate,
@UI.hidden: true
'' as UICT_TaxRateValidityStartDate,
@UI.hidden: true
'' as UICT_TaxCountry,
@UI.hidden: true
'' as UICT_BusinessPlace,
@UI.hidden: true
'' as UICT_SupplyingCountry,
@UI.hidden: true
'' as UICT_StateCntrlBkPaymentReason,
@UI.hidden: true
'' as UICT_CashLedgerCompanyCode,
@UI.hidden: true
'' as UICT_CashLedgerAccount,
@UI.hidden: true
'' as UICT_PubSecBudgetAccount,
@UI.hidden: true
'' as UICT_JointVenture,
@UI.hidden: true
'' as UICT_JointVentureEquityGroup,
@UI.hidden: true
'' as UICT_JntVntrCostRecoveryCode,
@UI.hidden: true
'' as UICT_JointVentureEquityType,
@UI.hidden: true
'' as UICT_WithholdingTaxItem,
@UI.hidden: true
'' as UICT_CreditAmountInAddlCrcy1,
@UI.hidden: true
'' as UICT_DebitAmountInAddlCrcy1,
@UI.hidden: true
'' as UICT_CreditAmountInAddlCrcy2,
@UI.hidden: true
'' as UICT_DebitAmountInAddlCrcy2,
@UI.hidden: true
'' as UICT_FinancialManagementArea,
@UI.hidden: true
'' as UICT_FundsCenter,
@UI.hidden: true
'' as UICT_FundedProgram,
@UI.hidden: true
'' as UICT_Fund,
@UI.hidden: true
'' as UICT_GrantID,
@UI.hidden: true
'' as UICT_BudgetPeriod,
@UI.hidden: true
'' as UICT_PartnerFund,
@UI.hidden: true
'' as UICT_PartnerGrant,
@UI.hidden: true
'' as UICT_PartnerBudgetPeriod,
@UI.hidden: true
'' as UICT_PubSecBudgetAccountCoCode,
@UI.hidden: true
'' as UICT_ProfitabilitySegment,
@UI.hidden: true
'' as UICT_OplAcctgDocItmCSRef1,
@UI.hidden: true
cast ('' as abap.sstring( 1332 )) as UICT_GloMetadata,
//
// @UI.hidden: true
// '' as UICT_CommitmentItemShortID,
@UI.hidden: true
'' as UICT_DelivOfGdsReportingCntry,
@UI.hidden: true
'' as UICT_PaytSlipWthRefReference,
@UI.hidden: true
'' as UICT_RecrrgSuplrInvcIsSrvcInvc,
@UI.hidden: true
'' as UICT_AcctgDocItmCstmsTrifNmbr,
@UI.hidden: true
'' as UICT_AcctgDocItmCstmsClrnceDte,
@UI.hidden: true
'' as UICT_ClrgIsLdgrGroupSpecific,
@UI.hidden: true
'' as UICT_InvcItmIsExcldFrmPromptPA,
@UI.hidden: true
'' as UICT_IntrstCalcBlockReason,
@UI.hidden: true
'' as UICT_CreditAmountInCoCodeCrcy,
@UI.hidden: true
'' as UICT_DebitAmountInCoCodeCrcy,
@UI.hidden: true
'' as UICT_CreditAmountInTransCrcy,
@UI.hidden: true
'' as UICT_DebitAmountInTransCrcy,
@UI.hidden: true
'' as UICT_CreditAmtInFunctionalCrcy,
@UI.hidden: true
'' as UICT_DebitAmtInFunctionalCrcy,
@UI.hidden: true
'' as UICT_CreditAmtInBalTransCrcy,
@UI.hidden: true
'' as UICT_DebitAmtInBalTransCrcy,
@UI.hidden: true
'' as CostElementIsHdn,
@UI.hidden: true
'' as AlternativeGLAccountIsHdn,
@UI.hidden: true
'' as ServiceDocumentTypeIsHdn,
@UI.hidden: true
'' as ServiceDocumentIsHdn,
@UI.hidden: true
'' as ServiceDocumentItemIsHdn,
@UI.hidden: true
'' as OperationalGLAccountIsHdn,
@UI.hidden: true
'' as CreditControlAreaIsHdn,
@UI.hidden: true
'' as ARIsPledgedIsHdn,
@UI.hidden: true
'' as AcctsRblPledgingCodeIsHdn,
@UI.hidden: true
'' as CustomerIsInExecutionIsHdn,
@UI.hidden: true
'' as CustomerGroupIsHdn,
@UI.hidden: true
'' as CustomerSupplierCountryIsHdn,
@UI.hidden: true
'' as CustomerSupplierIndustryIsHdn,
@UI.hidden: true
'' as SuplrInvcIsCptlGdsReltdIsHdn,
@UI.hidden: true
'' as AssetContractIsHdn,
@UI.hidden: true
'' as BillOfExchangeUsageIsHdn,
@UI.hidden: true
'' as ReferenceDocumentTypeIsHdn,
@UI.hidden: true
'' as ChartOfAccountsIsHdn,
@UI.hidden: true
'' as FiscalPeriodIsHdn,
@UI.hidden: true
'' as PostingDateIsHdn,
@UI.hidden: true
'' as DocumentDateIsHdn,
@UI.hidden: true
'' as AccountingDocumentTypeIsHdn,
@UI.hidden: true
'' as SpecialGLTransactionTypeIsHdn,
@UI.hidden: true
'' as OriginalReferenceDocumentIsHdn,
@UI.hidden: true
'' as NetDueDateIsHdn,
@UI.hidden: true
'' as CashDiscount1DueDateIsHdn,
@UI.hidden: true
'' as CashDiscount2DueDateIsHdn,
@UI.hidden: true
'' as PaymentCardItemIsHdn,
@UI.hidden: true
'' as PaytCardPaytSettlmtIsHdn,
@UI.hidden: true
'' as PaymentServiceProviderIsHdn,
@UI.hidden: true
'' as PaytRefByPaytSrvcPrvdrIsHdn,
@UI.hidden: true
'' as TaxTypeIsHdn,
// @UI.hidden: true
// '' as UICT_TaxDistributionCode1,
// @UI.hidden: true
// '' as UICT_TaxDistributionCode2,
// @UI.hidden: true
// '' as UICT_TaxDistributionCode3,
@UI.hidden: true
'' as TaxSectionIsHdn,
@UI.hidden: true
'' as PartnerFunctionalAreaIsHdn,
@UI.hidden: true
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
abap.string'' as DynamicalMetadataString,
@UI.hidden: true
cast('' as kalsm_d) as TaxCalculationProcedure,
_WithholdingTaxItem
}
where
CompanyCode = ''
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA