P_OperationalAcctgDocBrowser
P_OperationalAcctgDocBrowser
P_OperationalAcctgDocBrowser is a Composite CDS View that provides data about "P_OperationalAcctgDocBrowser" in SAP S/4HANA. It reads from 4 data sources (I_AddlLedgerOplAcctgDocItem, I_OperationalAcctgDocItem, I_OperationalAcctgDocItem, I_ParkedOplAcctgDocItem) and exposes 1174 fields with key fields AccountingDocumentCatGroup, CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 35 associations to related views. Part of development package FINS_FIS_FICO_APPS.
Data Sources (4)
| Source | Alias | Join Type |
|---|---|---|
| I_AddlLedgerOplAcctgDocItem | I_AddlLedgerOplAcctgDocItem | union_all |
| I_OperationalAcctgDocItem | I_OperationalAcctgDocItem | from |
| I_OperationalAcctgDocItem | I_OperationalAcctgDocItem | union_all |
| I_ParkedOplAcctgDocItem | I_ParkedOplAcctgDocItem | union_all |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_ClearingStatusSelection | fis_clearingstatusselection |
Associations (35)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_WBSElementBasicData | _WBSElementBasicData | $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID |
| [0..1] | I_SalesDocument | _SalesDocument | $projection.SalesDocument = _SalesDocument.SalesDocument |
| [0..1] | I_SalesDocumentItem | _SalesDocumentItem | $projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem |
| [0..1] | I_SrvcDocByDocumentType | _ServiceDocument | $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType and $projection.ServiceDocument = _ServiceDocument.ServiceDocument |
| [0..1] | I_CostCenter | _CurrentCostCenter | $projection.ControllingArea = _CurrentCostCenter.ControllingArea and $projection.CostCenter = _CurrentCostCenter.CostCenter and _CurrentCostCenter.ValidityStartDate <= $session.system_date and _CurrentCostCenter.ValidityEndDate >= $session.system_date |
| [0..1] | I_ProfitCenter | _CurrentProfitCenter | $projection.ControllingArea = _CurrentProfitCenter.ControllingArea and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter and _CurrentProfitCenter.ValidityStartDate <= $session.system_date and _CurrentProfitCenter.ValidityEndDate >= $session.system_date |
| [0..1] | I_AdditionalCurrencyRoles | _AdditionalCurrencyRoles | $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup and $projection.Ledger = _AdditionalCurrencyRoles.Ledger |
| [0..*] | I_FundsCenter | _FundsCenter | $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea and $projection.FundsCenter = _FundsCenter.FundsCenter |
| [0..1] | I_Fund | _Fund | $projection.FinancialManagementArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund |
| [0..1] | I_Fund | _PartnerFund | $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea and $projection.PartnerFund = _PartnerFund.Fund |
| [0..1] | I_FundedProgram | _FundedProgram | $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea and $projection.FundedProgram = _FundedProgram.FundedProgram |
| [0..1] | I_CompanyCode | _CashLedgerCompanyCode | $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode |
| [0..1] | I_GLAccountInCompanyCode | _CashLedgerAccount | $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount |
| [0..1] | I_CompanyCode | _PubSecBudgetAccountCoCode | $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode |
| [0..1] | I_PubSecBudgetAccount | _PubSecBudgetAccount | $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount |
| [0..1] | I_JournalEntry | _JournalEntry | $projection.CompanyCode = _JournalEntry.CompanyCode and $projection.FiscalYear = _JournalEntry.FiscalYear and $projection.AccountingDocument = _JournalEntry.AccountingDocument |
| [0..1] | I_InternalOrder | _InternalOrder | $projection.OrderID = _InternalOrder.InternalOrder |
| [0..1] | I_Purreqvaluationarea | _ValuationArea | $projection.ValuationArea = _ValuationArea.ValuationArea |
| [0..1] | I_FinancialManagementArea | _FinancialManagementArea | $projection.FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea |
| [0..1] | I_FiscalYearForCompanyCode | _FiscalYear | $projection.FiscalYear = _FiscalYear.FiscalYear and $projection.CompanyCode = _FiscalYear.CompanyCode |
| [0..1] | I_TaxType | _TaxType | $projection.TaxType = _TaxType.TaxType |
| [0..1] | I_Country | _SupplyingCountry | $projection.SupplyingCountry = _SupplyingCountry.Country |
| [0..1] | I_Product | _Product | $projection.Product = _Product.Product |
| [0..1] | I_PaymentDifferenceReason | _PaymentDifferenceReason | $projection.PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason and $projection.CompanyCode = _PaymentDifferenceReason.CompanyCode |
| [0..1] | I_Order | _Order | $projection.OrderID = _Order.OrderID |
| [0..1] | I_PurchasingDocument | _PurchasingDocument | $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument |
| [0..1] | I_PurchasingDocumentItem | _PurchasingDocumentItem | $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem |
| [0..1] | I_Currency | _TransactionCurrency | $projection.TransactionCurrency = _TransactionCurrency.Currency |
| [0..1] | I_Supplier | _Supplier | $projection.Supplier = _Supplier.Supplier |
| [0..1] | I_SupplierCompany | _SupplierCompany | $projection.Supplier = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode |
| [0..1] | I_Customer | _Customer | $projection.Customer = _Customer.Customer |
| [0..1] | I_CustomerCompany | _CustomerCompany | $projection.Customer = _CustomerCompany.Customer and $projection.CompanyCode = _CustomerCompany.CompanyCode |
| [0..1] | I_GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount |
| [0..1] | I_GLAccountInCompanyCode | _GLAccountInCompanyCode | $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount |
| [0..1] | I_AccountingDocumentType | _AccountingDocumentType | $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType |
Annotations (5)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.entityBuffer.definitionAllowed | false | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (1174)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | AccountingDocumentCatGroup | |||
| KEY | CompanyCode | I_OperationalAcctgDocItem | CompanyCode | |
| KEY | FiscalYear | I_OperationalAcctgDocItem | FiscalYear | |
| KEY | AccountingDocument | I_OperationalAcctgDocItem | AccountingDocument | |
| KEY | AccountingDocumentItem | I_OperationalAcctgDocItem | AccountingDocumentItem | |
| ChartOfAccounts | I_OperationalAcctgDocItem | ChartOfAccounts | ||
| ClearingDate | I_OperationalAcctgDocItem | ClearingDate | ||
| ClearingCreationDate | I_OperationalAcctgDocItem | ClearingCreationDate | ||
| ClearingJournalEntry | I_OperationalAcctgDocItem | ClearingJournalEntry | ||
| ClearingAccountingDocument | I_OperationalAcctgDocItem | ClearingAccountingDocument | ||
| PostingKey | I_OperationalAcctgDocItem | PostingKey | ||
| FinancialAccountType | I_OperationalAcctgDocItem | FinancialAccountType | ||
| SpecialGLCode | I_OperationalAcctgDocItem | SpecialGLCode | ||
| SpecialGLTransactionType | I_OperationalAcctgDocItem | SpecialGLTransactionType | ||
| DebitCreditCode | I_OperationalAcctgDocItem | DebitCreditCode | ||
| BusinessArea | I_OperationalAcctgDocItem | BusinessArea | ||
| PartnerBusinessArea | I_OperationalAcctgDocItem | PartnerBusinessArea | ||
| TaxCode | I_OperationalAcctgDocItem | TaxCode | ||
| WithholdingTaxCode | I_OperationalAcctgDocItem | WithholdingTaxCode | ||
| TaxType | I_OperationalAcctgDocItem | TaxType | ||
| TransactionTypeDetermination | I_OperationalAcctgDocItem | TransactionTypeDetermination | ||
| ValueDate | I_OperationalAcctgDocItem | ValueDate | ||
| AssignmentReference | I_OperationalAcctgDocItem | AssignmentReference | ||
| DocumentItemText | I_OperationalAcctgDocItem | DocumentItemText | ||
| PartnerCompany | I_OperationalAcctgDocItem | PartnerCompany | ||
| FinancialTransactionType | I_OperationalAcctgDocItem | FinancialTransactionType | ||
| CorporateGroupAccount | I_OperationalAcctgDocItem | CorporateGroupAccount | ||
| PlanningLevel | I_OperationalAcctgDocItem | PlanningLevel | ||
| ControllingArea | I_OperationalAcctgDocItem | ControllingArea | ||
| CostCenter | I_OperationalAcctgDocItem | CostCenter | ||
| OrderID | I_OperationalAcctgDocItem | OrderID | ||
| BillingDocument | I_OperationalAcctgDocItem | BillingDocument | ||
| SalesDocument | I_OperationalAcctgDocItem | SalesDocument | ||
| SalesDocumentItem | I_OperationalAcctgDocItem | SalesDocumentItem | ||
| ScheduleLine | I_OperationalAcctgDocItem | ScheduleLine | ||
| ServiceDocumentType | I_OperationalAcctgDocItem | ServiceDocumentType | ||
| ServiceDocument | I_OperationalAcctgDocItem | ServiceDocument | ||
| ServiceDocumentItem | I_OperationalAcctgDocItem | ServiceDocumentItem | ||
| MasterFixedAsset | I_OperationalAcctgDocItem | MasterFixedAsset | ||
| FixedAsset | I_OperationalAcctgDocItem | FixedAsset | ||
| AssetTransactionType | I_OperationalAcctgDocItem | AssetTransactionType | ||
| AssetValueDate | I_OperationalAcctgDocItem | AssetValueDate | ||
| PersonnelNumber | I_OperationalAcctgDocItem | PersonnelNumber | ||
| IsSalesRelated | I_OperationalAcctgDocItem | IsSalesRelated | ||
| LineItemDisplayIsEnabled | I_OperationalAcctgDocItem | LineItemDisplayIsEnabled | ||
| IsOpenItemManaged | I_OperationalAcctgDocItem | IsOpenItemManaged | ||
| IsNotCashDiscountLiable | I_OperationalAcctgDocItem | IsNotCashDiscountLiable | ||
| IsAutomaticallyCreated | I_OperationalAcctgDocItem | IsAutomaticallyCreated | ||
| IsUsedInPaymentTransaction | I_OperationalAcctgDocItem | IsUsedInPaymentTransaction | ||
| OperationalGLAccount | I_OperationalAcctgDocItem | OperationalGLAccount | ||
| GLAccount | I_OperationalAcctgDocItem | GLAccount | ||
| Customer | I_OperationalAcctgDocItem | Customer | ||
| Supplier | I_OperationalAcctgDocItem | Supplier | ||
| BranchAccount | I_OperationalAcctgDocItem | BranchAccount | ||
| IsBalanceSheetAccount | I_OperationalAcctgDocItem | IsBalanceSheetAccount | ||
| ProfitLossAccountType | I_OperationalAcctgDocItem | ProfitLossAccountType | ||
| SpecialGLAccountAssignment | I_OperationalAcctgDocItem | SpecialGLAccountAssignment | ||
| DueCalculationBaseDate | I_OperationalAcctgDocItem | DueCalculationBaseDate | ||
| PaymentTerms | I_OperationalAcctgDocItem | PaymentTerms | ||
| CashDiscount1Days | I_OperationalAcctgDocItem | CashDiscount1Days | ||
| CashDiscount2Days | I_OperationalAcctgDocItem | CashDiscount2Days | ||
| NetPaymentDays | I_OperationalAcctgDocItem | NetPaymentDays | ||
| CashDiscount1Percent | I_OperationalAcctgDocItem | CashDiscount1Percent | ||
| CashDiscount2Percent | I_OperationalAcctgDocItem | CashDiscount2Percent | ||
| PaymentMethod | I_OperationalAcctgDocItem | PaymentMethod | ||
| PaymentBlockingReason | I_OperationalAcctgDocItem | PaymentBlockingReason | ||
| FixedCashDiscount | I_OperationalAcctgDocItem | FixedCashDiscount | ||
| HouseBank | I_OperationalAcctgDocItem | HouseBank | ||
| BPBankAccountInternalID | I_OperationalAcctgDocItem | BPBankAccountInternalID | ||
| TaxDistributionCode1 | I_OperationalAcctgDocItem | TaxDistributionCode1 | ||
| TaxDistributionCode2 | I_OperationalAcctgDocItem | TaxDistributionCode2 | ||
| TaxDistributionCode3 | I_OperationalAcctgDocItem | TaxDistributionCode3 | ||
| InvoiceReference | I_OperationalAcctgDocItem | InvoiceReference | ||
| InvoiceReferenceFiscalYear | I_OperationalAcctgDocItem | InvoiceReferenceFiscalYear | ||
| InvoiceItemReference | I_OperationalAcctgDocItem | InvoiceItemReference | ||
| FollowOnDocumentType | I_OperationalAcctgDocItem | FollowOnDocumentType | ||
| StateCentralBankPaymentReason | I_OperationalAcctgDocItem | StateCentralBankPaymentReason | ||
| SupplyingCountry | I_OperationalAcctgDocItem | SupplyingCountry | ||
| InvoiceList | I_OperationalAcctgDocItem | InvoiceList | ||
| BillOfExchangeUsage | I_OperationalAcctgDocItem | BillOfExchangeUsage | ||
| DunningKey | I_OperationalAcctgDocItem | DunningKey | ||
| DunningBlockingReason | I_OperationalAcctgDocItem | DunningBlockingReason | ||
| LastDunningDate | I_OperationalAcctgDocItem | LastDunningDate | ||
| DunningLevel | I_OperationalAcctgDocItem | DunningLevel | ||
| DunningArea | I_OperationalAcctgDocItem | DunningArea | ||
| WithholdingTaxCertificate | I_OperationalAcctgDocItem | WithholdingTaxCertificate | ||
| Product | I_OperationalAcctgDocItem | Product | ||
| Plant | I_OperationalAcctgDocItem | Plant | ||
| PurchasingDocument | I_OperationalAcctgDocItem | PurchasingDocument | ||
| PurchasingDocumentItem | I_OperationalAcctgDocItem | PurchasingDocumentItem | ||
| AccountAssignmentNumber | I_OperationalAcctgDocItem | AccountAssignmentNumber | ||
| IsCompletelyDelivered | I_OperationalAcctgDocItem | IsCompletelyDelivered | ||
| MaterialPriceControl | I_OperationalAcctgDocItem | MaterialPriceControl | ||
| ValuationArea | I_OperationalAcctgDocItem | ValuationArea | ||
| InventoryValuationType | I_OperationalAcctgDocItem | InventoryValuationType | ||
| VATRegistration | I_OperationalAcctgDocItem | VATRegistration | ||
| DelivOfGoodsDestCountry | I_OperationalAcctgDocItem | DelivOfGoodsDestCountry | ||
| PaymentDifferenceReason | I_OperationalAcctgDocItem | PaymentDifferenceReason | ||
| ProfitCenter | I_OperationalAcctgDocItem | ProfitCenter | ||
| JointVenture | I_OperationalAcctgDocItem | JointVenture | ||
| JointVentureCostRecoveryCode | I_OperationalAcctgDocItem | JointVentureCostRecoveryCode | ||
| JointVentureEquityGroup | I_OperationalAcctgDocItem | JointVentureEquityGroup | ||
| TreasuryContractType | I_OperationalAcctgDocItem | TreasuryContractType | ||
| AssetContract | I_OperationalAcctgDocItem | AssetContract | ||
| CashFlowType | I_OperationalAcctgDocItem | CashFlowType | ||
| TaxJurisdiction | I_OperationalAcctgDocItem | TaxJurisdiction | ||
| REInternalFinNumber | I_OperationalAcctgDocItem | REInternalFinNumber | ||
| RealEstateObject | I_OperationalAcctgDocItem | RealEstateObject | ||
| SettlementReferenceDate | I_OperationalAcctgDocItem | SettlementReferenceDate | ||
| CommitmentItem | I_OperationalAcctgDocItem | CommitmentItem | ||
| CommitmentItemShortID | I_OperationalAcctgDocItem | CommitmentItemShortID | ||
| CostObject | I_OperationalAcctgDocItem | CostObject | ||
| ProjectNetwork | I_OperationalAcctgDocItem | ProjectNetwork | ||
| OrderInternalBillOfOperations | I_OperationalAcctgDocItem | OrderInternalBillOfOperations | ||
| OrderIntBillOfOperationsItem | I_OperationalAcctgDocItem | OrderIntBillOfOperationsItem | ||
| WBSElementInternalID | ||||
| ProfitabilitySegment | ||||
| ProfitabilitySegment_2 | I_OperationalAcctgDocItem | ProfitabilitySegment_2 | ||
| JointVentureEquityType | I_OperationalAcctgDocItem | JointVentureEquityType | ||
| IsEUTriangularDeal | I_OperationalAcctgDocItem | IsEUTriangularDeal | ||
| CostOriginGroup | I_OperationalAcctgDocItem | CostOriginGroup | ||
| CompanyCodeCurrencyDetnMethod | I_OperationalAcctgDocItem | CompanyCodeCurrencyDetnMethod | ||
| ClearingIsReversed | I_OperationalAcctgDocItem | ClearingIsReversed | ||
| PaymentMethodSupplement | I_OperationalAcctgDocItem | PaymentMethodSupplement | ||
| AlternativeGLAccount | I_OperationalAcctgDocItem | AlternativeGLAccount | ||
| PartnerProfitCenter | I_OperationalAcctgDocItem | PartnerProfitCenter | ||
| Reference1IDByBusinessPartner | I_OperationalAcctgDocItem | Reference1IDByBusinessPartner | ||
| Reference2IDByBusinessPartner | I_OperationalAcctgDocItem | Reference2IDByBusinessPartner | ||
| IsNegativePosting | I_OperationalAcctgDocItem | IsNegativePosting | ||
| PaymentCardItem | I_OperationalAcctgDocItem | PaymentCardItem | ||
| PaymentCardPaymentSettlement | I_OperationalAcctgDocItem | PaymentCardPaymentSettlement | ||
| CreditControlArea | I_OperationalAcctgDocItem | CreditControlArea | ||
| Reference3IDByBusinessPartner | I_OperationalAcctgDocItem | Reference3IDByBusinessPartner | ||
| DataExchangeInstruction1 | I_OperationalAcctgDocItem | DataExchangeInstruction1 | ||
| DataExchangeInstruction2 | I_OperationalAcctgDocItem | DataExchangeInstruction2 | ||
| DataExchangeInstruction3 | I_OperationalAcctgDocItem | DataExchangeInstruction3 | ||
| DataExchangeInstruction4 | I_OperationalAcctgDocItem | DataExchangeInstruction4 | ||
| Region | I_OperationalAcctgDocItem | Region | ||
| HasPaymentOrder | I_OperationalAcctgDocItem | HasPaymentOrder | ||
| PaymentReference | I_OperationalAcctgDocItem | PaymentReference | ||
| TaxDeterminationDate | I_OperationalAcctgDocItem | TaxDeterminationDate | ||
| ClearingItem | I_OperationalAcctgDocItem | ClearingItem | ||
| BusinessPlace | I_OperationalAcctgDocItem | BusinessPlace | ||
| TaxSection | I_OperationalAcctgDocItem | TaxSection | ||
| CostCtrActivityType | I_OperationalAcctgDocItem | CostCtrActivityType | ||
| AccountsReceivableIsPledged | I_OperationalAcctgDocItem | AccountsReceivableIsPledged | ||
| AcctsReceivablePledgingCode | I_OperationalAcctgDocItem | AcctsReceivablePledgingCode | ||
| BusinessProcess | I_OperationalAcctgDocItem | BusinessProcess | ||
| FunctionalArea | I_OperationalAcctgDocItem | FunctionalArea | ||
| CustomerIsInExecution | I_OperationalAcctgDocItem | CustomerIsInExecution | ||
| ClearingJournalEntryFiscalYear | I_OperationalAcctgDocItem | ClearingJournalEntryFiscalYear | ||
| ClearingDocFiscalYear | I_OperationalAcctgDocItem | ClearingDocFiscalYear | ||
| LedgerGLLineItem | I_OperationalAcctgDocItem | LedgerGLLineItem | ||
| Segment | I_OperationalAcctgDocItem | Segment | ||
| PartnerSegment | I_OperationalAcctgDocItem | PartnerSegment | ||
| PartnerFunctionalArea | I_OperationalAcctgDocItem | PartnerFunctionalArea | ||
| HouseBankAccount | I_OperationalAcctgDocItem | HouseBankAccount | ||
| CostElement | I_OperationalAcctgDocItem | CostElement | ||
| PaymentServiceProvider | I_OperationalAcctgDocItem | PaymentServiceProvider | ||
| PaymentRefByPaytSrvcProvider | I_OperationalAcctgDocItem | PaymentRefByPaytSrvcProvider | ||
| SEPAMandate | I_OperationalAcctgDocItem | SEPAMandate | ||
| ReferenceDocumentType | I_OperationalAcctgDocItem | ReferenceDocumentType | ||
| OriginalReferenceDocument | I_OperationalAcctgDocItem | OriginalReferenceDocument | ||
| ReferenceDocumentLogicalSystem | I_OperationalAcctgDocItem | ReferenceDocumentLogicalSystem | ||
| AccountingDocumentItemRef | I_OperationalAcctgDocItem | AccountingDocumentItemRef | ||
| FiscalPeriod | I_OperationalAcctgDocItem | FiscalPeriod | ||
| AccountingDocumentCategory | I_OperationalAcctgDocItem | AccountingDocumentCategory | ||
| PostingDate | I_OperationalAcctgDocItem | PostingDate | ||
| DocumentDate | I_OperationalAcctgDocItem | DocumentDate | ||
| AccountingDocumentType | I_OperationalAcctgDocItem | AccountingDocumentType | ||
| NetDueDate | I_OperationalAcctgDocItem | NetDueDate | ||
| CashDiscount1DueDate | I_OperationalAcctgDocItem | CashDiscount1DueDate | ||
| CashDiscount2DueDate | I_OperationalAcctgDocItem | CashDiscount2DueDate | ||
| OffsettingAccount | I_OperationalAcctgDocItem | OffsettingAccount | ||
| OffsettingAccountType | I_OperationalAcctgDocItem | OffsettingAccountType | ||
| OffsettingChartOfAccounts | I_OperationalAcctgDocItem | OffsettingChartOfAccounts | ||
| CashLedgerCompanyCode | I_OperationalAcctgDocItem | CashLedgerCompanyCode | ||
| CashLedgerAccount | I_OperationalAcctgDocItem | CashLedgerAccount | ||
| FinancialManagementArea | ||||
| FundsCenter | I_OperationalAcctgDocItem | FundsCenter | ||
| FundedProgram | I_OperationalAcctgDocItem | FundedProgram | ||
| Fund | I_OperationalAcctgDocItem | Fund | ||
| GrantID | I_OperationalAcctgDocItem | GrantID | ||
| BudgetPeriod | I_OperationalAcctgDocItem | BudgetPeriod | ||
| PartnerFund | I_OperationalAcctgDocItem | PartnerFund | ||
| PartnerGrant | I_OperationalAcctgDocItem | PartnerGrant | ||
| PartnerBudgetPeriod | I_OperationalAcctgDocItem | PartnerBudgetPeriod | ||
| PubSecBudgetAccount | I_OperationalAcctgDocItem | PubSecBudgetAccount | ||
| PubSecBudgetAccountCoCode | I_OperationalAcctgDocItem | PubSecBudgetAccountCoCode | ||
| CompanyCodeCurrency | I_OperationalAcctgDocItem | CompanyCodeCurrency | ||
| AmountInCompanyCodeCurrency | I_OperationalAcctgDocItem | AmountInCompanyCodeCurrency | ||
| TaxAmountInCoCodeCrcy | I_OperationalAcctgDocItem | TaxAmountInCoCodeCrcy | ||
| TaxBaseAmountInCoCodeCrcy | I_OperationalAcctgDocItem | TaxBaseAmountInCoCodeCrcy | ||
| ValuationDiffAmtInCoCodeCrcy | I_OperationalAcctgDocItem | ValuationDiffAmtInCoCodeCrcy | ||
| CashDiscountAmtInCoCodeCrcy | ||||
| InvoiceAmtInCoCodeCrcy | I_OperationalAcctgDocItem | InvoiceAmtInCoCodeCrcy | ||
| FunctionalCurrency | I_OperationalAcctgDocItem | FunctionalCurrency | ||
| AmountInFunctionalCurrency | I_OperationalAcctgDocItem | AmountInFunctionalCurrency | ||
| TransactionCurrency | I_OperationalAcctgDocItem | TransactionCurrency | ||
| AmountInTransactionCurrency | I_OperationalAcctgDocItem | AmountInTransactionCurrency | ||
| OriginalTaxBaseAmount | I_OperationalAcctgDocItem | OriginalTaxBaseAmount | ||
| TaxAmount | I_OperationalAcctgDocItem | TaxAmount | ||
| TaxBaseAmountInTransCrcy | I_OperationalAcctgDocItem | TaxBaseAmountInTransCrcy | ||
| WithholdingTaxBaseAmount | I_OperationalAcctgDocItem | WithholdingTaxBaseAmount | ||
| PlannedAmtInTransactionCrcy | I_OperationalAcctgDocItem | PlannedAmtInTransactionCrcy | ||
| CashDiscountBaseAmount | ||||
| CashDiscountAmount | I_OperationalAcctgDocItem | CashDiscountAmount | ||
| NetPaymentAmount | I_OperationalAcctgDocItem | NetPaymentAmount | ||
| WithholdingTaxAmount | I_OperationalAcctgDocItem | WithholdingTaxAmount | ||
| WithholdingTaxExemptionAmt | I_OperationalAcctgDocItem | WithholdingTaxExemptionAmt | ||
| InvoiceAmountInFrgnCurrency | I_OperationalAcctgDocItem | InvoiceAmountInFrgnCurrency | ||
| BalanceTransactionCurrency | I_OperationalAcctgDocItem | BalanceTransactionCurrency | ||
| AmountInBalanceTransacCrcy | I_OperationalAcctgDocItem | AmountInBalanceTransacCrcy | ||
| AdditionalCurrency1 | I_OperationalAcctgDocItem | AdditionalCurrency1 | ||
| ValuationDiffAmtInAddlCrcy1 | I_OperationalAcctgDocItem | ValuationDiffAmtInAddlCrcy1 | ||
| AmountInAdditionalCurrency1 | I_OperationalAcctgDocItem | AmountInAdditionalCurrency1 | ||
| AdditionalCurrency2 | I_OperationalAcctgDocItem | AdditionalCurrency2 | ||
| AmountInAdditionalCurrency2 | I_OperationalAcctgDocItem | AmountInAdditionalCurrency2 | ||
| ValuationDiffAmtInAddlCrcy2 | I_OperationalAcctgDocItem | ValuationDiffAmtInAddlCrcy2 | ||
| PaymentCurrency | I_OperationalAcctgDocItem | PaymentCurrency | ||
| AmountInPaymentCurrency | I_OperationalAcctgDocItem | AmountInPaymentCurrency | ||
| CreditControlAreaCurrency | I_OperationalAcctgDocItem | CreditControlAreaCurrency | ||
| HedgedAmount | I_OperationalAcctgDocItem | HedgedAmount | ||
| BaseUnit | I_OperationalAcctgDocItem | BaseUnit | ||
| Quantityasquan1_12endasQuantity | ||||
| AbsoluteQuantity | ||||
| GoodsMovementEntryUnit | I_OperationalAcctgDocItem | GoodsMovementEntryUnit | ||
| QuantityInEntryUnit | I_OperationalAcctgDocItem | QuantityInEntryUnit | ||
| PurchasingDocumentPriceUnit | I_OperationalAcctgDocItem | PurchasingDocumentPriceUnit | ||
| PurchaseOrderQty | I_OperationalAcctgDocItem | PurchaseOrderQty | ||
| MaterialPriceUnitQty | I_OperationalAcctgDocItem | MaterialPriceUnitQty | ||
| Ledger | ||||
| LedgerGroup | ||||
| NumberOfItems | I_OperationalAcctgDocItem | NumberOfItems | ||
| ClearingStatusSelection | ||||
| _CompanyCode | I_OperationalAcctgDocItem | _CompanyCode | ||
| _FiscalYear | I_OperationalAcctgDocItem | _FiscalYear | ||
| _JournalEntry | I_OperationalAcctgDocItem | _JournalEntry | ||
| _GLAccountInChartOfAccounts | I_OperationalAcctgDocItem | _GLAccountInChartOfAccounts | ||
| _ChartOfAccounts | I_OperationalAcctgDocItem | _ChartOfAccounts | ||
| _PostingKey | I_OperationalAcctgDocItem | _PostingKey | ||
| _FinancialAccountType | I_OperationalAcctgDocItem | _FinancialAccountType | ||
| _DebitCreditCode | I_OperationalAcctgDocItem | _DebitCreditCode | ||
| _BusinessArea | I_OperationalAcctgDocItem | _BusinessArea | ||
| _PartnerBusinessArea | I_OperationalAcctgDocItem | _PartnerBusinessArea | ||
| _TaxType | I_OperationalAcctgDocItem | _TaxType | ||
| _ControllingArea | I_OperationalAcctgDocItem | _ControllingArea | ||
| _ProfitCenter | I_OperationalAcctgDocItem | _ProfitCenter | ||
| _CostCenter | I_OperationalAcctgDocItem | _CostCenter | ||
| _SupplyingCountry | I_OperationalAcctgDocItem | _SupplyingCountry | ||
| _Product | I_OperationalAcctgDocItem | _Product | ||
| _Plant | I_OperationalAcctgDocItem | _Plant | ||
| _BaseUnit | I_OperationalAcctgDocItem | _BaseUnit | ||
| _InventoryValuationType | I_OperationalAcctgDocItem | _InventoryValuationType | ||
| _PaymentDifferenceReason | I_OperationalAcctgDocItem | _PaymentDifferenceReason | ||
| _Segment | I_OperationalAcctgDocItem | _Segment | ||
| _PartnerSegment | I_OperationalAcctgDocItem | _PartnerSegment | ||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _AccountingDocumentType | I_OperationalAcctgDocItem | _AccountingDocumentType | ||
| _TransactionCurrency | I_OperationalAcctgDocItem | _TransactionCurrency | ||
| _InternalOrder | I_OperationalAcctgDocItem | _InternalOrder | ||
| _Order | I_OperationalAcctgDocItem | _Order | ||
| _MasterFixedAsset | I_OperationalAcctgDocItem | _MasterFixedAsset | ||
| _FixedAsset | I_OperationalAcctgDocItem | _FixedAsset | ||
| _AssetTransactionType | I_OperationalAcctgDocItem | _AssetTransactionType | ||
| _PurchasingDocument | I_OperationalAcctgDocItem | _PurchasingDocument | ||
| _PurchasingDocumentItem | I_OperationalAcctgDocItem | _PurchasingDocumentItem | ||
| _ValuationArea | I_OperationalAcctgDocItem | _ValuationArea | ||
| _ProjectNetwork | I_OperationalAcctgDocItem | _ProjectNetwork | ||
| _CostCtrActivityType | I_OperationalAcctgDocItem | _CostCtrActivityType | ||
| _BusinessProcess | I_OperationalAcctgDocItem | _BusinessProcess | ||
| _FunctionalArea | I_OperationalAcctgDocItem | _FunctionalArea | ||
| _AdditionalCurrencyRoles | _AdditionalCurrencyRoles | |||
| _CurrentCostCenter | _CurrentCostCenter | |||
| _CurrentProfitCenter | _CurrentProfitCenter | |||
| _Customer | I_OperationalAcctgDocItem | _Customer | ||
| _CustomerCompany | I_OperationalAcctgDocItem | _CustomerCompany | ||
| _GLAccountInCompanyCode | I_OperationalAcctgDocItem | _GLAccountInCompanyCode | ||
| _SalesDocument | _SalesDocument | |||
| _ServiceDocument | _ServiceDocument | |||
| _Supplier | I_OperationalAcctgDocItem | _Supplier | ||
| _SupplierCompany | I_OperationalAcctgDocItem | _SupplierCompany | ||
| _FinancialManagementArea | ||||
| _FundsCenter | _FundsCenter | |||
| _Fund | _Fund | |||
| _PartnerFund | _PartnerFund | |||
| _FundedProgram | _FundedProgram | |||
| _CashLedgerCompanyCode | _CashLedgerCompanyCode | |||
| _CashLedgerAccount | _CashLedgerAccount | |||
| _BudgetPeriod | I_OperationalAcctgDocItem | _BudgetPeriod | ||
| _PartnerBudgetPeriod | I_OperationalAcctgDocItem | _PartnerBudgetPeriod | ||
| _Grant | I_OperationalAcctgDocItem | _Grant | ||
| _PartnerGrant | I_OperationalAcctgDocItem | _PartnerGrant | ||
| _PubSecBudgetAccountCoCode | _PubSecBudgetAccountCoCode | |||
| KEY | CompanyCode | I_OperationalAcctgDocItem | CompanyCode | |
| KEY | FiscalYear | I_OperationalAcctgDocItem | FiscalYear | |
| KEY | AccountingDocument | I_OperationalAcctgDocItem | AccountingDocument | |
| KEY | AccountingDocumentItem | I_OperationalAcctgDocItem | AccountingDocumentItem | |
| ChartOfAccounts | I_OperationalAcctgDocItem | ChartOfAccounts | ||
| ClearingDate | I_OperationalAcctgDocItem | ClearingDate | ||
| ClearingCreationDate | I_OperationalAcctgDocItem | ClearingCreationDate | ||
| ClearingJournalEntry | I_OperationalAcctgDocItem | ClearingJournalEntry | ||
| ClearingAccountingDocument | I_OperationalAcctgDocItem | ClearingAccountingDocument | ||
| PostingKey | I_OperationalAcctgDocItem | PostingKey | ||
| FinancialAccountType | I_OperationalAcctgDocItem | FinancialAccountType | ||
| SpecialGLCode | I_OperationalAcctgDocItem | SpecialGLCode | ||
| SpecialGLTransactionType | I_OperationalAcctgDocItem | SpecialGLTransactionType | ||
| DebitCreditCode | I_OperationalAcctgDocItem | DebitCreditCode | ||
| BusinessArea | I_OperationalAcctgDocItem | BusinessArea | ||
| PartnerBusinessArea | I_OperationalAcctgDocItem | PartnerBusinessArea | ||
| TaxCode | I_OperationalAcctgDocItem | TaxCode | ||
| WithholdingTaxCode | I_OperationalAcctgDocItem | WithholdingTaxCode | ||
| TaxType | I_OperationalAcctgDocItem | TaxType | ||
| TransactionTypeDetermination | I_OperationalAcctgDocItem | TransactionTypeDetermination | ||
| ValueDate | I_OperationalAcctgDocItem | ValueDate | ||
| AssignmentReference | I_OperationalAcctgDocItem | AssignmentReference | ||
| DocumentItemText | I_OperationalAcctgDocItem | DocumentItemText | ||
| PartnerCompany | I_OperationalAcctgDocItem | PartnerCompany | ||
| FinancialTransactionType | I_OperationalAcctgDocItem | FinancialTransactionType | ||
| CorporateGroupAccount | I_OperationalAcctgDocItem | CorporateGroupAccount | ||
| PlanningLevel | I_OperationalAcctgDocItem | PlanningLevel | ||
| ControllingArea | I_OperationalAcctgDocItem | ControllingArea | ||
| CostCenter | I_OperationalAcctgDocItem | CostCenter | ||
| OrderID | I_OperationalAcctgDocItem | OrderID | ||
| BillingDocument | I_OperationalAcctgDocItem | BillingDocument | ||
| SalesDocument | I_OperationalAcctgDocItem | SalesDocument | ||
| SalesDocumentItem | I_OperationalAcctgDocItem | SalesDocumentItem | ||
| ScheduleLine | I_OperationalAcctgDocItem | ScheduleLine | ||
| ServiceDocumentType | I_OperationalAcctgDocItem | ServiceDocumentType | ||
| ServiceDocument | I_OperationalAcctgDocItem | ServiceDocument | ||
| ServiceDocumentItem | I_OperationalAcctgDocItem | ServiceDocumentItem | ||
| MasterFixedAsset | I_OperationalAcctgDocItem | MasterFixedAsset | ||
| FixedAsset | I_OperationalAcctgDocItem | FixedAsset | ||
| AssetTransactionType | I_OperationalAcctgDocItem | AssetTransactionType | ||
| AssetValueDate | I_OperationalAcctgDocItem | AssetValueDate | ||
| PersonnelNumber | I_OperationalAcctgDocItem | PersonnelNumber | ||
| IsSalesRelated | I_OperationalAcctgDocItem | IsSalesRelated | ||
| LineItemDisplayIsEnabled | I_OperationalAcctgDocItem | LineItemDisplayIsEnabled | ||
| IsOpenItemManaged | I_OperationalAcctgDocItem | IsOpenItemManaged | ||
| IsNotCashDiscountLiable | I_OperationalAcctgDocItem | IsNotCashDiscountLiable | ||
| IsAutomaticallyCreated | I_OperationalAcctgDocItem | IsAutomaticallyCreated | ||
| IsUsedInPaymentTransaction | I_OperationalAcctgDocItem | IsUsedInPaymentTransaction | ||
| OperationalGLAccount | I_OperationalAcctgDocItem | OperationalGLAccount | ||
| GLAccount | I_OperationalAcctgDocItem | GLAccount | ||
| Customer | I_OperationalAcctgDocItem | Customer | ||
| Supplier | I_OperationalAcctgDocItem | Supplier | ||
| BranchAccount | I_OperationalAcctgDocItem | BranchAccount | ||
| IsBalanceSheetAccount | I_OperationalAcctgDocItem | IsBalanceSheetAccount | ||
| ProfitLossAccountType | I_OperationalAcctgDocItem | ProfitLossAccountType | ||
| SpecialGLAccountAssignment | I_OperationalAcctgDocItem | SpecialGLAccountAssignment | ||
| DueCalculationBaseDate | I_OperationalAcctgDocItem | DueCalculationBaseDate | ||
| PaymentTerms | I_OperationalAcctgDocItem | PaymentTerms | ||
| CashDiscount1Days | I_OperationalAcctgDocItem | CashDiscount1Days | ||
| CashDiscount2Days | I_OperationalAcctgDocItem | CashDiscount2Days | ||
| NetPaymentDays | I_OperationalAcctgDocItem | NetPaymentDays | ||
| CashDiscount1Percent | I_OperationalAcctgDocItem | CashDiscount1Percent | ||
| CashDiscount2Percent | I_OperationalAcctgDocItem | CashDiscount2Percent | ||
| PaymentMethod | I_OperationalAcctgDocItem | PaymentMethod | ||
| PaymentBlockingReason | I_OperationalAcctgDocItem | PaymentBlockingReason | ||
| FixedCashDiscount | I_OperationalAcctgDocItem | FixedCashDiscount | ||
| HouseBank | I_OperationalAcctgDocItem | HouseBank | ||
| BPBankAccountInternalID | I_OperationalAcctgDocItem | BPBankAccountInternalID | ||
| TaxDistributionCode1 | I_OperationalAcctgDocItem | TaxDistributionCode1 | ||
| TaxDistributionCode2 | I_OperationalAcctgDocItem | TaxDistributionCode2 | ||
| TaxDistributionCode3 | I_OperationalAcctgDocItem | TaxDistributionCode3 | ||
| InvoiceReference | I_OperationalAcctgDocItem | InvoiceReference | ||
| InvoiceReferenceFiscalYear | I_OperationalAcctgDocItem | InvoiceReferenceFiscalYear | ||
| InvoiceItemReference | I_OperationalAcctgDocItem | InvoiceItemReference | ||
| FollowOnDocumentType | I_OperationalAcctgDocItem | FollowOnDocumentType | ||
| StateCentralBankPaymentReason | I_OperationalAcctgDocItem | StateCentralBankPaymentReason | ||
| SupplyingCountry | I_OperationalAcctgDocItem | SupplyingCountry | ||
| InvoiceList | I_OperationalAcctgDocItem | InvoiceList | ||
| BillOfExchangeUsage | I_OperationalAcctgDocItem | BillOfExchangeUsage | ||
| DunningKey | I_OperationalAcctgDocItem | DunningKey | ||
| DunningBlockingReason | I_OperationalAcctgDocItem | DunningBlockingReason | ||
| LastDunningDate | I_OperationalAcctgDocItem | LastDunningDate | ||
| DunningLevel | I_OperationalAcctgDocItem | DunningLevel | ||
| DunningArea | I_OperationalAcctgDocItem | DunningArea | ||
| WithholdingTaxCertificate | I_OperationalAcctgDocItem | WithholdingTaxCertificate | ||
| Product | I_OperationalAcctgDocItem | Product | ||
| Plant | I_OperationalAcctgDocItem | Plant | ||
| PurchasingDocument | I_OperationalAcctgDocItem | PurchasingDocument | ||
| PurchasingDocumentItem | I_OperationalAcctgDocItem | PurchasingDocumentItem | ||
| AccountAssignmentNumber | I_OperationalAcctgDocItem | AccountAssignmentNumber | ||
| IsCompletelyDelivered | I_OperationalAcctgDocItem | IsCompletelyDelivered | ||
| MaterialPriceControl | I_OperationalAcctgDocItem | MaterialPriceControl | ||
| ValuationArea | I_OperationalAcctgDocItem | ValuationArea | ||
| InventoryValuationType | I_OperationalAcctgDocItem | InventoryValuationType | ||
| VATRegistration | I_OperationalAcctgDocItem | VATRegistration | ||
| DelivOfGoodsDestCountry | I_OperationalAcctgDocItem | DelivOfGoodsDestCountry | ||
| PaymentDifferenceReason | I_OperationalAcctgDocItem | PaymentDifferenceReason | ||
| ProfitCenter | I_OperationalAcctgDocItem | ProfitCenter | ||
| JointVenture | I_OperationalAcctgDocItem | JointVenture | ||
| JointVentureCostRecoveryCode | I_OperationalAcctgDocItem | JointVentureCostRecoveryCode | ||
| JointVentureEquityGroup | I_OperationalAcctgDocItem | JointVentureEquityGroup | ||
| TreasuryContractType | I_OperationalAcctgDocItem | TreasuryContractType | ||
| AssetContract | I_OperationalAcctgDocItem | AssetContract | ||
| CashFlowType | I_OperationalAcctgDocItem | CashFlowType | ||
| TaxJurisdiction | I_OperationalAcctgDocItem | TaxJurisdiction | ||
| REInternalFinNumber | I_OperationalAcctgDocItem | REInternalFinNumber | ||
| RealEstateObject | I_OperationalAcctgDocItem | RealEstateObject | ||
| SettlementReferenceDate | I_OperationalAcctgDocItem | SettlementReferenceDate | ||
| CommitmentItem | I_OperationalAcctgDocItem | CommitmentItem | ||
| CommitmentItemShortID | I_OperationalAcctgDocItem | CommitmentItemShortID | ||
| CostObject | I_OperationalAcctgDocItem | CostObject | ||
| ProjectNetwork | I_OperationalAcctgDocItem | ProjectNetwork | ||
| OrderInternalBillOfOperations | I_OperationalAcctgDocItem | OrderInternalBillOfOperations | ||
| OrderIntBillOfOperationsItem | I_OperationalAcctgDocItem | OrderIntBillOfOperationsItem | ||
| WBSElementInternalID | ||||
| ProfitabilitySegment | I_OperationalAcctgDocItem | ProfitabilitySegment | ||
| ProfitabilitySegment_2 | I_OperationalAcctgDocItem | ProfitabilitySegment_2 | ||
| JointVentureEquityType | I_OperationalAcctgDocItem | JointVentureEquityType | ||
| IsEUTriangularDeal | I_OperationalAcctgDocItem | IsEUTriangularDeal | ||
| CostOriginGroup | I_OperationalAcctgDocItem | CostOriginGroup | ||
| CompanyCodeCurrencyDetnMethod | I_OperationalAcctgDocItem | CompanyCodeCurrencyDetnMethod | ||
| ClearingIsReversed | I_OperationalAcctgDocItem | ClearingIsReversed | ||
| PaymentMethodSupplement | I_OperationalAcctgDocItem | PaymentMethodSupplement | ||
| AlternativeGLAccount | I_OperationalAcctgDocItem | AlternativeGLAccount | ||
| PartnerProfitCenter | I_OperationalAcctgDocItem | PartnerProfitCenter | ||
| Reference1IDByBusinessPartner | I_OperationalAcctgDocItem | Reference1IDByBusinessPartner | ||
| Reference2IDByBusinessPartner | I_OperationalAcctgDocItem | Reference2IDByBusinessPartner | ||
| IsNegativePosting | I_OperationalAcctgDocItem | IsNegativePosting | ||
| PaymentCardItem | I_OperationalAcctgDocItem | PaymentCardItem | ||
| PaymentCardPaymentSettlement | I_OperationalAcctgDocItem | PaymentCardPaymentSettlement | ||
| CreditControlArea | I_OperationalAcctgDocItem | CreditControlArea | ||
| Reference3IDByBusinessPartner | I_OperationalAcctgDocItem | Reference3IDByBusinessPartner | ||
| DataExchangeInstruction1 | I_OperationalAcctgDocItem | DataExchangeInstruction1 | ||
| DataExchangeInstruction2 | I_OperationalAcctgDocItem | DataExchangeInstruction2 | ||
| DataExchangeInstruction3 | I_OperationalAcctgDocItem | DataExchangeInstruction3 | ||
| DataExchangeInstruction4 | I_OperationalAcctgDocItem | DataExchangeInstruction4 | ||
| Region | I_OperationalAcctgDocItem | Region | ||
| HasPaymentOrder | I_OperationalAcctgDocItem | HasPaymentOrder | ||
| PaymentReference | I_OperationalAcctgDocItem | PaymentReference | ||
| TaxDeterminationDate | I_OperationalAcctgDocItem | TaxDeterminationDate | ||
| ClearingItem | I_OperationalAcctgDocItem | ClearingItem | ||
| BusinessPlace | I_OperationalAcctgDocItem | BusinessPlace | ||
| TaxSection | I_OperationalAcctgDocItem | TaxSection | ||
| CostCtrActivityType | I_OperationalAcctgDocItem | CostCtrActivityType | ||
| AccountsReceivableIsPledged | I_OperationalAcctgDocItem | AccountsReceivableIsPledged | ||
| AcctsReceivablePledgingCode | I_OperationalAcctgDocItem | AcctsReceivablePledgingCode | ||
| BusinessProcess | I_OperationalAcctgDocItem | BusinessProcess | ||
| FunctionalArea | I_OperationalAcctgDocItem | FunctionalArea | ||
| CustomerIsInExecution | I_OperationalAcctgDocItem | CustomerIsInExecution | ||
| ClearingJournalEntryFiscalYear | I_OperationalAcctgDocItem | ClearingJournalEntryFiscalYear | ||
| ClearingDocFiscalYear | I_OperationalAcctgDocItem | ClearingDocFiscalYear | ||
| LedgerGLLineItem | I_OperationalAcctgDocItem | LedgerGLLineItem | ||
| Segment | I_OperationalAcctgDocItem | Segment | ||
| PartnerSegment | I_OperationalAcctgDocItem | PartnerSegment | ||
| PartnerFunctionalArea | I_OperationalAcctgDocItem | PartnerFunctionalArea | ||
| HouseBankAccount | I_OperationalAcctgDocItem | HouseBankAccount | ||
| CostElement | I_OperationalAcctgDocItem | CostElement | ||
| PaymentServiceProvider | I_OperationalAcctgDocItem | PaymentServiceProvider | ||
| PaymentRefByPaytSrvcProvider | I_OperationalAcctgDocItem | PaymentRefByPaytSrvcProvider | ||
| SEPAMandate | I_OperationalAcctgDocItem | SEPAMandate | ||
| ReferenceDocumentType | I_OperationalAcctgDocItem | ReferenceDocumentType | ||
| OriginalReferenceDocument | I_OperationalAcctgDocItem | OriginalReferenceDocument | ||
| ReferenceDocumentLogicalSystem | I_OperationalAcctgDocItem | ReferenceDocumentLogicalSystem | ||
| AccountingDocumentItemRef | I_OperationalAcctgDocItem | AccountingDocumentItemRef | ||
| FiscalPeriod | I_OperationalAcctgDocItem | FiscalPeriod | ||
| AccountingDocumentCategory | I_OperationalAcctgDocItem | AccountingDocumentCategory | ||
| PostingDate | I_OperationalAcctgDocItem | PostingDate | ||
| DocumentDate | I_OperationalAcctgDocItem | DocumentDate | ||
| AccountingDocumentType | I_OperationalAcctgDocItem | AccountingDocumentType | ||
| NetDueDate | I_OperationalAcctgDocItem | NetDueDate | ||
| CashDiscount1DueDate | I_OperationalAcctgDocItem | CashDiscount1DueDate | ||
| CashDiscount2DueDate | I_OperationalAcctgDocItem | CashDiscount2DueDate | ||
| OffsettingAccount | I_OperationalAcctgDocItem | OffsettingAccount | ||
| OffsettingAccountType | I_OperationalAcctgDocItem | OffsettingAccountType | ||
| OffsettingChartOfAccounts | I_OperationalAcctgDocItem | OffsettingChartOfAccounts | ||
| CashLedgerCompanyCode | I_OperationalAcctgDocItem | CashLedgerCompanyCode | ||
| CashLedgerAccount | I_OperationalAcctgDocItem | CashLedgerAccount | ||
| FinancialManagementArea | ||||
| FundsCenter | I_OperationalAcctgDocItem | FundsCenter | ||
| FundedProgram | I_OperationalAcctgDocItem | FundedProgram | ||
| Fund | I_OperationalAcctgDocItem | Fund | ||
| GrantID | I_OperationalAcctgDocItem | GrantID | ||
| BudgetPeriod | I_OperationalAcctgDocItem | BudgetPeriod | ||
| PartnerFund | I_OperationalAcctgDocItem | PartnerFund | ||
| PartnerGrant | I_OperationalAcctgDocItem | PartnerGrant | ||
| PartnerBudgetPeriod | I_OperationalAcctgDocItem | PartnerBudgetPeriod | ||
| PubSecBudgetAccount | I_OperationalAcctgDocItem | PubSecBudgetAccount | ||
| PubSecBudgetAccountCoCode | I_OperationalAcctgDocItem | PubSecBudgetAccountCoCode | ||
| CompanyCodeCurrency | I_OperationalAcctgDocItem | CompanyCodeCurrency | ||
| AmountInCompanyCodeCurrency | I_OperationalAcctgDocItem | AmountInCompanyCodeCurrency | ||
| TaxAmountInCoCodeCrcy | I_OperationalAcctgDocItem | TaxAmountInCoCodeCrcy | ||
| TaxBaseAmountInCoCodeCrcy | I_OperationalAcctgDocItem | TaxBaseAmountInCoCodeCrcy | ||
| ValuationDiffAmtInCoCodeCrcy | I_OperationalAcctgDocItem | ValuationDiffAmtInCoCodeCrcy | ||
| CashDiscountAmtInCoCodeCrcy | ||||
| InvoiceAmtInCoCodeCrcy | I_OperationalAcctgDocItem | InvoiceAmtInCoCodeCrcy | ||
| FunctionalCurrency | I_OperationalAcctgDocItem | FunctionalCurrency | ||
| AmountInFunctionalCurrency | I_OperationalAcctgDocItem | AmountInFunctionalCurrency | ||
| TransactionCurrency | I_OperationalAcctgDocItem | TransactionCurrency | ||
| AmountInTransactionCurrency | I_OperationalAcctgDocItem | AmountInTransactionCurrency | ||
| OriginalTaxBaseAmount | I_OperationalAcctgDocItem | OriginalTaxBaseAmount | ||
| TaxAmount | I_OperationalAcctgDocItem | TaxAmount | ||
| TaxBaseAmountInTransCrcy | I_OperationalAcctgDocItem | TaxBaseAmountInTransCrcy | ||
| WithholdingTaxBaseAmount | I_OperationalAcctgDocItem | WithholdingTaxBaseAmount | ||
| PlannedAmtInTransactionCrcy | I_OperationalAcctgDocItem | PlannedAmtInTransactionCrcy | ||
| CashDiscountBaseAmount | ||||
| CashDiscountAmount | I_OperationalAcctgDocItem | CashDiscountAmount | ||
| NetPaymentAmount | I_OperationalAcctgDocItem | NetPaymentAmount | ||
| WithholdingTaxAmount | I_OperationalAcctgDocItem | WithholdingTaxAmount | ||
| WithholdingTaxExemptionAmt | I_OperationalAcctgDocItem | WithholdingTaxExemptionAmt | ||
| InvoiceAmountInFrgnCurrency | I_OperationalAcctgDocItem | InvoiceAmountInFrgnCurrency | ||
| BalanceTransactionCurrency | I_OperationalAcctgDocItem | BalanceTransactionCurrency | ||
| AmountInBalanceTransacCrcy | I_OperationalAcctgDocItem | AmountInBalanceTransacCrcy | ||
| AdditionalCurrency1 | I_OperationalAcctgDocItem | AdditionalCurrency1 | ||
| ValuationDiffAmtInAddlCrcy1 | I_OperationalAcctgDocItem | ValuationDiffAmtInAddlCrcy1 | ||
| AmountInAdditionalCurrency1 | I_OperationalAcctgDocItem | AmountInAdditionalCurrency1 | ||
| AdditionalCurrency2 | I_OperationalAcctgDocItem | AdditionalCurrency2 | ||
| AmountInAdditionalCurrency2 | I_OperationalAcctgDocItem | AmountInAdditionalCurrency2 | ||
| ValuationDiffAmtInAddlCrcy2 | I_OperationalAcctgDocItem | ValuationDiffAmtInAddlCrcy2 | ||
| PaymentCurrency | I_OperationalAcctgDocItem | PaymentCurrency | ||
| AmountInPaymentCurrency | I_OperationalAcctgDocItem | AmountInPaymentCurrency | ||
| CreditControlAreaCurrency | I_OperationalAcctgDocItem | CreditControlAreaCurrency | ||
| HedgedAmount | I_OperationalAcctgDocItem | HedgedAmount | ||
| BaseUnit | I_OperationalAcctgDocItem | BaseUnit | ||
| Quantityasquan1_12endasQuantity | ||||
| AbsoluteQuantity | ||||
| GoodsMovementEntryUnit | I_OperationalAcctgDocItem | GoodsMovementEntryUnit | ||
| QuantityInEntryUnit | I_OperationalAcctgDocItem | QuantityInEntryUnit | ||
| PurchasingDocumentPriceUnit | I_OperationalAcctgDocItem | PurchasingDocumentPriceUnit | ||
| PurchaseOrderQty | I_OperationalAcctgDocItem | PurchaseOrderQty | ||
| MaterialPriceUnitQty | I_OperationalAcctgDocItem | MaterialPriceUnitQty | ||
| Ledger | ||||
| LedgerGroup | ||||
| NumberOfItems | I_OperationalAcctgDocItem | NumberOfItems | ||
| ClearingStatusSelection | ||||
| _CompanyCode | I_OperationalAcctgDocItem | _CompanyCode | ||
| _FiscalYear | I_OperationalAcctgDocItem | _FiscalYear | ||
| _JournalEntry | I_OperationalAcctgDocItem | _JournalEntry | ||
| _GLAccountInChartOfAccounts | I_OperationalAcctgDocItem | _GLAccountInChartOfAccounts | ||
| _ChartOfAccounts | I_OperationalAcctgDocItem | _ChartOfAccounts | ||
| _PostingKey | I_OperationalAcctgDocItem | _PostingKey | ||
| _FinancialAccountType | I_OperationalAcctgDocItem | _FinancialAccountType | ||
| _DebitCreditCode | I_OperationalAcctgDocItem | _DebitCreditCode | ||
| _BusinessArea | I_OperationalAcctgDocItem | _BusinessArea | ||
| _PartnerBusinessArea | I_OperationalAcctgDocItem | _PartnerBusinessArea | ||
| _TaxType | I_OperationalAcctgDocItem | _TaxType | ||
| _ControllingArea | I_OperationalAcctgDocItem | _ControllingArea | ||
| _ProfitCenter | I_OperationalAcctgDocItem | _ProfitCenter | ||
| _CostCenter | I_OperationalAcctgDocItem | _CostCenter | ||
| _SupplyingCountry | I_OperationalAcctgDocItem | _SupplyingCountry | ||
| _Product | I_OperationalAcctgDocItem | _Product | ||
| _Plant | I_OperationalAcctgDocItem | _Plant | ||
| _BaseUnit | I_OperationalAcctgDocItem | _BaseUnit | ||
| _InventoryValuationType | I_OperationalAcctgDocItem | _InventoryValuationType | ||
| _PaymentDifferenceReason | I_OperationalAcctgDocItem | _PaymentDifferenceReason | ||
| _Segment | I_OperationalAcctgDocItem | _Segment | ||
| _PartnerSegment | I_OperationalAcctgDocItem | _PartnerSegment | ||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _AccountingDocumentType | I_OperationalAcctgDocItem | _AccountingDocumentType | ||
| _TransactionCurrency | I_OperationalAcctgDocItem | _TransactionCurrency | ||
| _InternalOrder | I_OperationalAcctgDocItem | _InternalOrder | ||
| _Order | I_OperationalAcctgDocItem | _Order | ||
| _MasterFixedAsset | I_OperationalAcctgDocItem | _MasterFixedAsset | ||
| _FixedAsset | I_OperationalAcctgDocItem | _FixedAsset | ||
| _AssetTransactionType | I_OperationalAcctgDocItem | _AssetTransactionType | ||
| _PurchasingDocument | I_OperationalAcctgDocItem | _PurchasingDocument | ||
| _PurchasingDocumentItem | I_OperationalAcctgDocItem | _PurchasingDocumentItem | ||
| _ValuationArea | I_OperationalAcctgDocItem | _ValuationArea | ||
| _ProjectNetwork | I_OperationalAcctgDocItem | _ProjectNetwork | ||
| _CostCtrActivityType | I_OperationalAcctgDocItem | _CostCtrActivityType | ||
| _BusinessProcess | I_OperationalAcctgDocItem | _BusinessProcess | ||
| _FunctionalArea | I_OperationalAcctgDocItem | _FunctionalArea | ||
| _AdditionalCurrencyRoles | _AdditionalCurrencyRoles | |||
| _CurrentCostCenter | _CurrentCostCenter | |||
| _CurrentProfitCenter | _CurrentProfitCenter | |||
| _Customer | I_OperationalAcctgDocItem | _Customer | ||
| _CustomerCompany | I_OperationalAcctgDocItem | _CustomerCompany | ||
| _GLAccountInCompanyCode | I_OperationalAcctgDocItem | _GLAccountInCompanyCode | ||
| _SalesDocument | _SalesDocument | |||
| _ServiceDocument | _ServiceDocument | |||
| _Supplier | I_OperationalAcctgDocItem | _Supplier | ||
| _SupplierCompany | I_OperationalAcctgDocItem | _SupplierCompany | ||
| _FinancialManagementArea | ||||
| _FundsCenter | _FundsCenter | |||
| _Fund | _Fund | |||
| _PartnerFund | _PartnerFund | |||
| _FundedProgram | _FundedProgram | |||
| _CashLedgerCompanyCode | _CashLedgerCompanyCode | |||
| _CashLedgerAccount | _CashLedgerAccount | |||
| _BudgetPeriod | I_OperationalAcctgDocItem | _BudgetPeriod | ||
| _PartnerBudgetPeriod | I_OperationalAcctgDocItem | _PartnerBudgetPeriod | ||
| _Grant | I_OperationalAcctgDocItem | _Grant | ||
| _PartnerGrant | I_OperationalAcctgDocItem | _PartnerGrant | ||
| _PubSecBudgetAccountCoCode | _PubSecBudgetAccountCoCode | |||
| KEY | CompanyCode | I_ParkedOplAcctgDocItem | CompanyCode | |
| KEY | FiscalYear | I_ParkedOplAcctgDocItem | SourceFiscalYear | |
| KEY | AccountingDocument | I_ParkedOplAcctgDocItem | SourceAccountingDocument | |
| KEY | AccountingDocumentItem | I_ParkedOplAcctgDocItem | SourceAccountingDocumentItem | |
| ChartOfAccounts | I_ParkedOplAcctgDocItem | ChartOfAccounts | ||
| ClearingDate | ||||
| ClearingCreationDate | ||||
| ClearingJournalEntry | ||||
| ClearingAccountingDocument | ||||
| PostingKey | I_ParkedOplAcctgDocItem | PostingKey | ||
| FinancialAccountType | I_ParkedOplAcctgDocItem | FinancialAccountType | ||
| SpecialGLCode | I_ParkedOplAcctgDocItem | SpecialGLCode | ||
| SpecialGLTransactionType | I_ParkedOplAcctgDocItem | SpecialGLTransactionType | ||
| DebitCreditCode | I_ParkedOplAcctgDocItem | DebitCreditCode | ||
| BusinessArea | I_ParkedOplAcctgDocItem | BusinessArea | ||
| PartnerBusinessArea | I_ParkedOplAcctgDocItem | PartnerBusinessArea | ||
| TaxCode | I_ParkedOplAcctgDocItem | TaxCode | ||
| WithholdingTaxCode | I_ParkedOplAcctgDocItem | WithholdingTaxCode | ||
| TaxType | I_ParkedOplAcctgDocItem | TaxType | ||
| TransactionTypeDetermination | ||||
| ValueDate | I_ParkedOplAcctgDocItem | ValueDate | ||
| AssignmentReference | I_ParkedOplAcctgDocItem | AssignmentReference | ||
| DocumentItemText | I_ParkedOplAcctgDocItem | DocumentItemText | ||
| PartnerCompany | ||||
| FinancialTransactionType | I_ParkedOplAcctgDocItem | FinancialTransactionType | ||
| CorporateGroupAccount | ||||
| PlanningLevel | I_ParkedOplAcctgDocItem | PlanningLevel | ||
| ControllingArea | I_ParkedOplAcctgDocItem | ControllingArea | ||
| CostCenter | I_ParkedOplAcctgDocItem | CostCenter | ||
| OrderID | I_ParkedOplAcctgDocItem | OrderID | ||
| BillingDocument | ||||
| SalesDocument | ||||
| SalesDocumentItem | ||||
| ScheduleLine | ||||
| ServiceDocumentType | ||||
| ServiceDocument | ||||
| ServiceDocumentItem | ||||
| MasterFixedAsset | I_ParkedOplAcctgDocItem | MasterFixedAsset | ||
| FixedAsset | I_ParkedOplAcctgDocItem | FixedAsset | ||
| AssetTransactionType | I_ParkedOplAcctgDocItem | AssetTransactionType | ||
| AssetValueDate | I_ParkedOplAcctgDocItem | AssetValueDate | ||
| PersonnelNumber | I_ParkedOplAcctgDocItem | PersonnelNumber | ||
| IsSalesRelated | I_ParkedOplAcctgDocItem | IsSalesRelated | ||
| LineItemDisplayIsEnabled | ||||
| IsOpenItemManaged | ||||
| IsNotCashDiscountLiable | I_ParkedOplAcctgDocItem | IsNotCashDiscountLiable | ||
| IsAutomaticallyCreated | ||||
| IsUsedInPaymentTransaction | ||||
| OperationalGLAccount | ||||
| GLAccount | I_ParkedOplAcctgDocItem | GLAccount | ||
| Customer | ||||
| Supplier | ||||
| BranchAccount | I_ParkedOplAcctgDocItem | BranchAccount | ||
| IsBalanceSheetAccount | ||||
| ProfitLossAccountType | ||||
| SpecialGLAccountAssignment | I_ParkedOplAcctgDocItem | SpecialGLAccountAssignment | ||
| DueCalculationBaseDate | I_ParkedOplAcctgDocItem | DueCalculationBaseDate | ||
| PaymentTerms | I_ParkedOplAcctgDocItem | PaymentTerms | ||
| CashDiscount1Days | I_ParkedOplAcctgDocItem | CashDiscount1Days | ||
| CashDiscount2Days | I_ParkedOplAcctgDocItem | CashDiscount2Days | ||
| NetPaymentDays | I_ParkedOplAcctgDocItem | NetPaymentDays | ||
| CashDiscount1Percent | ||||
| CashDiscount2Percent | ||||
| PaymentMethod | I_ParkedOplAcctgDocItem | PaymentMethod | ||
| PaymentBlockingReason | ||||
| FixedCashDiscount | I_ParkedOplAcctgDocItem | FixedCashDiscount | ||
| HouseBank | I_ParkedOplAcctgDocItem | HouseBank | ||
| BPBankAccountInternalID | I_ParkedOplAcctgDocItem | BPBankAccountInternalID | ||
| TaxDistributionCode1 | ||||
| TaxDistributionCode2 | ||||
| TaxDistributionCode3 | ||||
| InvoiceReference | ||||
| InvoiceReferenceFiscalYear | ||||
| InvoiceItemReference | I_ParkedOplAcctgDocItem | InvoiceItemReference | ||
| FollowOnDocumentType | I_ParkedOplAcctgDocItem | FollowOnDocumentType | ||
| StateCentralBankPaymentReason | I_ParkedOplAcctgDocItem | StateCentralBankPaymentReason | ||
| SupplyingCountry | I_ParkedOplAcctgDocItem | SupplyingCountry | ||
| InvoiceList | ||||
| BillOfExchangeUsage | ||||
| DunningKey | I_ParkedOplAcctgDocItem | DunningKey | ||
| DunningBlockingReason | I_ParkedOplAcctgDocItem | DunningBlockingReason | ||
| LastDunningDate | I_ParkedOplAcctgDocItem | LastDunningDate | ||
| DunningLevel | I_ParkedOplAcctgDocItem | DunningLevel | ||
| DunningArea | I_ParkedOplAcctgDocItem | DunningArea | ||
| WithholdingTaxCertificate | ||||
| Product | I_ParkedOplAcctgDocItem | Product | ||
| Plant | I_ParkedOplAcctgDocItem | Plant | ||
| PurchasingDocument | I_ParkedOplAcctgDocItem | PurchasingDocument | ||
| PurchasingDocumentItem | I_ParkedOplAcctgDocItem | PurchasingDocumentItem | ||
| AccountAssignmentNumber | I_ParkedOplAcctgDocItem | AccountAssignmentNumber | ||
| IsCompletelyDelivered | ||||
| MaterialPriceControl | I_ParkedOplAcctgDocItem | MaterialPriceControl | ||
| ValuationArea | I_ParkedOplAcctgDocItem | ValuationArea | ||
| InventoryValuationType | I_ParkedOplAcctgDocItem | InventoryValuationType | ||
| VATRegistration | I_ParkedOplAcctgDocItem | VATRegistration | ||
| DelivOfGoodsDestCountry | ||||
| PaymentDifferenceReason | I_ParkedOplAcctgDocItem | PaymentDifferenceReason | ||
| ProfitCenter | I_ParkedOplAcctgDocItem | ProfitCenter | ||
| JointVenture | I_ParkedOplAcctgDocItem | JointVenture | ||
| JointVentureCostRecoveryCode | I_ParkedOplAcctgDocItem | JointVentureCostRecoveryCode | ||
| JointVentureEquityGroup | I_ParkedOplAcctgDocItem | JointVentureEquityGroup | ||
| TreasuryContractType | I_ParkedOplAcctgDocItem | TreasuryContractType | ||
| AssetContract | I_ParkedOplAcctgDocItem | AssetContract | ||
| CashFlowType | I_ParkedOplAcctgDocItem | CashFlowType | ||
| TaxJurisdiction | I_ParkedOplAcctgDocItem | TaxJurisdiction | ||
| REInternalFinNumber | I_ParkedOplAcctgDocItem | REInternalFinNumber | ||
| RealEstateObject | ||||
| SettlementReferenceDate | I_ParkedOplAcctgDocItem | SettlementReferenceDate | ||
| CommitmentItem | ||||
| CommitmentItemShortID | I_ParkedOplAcctgDocItem | CommitmentItemShortID | ||
| CostObject | I_ParkedOplAcctgDocItem | CostObject | ||
| ProjectNetwork | I_ParkedOplAcctgDocItem | ProjectNetwork | ||
| OrderInternalBillOfOperations | I_ParkedOplAcctgDocItem | OrderInternalBillOfOperations | ||
| OrderIntBillOfOperationsItem | ||||
| WBSElementInternalID | ||||
| ProfitabilitySegment | ||||
| ProfitabilitySegment_2 | I_ParkedOplAcctgDocItem | ProfitabilitySegment | ||
| JointVentureEquityType | I_ParkedOplAcctgDocItem | JointVentureEquityType | ||
| IsEUTriangularDeal | I_ParkedOplAcctgDocItem | IsEUTriangularDeal | ||
| CostOriginGroup | I_ParkedOplAcctgDocItem | CostOriginGroup | ||
| CompanyCodeCurrencyDetnMethod | I_ParkedOplAcctgDocItem | CompanyCodeCurrencyDetnMethod | ||
| ClearingIsReversed | ||||
| PaymentMethodSupplement | I_ParkedOplAcctgDocItem | PaymentMethodSupplement | ||
| AlternativeGLAccount | ||||
| PartnerProfitCenter | ||||
| Reference1IDByBusinessPartner | I_ParkedOplAcctgDocItem | Reference1IDByBusinessPartner | ||
| Reference2IDByBusinessPartner | I_ParkedOplAcctgDocItem | Reference2IDByBusinessPartner | ||
| IsNegativePosting | ||||
| PaymentCardItem | ||||
| PaymentCardPaymentSettlement | I_ParkedOplAcctgDocItem | PaymentCardPaymentSettlement | ||
| CreditControlArea | I_ParkedOplAcctgDocItem | CreditControlArea | ||
| Reference3IDByBusinessPartner | I_ParkedOplAcctgDocItem | Reference3IDByBusinessPartner | ||
| DataExchangeInstruction1 | I_ParkedOplAcctgDocItem | DataExchangeInstruction1 | ||
| DataExchangeInstruction2 | I_ParkedOplAcctgDocItem | DataExchangeInstruction2 | ||
| DataExchangeInstruction3 | I_ParkedOplAcctgDocItem | DataExchangeInstruction3 | ||
| DataExchangeInstruction4 | I_ParkedOplAcctgDocItem | DataExchangeInstruction4 | ||
| Region | I_ParkedOplAcctgDocItem | Region | ||
| HasPaymentOrder | ||||
| PaymentReference | I_ParkedOplAcctgDocItem | PaymentReference | ||
| TaxDeterminationDate | ||||
| ClearingItem | ||||
| BusinessPlace | I_ParkedOplAcctgDocItem | BusinessPlace | ||
| TaxSection | ||||
| CostCtrActivityType | I_ParkedOplAcctgDocItem | CostCtrActivityType | ||
| AccountsReceivableIsPledged | ||||
| AcctsReceivablePledgingCode | ||||
| BusinessProcess | I_ParkedOplAcctgDocItem | BusinessProcess | ||
| FunctionalArea | I_ParkedOplAcctgDocItem | FunctionalArea | ||
| CustomerIsInExecution | ||||
| ClearingJournalEntryFiscalYear | ||||
| ClearingDocFiscalYear | ||||
| LedgerGLLineItem | ||||
| Segment | I_ParkedOplAcctgDocItem | Segment | ||
| PartnerSegment | I_ParkedOplAcctgDocItem | PartnerSegment | ||
| PartnerFunctionalArea | ||||
| HouseBankAccount | ||||
| CostElement | ||||
| PaymentServiceProvider | ||||
| PaymentRefByPaytSrvcProvider | ||||
| SEPAMandate | ||||
| ReferenceDocumentType | ||||
| OriginalReferenceDocument | ||||
| ReferenceDocumentLogicalSystem | ||||
| AccountingDocumentItemRef | ||||
| FiscalPeriod | ||||
| AccountingDocumentCategory | ||||
| PostingDate | ||||
| DocumentDate | ||||
| AccountingDocumentType | ||||
| NetDueDate | I_ParkedOplAcctgDocItem | NetDueDate | ||
| CashDiscount1DueDate | I_ParkedOplAcctgDocItem | CashDiscount1DueDate | ||
| CashDiscount2DueDate | I_ParkedOplAcctgDocItem | CashDiscount2DueDate | ||
| OffsettingAccount | ||||
| OffsettingAccountType | ||||
| OffsettingChartOfAccounts | ||||
| CashLedgerCompanyCode | ||||
| CashLedgerAccount | ||||
| FinancialManagementArea | I_ParkedOplAcctgDocItem | FinancialManagementArea | ||
| FundsCenter | I_ParkedOplAcctgDocItem | FundsCenter | ||
| FundedProgram | I_ParkedOplAcctgDocItem | FundedProgram | ||
| Fund | I_ParkedOplAcctgDocItem | Fund | ||
| GrantID | I_ParkedOplAcctgDocItem | GrantID | ||
| BudgetPeriod | I_ParkedOplAcctgDocItem | BudgetPeriod | ||
| PartnerFund | I_ParkedOplAcctgDocItem | PartnerFund | ||
| PartnerGrant | I_ParkedOplAcctgDocItem | PartnerGrant | ||
| PartnerBudgetPeriod | I_ParkedOplAcctgDocItem | PartnerBudgetPeriod | ||
| PubSecBudgetAccount | ||||
| PubSecBudgetAccountCoCode | ||||
| CompanyCodeCurrency | ||||
| AmountInCompanyCodeCurrency | I_ParkedOplAcctgDocItem | AmountInCompanyCodeCurrency | ||
| TaxAmountInCoCodeCrcy | ||||
| TaxBaseAmountInCoCodeCrcy | I_ParkedOplAcctgDocItem | TaxBaseAmountInCoCodeCrcy | ||
| ValuationDiffAmtInCoCodeCrcy | ||||
| CashDiscountAmtInCoCodeCrcy | I_ParkedOplAcctgDocItem | CashDiscountAmtInCoCodeCrcy | ||
| InvoiceAmtInCoCodeCrcy | I_ParkedOplAcctgDocItem | InvoiceAmtInCoCodeCrcy | ||
| FunctionalCurrency | ||||
| AmountInFunctionalCurrency | ||||
| TransactionCurrency | ||||
| AmountInTransactionCurrency | I_ParkedOplAcctgDocItem | AmountInTransactionCurrency | ||
| OriginalTaxBaseAmount | ||||
| TaxAmount | I_ParkedOplAcctgDocItem | TaxAmount | ||
| TaxBaseAmountInTransCrcy | I_ParkedOplAcctgDocItem | TaxBaseAmountInTransCrcy | ||
| WithholdingTaxBaseAmount | I_ParkedOplAcctgDocItem | WithholdingTaxBaseAmount | ||
| PlannedAmtInTransactionCrcy | I_ParkedOplAcctgDocItem | PlannedAmtInTransactionCrcy | ||
| CashDiscountBaseAmount | I_ParkedOplAcctgDocItem | CashDiscountBaseAmount | ||
| CashDiscountAmount | ||||
| NetPaymentAmount | ||||
| WithholdingTaxAmount | I_ParkedOplAcctgDocItem | WithholdingTaxAmount | ||
| WithholdingTaxExemptionAmt | I_ParkedOplAcctgDocItem | WithholdingTaxExemptionAmt | ||
| InvoiceAmountInFrgnCurrency | I_ParkedOplAcctgDocItem | InvoiceAmountInFrgnCurrency | ||
| BalanceTransactionCurrency | ||||
| AmountInBalanceTransacCrcy | ||||
| AdditionalCurrency1 | ||||
| ValuationDiffAmtInAddlCrcy1 | ||||
| AmountInAdditionalCurrency1 | I_ParkedOplAcctgDocItem | AmountInAdditionalCurrency1 | ||
| AdditionalCurrency2 | ||||
| AmountInAdditionalCurrency2 | I_ParkedOplAcctgDocItem | AmountInAdditionalCurrency2 | ||
| ValuationDiffAmtInAddlCrcy2 | ||||
| PaymentCurrency | I_ParkedOplAcctgDocItem | PaymentCurrency | ||
| AmountInPaymentCurrency | ||||
| CreditControlAreaCurrency | ||||
| HedgedAmount | ||||
| BaseUnit | I_ParkedOplAcctgDocItem | BaseUnit | ||
| Quantityasquan1_12endasQuantity | ||||
| AbsoluteQuantity | ||||
| GoodsMovementEntryUnit | ||||
| QuantityInEntryUnit | ||||
| PurchasingDocumentPriceUnit | ||||
| PurchaseOrderQty | ||||
| MaterialPriceUnitQty | I_ParkedOplAcctgDocItem | MaterialPriceUnitQty | ||
| Ledger | ||||
| LedgerGroup | ||||
| NumberOfItems | ||||
| ClearingStatusSelection | ||||
| _CompanyCode | I_ParkedOplAcctgDocItem | _CompanyCode | ||
| _FiscalYear | _FiscalYear | |||
| _JournalEntry | _JournalEntry | |||
| _GLAccountInChartOfAccounts | I_ParkedOplAcctgDocItem | _GLAccountInChartOfAccounts | ||
| _ChartOfAccounts | I_ParkedOplAcctgDocItem | _ChartOfAccounts | ||
| _PostingKey | I_ParkedOplAcctgDocItem | _PostingKey | ||
| _FinancialAccountType | I_ParkedOplAcctgDocItem | _FinancialAccountType | ||
| _DebitCreditCode | I_ParkedOplAcctgDocItem | _DebitCreditCode | ||
| _BusinessArea | I_ParkedOplAcctgDocItem | _BusinessArea | ||
| _PartnerBusinessArea | I_ParkedOplAcctgDocItem | _PartnerBusinessArea | ||
| _TaxType | I_ParkedOplAcctgDocItem | _TaxType | ||
| _ControllingArea | I_ParkedOplAcctgDocItem | _ControllingArea | ||
| _ProfitCenter | I_ParkedOplAcctgDocItem | _ProfitCenter | ||
| _CostCenter | I_ParkedOplAcctgDocItem | _CostCenter | ||
| _SupplyingCountry | I_ParkedOplAcctgDocItem | _SupplyingCountry | ||
| _Product | I_ParkedOplAcctgDocItem | _Product | ||
| _Plant | I_ParkedOplAcctgDocItem | _Plant | ||
| _BaseUnit | I_ParkedOplAcctgDocItem | _BaseUnit | ||
| _InventoryValuationType | I_ParkedOplAcctgDocItem | _InventoryValuationType | ||
| _PaymentDifferenceReason | I_ParkedOplAcctgDocItem | _PaymentDifferenceReason | ||
| _Segment | I_ParkedOplAcctgDocItem | _Segment | ||
| _PartnerSegment | I_ParkedOplAcctgDocItem | _PartnerSegment | ||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _AccountingDocumentType | ||||
| _TransactionCurrency | ||||
| _InternalOrder | _InternalOrder | |||
| _Order | I_ParkedOplAcctgDocItem | _Order | ||
| _MasterFixedAsset | I_ParkedOplAcctgDocItem | _MasterFixedAsset | ||
| _FixedAsset | I_ParkedOplAcctgDocItem | _FixedAsset | ||
| _AssetTransactionType | I_ParkedOplAcctgDocItem | _AssetTransactionType | ||
| _PurchasingDocument | I_ParkedOplAcctgDocItem | _PurchasingDocument | ||
| _PurchasingDocumentItem | I_ParkedOplAcctgDocItem | _PurchasingDocumentItem | ||
| _ValuationArea | _ValuationArea | |||
| _ProjectNetwork | I_ParkedOplAcctgDocItem | _ProjectNetwork | ||
| _CostCtrActivityType | I_ParkedOplAcctgDocItem | _CostCtrActivityType | ||
| _BusinessProcess | I_ParkedOplAcctgDocItem | _BusinessProcess | ||
| _FunctionalArea | I_ParkedOplAcctgDocItem | _FunctionalArea | ||
| _AdditionalCurrencyRoles | _AdditionalCurrencyRoles | |||
| _CurrentCostCenter | _CurrentCostCenter | |||
| _CurrentProfitCenter | _CurrentProfitCenter | |||
| _Customer | I_ParkedOplAcctgDocItem | _Customer | ||
| _CustomerCompany | I_ParkedOplAcctgDocItem | _CustomerCompany | ||
| _GLAccountInCompanyCode | I_ParkedOplAcctgDocItem | _GLAccountInCompanyCode | ||
| _SalesDocument | _SalesDocument | |||
| _ServiceDocument | _ServiceDocument | |||
| _Supplier | I_ParkedOplAcctgDocItem | _Supplier | ||
| _SupplierCompany | I_ParkedOplAcctgDocItem | _SupplierCompany | ||
| _FinancialManagementArea | _FinancialManagementArea | |||
| _FundsCenter | _FundsCenter | |||
| _Fund | _Fund | |||
| _PartnerFund | _PartnerFund | |||
| _FundedProgram | _FundedProgram | |||
| _CashLedgerCompanyCode | _CashLedgerCompanyCode | |||
| _CashLedgerAccount | _CashLedgerAccount | |||
| _BudgetPeriod | I_ParkedOplAcctgDocItem | _BudgetPeriod | ||
| _PartnerBudgetPeriod | I_ParkedOplAcctgDocItem | _PartnerBudgetPeriod | ||
| _Grant | I_ParkedOplAcctgDocItem | _Grant | ||
| _PartnerGrant | I_ParkedOplAcctgDocItem | _PartnerGrant | ||
| _PubSecBudgetAccountCoCode | _PubSecBudgetAccountCoCode | |||
| KEY | CompanyCode | I_AddlLedgerOplAcctgDocItem | CompanyCode | |
| KEY | FiscalYear | I_AddlLedgerOplAcctgDocItem | FiscalYear | |
| KEY | AccountingDocument | I_AddlLedgerOplAcctgDocItem | AccountingDocument | |
| KEY | AccountingDocumentItem | |||
| ChartOfAccounts | I_AddlLedgerOplAcctgDocItem | ChartOfAccounts | ||
| ClearingDate | I_AddlLedgerOplAcctgDocItem | ClearingDate | ||
| ClearingCreationDate | I_AddlLedgerOplAcctgDocItem | ClearingCreationDate | ||
| ClearingJournalEntry | I_AddlLedgerOplAcctgDocItem | ClearingJournalEntry | ||
| ClearingAccountingDocument | I_AddlLedgerOplAcctgDocItem | ClearingAccountingDocument | ||
| PostingKey | I_AddlLedgerOplAcctgDocItem | PostingKey | ||
| FinancialAccountType | I_AddlLedgerOplAcctgDocItem | FinancialAccountType | ||
| SpecialGLCode | ||||
| SpecialGLTransactionType | ||||
| DebitCreditCode | I_AddlLedgerOplAcctgDocItem | DebitCreditCode | ||
| BusinessArea | I_AddlLedgerOplAcctgDocItem | BusinessArea | ||
| PartnerBusinessArea | I_AddlLedgerOplAcctgDocItem | PartnerBusinessArea | ||
| TaxCode | I_AddlLedgerOplAcctgDocItem | TaxCode | ||
| WithholdingTaxCode | I_AddlLedgerOplAcctgDocItem | WithholdingTaxCode | ||
| TaxType | ||||
| TransactionTypeDetermination | I_AddlLedgerOplAcctgDocItem | TransactionTypeDetermination | ||
| ValueDate | I_AddlLedgerOplAcctgDocItem | ValueDate | ||
| AssignmentReference | I_AddlLedgerOplAcctgDocItem | AssignmentReference | ||
| DocumentItemText | I_AddlLedgerOplAcctgDocItem | DocumentItemText | ||
| PartnerCompany | I_AddlLedgerOplAcctgDocItem | PartnerCompany | ||
| FinancialTransactionType | I_AddlLedgerOplAcctgDocItem | FinancialTransactionType | ||
| CorporateGroupAccount | I_AddlLedgerOplAcctgDocItem | CorporateGroupAccount | ||
| PlanningLevel | ||||
| ControllingArea | I_AddlLedgerOplAcctgDocItem | ControllingArea | ||
| CostCenter | I_AddlLedgerOplAcctgDocItem | CostCenter | ||
| OrderID | I_AddlLedgerOplAcctgDocItem | OrderID | ||
| BillingDocument | ||||
| SalesDocument | ||||
| SalesDocumentItem | ||||
| ScheduleLine | ||||
| ServiceDocumentType | ||||
| ServiceDocument | ||||
| ServiceDocumentItem | ||||
| MasterFixedAsset | I_AddlLedgerOplAcctgDocItem | MasterFixedAsset | ||
| FixedAsset | I_AddlLedgerOplAcctgDocItem | FixedAsset | ||
| AssetTransactionType | I_AddlLedgerOplAcctgDocItem | AssetTransactionType | ||
| AssetValueDate | ||||
| PersonnelNumber | ||||
| IsSalesRelated | ||||
| LineItemDisplayIsEnabled | ||||
| IsOpenItemManaged | I_AddlLedgerOplAcctgDocItem | IsOpenItemManaged | ||
| IsNotCashDiscountLiable | ||||
| IsAutomaticallyCreated | I_AddlLedgerOplAcctgDocItem | IsAutomaticallyCreated | ||
| IsUsedInPaymentTransaction | ||||
| OperationalGLAccount | ||||
| GLAccount | I_AddlLedgerOplAcctgDocItem | GLAccount | ||
| Customer | ||||
| Supplier | ||||
| BranchAccount | ||||
| IsBalanceSheetAccount | I_AddlLedgerOplAcctgDocItem | IsBalanceSheetAccount | ||
| ProfitLossAccountType | I_AddlLedgerOplAcctgDocItem | ProfitLossAccountType | ||
| SpecialGLAccountAssignment | ||||
| DueCalculationBaseDate | I_AddlLedgerOplAcctgDocItem | DueCalculationBaseDate | ||
| PaymentTerms | ||||
| CashDiscount1Days | ||||
| CashDiscount2Days | ||||
| NetPaymentDays | ||||
| CashDiscount1Percent | ||||
| CashDiscount2Percent | ||||
| PaymentMethod | ||||
| PaymentBlockingReason | ||||
| FixedCashDiscount | ||||
| HouseBank | ||||
| BPBankAccountInternalID | ||||
| TaxDistributionCode1 | ||||
| TaxDistributionCode2 | ||||
| TaxDistributionCode3 | ||||
| InvoiceReference | I_AddlLedgerOplAcctgDocItem | InvoiceReference | ||
| InvoiceReferenceFiscalYear | I_AddlLedgerOplAcctgDocItem | InvoiceReferenceFiscalYear | ||
| InvoiceItemReference | I_AddlLedgerOplAcctgDocItem | InvoiceItemReference | ||
| FollowOnDocumentType | I_AddlLedgerOplAcctgDocItem | FollowOnDocumentType | ||
| StateCentralBankPaymentReason | ||||
| SupplyingCountry | ||||
| InvoiceList | ||||
| BillOfExchangeUsage | I_AddlLedgerOplAcctgDocItem | BillOfExchangeUsage | ||
| DunningKey | ||||
| DunningBlockingReason | ||||
| LastDunningDate | ||||
| DunningLevel | ||||
| DunningArea | ||||
| WithholdingTaxCertificate | ||||
| Product | I_AddlLedgerOplAcctgDocItem | Material | ||
| Plant | I_AddlLedgerOplAcctgDocItem | Plant | ||
| PurchasingDocument | ||||
| PurchasingDocumentItem | ||||
| AccountAssignmentNumber | ||||
| IsCompletelyDelivered | ||||
| MaterialPriceControl | ||||
| ValuationArea | I_AddlLedgerOplAcctgDocItem | ValuationArea | ||
| InventoryValuationType | I_AddlLedgerOplAcctgDocItem | InventoryValuationType | ||
| VATRegistration | ||||
| DelivOfGoodsDestCountry | ||||
| PaymentDifferenceReason | ||||
| ProfitCenter | I_AddlLedgerOplAcctgDocItem | ProfitCenter | ||
| JointVenture | I_AddlLedgerOplAcctgDocItem | JointVenture | ||
| JointVentureCostRecoveryCode | I_AddlLedgerOplAcctgDocItem | JointVentureCostRecoveryCode | ||
| JointVentureEquityGroup | I_AddlLedgerOplAcctgDocItem | JointVentureEquityGroup | ||
| TreasuryContractType | I_AddlLedgerOplAcctgDocItem | TreasuryContractType | ||
| AssetContract | I_AddlLedgerOplAcctgDocItem | AssetContract | ||
| CashFlowType | I_AddlLedgerOplAcctgDocItem | CashFlowType | ||
| TaxJurisdiction | ||||
| REInternalFinNumber | I_AddlLedgerOplAcctgDocItem | REInternalFinNumber | ||
| RealEstateObject | I_AddlLedgerOplAcctgDocItem | RealEstateObject | ||
| SettlementReferenceDate | I_AddlLedgerOplAcctgDocItem | SettlementReferenceDate | ||
| CommitmentItem | I_AddlLedgerOplAcctgDocItem | CommitmentItem | ||
| CommitmentItemShortID | ||||
| CostObject | I_AddlLedgerOplAcctgDocItem | CostObject | ||
| ProjectNetwork | I_AddlLedgerOplAcctgDocItem | ProjectNetwork | ||
| OrderInternalBillOfOperations | I_AddlLedgerOplAcctgDocItem | OrderInternalBillOfOperations | ||
| OrderIntBillOfOperationsItem | I_AddlLedgerOplAcctgDocItem | OrderIntBillOfOperationsItem | ||
| WBSElementInternalID | ||||
| ProfitabilitySegment | I_AddlLedgerOplAcctgDocItem | ProfitabilitySegment | ||
| ProfitabilitySegment_2 | I_AddlLedgerOplAcctgDocItem | ProfitabilitySegment_2 | ||
| JointVentureEquityType | ||||
| IsEUTriangularDeal | ||||
| CostOriginGroup | ||||
| CompanyCodeCurrencyDetnMethod | ||||
| ClearingIsReversed | I_AddlLedgerOplAcctgDocItem | ClearingIsReversed | ||
| PaymentMethodSupplement | I_AddlLedgerOplAcctgDocItem | PaymentMethodSupplement | ||
| AlternativeGLAccount | I_AddlLedgerOplAcctgDocItem | AlternativeGLAccount | ||
| PartnerProfitCenter | I_AddlLedgerOplAcctgDocItem | PartnerProfitCenter | ||
| Reference1IDByBusinessPartner | I_AddlLedgerOplAcctgDocItem | Reference1IDByBusinessPartner | ||
| Reference2IDByBusinessPartner | I_AddlLedgerOplAcctgDocItem | Reference2IDByBusinessPartner | ||
| IsNegativePosting | ||||
| PaymentCardItem | I_AddlLedgerOplAcctgDocItem | PaymentCardItem | ||
| PaymentCardPaymentSettlement | I_AddlLedgerOplAcctgDocItem | PaymentCardPaymentSettlement | ||
| CreditControlArea | ||||
| Reference3IDByBusinessPartner | I_AddlLedgerOplAcctgDocItem | Reference3IDByBusinessPartner | ||
| DataExchangeInstruction1 | ||||
| DataExchangeInstruction2 | ||||
| DataExchangeInstruction3 | ||||
| DataExchangeInstruction4 | ||||
| Region | ||||
| HasPaymentOrder | ||||
| PaymentReference | ||||
| TaxDeterminationDate | ||||
| ClearingItem | I_AddlLedgerOplAcctgDocItem | ClearingItem | ||
| BusinessPlace | I_AddlLedgerOplAcctgDocItem | BusinessPlace | ||
| TaxSection | I_AddlLedgerOplAcctgDocItem | TaxSection | ||
| CostCtrActivityType | I_AddlLedgerOplAcctgDocItem | CostCtrActivityType | ||
| AccountsReceivableIsPledged | ||||
| AcctsReceivablePledgingCode | ||||
| BusinessProcess | I_AddlLedgerOplAcctgDocItem | BusinessProcess | ||
| FunctionalArea | I_AddlLedgerOplAcctgDocItem | FunctionalArea | ||
| CustomerIsInExecution | ||||
| ClearingJournalEntryFiscalYear | I_AddlLedgerOplAcctgDocItem | ClearingJournalEntryFiscalYear | ||
| ClearingDocFiscalYear | I_AddlLedgerOplAcctgDocItem | ClearingDocFiscalYear | ||
| LedgerGLLineItem | ||||
| Segment | I_AddlLedgerOplAcctgDocItem | Segment | ||
| PartnerSegment | I_AddlLedgerOplAcctgDocItem | PartnerSegment | ||
| PartnerFunctionalArea | I_AddlLedgerOplAcctgDocItem | PartnerFunctionalArea | ||
| HouseBankAccount | ||||
| CostElement | I_AddlLedgerOplAcctgDocItem | CostElement | ||
| PaymentServiceProvider | ||||
| PaymentRefByPaytSrvcProvider | ||||
| SEPAMandate | ||||
| ReferenceDocumentType | ||||
| OriginalReferenceDocument | ||||
| ReferenceDocumentLogicalSystem | ||||
| AccountingDocumentItemRef | ||||
| FiscalPeriod | _JournalEntry | FiscalPeriod | ||
| AccountingDocumentCategory | I_AddlLedgerOplAcctgDocItem | AccountingDocumentCategory | ||
| PostingDate | _JournalEntry | PostingDate | ||
| DocumentDate | ||||
| AccountingDocumentType | _JournalEntry | AccountingDocumentType | ||
| NetDueDate | I_AddlLedgerOplAcctgDocItem | NetDueDate | ||
| CashDiscount1DueDate | ||||
| CashDiscount2DueDate | ||||
| OffsettingAccount | I_AddlLedgerOplAcctgDocItem | OffsettingAccount | ||
| OffsettingAccountType | I_AddlLedgerOplAcctgDocItem | OffsettingAccountType | ||
| OffsettingChartOfAccounts | I_AddlLedgerOplAcctgDocItem | OffsettingChartOfAccounts | ||
| CashLedgerCompanyCode | I_AddlLedgerOplAcctgDocItem | CashLedgerCompanyCode | ||
| CashLedgerAccount | I_AddlLedgerOplAcctgDocItem | CashLedgerAccount | ||
| FinancialManagementArea | ||||
| FundsCenter | I_AddlLedgerOplAcctgDocItem | FundsCenter | ||
| FundedProgram | I_AddlLedgerOplAcctgDocItem | FundedProgram | ||
| Fund | I_AddlLedgerOplAcctgDocItem | Fund | ||
| GrantID | I_AddlLedgerOplAcctgDocItem | GrantID | ||
| BudgetPeriod | I_AddlLedgerOplAcctgDocItem | BudgetPeriod | ||
| PartnerFund | I_AddlLedgerOplAcctgDocItem | PartnerFund | ||
| PartnerGrant | I_AddlLedgerOplAcctgDocItem | PartnerGrant | ||
| PartnerBudgetPeriod | I_AddlLedgerOplAcctgDocItem | PartnerBudgetPeriod | ||
| PubSecBudgetAccount | I_AddlLedgerOplAcctgDocItem | PubSecBudgetAccount | ||
| PubSecBudgetAccountCoCode | I_AddlLedgerOplAcctgDocItem | PubSecBudgetAccountCoCode | ||
| CompanyCodeCurrency | I_AddlLedgerOplAcctgDocItem | CompanyCodeCurrency | ||
| AmountInCompanyCodeCurrency | I_AddlLedgerOplAcctgDocItem | AmountInCompanyCodeCurrency | ||
| TaxAmountInCoCodeCrcy | I_AddlLedgerOplAcctgDocItem | TaxAmountInCoCodeCrcy | ||
| TaxBaseAmountInCoCodeCrcy | ||||
| ValuationDiffAmtInCoCodeCrcy | I_AddlLedgerOplAcctgDocItem | ValuationDiffAmtInCoCodeCrcy | ||
| CashDiscountAmtInCoCodeCrcy | ||||
| InvoiceAmtInCoCodeCrcy | ||||
| FunctionalCurrency | I_AddlLedgerOplAcctgDocItem | FunctionalCurrency | ||
| AmountInFunctionalCurrency | I_AddlLedgerOplAcctgDocItem | AmountInFunctionalCurrency | ||
| TransactionCurrency | I_AddlLedgerOplAcctgDocItem | TransactionCurrency | ||
| AmountInTransactionCurrency | I_AddlLedgerOplAcctgDocItem | AmountInTransactionCurrency | ||
| OriginalTaxBaseAmount | ||||
| TaxAmount | I_AddlLedgerOplAcctgDocItem | TaxAmount | ||
| TaxBaseAmountInTransCrcy | ||||
| WithholdingTaxBaseAmount | ||||
| PlannedAmtInTransactionCrcy | ||||
| CashDiscountBaseAmount | ||||
| CashDiscountAmount | ||||
| NetPaymentAmount | ||||
| WithholdingTaxAmount | ||||
| WithholdingTaxExemptionAmt | ||||
| InvoiceAmountInFrgnCurrency | ||||
| BalanceTransactionCurrency | I_AddlLedgerOplAcctgDocItem | BalanceTransactionCurrency | ||
| AmountInBalanceTransacCrcy | I_AddlLedgerOplAcctgDocItem | AmountInBalanceTransacCrcy | ||
| AdditionalCurrency1 | I_AddlLedgerOplAcctgDocItem | AdditionalCurrency1 | ||
| ValuationDiffAmtInAddlCrcy1 | I_AddlLedgerOplAcctgDocItem | ValuationDiffAmtInAddlCrcy1 | ||
| AmountInAdditionalCurrency1 | I_AddlLedgerOplAcctgDocItem | AmountInAdditionalCurrency1 | ||
| AdditionalCurrency2 | I_AddlLedgerOplAcctgDocItem | AdditionalCurrency2 | ||
| AmountInAdditionalCurrency2 | I_AddlLedgerOplAcctgDocItem | AmountInAdditionalCurrency2 | ||
| ValuationDiffAmtInAddlCrcy2 | I_AddlLedgerOplAcctgDocItem | ValuationDiffAmtInAddlCrcy2 | ||
| PaymentCurrency | ||||
| AmountInPaymentCurrency | ||||
| CreditControlAreaCurrency | ||||
| HedgedAmount | ||||
| BaseUnit | I_AddlLedgerOplAcctgDocItem | BaseUnit | ||
| Quantityasquan1_12endasQuantity | ||||
| AbsoluteQuantity | ||||
| GoodsMovementEntryUnit | ||||
| QuantityInEntryUnit | ||||
| PurchasingDocumentPriceUnit | ||||
| PurchaseOrderQty | ||||
| MaterialPriceUnitQty | ||||
| Ledger | _JournalEntry | Ledger | ||
| LedgerGroup | _JournalEntry | LedgerGroup | ||
| NumberOfItems | I_AddlLedgerOplAcctgDocItem | NumberOfItems | ||
| ClearingStatusSelection | ||||
| _CompanyCode | I_AddlLedgerOplAcctgDocItem | _CompanyCode | ||
| _FiscalYear | I_AddlLedgerOplAcctgDocItem | _FiscalYear | ||
| _JournalEntry | _JournalEntry | |||
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | |||
| _ChartOfAccounts | I_AddlLedgerOplAcctgDocItem | _ChartOfAccounts | ||
| _PostingKey | I_AddlLedgerOplAcctgDocItem | _PostingKey | ||
| _FinancialAccountType | I_AddlLedgerOplAcctgDocItem | _FinancialAccountType | ||
| _DebitCreditCode | I_AddlLedgerOplAcctgDocItem | _DebitCreditCode | ||
| _BusinessArea | I_AddlLedgerOplAcctgDocItem | _BusinessArea | ||
| _PartnerBusinessArea | I_AddlLedgerOplAcctgDocItem | _PartnerBusinessArea | ||
| _TaxType | _TaxType | |||
| _ControllingArea | I_AddlLedgerOplAcctgDocItem | _ControllingArea | ||
| _ProfitCenter | I_AddlLedgerOplAcctgDocItem | _ProfitCenter | ||
| _CostCenter | I_AddlLedgerOplAcctgDocItem | _CostCenter | ||
| _SupplyingCountry | _SupplyingCountry | |||
| _Product | _Product | |||
| _Plant | I_AddlLedgerOplAcctgDocItem | _Plant | ||
| _BaseUnit | I_AddlLedgerOplAcctgDocItem | _BaseUnit | ||
| _InventoryValuationType | I_AddlLedgerOplAcctgDocItem | _InventoryValuationType | ||
| _PaymentDifferenceReason | _PaymentDifferenceReason | |||
| _Segment | I_AddlLedgerOplAcctgDocItem | _Segment | ||
| _PartnerSegment | I_AddlLedgerOplAcctgDocItem | _PartnerSegment | ||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _AccountingDocumentType | _AccountingDocumentType | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _InternalOrder | I_AddlLedgerOplAcctgDocItem | _InternalOrder | ||
| _Order | _Order | |||
| _MasterFixedAsset | I_AddlLedgerOplAcctgDocItem | _MasterFixedAsset | ||
| _FixedAsset | I_AddlLedgerOplAcctgDocItem | _FixedAsset | ||
| _AssetTransactionType | I_AddlLedgerOplAcctgDocItem | _AssetTransactionType | ||
| _PurchasingDocument | _PurchasingDocument | |||
| _PurchasingDocumentItem | _PurchasingDocumentItem | |||
| _ValuationArea | I_AddlLedgerOplAcctgDocItem | _ValuationArea | ||
| _ProjectNetwork | I_AddlLedgerOplAcctgDocItem | _ProjectNetwork | ||
| _CostCtrActivityType | I_AddlLedgerOplAcctgDocItem | _CostCtrActivityType | ||
| _BusinessProcess | I_AddlLedgerOplAcctgDocItem | _BusinessProcess | ||
| _FunctionalArea | I_AddlLedgerOplAcctgDocItem | _FunctionalArea | ||
| _AdditionalCurrencyRoles | _AdditionalCurrencyRoles | |||
| _CurrentCostCenter | _CurrentCostCenter | |||
| _CurrentProfitCenter | _CurrentProfitCenter | |||
| _Customer | _Customer | |||
| _CustomerCompany | _CustomerCompany | |||
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | |||
| _SalesDocument | _SalesDocument | |||
| _ServiceDocument | _ServiceDocument | |||
| _Supplier | _Supplier | |||
| _SupplierCompany | _SupplierCompany | |||
| _FinancialManagementArea | ||||
| _FundsCenter | _FundsCenter | |||
| _Fund | _Fund | |||
| _PartnerFund | _PartnerFund | |||
| _FundedProgram | _FundedProgram | |||
| _CashLedgerCompanyCode | _CashLedgerCompanyCode | |||
| _CashLedgerAccount | _CashLedgerAccount | |||
| _BudgetPeriod | I_AddlLedgerOplAcctgDocItem | _BudgetPeriod | ||
| _PartnerBudgetPeriod | I_AddlLedgerOplAcctgDocItem | _PartnerBudgetPeriod | ||
| _Grant | I_AddlLedgerOplAcctgDocItem | _Grant | ||
| _PartnerGrant | I_AddlLedgerOplAcctgDocItem | _PartnerGrant | ||
| _PubSecBudgetAccountCoCode | _PubSecBudgetAccountCoCode | |||
| _PubSecBudgetAccount | _PubSecBudgetAccount |
@AbapCatalog.entityBuffer.definitionAllowed: false
@VDM.viewType: #COMPOSITE
@VDM.private:true
//@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Operational Accounting Document Header and Item'
//@ObjectModel.representativeKey: 'AccountingDocumentItem'
//@ObjectModel.usageType.sizeCategory: #XXL
//@ObjectModel.usageType.dataClass: #TRANSACTIONAL
//@ObjectModel.usageType.serviceQuality: #D
//@Analytics: { dataCategory: #CUBE, dataExtraction.enabled: true }
@Metadata.ignorePropagatedAnnotations: true
define view entity P_OperationalAcctgDocBrowser
with parameters P_ClearingStatusSelection : fis_clearingstatusselection
as select from I_OperationalAcctgDocItem as I_OperationalAcctgDocItem
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association [0..1] to I_SalesDocumentItem as _SalesDocumentItem on $projection.SalesDocument = _SalesDocumentItem.SalesDocument
and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
and _CurrentCostCenter.ValidityStartDate <= $session.system_date
and _CurrentCostCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_AdditionalCurrencyRoles as _AdditionalCurrencyRoles on $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode
and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup
and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_Fund as _Fund on $projection.FinancialManagementArea = _Fund.FinancialManagementArea
and $projection.Fund = _Fund.Fund
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
{
@Consumption.hidden: true
key cast( cast( '1' as abap.char(1)) as fis_bstat_grp preserving type ) as AccountingDocumentCatGroup,
@ObjectModel.foreignKey.association: '_CompanyCode'
key I_OperationalAcctgDocItem.CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
key I_OperationalAcctgDocItem.FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key I_OperationalAcctgDocItem.AccountingDocument,
key I_OperationalAcctgDocItem.AccountingDocumentItem,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
I_OperationalAcctgDocItem.ChartOfAccounts,
I_OperationalAcctgDocItem.ClearingDate,
I_OperationalAcctgDocItem.ClearingCreationDate,
I_OperationalAcctgDocItem.ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
I_OperationalAcctgDocItem.ClearingAccountingDocument,
I_OperationalAcctgDocItem.PostingKey,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
I_OperationalAcctgDocItem.FinancialAccountType,
I_OperationalAcctgDocItem.SpecialGLCode,
I_OperationalAcctgDocItem.SpecialGLTransactionType,
I_OperationalAcctgDocItem.DebitCreditCode,
@ObjectModel.foreignKey.association: '_BusinessArea'
I_OperationalAcctgDocItem.BusinessArea,
I_OperationalAcctgDocItem.PartnerBusinessArea,
I_OperationalAcctgDocItem.TaxCode,
I_OperationalAcctgDocItem.WithholdingTaxCode,
I_OperationalAcctgDocItem.TaxType,
I_OperationalAcctgDocItem.TransactionTypeDetermination,
I_OperationalAcctgDocItem.ValueDate,
I_OperationalAcctgDocItem.AssignmentReference,
I_OperationalAcctgDocItem.DocumentItemText,
I_OperationalAcctgDocItem.PartnerCompany,
I_OperationalAcctgDocItem.FinancialTransactionType,
I_OperationalAcctgDocItem.CorporateGroupAccount,
I_OperationalAcctgDocItem.PlanningLevel,
@ObjectModel.foreignKey.association: '_ControllingArea'
I_OperationalAcctgDocItem.ControllingArea,
@ObjectModel.foreignKey.association: '_CostCenter'
I_OperationalAcctgDocItem.CostCenter,
//ProjectInternalID, -- to be retrieved later from WBS Element
@ObjectModel.foreignKey.association: '_Order'
I_OperationalAcctgDocItem.OrderID,
I_OperationalAcctgDocItem.BillingDocument,
I_OperationalAcctgDocItem.SalesDocument,
I_OperationalAcctgDocItem.SalesDocumentItem,
I_OperationalAcctgDocItem.ScheduleLine,
I_OperationalAcctgDocItem.ServiceDocumentType,
I_OperationalAcctgDocItem.ServiceDocument,
I_OperationalAcctgDocItem.ServiceDocumentItem,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
I_OperationalAcctgDocItem.MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
I_OperationalAcctgDocItem.FixedAsset,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
I_OperationalAcctgDocItem.AssetTransactionType,
I_OperationalAcctgDocItem.AssetValueDate,
I_OperationalAcctgDocItem.PersonnelNumber,
I_OperationalAcctgDocItem.IsSalesRelated,
//xhres,
I_OperationalAcctgDocItem.LineItemDisplayIsEnabled,
I_OperationalAcctgDocItem.IsOpenItemManaged,
I_OperationalAcctgDocItem.IsNotCashDiscountLiable,
I_OperationalAcctgDocItem.IsAutomaticallyCreated,
I_OperationalAcctgDocItem.IsUsedInPaymentTransaction,
I_OperationalAcctgDocItem.OperationalGLAccount,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
I_OperationalAcctgDocItem.GLAccount,
I_OperationalAcctgDocItem.Customer,
I_OperationalAcctgDocItem.Supplier,
I_OperationalAcctgDocItem.BranchAccount,
I_OperationalAcctgDocItem.IsBalanceSheetAccount,
I_OperationalAcctgDocItem.ProfitLossAccountType,
I_OperationalAcctgDocItem.SpecialGLAccountAssignment,
I_OperationalAcctgDocItem.DueCalculationBaseDate,
I_OperationalAcctgDocItem.PaymentTerms,
I_OperationalAcctgDocItem.CashDiscount1Days,
I_OperationalAcctgDocItem.CashDiscount2Days,
I_OperationalAcctgDocItem.NetPaymentDays,
I_OperationalAcctgDocItem.CashDiscount1Percent, // ?????????
I_OperationalAcctgDocItem.CashDiscount2Percent, // ??????
I_OperationalAcctgDocItem.PaymentMethod,
I_OperationalAcctgDocItem.PaymentBlockingReason,
I_OperationalAcctgDocItem.FixedCashDiscount,
I_OperationalAcctgDocItem.HouseBank,
I_OperationalAcctgDocItem.BPBankAccountInternalID,
I_OperationalAcctgDocItem.TaxDistributionCode1,
I_OperationalAcctgDocItem.TaxDistributionCode2,
I_OperationalAcctgDocItem.TaxDistributionCode3,
I_OperationalAcctgDocItem.InvoiceReference,
I_OperationalAcctgDocItem.InvoiceReferenceFiscalYear,
I_OperationalAcctgDocItem.InvoiceItemReference,
I_OperationalAcctgDocItem.FollowOnDocumentType,
I_OperationalAcctgDocItem.StateCentralBankPaymentReason,
I_OperationalAcctgDocItem.SupplyingCountry,
I_OperationalAcctgDocItem.InvoiceList,
I_OperationalAcctgDocItem.BillOfExchangeUsage,
I_OperationalAcctgDocItem.DunningKey,
I_OperationalAcctgDocItem.DunningBlockingReason,
I_OperationalAcctgDocItem.LastDunningDate,
I_OperationalAcctgDocItem.DunningLevel,
I_OperationalAcctgDocItem.DunningArea,
I_OperationalAcctgDocItem.WithholdingTaxCertificate,
@ObjectModel.foreignKey.association: '_Product'
I_OperationalAcctgDocItem.Product,
@ObjectModel.foreignKey.association: '_Plant'
I_OperationalAcctgDocItem.Plant,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
I_OperationalAcctgDocItem.PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
I_OperationalAcctgDocItem.PurchasingDocumentItem,
I_OperationalAcctgDocItem.AccountAssignmentNumber,
I_OperationalAcctgDocItem.IsCompletelyDelivered,
I_OperationalAcctgDocItem.MaterialPriceControl,
@ObjectModel.foreignKey.association: '_ValuationArea'
I_OperationalAcctgDocItem.ValuationArea,
I_OperationalAcctgDocItem.InventoryValuationType,
I_OperationalAcctgDocItem.VATRegistration,
I_OperationalAcctgDocItem.DelivOfGoodsDestCountry,
I_OperationalAcctgDocItem.PaymentDifferenceReason,
@ObjectModel.foreignKey.association: '_ProfitCenter'
I_OperationalAcctgDocItem.ProfitCenter,
I_OperationalAcctgDocItem.JointVenture,
I_OperationalAcctgDocItem.JointVentureCostRecoveryCode,
I_OperationalAcctgDocItem.JointVentureEquityGroup,
I_OperationalAcctgDocItem.TreasuryContractType,
I_OperationalAcctgDocItem.AssetContract,
I_OperationalAcctgDocItem.CashFlowType,
//depot,
I_OperationalAcctgDocItem.TaxJurisdiction,
I_OperationalAcctgDocItem.REInternalFinNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REInternalFinNumber'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
I_OperationalAcctgDocItem.RealEstateObject,
I_OperationalAcctgDocItem.SettlementReferenceDate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'CommitmentItemShortID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'CommitmentItemShortID'
I_OperationalAcctgDocItem.CommitmentItem,
I_OperationalAcctgDocItem.CommitmentItemShortID,
I_OperationalAcctgDocItem.CostObject,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
I_OperationalAcctgDocItem.ProjectNetwork,
I_OperationalAcctgDocItem.OrderInternalBillOfOperations,
I_OperationalAcctgDocItem.OrderIntBillOfOperationsItem,
cast( I_OperationalAcctgDocItem.WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
@API.element.releaseState: #DECOMMISSIONED
@API.element.successor: 'ProfitabilitySegment_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProfitabilitySegment_2'
cast( case when I_OperationalAcctgDocItem.ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( I_OperationalAcctgDocItem.ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) as ProfitabilitySegment,
I_OperationalAcctgDocItem.ProfitabilitySegment_2,
I_OperationalAcctgDocItem.JointVentureEquityType,
I_OperationalAcctgDocItem.IsEUTriangularDeal,
I_OperationalAcctgDocItem.CostOriginGroup,
I_OperationalAcctgDocItem.CompanyCodeCurrencyDetnMethod,
I_OperationalAcctgDocItem.ClearingIsReversed,
I_OperationalAcctgDocItem.PaymentMethodSupplement,
I_OperationalAcctgDocItem.AlternativeGLAccount,
I_OperationalAcctgDocItem.PartnerProfitCenter,
I_OperationalAcctgDocItem.Reference1IDByBusinessPartner,
I_OperationalAcctgDocItem.Reference2IDByBusinessPartner,
I_OperationalAcctgDocItem.IsNegativePosting,
I_OperationalAcctgDocItem.PaymentCardItem,
I_OperationalAcctgDocItem.PaymentCardPaymentSettlement,
I_OperationalAcctgDocItem.CreditControlArea,
I_OperationalAcctgDocItem.Reference3IDByBusinessPartner,
I_OperationalAcctgDocItem.DataExchangeInstruction1,
I_OperationalAcctgDocItem.DataExchangeInstruction2,
I_OperationalAcctgDocItem.DataExchangeInstruction3,
I_OperationalAcctgDocItem.DataExchangeInstruction4,
I_OperationalAcctgDocItem.Region,
I_OperationalAcctgDocItem.HasPaymentOrder,
I_OperationalAcctgDocItem.PaymentReference,
I_OperationalAcctgDocItem.TaxDeterminationDate,
I_OperationalAcctgDocItem.ClearingItem,
I_OperationalAcctgDocItem.BusinessPlace,
I_OperationalAcctgDocItem.TaxSection,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
I_OperationalAcctgDocItem.CostCtrActivityType,
I_OperationalAcctgDocItem.AccountsReceivableIsPledged,
I_OperationalAcctgDocItem.AcctsReceivablePledgingCode,
@ObjectModel.foreignKey.association: '_BusinessProcess'
I_OperationalAcctgDocItem.BusinessProcess,
@ObjectModel.foreignKey.association: '_FunctionalArea'
I_OperationalAcctgDocItem.FunctionalArea,
I_OperationalAcctgDocItem.CustomerIsInExecution,
I_OperationalAcctgDocItem.ClearingJournalEntryFiscalYear,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
I_OperationalAcctgDocItem.ClearingDocFiscalYear,
I_OperationalAcctgDocItem.LedgerGLLineItem,
@ObjectModel.foreignKey.association: '_Segment'
I_OperationalAcctgDocItem.Segment,
I_OperationalAcctgDocItem.PartnerSegment,
I_OperationalAcctgDocItem.PartnerFunctionalArea,
I_OperationalAcctgDocItem.HouseBankAccount,
I_OperationalAcctgDocItem.CostElement,
I_OperationalAcctgDocItem.PaymentServiceProvider,
I_OperationalAcctgDocItem.PaymentRefByPaytSrvcProvider,
I_OperationalAcctgDocItem.SEPAMandate,
I_OperationalAcctgDocItem.ReferenceDocumentType,
I_OperationalAcctgDocItem.OriginalReferenceDocument,
I_OperationalAcctgDocItem.ReferenceDocumentLogicalSystem,
I_OperationalAcctgDocItem.AccountingDocumentItemRef,
I_OperationalAcctgDocItem.FiscalPeriod,
I_OperationalAcctgDocItem.AccountingDocumentCategory,
I_OperationalAcctgDocItem.PostingDate,
I_OperationalAcctgDocItem.DocumentDate,
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
I_OperationalAcctgDocItem.AccountingDocumentType,
I_OperationalAcctgDocItem.NetDueDate,
I_OperationalAcctgDocItem.CashDiscount1DueDate,
I_OperationalAcctgDocItem.CashDiscount2DueDate,
I_OperationalAcctgDocItem.OffsettingAccount,
I_OperationalAcctgDocItem.OffsettingAccountType,
I_OperationalAcctgDocItem.OffsettingChartOfAccounts,
@ObjectModel.foreignKey.association: '_CashLedgerCompanyCode'
I_OperationalAcctgDocItem.CashLedgerCompanyCode,
@ObjectModel.foreignKey.association: '_CashLedgerAccount'
I_OperationalAcctgDocItem.CashLedgerAccount,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FinMgmtAreaStdVH',
element: 'FinancialManagementArea' }
}]
// @ObjectModel.text.association: '_FinancialManagementAreaText'
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
I_OperationalAcctgDocItem._JournalEntry.FinancialManagementArea as FinancialManagementArea,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundsCenterStdVH',
element: 'FundsCenter' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
@ObjectModel.foreignKey.association: '_FundsCenter'
I_OperationalAcctgDocItem.FundsCenter,
@ObjectModel.foreignKey.association: '_FundedProgram'
I_OperationalAcctgDocItem.FundedProgram,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_FundText'
@ObjectModel.foreignKey.association: '_Fund'
I_OperationalAcctgDocItem.Fund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_Grant'
I_OperationalAcctgDocItem.GrantID,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BudgetPeriodStdVH',
element: 'BudgetPeriod' }
}]
// @ObjectModel.text.association: '_BudgetPeriodText'
@ObjectModel.foreignKey.association: '_BudgetPeriod'
I_OperationalAcctgDocItem.BudgetPeriod,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_PartnerFundText'
@ObjectModel.foreignKey.association: '_PartnerFund'
I_OperationalAcctgDocItem.PartnerFund,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartnerGrant'
I_OperationalAcctgDocItem.PartnerGrant,
@ObjectModel.foreignKey.association: '_PartnerBudgetPeriod'
I_OperationalAcctgDocItem.PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccount'
I_OperationalAcctgDocItem.PubSecBudgetAccount,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccountCoCode'
I_OperationalAcctgDocItem.PubSecBudgetAccountCoCode,
I_OperationalAcctgDocItem.CompanyCodeCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } I_OperationalAcctgDocItem.TaxAmountInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } I_OperationalAcctgDocItem.TaxBaseAmountInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } I_OperationalAcctgDocItem.ValuationDiffAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( I_OperationalAcctgDocItem.CashDiscountAmtInCoCodeCrcy as fis_sknto preserving type ) as CashDiscountAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } I_OperationalAcctgDocItem.InvoiceAmtInCoCodeCrcy,
I_OperationalAcctgDocItem.FunctionalCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
I_OperationalAcctgDocItem.AmountInFunctionalCurrency,
@ObjectModel.foreignKey.association: '_TransactionCurrency'
I_OperationalAcctgDocItem.TransactionCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.AmountInTransactionCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.OriginalTaxBaseAmount,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.TaxAmount,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.TaxBaseAmountInTransCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.WithholdingTaxBaseAmount,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.PlannedAmtInTransactionCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( I_OperationalAcctgDocItem.CashDiscountBaseAmount as fis_skfbt preserving type ) as CashDiscountBaseAmount,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.CashDiscountAmount,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.NetPaymentAmount,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.WithholdingTaxAmount,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.WithholdingTaxExemptionAmt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_OperationalAcctgDocItem.InvoiceAmountInFrgnCurrency,
I_OperationalAcctgDocItem.BalanceTransactionCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } I_OperationalAcctgDocItem.AmountInBalanceTransacCrcy,
I_OperationalAcctgDocItem.AdditionalCurrency1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } I_OperationalAcctgDocItem.ValuationDiffAmtInAddlCrcy1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} } I_OperationalAcctgDocItem.AmountInAdditionalCurrency1,
I_OperationalAcctgDocItem.AdditionalCurrency2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } I_OperationalAcctgDocItem.AmountInAdditionalCurrency2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} } I_OperationalAcctgDocItem.ValuationDiffAmtInAddlCrcy2,
I_OperationalAcctgDocItem.PaymentCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'PaymentCurrency'} } I_OperationalAcctgDocItem.AmountInPaymentCurrency,
I_OperationalAcctgDocItem.CreditControlAreaCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} } I_OperationalAcctgDocItem.HedgedAmount,
@ObjectModel.foreignKey.association: '_BaseUnit'
I_OperationalAcctgDocItem.BaseUnit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
case I_OperationalAcctgDocItem.IsNegativePosting when 'X' then case I_OperationalAcctgDocItem.DebitCreditCode when 'S' then cast(-I_OperationalAcctgDocItem.Quantity as quan1_12)
when 'H' then cast( I_OperationalAcctgDocItem.Quantity as quan1_12)
end
when ' ' then case I_OperationalAcctgDocItem.DebitCreditCode when 'H' then cast(-I_OperationalAcctgDocItem.Quantity as quan1_12)
when 'S' then cast( I_OperationalAcctgDocItem.Quantity as quan1_12)
end
else cast( I_OperationalAcctgDocItem.Quantity as quan1_12)
end as Quantity,
/*cast( case IsNegativePosting when 'X' then case DebitCreditCode when 'S' then -Quantity
when 'H' then Quantity
end
when ' ' then case DebitCreditCode when 'H' then -Quantity
when 'S' then Quantity
end
else Quantity
end as quan1_12) as Quantity,*/
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} } cast( I_OperationalAcctgDocItem.Quantity as fis_absolute_quantity ) as AbsoluteQuantity,
I_OperationalAcctgDocItem.GoodsMovementEntryUnit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} } I_OperationalAcctgDocItem.QuantityInEntryUnit,
I_OperationalAcctgDocItem.PurchasingDocumentPriceUnit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} } I_OperationalAcctgDocItem.PurchaseOrderQty,
I_OperationalAcctgDocItem.MaterialPriceUnitQty,
I_OperationalAcctgDocItem._JournalEntry.Ledger as Ledger,
I_OperationalAcctgDocItem._JournalEntry.LedgerGroup as LedgerGroup,
I_OperationalAcctgDocItem.NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
I_OperationalAcctgDocItem._CompanyCode,
I_OperationalAcctgDocItem._FiscalYear,
I_OperationalAcctgDocItem._JournalEntry,
I_OperationalAcctgDocItem._GLAccountInChartOfAccounts,
I_OperationalAcctgDocItem._ChartOfAccounts,
I_OperationalAcctgDocItem._PostingKey,
I_OperationalAcctgDocItem._FinancialAccountType,
I_OperationalAcctgDocItem._DebitCreditCode,
I_OperationalAcctgDocItem._BusinessArea,
I_OperationalAcctgDocItem._PartnerBusinessArea,
I_OperationalAcctgDocItem._TaxType,
// _PartnerCompany,
I_OperationalAcctgDocItem._ControllingArea,
I_OperationalAcctgDocItem._ProfitCenter,
I_OperationalAcctgDocItem._CostCenter,
I_OperationalAcctgDocItem._SupplyingCountry,
I_OperationalAcctgDocItem._Product,
I_OperationalAcctgDocItem._Plant,
I_OperationalAcctgDocItem._BaseUnit,
I_OperationalAcctgDocItem._InventoryValuationType,
I_OperationalAcctgDocItem._PaymentDifferenceReason,
I_OperationalAcctgDocItem._Segment,
I_OperationalAcctgDocItem._PartnerSegment,
_WBSElementBasicData,
I_OperationalAcctgDocItem._AccountingDocumentType,
I_OperationalAcctgDocItem._TransactionCurrency,
I_OperationalAcctgDocItem._InternalOrder,
I_OperationalAcctgDocItem._Order,
I_OperationalAcctgDocItem._MasterFixedAsset,
I_OperationalAcctgDocItem._FixedAsset,
I_OperationalAcctgDocItem._AssetTransactionType,
I_OperationalAcctgDocItem._PurchasingDocument,
I_OperationalAcctgDocItem._PurchasingDocumentItem,
//@API.element.releaseState: #DEPRECATED
//@API.element.successor: ''
//@VDM.lifecycle.status: #DEPRECATED
//@VDM.lifecycle.successor: ''
I_OperationalAcctgDocItem._ValuationArea,
I_OperationalAcctgDocItem._ProjectNetwork,
I_OperationalAcctgDocItem._CostCtrActivityType,
I_OperationalAcctgDocItem._BusinessProcess,
I_OperationalAcctgDocItem._FunctionalArea,
_AdditionalCurrencyRoles,
_CurrentCostCenter,
_CurrentProfitCenter,
I_OperationalAcctgDocItem._Customer,
I_OperationalAcctgDocItem._CustomerCompany,
I_OperationalAcctgDocItem._GLAccountInCompanyCode,
_SalesDocument,
_ServiceDocument,
I_OperationalAcctgDocItem._Supplier,
I_OperationalAcctgDocItem._SupplierCompany,
I_OperationalAcctgDocItem._JournalEntry._FinancialManagementArea,
_FundsCenter,
_Fund,
_PartnerFund,
_FundedProgram,
_CashLedgerCompanyCode,
_CashLedgerAccount,
I_OperationalAcctgDocItem._BudgetPeriod,
I_OperationalAcctgDocItem._PartnerBudgetPeriod,
I_OperationalAcctgDocItem._Grant,
I_OperationalAcctgDocItem._PartnerGrant,
_PubSecBudgetAccountCoCode,
_PubSecBudgetAccount
// _REObjectByIntFinNumber
}
//where AccountingDocumentCategory <> 'S'
where ( I_OperationalAcctgDocItem.AccountingDocumentCategory = ' ' and I_OperationalAcctgDocItem.SpecialGLCode = ' ' ) or
( I_OperationalAcctgDocItem.SpecialGLCode <> ' ' and I_OperationalAcctgDocItem.AccountingDocumentCategory <> 'S' and I_OperationalAcctgDocItem.AccountingDocumentCategory <> 'V' and
I_OperationalAcctgDocItem.AccountingDocumentCategory <> 'W' and I_OperationalAcctgDocItem.AccountingDocumentCategory <> 'Z' )
union all
select from I_OperationalAcctgDocItem as I_OperationalAcctgDocItem
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association [0..1] to I_SalesDocumentItem as _SalesDocumentItem on $projection.SalesDocument = _SalesDocumentItem.SalesDocument
and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
and _CurrentCostCenter.ValidityStartDate <= $session.system_date
and _CurrentCostCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_AdditionalCurrencyRoles as _AdditionalCurrencyRoles on $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode
and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup
and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_Fund as _Fund on $projection.FinancialManagementArea = _Fund.FinancialManagementArea
and $projection.Fund = _Fund.Fund
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
{
key cast( cast( '2' as abap.char(1)) as fis_bstat_grp preserving type ) as AccountingDocumentCatGroup,
key I_OperationalAcctgDocItem.CompanyCode,
key I_OperationalAcctgDocItem.FiscalYear,
key I_OperationalAcctgDocItem.AccountingDocument,
key I_OperationalAcctgDocItem.AccountingDocumentItem,
I_OperationalAcctgDocItem.ChartOfAccounts,
I_OperationalAcctgDocItem.ClearingDate,
I_OperationalAcctgDocItem.ClearingCreationDate,
I_OperationalAcctgDocItem.ClearingJournalEntry,
I_OperationalAcctgDocItem.ClearingAccountingDocument,
I_OperationalAcctgDocItem.PostingKey,
I_OperationalAcctgDocItem.FinancialAccountType,
I_OperationalAcctgDocItem.SpecialGLCode,
I_OperationalAcctgDocItem.SpecialGLTransactionType,
I_OperationalAcctgDocItem.DebitCreditCode,
I_OperationalAcctgDocItem.BusinessArea,
I_OperationalAcctgDocItem.PartnerBusinessArea,
I_OperationalAcctgDocItem.TaxCode,
I_OperationalAcctgDocItem.WithholdingTaxCode,
I_OperationalAcctgDocItem.TaxType,
I_OperationalAcctgDocItem.TransactionTypeDetermination,
I_OperationalAcctgDocItem.ValueDate,
I_OperationalAcctgDocItem.AssignmentReference,
I_OperationalAcctgDocItem.DocumentItemText,
I_OperationalAcctgDocItem.PartnerCompany,
I_OperationalAcctgDocItem.FinancialTransactionType,
I_OperationalAcctgDocItem.CorporateGroupAccount,
I_OperationalAcctgDocItem.PlanningLevel,
I_OperationalAcctgDocItem.ControllingArea,
I_OperationalAcctgDocItem.CostCenter,
//ProjectInternalID, -- to be retrieved later from WBS Element
I_OperationalAcctgDocItem.OrderID,
I_OperationalAcctgDocItem.BillingDocument,
I_OperationalAcctgDocItem.SalesDocument,
I_OperationalAcctgDocItem.SalesDocumentItem,
I_OperationalAcctgDocItem.ScheduleLine,
I_OperationalAcctgDocItem.ServiceDocumentType,
I_OperationalAcctgDocItem.ServiceDocument,
I_OperationalAcctgDocItem.ServiceDocumentItem,
I_OperationalAcctgDocItem.MasterFixedAsset,
I_OperationalAcctgDocItem.FixedAsset,
I_OperationalAcctgDocItem.AssetTransactionType,
I_OperationalAcctgDocItem.AssetValueDate,
I_OperationalAcctgDocItem.PersonnelNumber,
I_OperationalAcctgDocItem.IsSalesRelated,
//xhres,
I_OperationalAcctgDocItem.LineItemDisplayIsEnabled,
I_OperationalAcctgDocItem.IsOpenItemManaged,
I_OperationalAcctgDocItem.IsNotCashDiscountLiable,
I_OperationalAcctgDocItem.IsAutomaticallyCreated,
I_OperationalAcctgDocItem.IsUsedInPaymentTransaction,
I_OperationalAcctgDocItem.OperationalGLAccount,
I_OperationalAcctgDocItem.GLAccount,
I_OperationalAcctgDocItem.Customer,
I_OperationalAcctgDocItem.Supplier,
I_OperationalAcctgDocItem.BranchAccount,
I_OperationalAcctgDocItem.IsBalanceSheetAccount,
I_OperationalAcctgDocItem.ProfitLossAccountType,
I_OperationalAcctgDocItem.SpecialGLAccountAssignment,
I_OperationalAcctgDocItem.DueCalculationBaseDate,
I_OperationalAcctgDocItem.PaymentTerms,
I_OperationalAcctgDocItem.CashDiscount1Days,
I_OperationalAcctgDocItem.CashDiscount2Days,
I_OperationalAcctgDocItem.NetPaymentDays,
I_OperationalAcctgDocItem.CashDiscount1Percent, // ?????????
I_OperationalAcctgDocItem.CashDiscount2Percent, // ??????
I_OperationalAcctgDocItem.PaymentMethod,
I_OperationalAcctgDocItem.PaymentBlockingReason,
I_OperationalAcctgDocItem.FixedCashDiscount,
I_OperationalAcctgDocItem.HouseBank,
I_OperationalAcctgDocItem.BPBankAccountInternalID,
I_OperationalAcctgDocItem.TaxDistributionCode1,
I_OperationalAcctgDocItem.TaxDistributionCode2,
I_OperationalAcctgDocItem.TaxDistributionCode3,
I_OperationalAcctgDocItem.InvoiceReference,
I_OperationalAcctgDocItem.InvoiceReferenceFiscalYear,
I_OperationalAcctgDocItem.InvoiceItemReference,
I_OperationalAcctgDocItem.FollowOnDocumentType,
I_OperationalAcctgDocItem.StateCentralBankPaymentReason,
I_OperationalAcctgDocItem.SupplyingCountry,
I_OperationalAcctgDocItem.InvoiceList,
I_OperationalAcctgDocItem.BillOfExchangeUsage,
I_OperationalAcctgDocItem.DunningKey,
I_OperationalAcctgDocItem.DunningBlockingReason,
I_OperationalAcctgDocItem.LastDunningDate,
I_OperationalAcctgDocItem.DunningLevel,
I_OperationalAcctgDocItem.DunningArea,
I_OperationalAcctgDocItem.WithholdingTaxCertificate,
I_OperationalAcctgDocItem.Product,
I_OperationalAcctgDocItem.Plant,
I_OperationalAcctgDocItem.PurchasingDocument,
I_OperationalAcctgDocItem.PurchasingDocumentItem,
I_OperationalAcctgDocItem.AccountAssignmentNumber,
I_OperationalAcctgDocItem.IsCompletelyDelivered,
I_OperationalAcctgDocItem.MaterialPriceControl,
I_OperationalAcctgDocItem.ValuationArea,
I_OperationalAcctgDocItem.InventoryValuationType,
I_OperationalAcctgDocItem.VATRegistration,
I_OperationalAcctgDocItem.DelivOfGoodsDestCountry,
I_OperationalAcctgDocItem.PaymentDifferenceReason,
I_OperationalAcctgDocItem.ProfitCenter,
I_OperationalAcctgDocItem.JointVenture,
I_OperationalAcctgDocItem.JointVentureCostRecoveryCode,
I_OperationalAcctgDocItem.JointVentureEquityGroup,
I_OperationalAcctgDocItem.TreasuryContractType,
I_OperationalAcctgDocItem.AssetContract,
I_OperationalAcctgDocItem.CashFlowType,
//depot,
I_OperationalAcctgDocItem.TaxJurisdiction,
I_OperationalAcctgDocItem.REInternalFinNumber,
I_OperationalAcctgDocItem.RealEstateObject,
I_OperationalAcctgDocItem.SettlementReferenceDate,
I_OperationalAcctgDocItem.CommitmentItem,
I_OperationalAcctgDocItem.CommitmentItemShortID,
I_OperationalAcctgDocItem.CostObject,
I_OperationalAcctgDocItem.ProjectNetwork,
I_OperationalAcctgDocItem.OrderInternalBillOfOperations,
I_OperationalAcctgDocItem.OrderIntBillOfOperationsItem,
cast( I_OperationalAcctgDocItem.WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
I_OperationalAcctgDocItem.ProfitabilitySegment,
I_OperationalAcctgDocItem.ProfitabilitySegment_2,
I_OperationalAcctgDocItem.JointVentureEquityType,
I_OperationalAcctgDocItem.IsEUTriangularDeal,
I_OperationalAcctgDocItem.CostOriginGroup,
I_OperationalAcctgDocItem.CompanyCodeCurrencyDetnMethod,
I_OperationalAcctgDocItem.ClearingIsReversed,
I_OperationalAcctgDocItem.PaymentMethodSupplement,
I_OperationalAcctgDocItem.AlternativeGLAccount,
I_OperationalAcctgDocItem.PartnerProfitCenter,
I_OperationalAcctgDocItem.Reference1IDByBusinessPartner,
I_OperationalAcctgDocItem.Reference2IDByBusinessPartner,
I_OperationalAcctgDocItem.IsNegativePosting,
I_OperationalAcctgDocItem.PaymentCardItem,
I_OperationalAcctgDocItem.PaymentCardPaymentSettlement,
I_OperationalAcctgDocItem.CreditControlArea,
I_OperationalAcctgDocItem.Reference3IDByBusinessPartner,
I_OperationalAcctgDocItem.DataExchangeInstruction1,
I_OperationalAcctgDocItem.DataExchangeInstruction2,
I_OperationalAcctgDocItem.DataExchangeInstruction3,
I_OperationalAcctgDocItem.DataExchangeInstruction4,
I_OperationalAcctgDocItem.Region,
I_OperationalAcctgDocItem.HasPaymentOrder,
I_OperationalAcctgDocItem.PaymentReference,
I_OperationalAcctgDocItem.TaxDeterminationDate,
I_OperationalAcctgDocItem.ClearingItem,
I_OperationalAcctgDocItem.BusinessPlace,
I_OperationalAcctgDocItem.TaxSection,
I_OperationalAcctgDocItem.CostCtrActivityType,
I_OperationalAcctgDocItem.AccountsReceivableIsPledged,
I_OperationalAcctgDocItem.AcctsReceivablePledgingCode,
I_OperationalAcctgDocItem.BusinessProcess,
I_OperationalAcctgDocItem.FunctionalArea,
I_OperationalAcctgDocItem.CustomerIsInExecution,
I_OperationalAcctgDocItem.ClearingJournalEntryFiscalYear,
I_OperationalAcctgDocItem.ClearingDocFiscalYear,
I_OperationalAcctgDocItem.LedgerGLLineItem,
I_OperationalAcctgDocItem.Segment,
I_OperationalAcctgDocItem.PartnerSegment,
I_OperationalAcctgDocItem.PartnerFunctionalArea,
I_OperationalAcctgDocItem.HouseBankAccount,
I_OperationalAcctgDocItem.CostElement,
I_OperationalAcctgDocItem.PaymentServiceProvider,
I_OperationalAcctgDocItem.PaymentRefByPaytSrvcProvider,
I_OperationalAcctgDocItem.SEPAMandate,
I_OperationalAcctgDocItem.ReferenceDocumentType,
I_OperationalAcctgDocItem.OriginalReferenceDocument,
I_OperationalAcctgDocItem.ReferenceDocumentLogicalSystem,
I_OperationalAcctgDocItem.AccountingDocumentItemRef,
I_OperationalAcctgDocItem.FiscalPeriod,
I_OperationalAcctgDocItem.AccountingDocumentCategory,
I_OperationalAcctgDocItem.PostingDate,
I_OperationalAcctgDocItem.DocumentDate,
I_OperationalAcctgDocItem.AccountingDocumentType,
I_OperationalAcctgDocItem.NetDueDate,
I_OperationalAcctgDocItem.CashDiscount1DueDate,
I_OperationalAcctgDocItem.CashDiscount2DueDate,
I_OperationalAcctgDocItem.OffsettingAccount,
I_OperationalAcctgDocItem.OffsettingAccountType,
I_OperationalAcctgDocItem.OffsettingChartOfAccounts,
I_OperationalAcctgDocItem.CashLedgerCompanyCode,
I_OperationalAcctgDocItem.CashLedgerAccount,
I_OperationalAcctgDocItem._JournalEntry.FinancialManagementArea as FinancialManagementArea,
I_OperationalAcctgDocItem.FundsCenter,
I_OperationalAcctgDocItem.FundedProgram,
I_OperationalAcctgDocItem.Fund,
I_OperationalAcctgDocItem.GrantID,
I_OperationalAcctgDocItem.BudgetPeriod,
I_OperationalAcctgDocItem.PartnerFund,
I_OperationalAcctgDocItem.PartnerGrant,
I_OperationalAcctgDocItem.PartnerBudgetPeriod,
I_OperationalAcctgDocItem.PubSecBudgetAccount,
I_OperationalAcctgDocItem.PubSecBudgetAccountCoCode,
I_OperationalAcctgDocItem.CompanyCodeCurrency,
I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency,
I_OperationalAcctgDocItem.TaxAmountInCoCodeCrcy,
I_OperationalAcctgDocItem.TaxBaseAmountInCoCodeCrcy,
I_OperationalAcctgDocItem.ValuationDiffAmtInCoCodeCrcy,
cast( I_OperationalAcctgDocItem.CashDiscountAmtInCoCodeCrcy as fis_sknto preserving type ) as CashDiscountAmtInCoCodeCrcy,
I_OperationalAcctgDocItem.InvoiceAmtInCoCodeCrcy,
I_OperationalAcctgDocItem.FunctionalCurrency,
I_OperationalAcctgDocItem.AmountInFunctionalCurrency,
I_OperationalAcctgDocItem.TransactionCurrency,
I_OperationalAcctgDocItem.AmountInTransactionCurrency,
I_OperationalAcctgDocItem.OriginalTaxBaseAmount,
I_OperationalAcctgDocItem.TaxAmount,
I_OperationalAcctgDocItem.TaxBaseAmountInTransCrcy,
I_OperationalAcctgDocItem.WithholdingTaxBaseAmount,
I_OperationalAcctgDocItem.PlannedAmtInTransactionCrcy,
cast( I_OperationalAcctgDocItem.CashDiscountBaseAmount as fis_skfbt preserving type ) as CashDiscountBaseAmount,
I_OperationalAcctgDocItem.CashDiscountAmount,
I_OperationalAcctgDocItem.NetPaymentAmount,
I_OperationalAcctgDocItem.WithholdingTaxAmount,
I_OperationalAcctgDocItem.WithholdingTaxExemptionAmt,
I_OperationalAcctgDocItem.InvoiceAmountInFrgnCurrency,
I_OperationalAcctgDocItem.BalanceTransactionCurrency,
I_OperationalAcctgDocItem.AmountInBalanceTransacCrcy,
I_OperationalAcctgDocItem.AdditionalCurrency1,
I_OperationalAcctgDocItem.ValuationDiffAmtInAddlCrcy1,
I_OperationalAcctgDocItem.AmountInAdditionalCurrency1,
I_OperationalAcctgDocItem.AdditionalCurrency2,
I_OperationalAcctgDocItem.AmountInAdditionalCurrency2,
I_OperationalAcctgDocItem.ValuationDiffAmtInAddlCrcy2,
I_OperationalAcctgDocItem.PaymentCurrency,
I_OperationalAcctgDocItem.AmountInPaymentCurrency,
I_OperationalAcctgDocItem.CreditControlAreaCurrency,
I_OperationalAcctgDocItem.HedgedAmount,
I_OperationalAcctgDocItem.BaseUnit,
case I_OperationalAcctgDocItem.IsNegativePosting when 'X' then case I_OperationalAcctgDocItem.DebitCreditCode when 'S' then cast(-I_OperationalAcctgDocItem.Quantity as quan1_12)
when 'H' then cast( I_OperationalAcctgDocItem.Quantity as quan1_12)
end
when ' ' then case I_OperationalAcctgDocItem.DebitCreditCode when 'H' then cast(-I_OperationalAcctgDocItem.Quantity as quan1_12)
when 'S' then cast( I_OperationalAcctgDocItem.Quantity as quan1_12)
end
else cast( I_OperationalAcctgDocItem.Quantity as quan1_12)
end as Quantity,
/*cast( case IsNegativePosting when 'X' then case DebitCreditCode when 'S' then -Quantity
when 'H' then Quantity
end
when ' ' then case DebitCreditCode when 'H' then -Quantity
when 'S' then Quantity
end
else Quantity
end as quan1_12) as Quantity,*/
cast( I_OperationalAcctgDocItem.Quantity as fis_absolute_quantity preserving type ) as AbsoluteQuantity,
I_OperationalAcctgDocItem.GoodsMovementEntryUnit,
I_OperationalAcctgDocItem.QuantityInEntryUnit,
I_OperationalAcctgDocItem.PurchasingDocumentPriceUnit,
I_OperationalAcctgDocItem.PurchaseOrderQty,
I_OperationalAcctgDocItem.MaterialPriceUnitQty,
I_OperationalAcctgDocItem._JournalEntry.Ledger as Ledger,
I_OperationalAcctgDocItem._JournalEntry.LedgerGroup as LedgerGroup,
I_OperationalAcctgDocItem.NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
I_OperationalAcctgDocItem._CompanyCode,
I_OperationalAcctgDocItem._FiscalYear,
I_OperationalAcctgDocItem._JournalEntry,
I_OperationalAcctgDocItem._GLAccountInChartOfAccounts,
I_OperationalAcctgDocItem._ChartOfAccounts,
I_OperationalAcctgDocItem._PostingKey,
I_OperationalAcctgDocItem._FinancialAccountType,
I_OperationalAcctgDocItem._DebitCreditCode,
I_OperationalAcctgDocItem._BusinessArea,
I_OperationalAcctgDocItem._PartnerBusinessArea,
I_OperationalAcctgDocItem._TaxType,
// _PartnerCompany,
I_OperationalAcctgDocItem._ControllingArea,
I_OperationalAcctgDocItem._ProfitCenter,
I_OperationalAcctgDocItem._CostCenter,
I_OperationalAcctgDocItem._SupplyingCountry,
I_OperationalAcctgDocItem._Product,
I_OperationalAcctgDocItem._Plant,
I_OperationalAcctgDocItem._BaseUnit,
I_OperationalAcctgDocItem._InventoryValuationType,
I_OperationalAcctgDocItem._PaymentDifferenceReason,
I_OperationalAcctgDocItem._Segment,
I_OperationalAcctgDocItem._PartnerSegment,
_WBSElementBasicData,
I_OperationalAcctgDocItem._AccountingDocumentType,
I_OperationalAcctgDocItem._TransactionCurrency,
I_OperationalAcctgDocItem._InternalOrder,
I_OperationalAcctgDocItem._Order,
I_OperationalAcctgDocItem._MasterFixedAsset,
I_OperationalAcctgDocItem._FixedAsset,
I_OperationalAcctgDocItem._AssetTransactionType,
I_OperationalAcctgDocItem._PurchasingDocument,
I_OperationalAcctgDocItem._PurchasingDocumentItem,
//@API.element.releaseState: #DEPRECATED
//@API.element.successor: ''
//@VDM.lifecycle.status: #DEPRECATED
//@VDM.lifecycle.successor: ''
I_OperationalAcctgDocItem._ValuationArea,
I_OperationalAcctgDocItem._ProjectNetwork,
I_OperationalAcctgDocItem._CostCtrActivityType,
I_OperationalAcctgDocItem._BusinessProcess,
I_OperationalAcctgDocItem._FunctionalArea,
_AdditionalCurrencyRoles,
_CurrentCostCenter,
_CurrentProfitCenter,
I_OperationalAcctgDocItem._Customer,
I_OperationalAcctgDocItem._CustomerCompany,
I_OperationalAcctgDocItem._GLAccountInCompanyCode,
_SalesDocument,
_ServiceDocument,
I_OperationalAcctgDocItem._Supplier,
I_OperationalAcctgDocItem._SupplierCompany,
I_OperationalAcctgDocItem._JournalEntry._FinancialManagementArea,
_FundsCenter,
_Fund,
_PartnerFund,
_FundedProgram,
_CashLedgerCompanyCode,
_CashLedgerAccount,
I_OperationalAcctgDocItem._BudgetPeriod,
I_OperationalAcctgDocItem._PartnerBudgetPeriod,
I_OperationalAcctgDocItem._Grant,
I_OperationalAcctgDocItem._PartnerGrant,
_PubSecBudgetAccountCoCode,
_PubSecBudgetAccount
// _REObjectByIntFinNumber
}
where I_OperationalAcctgDocItem.AccountingDocumentCategory = 'S'
union all
select from I_ParkedOplAcctgDocItem as I_ParkedOplAcctgDocItem
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_JournalEntry as _JournalEntry on $projection.CompanyCode = _JournalEntry.CompanyCode
and $projection.FiscalYear = _JournalEntry.FiscalYear
and $projection.AccountingDocument = _JournalEntry.AccountingDocument
association [0..1] to I_InternalOrder as _InternalOrder on $projection.OrderID = _InternalOrder.InternalOrder
association [0..1] to I_Purreqvaluationarea as _ValuationArea on $projection.ValuationArea = _ValuationArea.ValuationArea
association [0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
and _CurrentCostCenter.ValidityStartDate <= $session.system_date
and _CurrentCostCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_AdditionalCurrencyRoles as _AdditionalCurrencyRoles on $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode
and $projection.ledgergroup = _AdditionalCurrencyRoles.LedgerGroup
and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_Fund as _Fund on $projection.FinancialManagementArea = _Fund.FinancialManagementArea
and $projection.Fund = _Fund.Fund
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
association [0..1] to I_FinancialManagementArea as _FinancialManagementArea on $projection.FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea
association [0..1] to I_FiscalYearForCompanyCode as _FiscalYear on $projection.FiscalYear = _FiscalYear.FiscalYear
and $projection.CompanyCode = _FiscalYear.CompanyCode
{
key cast( cast( '3' as abap.char(1)) as fis_bstat_grp preserving type ) as AccountingDocumentCatGroup,
key I_ParkedOplAcctgDocItem.CompanyCode,
key I_ParkedOplAcctgDocItem.SourceFiscalYear as FiscalYear,//key FiscalYear,
key I_ParkedOplAcctgDocItem.SourceAccountingDocument as AccountingDocument, //key AccountingDocument,
key I_ParkedOplAcctgDocItem.SourceAccountingDocumentItem as AccountingDocumentItem, //key AccountingDocumentItem,
I_ParkedOplAcctgDocItem.ChartOfAccounts,
//buzid,
cast( '00000000' as abap.dats( 8)) as ClearingDate,
cast( '00000000' as abap.dats( 8)) as ClearingCreationDate,
cast( '' as abap.char(10)) as ClearingJournalEntry,
cast( '' as abap.char(10)) as ClearingAccountingDocument,
I_ParkedOplAcctgDocItem.PostingKey,
I_ParkedOplAcctgDocItem.FinancialAccountType,
I_ParkedOplAcctgDocItem.SpecialGLCode,
I_ParkedOplAcctgDocItem.SpecialGLTransactionType,
I_ParkedOplAcctgDocItem.DebitCreditCode,
I_ParkedOplAcctgDocItem.BusinessArea,
I_ParkedOplAcctgDocItem.PartnerBusinessArea,
I_ParkedOplAcctgDocItem.TaxCode,
I_ParkedOplAcctgDocItem.WithholdingTaxCode,
I_ParkedOplAcctgDocItem.TaxType,
cast( '' as abap.char(3)) as TransactionTypeDetermination,
I_ParkedOplAcctgDocItem.ValueDate,
I_ParkedOplAcctgDocItem.AssignmentReference,
I_ParkedOplAcctgDocItem.DocumentItemText,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.PartnerCompany,
I_ParkedOplAcctgDocItem.FinancialTransactionType,
cast( '' as abap.char(10)) as CorporateGroupAccount,
I_ParkedOplAcctgDocItem.PlanningLevel,
I_ParkedOplAcctgDocItem.ControllingArea,
I_ParkedOplAcctgDocItem.CostCenter,
//ProjectInternalID, -- to be retrieved later from WBS Element
I_ParkedOplAcctgDocItem.OrderID,
cast( '' as abap.char(10)) as BillingDocument,
cast( '' as abap.char(10)) as SalesDocument,
cast( '000000' as abap.numc(6)) as SalesDocumentItem,
cast( '0000' as abap.numc(4)) as ScheduleLine,
cast( '' as abap.char(4)) as ServiceDocumentType,
cast( '' as abap.char(10)) as ServiceDocument,
cast( '000000' as abap.numc(6)) as ServiceDocumentItem,
I_ParkedOplAcctgDocItem.MasterFixedAsset,
I_ParkedOplAcctgDocItem.FixedAsset,
I_ParkedOplAcctgDocItem.AssetTransactionType,
I_ParkedOplAcctgDocItem.AssetValueDate,
I_ParkedOplAcctgDocItem.PersonnelNumber,
I_ParkedOplAcctgDocItem.IsSalesRelated,
cast( '' as abap.char(1)) as LineItemDisplayIsEnabled,
cast( '' as abap.char(1)) as IsOpenItemManaged,
I_ParkedOplAcctgDocItem.IsNotCashDiscountLiable,
cast( '' as abap.char(1)) as IsAutomaticallyCreated,
cast( '' as abap.char(1)) as IsUsedInPaymentTransaction,
cast( '' as abap.char(10)) as OperationalGLAccount,
I_ParkedOplAcctgDocItem.GLAccount,
cast( Customer as kunnr preserving type ) as Customer,
cast( Supplier as md_supplier preserving type ) as Supplier,
I_ParkedOplAcctgDocItem.BranchAccount, //cast( '' as abap.char(10)) as BranchAccount,
cast( '' as abap.char(1)) as IsBalanceSheetAccount,
cast( '' as abap.char(2)) as ProfitLossAccountType,
I_ParkedOplAcctgDocItem.SpecialGLAccountAssignment,
I_ParkedOplAcctgDocItem.DueCalculationBaseDate,
I_ParkedOplAcctgDocItem.PaymentTerms,
I_ParkedOplAcctgDocItem.CashDiscount1Days,
I_ParkedOplAcctgDocItem.CashDiscount2Days,
I_ParkedOplAcctgDocItem.NetPaymentDays, //cast( '000' as abap.dec(3,0)) as NetPaymentDays,
cast( I_ParkedOplAcctgDocItem.CashDiscount1Percent as dzbd1p_farp preserving type ) as CashDiscount1Percent,
cast( I_ParkedOplAcctgDocItem.CashDiscount2Percent as dzbd2p_farp preserving type ) as CashDiscount2Percent,
I_ParkedOplAcctgDocItem.PaymentMethod,
cast( I_ParkedOplAcctgDocItem.PaymentBlockingReason as fis_dzlspr preserving type ) as PaymentBlockingReason,
I_ParkedOplAcctgDocItem.FixedCashDiscount,
I_ParkedOplAcctgDocItem.HouseBank,
I_ParkedOplAcctgDocItem.BPBankAccountInternalID, //cast( '' as abap.char(4)) as BPBankAccountInternalID,
cast( '' as abap.char(2)) as TaxDistributionCode1,
cast( '' as abap.char(2)) as TaxDistributionCode2,
cast( '' as abap.char(2)) as TaxDistributionCode3,
cast( I_ParkedOplAcctgDocItem.InvoiceReference as fis_rebzg preserving type ) as InvoiceReference,
cast( I_ParkedOplAcctgDocItem.InvoiceReferenceFiscalYear as fis_rebzj_no_conv preserving type ) as InvoiceReferenceFiscalYear,
I_ParkedOplAcctgDocItem.InvoiceItemReference,
I_ParkedOplAcctgDocItem.FollowOnDocumentType, //cast( '' as abap.char(1)) as FollowOnDocumentType,
I_ParkedOplAcctgDocItem.StateCentralBankPaymentReason, //cast( '' as abap.char(3)) as StateCentralBankPaymentReason,
I_ParkedOplAcctgDocItem.SupplyingCountry,
cast( I_ParkedOplAcctgDocItem.InvoiceList as fis_samnr preserving type ) as InvoiceList,
cast( '' as abap.char(1)) as BillOfExchangeUsage,
I_ParkedOplAcctgDocItem.DunningKey, //cast( '' as abap.char(1)) as DunningKey,
I_ParkedOplAcctgDocItem.DunningBlockingReason, //cast( '' as abap.char(1)) as DunningBlockingReason,
I_ParkedOplAcctgDocItem.LastDunningDate, //cast( '00000000' as abap.dats( 8)) as LastDunningDate,
I_ParkedOplAcctgDocItem.DunningLevel, //cast( '' as abap.numc(1)) as DunningLevel,
I_ParkedOplAcctgDocItem.DunningArea, //cast( '' as abap.char(2)) as DunningArea,
cast( '' as abap.char(10)) as WithholdingTaxCertificate,
I_ParkedOplAcctgDocItem.Product,
I_ParkedOplAcctgDocItem.Plant,
I_ParkedOplAcctgDocItem.PurchasingDocument,
I_ParkedOplAcctgDocItem.PurchasingDocumentItem,
I_ParkedOplAcctgDocItem.AccountAssignmentNumber,
cast( '' as abap.char(1)) as IsCompletelyDelivered,
I_ParkedOplAcctgDocItem.MaterialPriceControl, //cast( '' as abap.char(1)) as MaterialPriceControl,
I_ParkedOplAcctgDocItem.ValuationArea,
I_ParkedOplAcctgDocItem.InventoryValuationType,
I_ParkedOplAcctgDocItem.VATRegistration,
cast( '' as abap.char(3)) as DelivOfGoodsDestCountry,
I_ParkedOplAcctgDocItem.PaymentDifferenceReason,
I_ParkedOplAcctgDocItem.ProfitCenter,
I_ParkedOplAcctgDocItem.JointVenture,
I_ParkedOplAcctgDocItem.JointVentureCostRecoveryCode,
I_ParkedOplAcctgDocItem.JointVentureEquityGroup,
I_ParkedOplAcctgDocItem.TreasuryContractType,
I_ParkedOplAcctgDocItem.AssetContract,
I_ParkedOplAcctgDocItem.CashFlowType,
I_ParkedOplAcctgDocItem.TaxJurisdiction,
I_ParkedOplAcctgDocItem.REInternalFinNumber,
cast( '' as fis_imkey ) as RealEstateObject, //RealEstateObject,
I_ParkedOplAcctgDocItem.SettlementReferenceDate,
cast( '' as fis_fipos ) as CommitmentItem, //cast(CommitmentItemShortID as fis_fipos preserving type ) as CommitmentItem,
I_ParkedOplAcctgDocItem.CommitmentItemShortID,
I_ParkedOplAcctgDocItem.CostObject,
I_ParkedOplAcctgDocItem.ProjectNetwork,
I_ParkedOplAcctgDocItem.OrderInternalBillOfOperations, //cast( '0000000000' as abap.numc(10)) as OrderInternalBillOfOperations,
cast( '00000000' as abap.numc(8)) as OrderIntBillOfOperationsItem,
//@ObjectModel.foreignKey.association: '_WBSElementInternalID'
cast( I_ParkedOplAcctgDocItem.WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
cast(I_ParkedOplAcctgDocItem.ProfitabilitySegment as rkeobjnr_numc) as ProfitabilitySegment,
I_ParkedOplAcctgDocItem.ProfitabilitySegment as ProfitabilitySegment_2,
I_ParkedOplAcctgDocItem.JointVentureEquityType,
I_ParkedOplAcctgDocItem.IsEUTriangularDeal, //cast( '' as abap.char(1)) as IsEUTriangularDeal,
I_ParkedOplAcctgDocItem.CostOriginGroup,
I_ParkedOplAcctgDocItem.CompanyCodeCurrencyDetnMethod, //cast( '' as abap.char(1)) as CompanyCodeCurrencyDetnMethod,
cast( '' as abap.char(1)) as ClearingIsReversed,
I_ParkedOplAcctgDocItem.PaymentMethodSupplement,
cast( '' as abap.char(10)) as AlternativeGLAccount,
//stbuk,
cast( '' as abap.char(10)) as PartnerProfitCenter,
I_ParkedOplAcctgDocItem.Reference1IDByBusinessPartner,
I_ParkedOplAcctgDocItem.Reference2IDByBusinessPartner,
cast( '' as abap.char(1)) as IsNegativePosting,
cast( '000' as abap.numc(3)) as PaymentCardItem,
I_ParkedOplAcctgDocItem.PaymentCardPaymentSettlement,
I_ParkedOplAcctgDocItem.CreditControlArea, //cast( '' as abap.char(4)) as CreditControlArea,
I_ParkedOplAcctgDocItem.Reference3IDByBusinessPartner,
I_ParkedOplAcctgDocItem.DataExchangeInstruction1, //cast( '00' as abap.numc(2)) as DataExchangeInstruction1,
I_ParkedOplAcctgDocItem.DataExchangeInstruction2, //cast( '00' as abap.numc(2)) as DataExchangeInstruction2,
I_ParkedOplAcctgDocItem.DataExchangeInstruction3, //cast( '00' as abap.numc(2)) as DataExchangeInstruction3,
I_ParkedOplAcctgDocItem.DataExchangeInstruction4, //cast( '00' as abap.numc(2)) as DataExchangeInstruction4,
I_ParkedOplAcctgDocItem.Region,
cast( '' as abap.char(1)) as HasPaymentOrder,
I_ParkedOplAcctgDocItem.PaymentReference,
cast( '00000000' as abap.dats( 8)) as TaxDeterminationDate,
cast( '00000' as abap.dec(5,0)) as ClearingItem,
I_ParkedOplAcctgDocItem.BusinessPlace,
cast( I_ParkedOplAcctgDocItem.TaxSection as fis_secco preserving type ) as TaxSection,
I_ParkedOplAcctgDocItem.CostCtrActivityType,
cast( '' as abap.char(2)) as AccountsReceivableIsPledged,
cast( '' as abap.char(2)) as AcctsReceivablePledgingCode,
I_ParkedOplAcctgDocItem.BusinessProcess,
I_ParkedOplAcctgDocItem.FunctionalArea,
cast( '' as abap.char(1)) as CustomerIsInExecution,
cast( '0000' as abap.numc(4)) as ClearingJournalEntryFiscalYear,
cast( '0000' as abap.numc(4)) as ClearingDocFiscalYear,
cast( '' as abap.char(6)) as LedgerGLLineItem,
I_ParkedOplAcctgDocItem.Segment,
I_ParkedOplAcctgDocItem.PartnerSegment,
cast( '' as abap.char(16)) as PartnerFunctionalArea,
cast( I_ParkedOplAcctgDocItem.HouseBankAccount as fac_hktid preserving type ) as HouseBankAccount,
cast( '' as abap.char(10)) as CostElement,
cast( '' as abap.char(4)) as PaymentServiceProvider,
cast( '' as abap.char(35)) as PaymentRefByPaytSrvcProvider,
cast( '' as abap.char(35)) as SEPAMandate,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.ReferenceDocumentType,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.OriginalReferenceDocument,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.ReferenceDocumentLogicalSystem,
cast( '0000000000' as abap.numc(10)) as AccountingDocumentItemRef,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.FiscalPeriod, //_AccountingDocument.FiscalPeriod as FiscalPeriod,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.AccountingDocumentCategory,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.PostingDate,
cast( I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.DocumentDate as fis_bldat) as DocumentDate, //cast( _AccountingDocument.DocumentDate as fis_bldat) as DocumentDate,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.AccountingDocumentType,
I_ParkedOplAcctgDocItem.NetDueDate,
I_ParkedOplAcctgDocItem.CashDiscount1DueDate,
I_ParkedOplAcctgDocItem.CashDiscount2DueDate,
cast( '' as abap.char(10)) as OffsettingAccount,
cast( '' as abap.char(1)) as OffsettingAccountType,
cast( '' as abap.char(4)) as OffsettingChartOfAccounts,
cast( '' as abap.char(4)) as CashLedgerCompanyCode,
cast( '' as abap.char(10)) as CashLedgerAccount,
I_ParkedOplAcctgDocItem.FinancialManagementArea, //_AccountingDocument.FinancialManagementArea as FinancialManagementArea,
I_ParkedOplAcctgDocItem.FundsCenter,
I_ParkedOplAcctgDocItem.FundedProgram,
I_ParkedOplAcctgDocItem.Fund,
I_ParkedOplAcctgDocItem.GrantID,
I_ParkedOplAcctgDocItem.BudgetPeriod,
I_ParkedOplAcctgDocItem.PartnerFund,
I_ParkedOplAcctgDocItem.PartnerGrant,
I_ParkedOplAcctgDocItem.PartnerBudgetPeriod,
cast( '' as abap.char(10)) as PubSecBudgetAccount,
cast( '' as abap.char(4)) as PubSecBudgetAccountCoCode,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.CompanyCodeCurrency,
I_ParkedOplAcctgDocItem.AmountInCompanyCodeCurrency,
cast( '0' as abap.curr( 23,2)) as TaxAmountInCoCodeCrcy,
I_ParkedOplAcctgDocItem.TaxBaseAmountInCoCodeCrcy,
cast( '0' as abap.curr( 23,2)) as ValuationDiffAmtInCoCodeCrcy,
I_ParkedOplAcctgDocItem.CashDiscountAmtInCoCodeCrcy,
I_ParkedOplAcctgDocItem.InvoiceAmtInCoCodeCrcy,
cast( ' ' as abap.cuky( 5 ) ) as FunctionalCurrency,
cast( '0' as abap.curr( 23,2)) as AmountInFunctionalCurrency,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.TransactionCurrency,
I_ParkedOplAcctgDocItem.AmountInTransactionCurrency,
cast( '0' as abap.curr( 23,2)) as OriginalTaxBaseAmount,
I_ParkedOplAcctgDocItem.TaxAmount, //cast( '0' as abap.curr( 23,2)) as TaxAmount,
I_ParkedOplAcctgDocItem.TaxBaseAmountInTransCrcy,
I_ParkedOplAcctgDocItem.WithholdingTaxBaseAmount, //cast( '0' as abap.curr( 23,2)) as WithholdingTaxBaseAmount,
I_ParkedOplAcctgDocItem.PlannedAmtInTransactionCrcy, //cast( '0' as abap.curr( 23,2)) as PlannedAmtInTransactionCrcy,
I_ParkedOplAcctgDocItem.CashDiscountBaseAmount,
cast( I_ParkedOplAcctgDocItem.CashDiscountAmount as fis_wskto preserving type ) as CashDiscountAmount,
cast( '0' as abap.curr( 23,2)) as NetPaymentAmount,
I_ParkedOplAcctgDocItem.WithholdingTaxAmount, //cast( '0' as abap.curr( 23,2)) as WithholdingTaxAmount,
I_ParkedOplAcctgDocItem.WithholdingTaxExemptionAmt, //cast( '0' as abap.curr( 23,2)) as WithholdingTaxExemptionAmt,
I_ParkedOplAcctgDocItem.InvoiceAmountInFrgnCurrency,
cast( ' ' as abap.cuky(5)) as BalanceTransactionCurrency,
cast( '0' as abap.curr( 23,2)) as AmountInBalanceTransacCrcy,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.AdditionalCurrency1,
cast( '0' as abap.curr( 23,2)) as ValuationDiffAmtInAddlCrcy1,
I_ParkedOplAcctgDocItem.AmountInAdditionalCurrency1,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.AdditionalCurrency2,
I_ParkedOplAcctgDocItem.AmountInAdditionalCurrency2,
cast( '0' as abap.curr( 23,2)) as ValuationDiffAmtInAddlCrcy2,
I_ParkedOplAcctgDocItem.PaymentCurrency, //cast( ' ' as abap.cuky(5)) as PaymentCurrency,
cast( '0' as abap.curr( 23,2)) as AmountInPaymentCurrency,
cast( ' ' as abap.cuky(5)) as CreditControlAreaCurrency,
cast( '0' as abap.curr( 23,2)) as HedgedAmount,
I_ParkedOplAcctgDocItem.BaseUnit,
case I_ParkedOplAcctgDocItem.DebitCreditCode when 'H' then cast(-I_ParkedOplAcctgDocItem.Quantity as quan1_12)
when 'S' then cast( I_ParkedOplAcctgDocItem.Quantity as quan1_12)
else cast( I_ParkedOplAcctgDocItem.Quantity as quan1_12)
end as Quantity,
/*cast( case DebitCreditCode when 'H' then -Quantity
when 'S' then Quantity
else Quantity
end as quan1_12) as Quantity,*/
cast( I_ParkedOplAcctgDocItem.Quantity as fis_absolute_quantity ) as AbsoluteQuantity,
cast( '' as abap.unit( 3 ) ) as GoodsMovementEntryUnit,
cast( 0 as abap.quan( 23, 3 ) ) as QuantityInEntryUnit,
cast( '' as abap.unit( 3 ) ) as PurchasingDocumentPriceUnit,
cast( 0 as abap.quan( 23, 3 ) ) as PurchaseOrderQty,
I_ParkedOplAcctgDocItem.MaterialPriceUnitQty, //cast( '0' as abap.dec(5)) as MaterialPriceUnitQty,
cast( '' as abap.char(2)) as Ledger,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument.LedgerGroup, //_AccountingDocument.LedgerGroup as LedgerGroup,
cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) as NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
I_ParkedOplAcctgDocItem._CompanyCode,
_FiscalYear,
_JournalEntry,
I_ParkedOplAcctgDocItem._GLAccountInChartOfAccounts,
I_ParkedOplAcctgDocItem._ChartOfAccounts,
I_ParkedOplAcctgDocItem._PostingKey,
I_ParkedOplAcctgDocItem._FinancialAccountType,
I_ParkedOplAcctgDocItem._DebitCreditCode,
I_ParkedOplAcctgDocItem._BusinessArea,
I_ParkedOplAcctgDocItem._PartnerBusinessArea,
I_ParkedOplAcctgDocItem._TaxType,
// _PartnerCompany,
I_ParkedOplAcctgDocItem._ControllingArea,
I_ParkedOplAcctgDocItem._ProfitCenter,
I_ParkedOplAcctgDocItem._CostCenter,
I_ParkedOplAcctgDocItem._SupplyingCountry,
I_ParkedOplAcctgDocItem._Product,
I_ParkedOplAcctgDocItem._Plant,
I_ParkedOplAcctgDocItem._BaseUnit,
I_ParkedOplAcctgDocItem._InventoryValuationType,
I_ParkedOplAcctgDocItem._PaymentDifferenceReason,
I_ParkedOplAcctgDocItem._Segment,
I_ParkedOplAcctgDocItem._PartnerSegment,
_WBSElementBasicData,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument._AccountingDocumentType,
I_ParkedOplAcctgDocItem._ParkedOplAcctgDocument._TransactionCurrency,
_InternalOrder,
I_ParkedOplAcctgDocItem._Order,
I_ParkedOplAcctgDocItem._MasterFixedAsset,
I_ParkedOplAcctgDocItem._FixedAsset,
I_ParkedOplAcctgDocItem._AssetTransactionType,
I_ParkedOplAcctgDocItem._PurchasingDocument,
I_ParkedOplAcctgDocItem._PurchasingDocumentItem,
//@API.element.releaseState: #DEPRECATED
//@API.element.successor: ''
//@VDM.lifecycle.status: #DEPRECATED
//@VDM.lifecycle.successor: ''
_ValuationArea,
I_ParkedOplAcctgDocItem._ProjectNetwork,
I_ParkedOplAcctgDocItem._CostCtrActivityType,
I_ParkedOplAcctgDocItem._BusinessProcess,
I_ParkedOplAcctgDocItem._FunctionalArea,
_AdditionalCurrencyRoles,
_CurrentCostCenter,
_CurrentProfitCenter,
I_ParkedOplAcctgDocItem._Customer,
I_ParkedOplAcctgDocItem._CustomerCompany,
I_ParkedOplAcctgDocItem._GLAccountInCompanyCode,
_SalesDocument,
_ServiceDocument,
I_ParkedOplAcctgDocItem._Supplier,
I_ParkedOplAcctgDocItem._SupplierCompany,
_FinancialManagementArea,
_FundsCenter,
_Fund,
_PartnerFund,
_FundedProgram,
_CashLedgerCompanyCode,
_CashLedgerAccount,
I_ParkedOplAcctgDocItem._BudgetPeriod,
I_ParkedOplAcctgDocItem._PartnerBudgetPeriod,
I_ParkedOplAcctgDocItem._Grant,
I_ParkedOplAcctgDocItem._PartnerGrant,
_PubSecBudgetAccountCoCode,
_PubSecBudgetAccount
// _REObjectByIntFinNumber
}
union all
select from I_AddlLedgerOplAcctgDocItem as I_AddlLedgerOplAcctgDocItem
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..1] to I_JournalEntry as _JournalEntry on $projection.CompanyCode = _JournalEntry.CompanyCode
and $projection.FiscalYear = _JournalEntry.FiscalYear
and $projection.AccountingDocument = _JournalEntry.AccountingDocument
association [0..1] to I_TaxType as _TaxType on $projection.TaxType = _TaxType.TaxType
association [0..1] to I_Country as _SupplyingCountry on $projection.SupplyingCountry = _SupplyingCountry.Country
association [0..1] to I_Product as _Product on $projection.Product = _Product.Product
association [0..1] to I_PaymentDifferenceReason as _PaymentDifferenceReason on $projection.PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason
and $projection.CompanyCode = _PaymentDifferenceReason.CompanyCode
association [0..1] to I_Order as _Order on $projection.OrderID = _Order.OrderID
association [0..1] to I_PurchasingDocument as _PurchasingDocument on $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
association [0..1] to I_PurchasingDocumentItem as _PurchasingDocumentItem on $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument
and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
association [0..1] to I_Currency as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency
association [0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea
and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter
and _CurrentProfitCenter.ValidityStartDate <= $session.system_date
and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea
and $projection.CostCenter = _CurrentCostCenter.CostCenter
and _CurrentCostCenter.ValidityStartDate <= $session.system_date
and _CurrentCostCenter.ValidityEndDate >= $session.system_date
association [0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [0..1] to I_SupplierCompany as _SupplierCompany on $projection.Supplier = _SupplierCompany.Supplier
and $projection.CompanyCode = _SupplierCompany.CompanyCode
association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
association [0..1] to I_CustomerCompany as _CustomerCompany on $projection.Customer = _CustomerCompany.Customer
and $projection.CompanyCode = _CustomerCompany.CompanyCode
association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
association [0..1] to I_GLAccountInCompanyCode as _GLAccountInCompanyCode on $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode
and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount
association [0..1] to I_AccountingDocumentType as _AccountingDocumentType on $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType
association [0..1] to I_AdditionalCurrencyRoles as _AdditionalCurrencyRoles on $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode
and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup
and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_Fund as _Fund on $projection.FinancialManagementArea = _Fund.FinancialManagementArea
and $projection.Fund = _Fund.Fund
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
{
key cast( cast( '4' as abap.char(1)) as fis_bstat_grp preserving type ) as AccountingDocumentCatGroup,
key I_AddlLedgerOplAcctgDocItem.CompanyCode,
key I_AddlLedgerOplAcctgDocItem.FiscalYear,
key I_AddlLedgerOplAcctgDocItem.AccountingDocument,
//key cast( substring( AccountingDocumentItem, 1, 3 ) as fis_buzei ) as AccountingDocumentItem0,
key cast( substring( I_AddlLedgerOplAcctgDocItem.AccountingDocumentItem, 4, 3 ) as fis_buzei ) as AccountingDocumentItem,
I_AddlLedgerOplAcctgDocItem.ChartOfAccounts,
I_AddlLedgerOplAcctgDocItem.ClearingDate,
I_AddlLedgerOplAcctgDocItem.ClearingCreationDate,
I_AddlLedgerOplAcctgDocItem.ClearingJournalEntry,
I_AddlLedgerOplAcctgDocItem.ClearingAccountingDocument,
I_AddlLedgerOplAcctgDocItem.PostingKey,
I_AddlLedgerOplAcctgDocItem.FinancialAccountType,
cast( ' ' as fac_umskz preserving type ) as SpecialGLCode,
cast( ' ' as farp_umsks preserving type ) as SpecialGLTransactionType,
I_AddlLedgerOplAcctgDocItem.DebitCreditCode,
I_AddlLedgerOplAcctgDocItem.BusinessArea,
I_AddlLedgerOplAcctgDocItem.PartnerBusinessArea,
I_AddlLedgerOplAcctgDocItem.TaxCode,
I_AddlLedgerOplAcctgDocItem.WithholdingTaxCode,
cast( ' ' as abap.char(1) ) as TaxType,
I_AddlLedgerOplAcctgDocItem.TransactionTypeDetermination,
I_AddlLedgerOplAcctgDocItem.ValueDate,
I_AddlLedgerOplAcctgDocItem.AssignmentReference,
I_AddlLedgerOplAcctgDocItem.DocumentItemText,
I_AddlLedgerOplAcctgDocItem.PartnerCompany,
I_AddlLedgerOplAcctgDocItem.FinancialTransactionType,
I_AddlLedgerOplAcctgDocItem.CorporateGroupAccount,
cast( ' ' as abap.char(2) ) as PlanningLevel,
I_AddlLedgerOplAcctgDocItem.ControllingArea,
I_AddlLedgerOplAcctgDocItem.CostCenter,
//ProjectInternalID, -- to be retrieved later from WBS Element
I_AddlLedgerOplAcctgDocItem.OrderID,
cast( '' as abap.char(10)) as BillingDocument,
cast( '' as abap.char(10)) as SalesDocument,
cast( '000000' as abap.numc(6)) as SalesDocumentItem,
cast( '0000' as abap.numc(4)) as ScheduleLine,
cast( '' as abap.char(4)) as ServiceDocumentType,
cast( '' as abap.char(10)) as ServiceDocument,
cast( '000000' as abap.numc(6)) as ServiceDocumentItem,
I_AddlLedgerOplAcctgDocItem.MasterFixedAsset,
I_AddlLedgerOplAcctgDocItem.FixedAsset,
I_AddlLedgerOplAcctgDocItem.AssetTransactionType,
cast ('00000000' as bzdat ) as AssetValueDate,
cast( '00000000' as abap.numc(8)) as PersonnelNumber,
cast( '' as abap.char(1)) as IsSalesRelated,
cast( '' as abap.char(1)) as LineItemDisplayIsEnabled,
I_AddlLedgerOplAcctgDocItem.IsOpenItemManaged,
cast( '' as abap.char(1)) as IsNotCashDiscountLiable,
I_AddlLedgerOplAcctgDocItem.IsAutomaticallyCreated,
cast( '' as abap.char(1)) as IsUsedInPaymentTransaction,
cast( '' as abap.char(10)) as OperationalGLAccount,
I_AddlLedgerOplAcctgDocItem.GLAccount,
cast( '' as abap.char(10)) as Customer,
cast( '' as abap.char(10)) as Supplier,
cast( '' as abap.char(10)) as BranchAccount,
I_AddlLedgerOplAcctgDocItem.IsBalanceSheetAccount,
I_AddlLedgerOplAcctgDocItem.ProfitLossAccountType,
cast( '' as abap.char(18)) as SpecialGLAccountAssignment,
I_AddlLedgerOplAcctgDocItem.DueCalculationBaseDate,
cast( '' as abap.char(4)) as PaymentTerms,
cast( '0' as abap.dec(3,0)) as CashDiscount1Days,
cast( '0' as abap.dec(3,0)) as CashDiscount2Days,
cast( '000' as abap.dec(3,0)) as NetPaymentDays,
cast( '0' as abap.dec(5,3)) as CashDiscount1Percent,
cast( '0' as abap.dec(5,3)) as CashDiscount2Percent,
cast( '' as abap.char(1)) as PaymentMethod,
cast( '' as abap.char(1)) as PaymentBlockingReason,
cast( '' as abap.char(1)) as FixedCashDiscount,
cast( '' as abap.char(5)) as HouseBank,
cast( '' as abap.char(4)) as BPBankAccountInternalID,
cast( '' as abap.char(2)) as TaxDistributionCode1,
cast( '' as abap.char(2)) as TaxDistributionCode2,
cast( '' as abap.char(2)) as TaxDistributionCode3,
I_AddlLedgerOplAcctgDocItem.InvoiceReference,
I_AddlLedgerOplAcctgDocItem.InvoiceReferenceFiscalYear,
I_AddlLedgerOplAcctgDocItem.InvoiceItemReference,
I_AddlLedgerOplAcctgDocItem.FollowOnDocumentType,
cast( '' as abap.char(3)) as StateCentralBankPaymentReason,
cast( '' as abap.char(3)) as SupplyingCountry,
cast( '' as abap.numc(8)) as InvoiceList,
I_AddlLedgerOplAcctgDocItem.BillOfExchangeUsage,
cast( '' as abap.char(1)) as DunningKey,
cast( '' as abap.char(1)) as DunningBlockingReason,
cast( '00000000' as abap.dats( 8)) as LastDunningDate,
cast( '' as abap.numc(1)) as DunningLevel,
cast( '' as abap.char(2)) as DunningArea,
cast( '' as abap.char(10)) as WithholdingTaxCertificate,
I_AddlLedgerOplAcctgDocItem.Material as Product,
I_AddlLedgerOplAcctgDocItem.Plant,
cast( '' as abap.char(10)) as PurchasingDocument,
cast( '' as abap.numc(5)) as PurchasingDocumentItem,
cast( '' as abap.numc(2)) as AccountAssignmentNumber,
cast( '' as abap.char(1)) as IsCompletelyDelivered,
cast( '' as abap.char(1)) as MaterialPriceControl,
I_AddlLedgerOplAcctgDocItem.ValuationArea,
I_AddlLedgerOplAcctgDocItem.InventoryValuationType,
cast( '' as abap.char(20)) as VATRegistration,
cast( '' as abap.char(3)) as DelivOfGoodsDestCountry,
//eglld,
cast( '' as abap.char(3)) as PaymentDifferenceReason,
I_AddlLedgerOplAcctgDocItem.ProfitCenter,
I_AddlLedgerOplAcctgDocItem.JointVenture,
I_AddlLedgerOplAcctgDocItem.JointVentureCostRecoveryCode,
I_AddlLedgerOplAcctgDocItem.JointVentureEquityGroup,
I_AddlLedgerOplAcctgDocItem.TreasuryContractType,
I_AddlLedgerOplAcctgDocItem.AssetContract,
I_AddlLedgerOplAcctgDocItem.CashFlowType,
cast( '' as abap.char(15)) as TaxJurisdiction,
I_AddlLedgerOplAcctgDocItem.REInternalFinNumber,
I_AddlLedgerOplAcctgDocItem.RealEstateObject,
I_AddlLedgerOplAcctgDocItem.SettlementReferenceDate,
I_AddlLedgerOplAcctgDocItem.CommitmentItem,
cast( I_AddlLedgerOplAcctgDocItem.CommitmentItem as fis_fipos_shortid preserving type ) as CommitmentItemShortID,
I_AddlLedgerOplAcctgDocItem.CostObject,
I_AddlLedgerOplAcctgDocItem.ProjectNetwork,
I_AddlLedgerOplAcctgDocItem.OrderInternalBillOfOperations,
I_AddlLedgerOplAcctgDocItem.OrderIntBillOfOperationsItem,
cast( I_AddlLedgerOplAcctgDocItem.WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
I_AddlLedgerOplAcctgDocItem.ProfitabilitySegment,
I_AddlLedgerOplAcctgDocItem.ProfitabilitySegment_2,
cast( '' as abap.char(3)) as JointVentureEquityType,
cast( '' as abap.char(1)) as IsEUTriangularDeal,
cast( '' as abap.char(4)) as CostOriginGroup,
cast( '' as abap.char(1)) as CompanyCodeCurrencyDetnMethod,
I_AddlLedgerOplAcctgDocItem.ClearingIsReversed,
I_AddlLedgerOplAcctgDocItem.PaymentMethodSupplement,
I_AddlLedgerOplAcctgDocItem.AlternativeGLAccount,
I_AddlLedgerOplAcctgDocItem.PartnerProfitCenter,
I_AddlLedgerOplAcctgDocItem.Reference1IDByBusinessPartner,
I_AddlLedgerOplAcctgDocItem.Reference2IDByBusinessPartner,
cast( '' as abap.char(1)) as IsNegativePosting,
I_AddlLedgerOplAcctgDocItem.PaymentCardItem,
I_AddlLedgerOplAcctgDocItem.PaymentCardPaymentSettlement,
cast( '' as abap.char(4)) as CreditControlArea,
I_AddlLedgerOplAcctgDocItem.Reference3IDByBusinessPartner,
cast( '00' as abap.numc(2)) as DataExchangeInstruction1,
cast( '00' as abap.numc(2)) as DataExchangeInstruction2,
cast( '00' as abap.numc(2)) as DataExchangeInstruction3,
cast( '00' as abap.numc(2)) as DataExchangeInstruction4,
cast( '' as abap.char(3)) as Region,
cast( '' as abap.char(1)) as HasPaymentOrder,
cast( '' as abap.char(30)) as PaymentReference,
cast( '00000000' as abap.dats( 8)) as TaxDeterminationDate,
I_AddlLedgerOplAcctgDocItem.ClearingItem,
I_AddlLedgerOplAcctgDocItem.BusinessPlace,
I_AddlLedgerOplAcctgDocItem.TaxSection,
I_AddlLedgerOplAcctgDocItem.CostCtrActivityType,
cast( '' as abap.char(2)) as AccountsReceivableIsPledged,
cast( '' as abap.char(2)) as AcctsReceivablePledgingCode,
I_AddlLedgerOplAcctgDocItem.BusinessProcess,
I_AddlLedgerOplAcctgDocItem.FunctionalArea,
cast( '' as abap.char(1)) as CustomerIsInExecution,
I_AddlLedgerOplAcctgDocItem.ClearingJournalEntryFiscalYear,
I_AddlLedgerOplAcctgDocItem.ClearingDocFiscalYear,
cast( '' as abap.char(6)) as LedgerGLLineItem,
I_AddlLedgerOplAcctgDocItem.Segment,
I_AddlLedgerOplAcctgDocItem.PartnerSegment,
I_AddlLedgerOplAcctgDocItem.PartnerFunctionalArea,
cast( '' as abap.char(5)) as HouseBankAccount,
I_AddlLedgerOplAcctgDocItem.CostElement,
cast( '' as abap.char(4)) as PaymentServiceProvider,
cast( '' as abap.char(35)) as PaymentRefByPaytSrvcProvider,
cast( '' as abap.char(35)) as SEPAMandate,
I_AddlLedgerOplAcctgDocItem._JournalEntry.ReferenceDocumentType,
I_AddlLedgerOplAcctgDocItem._JournalEntry.OriginalReferenceDocument,
I_AddlLedgerOplAcctgDocItem._JournalEntry.ReferenceDocumentLogicalSystem,
cast( '0000000000' as abap.numc(10)) as AccountingDocumentItemRef,
_JournalEntry.FiscalPeriod as FiscalPeriod,
I_AddlLedgerOplAcctgDocItem.AccountingDocumentCategory, // BSTAT directly from BSEG_ADD and not from BKPF
_JournalEntry.PostingDate,
cast( _JournalEntry.DocumentDate as fis_bldat) as DocumentDate,
_JournalEntry.AccountingDocumentType as AccountingDocumentType,
I_AddlLedgerOplAcctgDocItem.NetDueDate,
cast( '00000000' as abap.dats) as CashDiscount1DueDate,
cast( '00000000' as abap.dats) as CashDiscount2DueDate,
I_AddlLedgerOplAcctgDocItem.OffsettingAccount,
I_AddlLedgerOplAcctgDocItem.OffsettingAccountType,
I_AddlLedgerOplAcctgDocItem.OffsettingChartOfAccounts,
I_AddlLedgerOplAcctgDocItem.CashLedgerCompanyCode,
I_AddlLedgerOplAcctgDocItem.CashLedgerAccount,
I_AddlLedgerOplAcctgDocItem._JournalEntry.FinancialManagementArea as FinancialManagementArea,
I_AddlLedgerOplAcctgDocItem.FundsCenter,
I_AddlLedgerOplAcctgDocItem.FundedProgram,
I_AddlLedgerOplAcctgDocItem.Fund,
I_AddlLedgerOplAcctgDocItem.GrantID,
I_AddlLedgerOplAcctgDocItem.BudgetPeriod,
I_AddlLedgerOplAcctgDocItem.PartnerFund,
I_AddlLedgerOplAcctgDocItem.PartnerGrant,
I_AddlLedgerOplAcctgDocItem.PartnerBudgetPeriod,
I_AddlLedgerOplAcctgDocItem.PubSecBudgetAccount,
I_AddlLedgerOplAcctgDocItem.PubSecBudgetAccountCoCode,
I_AddlLedgerOplAcctgDocItem.CompanyCodeCurrency,
I_AddlLedgerOplAcctgDocItem.AmountInCompanyCodeCurrency,
I_AddlLedgerOplAcctgDocItem.TaxAmountInCoCodeCrcy,
cast( '0' as abap.curr( 23,2)) as TaxBaseAmountInCoCodeCrcy,
I_AddlLedgerOplAcctgDocItem.ValuationDiffAmtInCoCodeCrcy,
cast( '0' as abap.curr( 23,2)) as CashDiscountAmtInCoCodeCrcy,
cast( '0' as abap.curr( 23,2)) as InvoiceAmtInCoCodeCrcy,
I_AddlLedgerOplAcctgDocItem.FunctionalCurrency,
I_AddlLedgerOplAcctgDocItem.AmountInFunctionalCurrency,
I_AddlLedgerOplAcctgDocItem.TransactionCurrency,
I_AddlLedgerOplAcctgDocItem.AmountInTransactionCurrency,
cast( '0' as abap.curr( 23,2)) as OriginalTaxBaseAmount,
I_AddlLedgerOplAcctgDocItem.TaxAmount,
cast( '0' as abap.curr( 23,2)) as TaxBaseAmountInTransCrcy,
cast( '0' as abap.curr( 23,2)) as WithholdingTaxBaseAmount,
cast( '0' as abap.curr( 23,2)) as PlannedAmtInTransactionCrcy,
cast( '0' as abap.curr( 23,2)) as CashDiscountBaseAmount,
cast( '0' as abap.curr( 23,2)) as CashDiscountAmount,
cast( '0' as abap.curr( 23,2)) as NetPaymentAmount,
cast( '0' as abap.curr( 23,2)) as WithholdingTaxAmount,
cast( '0' as abap.curr( 23,2)) as WithholdingTaxExemptionAmt,
cast( '0' as abap.curr( 23,2)) as InvoiceAmountInFrgnCurrency,
I_AddlLedgerOplAcctgDocItem.BalanceTransactionCurrency,
I_AddlLedgerOplAcctgDocItem.AmountInBalanceTransacCrcy,
I_AddlLedgerOplAcctgDocItem.AdditionalCurrency1,
I_AddlLedgerOplAcctgDocItem.ValuationDiffAmtInAddlCrcy1,
I_AddlLedgerOplAcctgDocItem.AmountInAdditionalCurrency1,
I_AddlLedgerOplAcctgDocItem.AdditionalCurrency2,
I_AddlLedgerOplAcctgDocItem.AmountInAdditionalCurrency2,
I_AddlLedgerOplAcctgDocItem.ValuationDiffAmtInAddlCrcy2,
cast( ' ' as abap.cuky(5)) as PaymentCurrency,
cast( '0' as abap.curr( 23,2)) as AmountInPaymentCurrency,
cast( ' ' as abap.cuky(5)) as CreditControlAreaCurrency,
cast( '0' as abap.curr( 23,2)) as HedgedAmount,
I_AddlLedgerOplAcctgDocItem.BaseUnit,
case I_AddlLedgerOplAcctgDocItem.DebitCreditCode when 'H' then cast(-I_AddlLedgerOplAcctgDocItem.Quantity as quan1_12)
when 'S' then cast( I_AddlLedgerOplAcctgDocItem.Quantity as quan1_12)
else cast( I_AddlLedgerOplAcctgDocItem.Quantity as quan1_12)
end as Quantity,
/*cast( case DebitCreditCode when 'H' then -Quantity
when 'S' then Quantity
else Quantity
end as quan1_12) as Quantity,*/
cast( I_AddlLedgerOplAcctgDocItem.Quantity as fis_absolute_quantity ) as AbsoluteQuantity,
cast( '' as abap.unit( 3 ) ) as GoodsMovementEntryUnit,
cast( 0 as abap.quan( 23, 3 ) ) as QuantityInEntryUnit,
cast( '' as abap.unit( 3 ) ) as PurchasingDocumentPriceUnit,
cast( 0 as abap.quan( 23, 3 ) ) as PurchaseOrderQty,
cast( '0' as abap.dec(5)) as MaterialPriceUnitQty,
_JournalEntry.Ledger as Ledger,
_JournalEntry.LedgerGroup as LedgerGroup,
I_AddlLedgerOplAcctgDocItem.NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
I_AddlLedgerOplAcctgDocItem._CompanyCode,
I_AddlLedgerOplAcctgDocItem._FiscalYear,
_JournalEntry,
_GLAccountInChartOfAccounts,
I_AddlLedgerOplAcctgDocItem._ChartOfAccounts,
I_AddlLedgerOplAcctgDocItem._PostingKey,
I_AddlLedgerOplAcctgDocItem._FinancialAccountType,
I_AddlLedgerOplAcctgDocItem._DebitCreditCode,
I_AddlLedgerOplAcctgDocItem._BusinessArea,
I_AddlLedgerOplAcctgDocItem._PartnerBusinessArea,
_TaxType,
// _PartnerCompany,
I_AddlLedgerOplAcctgDocItem._ControllingArea,
I_AddlLedgerOplAcctgDocItem._ProfitCenter,
I_AddlLedgerOplAcctgDocItem._CostCenter,
_SupplyingCountry,
_Product,
I_AddlLedgerOplAcctgDocItem._Plant,
I_AddlLedgerOplAcctgDocItem._BaseUnit,
I_AddlLedgerOplAcctgDocItem._InventoryValuationType,
_PaymentDifferenceReason,
I_AddlLedgerOplAcctgDocItem._Segment,
I_AddlLedgerOplAcctgDocItem._PartnerSegment,
_WBSElementBasicData,
_AccountingDocumentType,
_TransactionCurrency,
I_AddlLedgerOplAcctgDocItem._InternalOrder,
_Order,
I_AddlLedgerOplAcctgDocItem._MasterFixedAsset,
I_AddlLedgerOplAcctgDocItem._FixedAsset,
I_AddlLedgerOplAcctgDocItem._AssetTransactionType,
_PurchasingDocument,
_PurchasingDocumentItem,
//@API.element.releaseState: #DEPRECATED
//@API.element.successor: ''
//@VDM.lifecycle.status: #DEPRECATED
//@VDM.lifecycle.successor: ''
I_AddlLedgerOplAcctgDocItem._ValuationArea,
I_AddlLedgerOplAcctgDocItem._ProjectNetwork,
I_AddlLedgerOplAcctgDocItem._CostCtrActivityType,
I_AddlLedgerOplAcctgDocItem._BusinessProcess,
I_AddlLedgerOplAcctgDocItem._FunctionalArea,
_AdditionalCurrencyRoles,
_CurrentCostCenter,
_CurrentProfitCenter,
_Customer,
_CustomerCompany,
_GLAccountInCompanyCode,
_SalesDocument,
_ServiceDocument,
_Supplier,
_SupplierCompany,
I_AddlLedgerOplAcctgDocItem._JournalEntry._FinancialManagementArea,
_FundsCenter,
_Fund,
_PartnerFund,
_FundedProgram,
_CashLedgerCompanyCode,
_CashLedgerAccount,
I_AddlLedgerOplAcctgDocItem._BudgetPeriod,
I_AddlLedgerOplAcctgDocItem._PartnerBudgetPeriod,
I_AddlLedgerOplAcctgDocItem._Grant,
I_AddlLedgerOplAcctgDocItem._PartnerGrant,
_PubSecBudgetAccountCoCode,
_PubSecBudgetAccount
// _REObjectByIntFinNumber
}
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