A_OperationalAcctgDocItemCube

DDL: A_OPERATIONALACCTGDOCITEMCUBE SQL: AFIOPACCTGDOCCUB Type: view COMPOSITE

Operational Accounting Document Items

A_OperationalAcctgDocItemCube is a Composite CDS View that provides data about "Operational Accounting Document Items" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocCube) and exposes 270 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocCube I_OperationalAcctgDocCube from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AFIOPACCTGDOCCUB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Operational Accounting Document Items view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (270)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
CompanyCodeName CompanyCodeName Company Name
ChartOfAccounts ChartOfAccounts Node Class
AccountingDocumentItemType AccountingDocumentItemType Line Item ID
ClearingDate ClearingDate Clearing Date
ClearingCreationDate ClearingCreationDate Clrg Creation Date
ClearingAccountingDocument ClearingJournalEntry Clrng doc.
IsCleared IsCleared Integer
PostingKey PostingKey Posting Key
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
SpecialGLTransactionType SpecialGLTransactionType Transact.Type
DebitCreditCode DebitCreditCode Single-Character Flag
BusinessArea BusinessArea Business Area
BusinessAreaName BusinessAreaName Business Area Name
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
TaxCode TaxCode Tax Code
WithholdingTaxCode WithholdingTaxCode WTax Code
TaxType TaxType Tax Type
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
ValueDate ValueDate Value Date
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
PartnerCompany PartnerCompany Trading Partner
FinancialTransactionType FinancialTransactionType Transact. Type
CorporateGroupAccount CorporateGroupAccount Group Account Number
PlanningLevel PlanningLevel Planning Level
ControllingArea ControllingArea Controlling Area
ControllingAreaName ControllingAreaName Long Text
CostCenter CostCenter Cost Center
CostCenterName CostCenterName Name
Project Project WBS Element
OrderID OrderID Order ID
BillingDocument BillingDocument SD Document
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
ScheduleLine ScheduleLine Schedule Line
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetTransactionType AssetTransactionType Trans.Type
AssetValueDate AssetValueDate Reference date
PersonnelNumber PersonnelNumber Personnel No.
IsSalesRelated IsSalesRelated Is Sales Related
LineItemDisplayIsEnabled LineItemDisplayIsEnabled Line Items
IsOpenItemManaged IsOpenItemManaged Open Item Management
IsNotCashDiscountLiable IsNotCashDiscountLiable W/o CashDsc.
IsAutomaticallyCreated IsAutomaticallyCreated Is Automatically Created
IsUsedInPaymentTransaction IsUsedInPaymentTransaction Is Used In Payment Transaction
OperationalGLAccount OperationalGLAccount Operational G/L Acct
GLAccount GLAccount General Ledger
GLAccountName GLAccountName Short Text
GLAccountLongName GLAccountLongName Long Text
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
BranchAccount BranchAccount Branch Account No.
IsBalanceSheetAccount IsBalanceSheetAccount Is Balance Sheet Account
ProfitLossAccountType ProfitLossAccountType Profit Loss Account Type
SpecialGLAccountAssignment SpecialGLAccountAssignment Special G/L Assignmt
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
PaymentMethod PaymentMethod Pymt Meth.
PaymentBlockingReason PaymentBlockingReason Pmnt block
FixedCashDiscount FixedCashDiscount Fixed Cash Discount
HouseBank HouseBank House Bank
BPBankAccountInternalID BPBankAccountInternalID BP Bank Account
TaxDistributionCode1 TaxDistributionCode1 Tax Distr. Code 1
TaxDistributionCode2 TaxDistributionCode2 Tax Distr. Code 2
TaxDistributionCode3 TaxDistributionCode3 Tax Distr. Code 3
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference InvoiceItemReference Item
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
StateCentralBankPaymentReason StateCentralBankPaymentReason SCB Ind.
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
InvoiceList InvoiceList Invoice List
BillOfExchangeUsage BillOfExchangeUsage BoE Usage
DunningKey DunningKey Dunning Key
DunningBlockingReason DunningBlockingReason Set Dunning Block
LastDunningDate LastDunningDate Last Dunned
DunningLevel DunningLevel Dunning Level
DunningArea DunningArea Dunning Area
WithholdingTaxCertificate WithholdingTaxCertificate WHT Certificate
Material Material Vehicle Model
Product Product Product Sold
Plant Plant Valuation Area
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
MaterialPriceControl MaterialPriceControl Price Control
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
VATRegistration VATRegistration VAT Registration No.
DelivOfGoodsDestCountry DelivOfGoodsDestCountry Dest. C/R
PaymentDifferenceReason PaymentDifferenceReason Reason Code
ProfitCenter ProfitCenter Profit Center
ProfitCenterName ProfitCenterName Profit Center Name
JointVenture JointVenture Joint venture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVenturePartner JointVenturePartner Joint Venture Partner
TreasuryContractType TreasuryContractType Treasury Contract Type
AssetContract AssetContract Asset Contract
CashFlowType CashFlowType Flow Type
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
RealEstateObject RealEstateObject Real Estate Key
SettlementReferenceDate SettlementReferenceDate Reference date
CommitmentItem CommitmentItem Commitment item
CostObject CostObject Cost Object
ProjectNetwork ProjectNetwork Order
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
WBSElementInternalID WBS Internal ID
ProfitabilitySegment ProfitabilitySegment_2 Profit. segment
JointVentureBillingType JointVentureBillingType
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
IsEUTriangularDeal IsEUTriangularDeal Is EU Triangular Deal
CostOriginGroup CostOriginGroup Origin Group
CompanyCodeCurrencyDetnMethod CompanyCodeCurrencyDetnMethod Co Crcy Detn Meth
ClearingIsReversed ClearingIsReversed Clearing Is Reversed
PaymentMethodSupplement PaymentMethodSupplement Pmnt Meth. Sup.
AlternativeGLAccount AlternativeGLAccount Group Account
FundsCenter FundsCenter Funds Center
Fund Fund Sender Fund
PartnerProfitCenter PartnerProfitCenter Profit Center
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner Reference Key 2
IsNegativePosting IsNegativePosting Negative Posting
PaymentCardItem PaymentCardItem Payment Card Item
PaymentCardPaymentSettlement PaymentCardPaymentSettlement Payment Card Payment Settlement
CreditControlArea CreditControlArea Credit Control Area
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
DataExchangeInstruction1 DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 DataExchangeInstruction4 Instruction 4
Region Region Venue Region
HasPaymentOrder HasPaymentOrder Payment Sent
PaymentReference PaymentReference Payment Reference
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
ClearingItem ClearingItem Clearing Item
BusinessPlace BusinessPlace Business place
TaxSection TaxSection Tax Section
CostCtrActivityType CostCtrActivityType Activity Type
AccountsReceivableIsPledged AccountsReceivableIsPledged Accounts Receivable Is Pledged
BusinessProcess BusinessProcess Business Process
GrantID GrantID Sender Grant
FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName FunctionalAreaName Long Text
CustomerIsInExecution CustomerIsInExecution Customer Is In Execution
FundedProgram FundedProgram Funded Program
ClearingDocFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
Segment Segment Segment number
SegmentName SegmentName Segment Name
PartnerSegment PartnerSegment Partner Segment
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
HouseBankAccount HouseBankAccount House Bank Account
CostElement CostElement G/L Account
SEPAMandate SEPAMandate SEPA Mandate
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
AccountingDocumentItemRef AccountingDocumentItemRef Position
FiscalPeriod FiscalPeriod Tax period
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
AccountingDocumentCategoryName AccountingDocumentCategoryName
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName AccountingDocumentTypeName
NetDueDate NetDueDate Net Due Date
CashDiscount1DueDate CashDiscount1DueDate Cash Discount 1
CashDiscount2DueDate CashDiscount2DueDate Cash Discount 2
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingAccountType OffsettingAccountType Offset Acct Type
PartnerFund PartnerFund Receiver Fund
PartnerGrant PartnerGrant Receiver Grant
BudgetPeriod BudgetPeriod Budget Period
PartnerBudgetPeriod PartnerBudgetPeriod Partner Budget Period
BranchCode BranchCode Branch Code
JointVentureProductionDate JointVentureProductionDate
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
ValuationDiffAmtInCoCodeCrcy ValuationDiffAmtInCoCodeCrcy
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy Discount Amt
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
OriginalTaxBaseAmount OriginalTaxBaseAmount
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
WithholdingTaxBaseAmount WithholdingTaxBaseAmount WTax Base Amt
PlannedAmtInTransactionCrcy PlannedAmtInTransactionCrcy Plnd Amt Trans. Crcy
CashDiscountBaseAmount CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscountAmount CashDiscountAmount CD Amount
NetPaymentAmount NetPaymentAmount Net Payment Amount
WithholdingTaxAmount WithholdingTaxAmount Withholding Tax Amt
WithholdingTaxExemptionAmt WithholdingTaxExemptionAmt WTax-Exempt
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
BalanceTransactionCurrency BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
ValuationDiffAmtInAddlCrcy1 ValuationDiffAmtInAddlCrcy1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 Amount in Additional Currency 1
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
ValuationDiffAmtInAddlCrcy2 ValuationDiffAmtInAddlCrcy2
PaymentCurrency PaymentCurrency Payment Currency
AmountInPaymentCurrency AmountInPaymentCurrency Amount in Payment Currency
CreditControlAreaCurrency CreditControlAreaCurrency Credit Control Area Currency
HedgedAmount HedgedAmount
BaseUnit BaseUnit Unit of Measure
Quantity Quantity Value
GoodsMovementEntryUnit GoodsMovementEntryUnit Unit of Entry
QuantityInEntryUnit Quantity in Unit of Entry
PurchasingDocumentPriceUnit PurchasingDocumentPriceUnit Purchasing Document Price Unit
PurchaseOrderQty Purchase Order Quantity
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
NumberOfItems NumberOfItems
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
ExchangeRateDate ExchangeRateDate Translatn Date
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
TransactionCode TransactionCode Transaction Code
IntercompanyTransaction IntercompanyTransaction Intercompany Transaction
DocumentReferenceID DocumentReferenceID Reference
RecurringAccountingDocument RecurringAccountingDocument Recurring Journal Entry
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
ExchangeRate ExchangeRate Exchange rate
BusinessTransactionType BusinessTransactionType Bus.transaction
BatchInputSession BatchInputSession
FinancialManagementArea FinancialManagementArea FM Area
ReversalIsPlanned ReversalIsPlanned
PlannedReversalDate PlannedReversalDate Reversal Date
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically Tax Is Automatically Calculated
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount Tax Base Amount is Net Amount
SourceCompanyCode SourceCompanyCode
LogicalSystem LogicalSystem Logical System
TaxExchangeRate TaxExchangeRate Rate for Taxes
ReversalReason ReversalReason Reversal Reason
Branch Branch Repository branch
Reference1InDocumentHeader Reference1InDocumentHeader Reference 1
Reference2InDocumentHeader Reference2InDocumentHeader Reference 2
InvoiceReceiptDate InvoiceReceiptDate Invoice Receipt Date
Ledger Ledger Ledger
LedgerGroup LedgerGroup Ledger Group
AlternativeReferenceDocument AlternativeReferenceDocument Alternative Reference Document
TaxReportingDate TaxReportingDate Tax Reporting Date
AccountingDocumentClass AccountingDocumentClass
ExchangeRateType ExchangeRateType Exch. Rate Type
LatePaymentReason LatePaymentReason
SalesDocumentCondition SalesDocumentCondition
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?

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

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

CREATE VIEW A_OperationalAcctgDocItemCube AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  CompanyCodeName,
  ChartOfAccounts,
  AccountingDocumentItemType,
  ClearingDate,
  ClearingCreationDate,
  ClearingJournalEntry AS ClearingAccountingDocument,
  IsCleared,
  PostingKey,
  FinancialAccountType,
  SpecialGLCode,
  SpecialGLTransactionType,
  DebitCreditCode,
  BusinessArea,
  BusinessAreaName,
  PartnerBusinessArea,
  TaxCode,
  WithholdingTaxCode,
  TaxType,
  TransactionTypeDetermination,
  ValueDate,
  AssignmentReference,
  DocumentItemText,
  PartnerCompany,
  FinancialTransactionType,
  CorporateGroupAccount,
  PlanningLevel,
  ControllingArea,
  ControllingAreaName,
  CostCenter,
  CostCenterName,
  Project,
  OrderID,
  BillingDocument,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetValueDate,
  PersonnelNumber,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  IsNotCashDiscountLiable,
  IsAutomaticallyCreated,
  IsUsedInPaymentTransaction,
  OperationalGLAccount,
  GLAccount,
  GLAccountName,
  GLAccountLongName,
  Customer,
  CustomerName,
  Supplier,
  SupplierName,
  BranchAccount,
  IsBalanceSheetAccount,
  ProfitLossAccountType,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  FixedCashDiscount,
  HouseBank,
  BPBankAccountInternalID,
  TaxDistributionCode1,
  TaxDistributionCode2,
  TaxDistributionCode3,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  InvoiceList,
  BillOfExchangeUsage,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  WithholdingTaxCertificate,
  Material,
  Product,
  Plant,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  IsCompletelyDelivered,
  MaterialPriceControl,
  ValuationArea,
  InventoryValuationType,
  VATRegistration,
  DelivOfGoodsDestCountry,
  PaymentDifferenceReason,
  ProfitCenter,
  ProfitCenterName,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  JointVenturePartner,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  TaxJurisdiction,
  RealEstateObject,
  SettlementReferenceDate,
  CommitmentItem,
  CostObject,
  ProjectNetwork,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  cast ( WBSElementInternalID as ps_posnr1 ) AS WBSElementInternalID,
  ProfitabilitySegment_2 AS ProfitabilitySegment,
  JointVentureBillingType,
  JointVentureEquityType,
  IsEUTriangularDeal,
  CostOriginGroup,
  CompanyCodeCurrencyDetnMethod,
  ClearingIsReversed,
  PaymentMethodSupplement,
  AlternativeGLAccount,
  FundsCenter,
  Fund,
  PartnerProfitCenter,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  IsNegativePosting,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  CreditControlArea,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  PaymentReference,
  TaxDeterminationDate,
  ClearingItem,
  BusinessPlace,
  TaxSection,
  CostCtrActivityType,
  AccountsReceivableIsPledged,
  BusinessProcess,
  GrantID,
  FunctionalArea,
  FunctionalAreaName,
  CustomerIsInExecution,
  FundedProgram,
  ClearingJournalEntryFiscalYear AS ClearingDocFiscalYear,
  LedgerGLLineItem,
  Segment,
  SegmentName,
  PartnerSegment,
  PartnerFunctionalArea,
  HouseBankAccount,
  CostElement,
  SEPAMandate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  AccountingDocumentItemRef,
  FiscalPeriod,
  AccountingDocumentCategory,
  AccountingDocumentCategoryName,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  PartnerFund,
  PartnerGrant,
  BudgetPeriod,
  PartnerBudgetPeriod,
  BranchCode,
  JointVentureProductionDate,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  ValuationDiffAmtInCoCodeCrcy,
  CashDiscountAmtInCoCodeCrcy,
  InvoiceAmtInCoCodeCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  OriginalTaxBaseAmount,
  TaxAmount,
  TaxBaseAmountInTransCrcy,
  WithholdingTaxBaseAmount,
  PlannedAmtInTransactionCrcy,
  CashDiscountBaseAmount,
  CashDiscountAmount,
  NetPaymentAmount,
  WithholdingTaxAmount,
  WithholdingTaxExemptionAmt,
  InvoiceAmountInFrgnCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  AdditionalCurrency1,
  ValuationDiffAmtInAddlCrcy1,
  AmountInAdditionalCurrency1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency2,
  ValuationDiffAmtInAddlCrcy2,
  PaymentCurrency,
  AmountInPaymentCurrency,
  CreditControlAreaCurrency,
  HedgedAmount,
  BaseUnit,
  Quantity,
  GoodsMovementEntryUnit,
  cast(QuantityInEntryUnit as quantityinentryunit) AS QuantityInEntryUnit,
  PurchasingDocumentPriceUnit,
  cast(PurchaseOrderQty as fis_bpmng) AS PurchaseOrderQty,
  MaterialPriceUnitQty,
  NumberOfItems,
  AccountingDocumentCreationDate,
  CreationTime,
  LastChangeDate,
  ExchangeRateDate,
  AccountingDocCreatedByUser,
  TransactionCode,
  IntercompanyTransaction,
  DocumentReferenceID,
  RecurringAccountingDocument,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  AccountingDocumentHeaderText,
  ExchangeRate,
  BusinessTransactionType,
  BatchInputSession,
  FinancialManagementArea,
  ReversalIsPlanned,
  PlannedReversalDate,
  TaxIsCalculatedAutomatically,
  TaxBaseAmountIsNetAmount,
  SourceCompanyCode,
  LogicalSystem,
  TaxExchangeRate,
  ReversalReason,
  Branch,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  InvoiceReceiptDate,
  Ledger,
  LedgerGroup,
  AlternativeReferenceDocument,
  TaxReportingDate,
  AccountingDocumentClass,
  ExchangeRateType,
  LatePaymentReason,
  SalesDocumentCondition,
  IsReversal,
  IsReversed
FROM I_OperationalAcctgDocCube
;