I_OPERATIONALACCTGDOCITEM

CDS View

Operational Accounting Document Item

I_OPERATIONALACCTGDOCITEM is a CDS View in S/4HANA. Operational Accounting Document Item. It contains 247 fields. 332 CDS views read from this table.

CDS Views using this table (332)

ViewTypeJoinVDMDescription
C_AddrBkMnllyOutgPayment view from CONSUMPTION Address Bank Manually Outgoing Payments
C_APProcFlwNodeClearingDoc view inner CONSUMPTION
C_AR_StRpJournalEntryTaxItem view inner CONSUMPTION Journal Entry Tax Item for Argentina
C_BlockedSupplierOpenItem view from CONSUMPTION Blocked Supplier Open Item
C_CreditOpenItem view from CONSUMPTION Credit Open Items
C_DebitOpenItem view from CONSUMPTION Debit Open Items
C_FactoringReceivableOpenItem view from CONSUMPTION Factoring Receivable Open Items for BVB
C_HR_CustomerItemReference view_entity from CONSUMPTION OPZ STAT 1 Customer Item Reference
C_IN_AcctgDocItem view from CONSUMPTION Accounting Document Segment entries
C_JP_MachineLearningOpenItem view inner CONSUMPTION Machine Learning Open Receivable Items
C_JP_MachineLrngClearedARItem view inner CONSUMPTION Machine Learning Cleared Receivable Item
C_MrkdDeltnSuplrOpenItem view from CONSUMPTION Supplier Marked for Deletion Open Item
C_MX_TaxItemLog view inner CONSUMPTION Mexico Tax Items for Statutory Reporting
C_OplAcctgDocItemCorrespnc view from CONSUMPTION Correspondence SAP09 - Operational document - items
C_OplAcctgDocItemForObjp view from CONSUMPTION Auxiliary Cosumption view for Object Page
C_PE_StRpJournalEntryWithTax view inner CONSUMPTION Peru journal entries with tax
C_ResetClearing view from CONSUMPTION Reset clearings
C_RO_StRpDomesticSlsPurListC view left_outer CONSUMPTION Romania Domestic Sales and Purchase List - Cube
C_RO_StRpSalesPurchaseItemC view left_outer CONSUMPTION RO: Sales/Purchase Journal Items
C_RO_StRpTaxItemWithEUTaxClfnC view left_outer CONSUMPTION EU Sales Tax Item View for RO
C_SI_OpnSupplierInvoiceItemC view_entity from CONSUMPTION Epobot Slovenia - Cube
C_StRpOplAcctgDocumentItemCube view from CONSUMPTION Opl Acc.Doc.Item Cube for Stat.Reporting
C_StRpOverdueInvoicesCube view from CONSUMPTION Overdue Invoices Cube for Stat.Reporting
C_SuplrDueInvcBlkdSitn view left_outer CONSUMPTION Situation for Blocked and Due Supplier Invoices
C_SuplrInvcBlkdSitn view left_outer CONSUMPTION Situation for Blocked Supplier Invoices
C_SuplrPaytBlkBlkdItmsAggrgn view from CONSUMPTION Total Amount and Count of Blocked Items
C_SuplrPaytBlkOpnItmsAggrgn view from CONSUMPTION Total Amount and Count of Open Items
C_TH_CreditMemoCube view_entity from CONSUMPTION View for Credit memo documents
CIC_DeltaOpenItem view_entity from Proj. View on Delta Open Item
CIC_DeltaResidualOpenItem view_entity from Proj. View on Open Item Delta
CIC_DeltaResidualOpenItem view_entity inner Proj. View on Open Item Delta
CIC_InitialOpenItem view_entity from Proj. View on Initial Open Item
CIC_InitialResidualOpenItem view_entity from Proj. View on Initial Residual Open Item
CIC_InitialResidualOpenItem view_entity inner Proj. View on Initial Residual Open Item
CIC_UpdatedResidualOpenItem view_entity from Proj. View on Residual Item Update
FAC_DART_Z3_AP_LINEITEM_BASE view from Account Payable - Line Items Base view
FAC_DART_Z3_AP_OPENITEM view from DART Z3 Account Payable - Open Items
FAC_DART_Z3_AR_LINEITEM_BASE view from Account Receivable - Line Items Base
FAC_DART_Z3_AR_OPENITEM view from Audit Z3 Account Receivable - Open Items
FAC_DART_Z3_GR_IR_BALANCE_BASE view from GR/IR Inventories - Balance Summary Base
FARMLVD_ACCDOCITM view from Accounting Document Key
FARMLVD_APAR_ACCDOC view inner Cleared Receivable Item Information
FARMLVD_APAR_ACCDOC_AUTH view from Rec Item Auth Check Helper View
FCLM_FI_STAGING_AREA view left_outer FI Staging Area
I_AcctDocCustomer view from COMPOSITE Customer Number for Accounting Document
I_APARWorklist view from COMPOSITE Open items which are not cleared in session of Write off
I_APProcessFlowDocumentVH view inner COMPOSITE Document Number
I_APProcessFlowDocumentVH view union COMPOSITE Document Number
I_AR_StRpPurFrgnSrvcItem view left_outer COMPOSITE Interface View For Argentina Foreign VAT Credit Service
I_AR_StRpPurFrgnSrvcItem view inner COMPOSITE Interface View For Argentina Foreign VAT Credit Service
I_AU_StRpTPARInvoiceLineItems view inner COMPOSITE Australia TPAR Invoice Line Items
I_BalanceAuditTrail view from COMPOSITE Line Items for Balance Audit Trail
I_BG_SAFTOneTimeCustomer view_entity inner COMPOSITE BG SAFT One Time Customer
I_BG_SAFTOneTimeSupplier view_entity inner COMPOSITE BG SAFT One Time Supplier
I_CO_UGPPBPInOplAcctgDocItem view_entity inner COMPOSITE
I_CollectionsInvoice view inner COMPOSITE Collections Invoices
I_FixedAssetTaxItem view inner COMPOSITE Tax Items for Fixed Asset
I_HR_CustomerItem view_entity from COMPOSITE OPZ STAT 1 Customer Item
I_IE_InvcGeneralLedgerItem view_entity from COMPOSITE ERR GL Item
I_IE_InvoiceSupplierItem view_entity from COMPOSITE ERR Supplier Item
I_IL_IncomingPaymentCashItem view_entity from COMPOSITE Payment Cash Item in IL Cashier System
I_IL_IncomingPaymentChequeItem view_entity from COMPOSITE Payment Cheque Item in IL Cashier System
I_IL_IncomingPmtBankTransItem view_entity from COMPOSITE Bank Transfer Item in IL Cashier System
I_IL_IncomingPmtCreditCardItem view_entity from COMPOSITE Credit Card Item in IL Cashier System
I_IN_IncgInvcAcctPyblItem view_entity from COMPOSITE Incoming Invoice Account Payable Item
I_IN_OutgInvcAcctRblItm view_entity from COMPOSITE Outgoing Invoice Account Receivable Item
I_IN_StRpGSTRet view left_outer COMPOSITE Tax Item Details for GST Returns
I_LU_SAFTGenLdgrTaxReportLine view from COMPOSITE SAFT LU Gnrl Ledger Tax Reporting Line
I_LU_SAFTGenLedgerLineSum view from COMPOSITE SAFT LU General Ledger Lines Total
I_OperationalAcctgDocCube view_entity from COMPOSITE Operational Journal Entry Item - Cube
I_PartnerInAccountingDocument view_entity inner COMPOSITE Partner in Accounting Document
I_PaymentRequestTP view left_outer TRANSACTIONAL Payment Request Draft
I_PH_JournalEntryCube view left_outer COMPOSITE PH CAS General Journal Cube
I_PT_AcctgDocCustAddrVers view inner COMPOSITE PT AccountingDoc CustAddr Version
I_PT_AcctgDocMatlVers view inner COMPOSITE PT AccountingDoc Material Version
I_PT_GenLedgerBPMasterData view_entity from COMPOSITE SAFT PT BP for Master Data
I_PT_SAFTAcctgDownPaytProd view_entity from COMPOSITE Accounting DownPayment Product Line
I_PT_SAFTBillAcctgOneTimeCust view_entity inner COMPOSITE One Time Customer from Accounting Doc
I_PT_SAFTBillgAccountingTax view_entity from COMPOSITE Taxes from Accounting Document
I_PT_SAFTBillgAcctgCustomer view_entity from COMPOSITE Customer from Accounting Document
I_PT_SAFTBillgAcctgItmAmt view_entity inner COMPOSITE Accounting Document Items Amount
I_PT_SAFTBillgAcctgProduct view_entity inner COMPOSITE Product from Accounting Document
I_PT_SAFTBillingAcctgPaytTax view_entity from COMPOSITE Down Payment Document Item Tax
I_PT_SAFTBillingAcctgSettlmt view_entity inner COMPOSITE Accounting Invoices Settlement Info
I_PT_SAFTOneTimeAcctgAddr view_entity from COMPOSITE One Time Customer Addr Accounting Docs
I_PT_SAFTPaytBusinessPartner view_entity from COMPOSITE Business Partner from Payment Document
I_RO_SAFTOneTimeCustomer view inner COMPOSITE RO SAFT One Time Customer
I_RO_SAFTOneTimeSupplier view inner COMPOSITE RO SAFT One Time Supplier
I_SAFTAccountingCustomer view from COMPOSITE SAF-T Regular Accounting Customers
I_SAFTAccountingItem view from BASIC SAF-T Accounting Item
I_SAFTAcctgOneTimeCustomer view from COMPOSITE SAF-T Accounting OneTimeCustomers
I_SAFTJournalItem view inner COMPOSITE SAF-T Journal Ledger Entry Item
I_SAFTJournalItem view left_outer COMPOSITE SAF-T Journal Ledger Entry Item
I_StRpAccountingDocumentItmC view from COMPOSITE Accounting Document Item Cube for Statutory Reporting
I_StRpTaxItemWithRefDocument view left_outer COMPOSITE Tax Items with Reference Documents
I_SupplierPaymentBlockOpnItmTP view from TRANSACTIONAL Payment Blocks for Open Items - TP
I_TaxItemProcessFlow view_entity inner COMPOSITE Tax Item Process Flow
P_AccountingDocumentCustomer view from COMPOSITE
P_AcctgDocKDMinItem view_entity from COMPOSITE Acctg Document Min Item for K or D line
P_APDaysPayOutst1 view from COMPOSITE
P_APLineItemForCorrespondence view from COMPOSITE
P_APLineItemForCorrespondence view union_all COMPOSITE
P_AR_CustomerReceivableTotal view from CONSUMPTION
P_AR_CustomerSupplierEntryItem view_entity inner CONSUMPTION
P_AR_DbtrCrdtrRblsPyblsTotal view from CONSUMPTION Arg. Dbt, Crdt, Receivables and Payables
P_AR_ElectronicDplItemsFromFI view inner CONSUMPTION
P_AR_SuplrFullClearingDocSel view_entity inner CONSUMPTION
P_AR_SuplrPartialPaymentDocSel view_entity inner CONSUMPTION
P_AR_SuplrPaymentDownPayment view_entity inner CONSUMPTION
P_AR_SuplrPaymentEndorsedCheck view_entity inner CONSUMPTION
P_AR_SuplrPaymentPartialFull view_entity inner CONSUMPTION
P_AR_SuplrPaymentPartialFull2 view_entity inner CONSUMPTION
P_AR_SuplrPaytSupplierLineItem view_entity inner CONSUMPTION
P_AR_SupplierPayable view from CONSUMPTION
P_AR_SupplierPaymentMethod view_entity from CONSUMPTION
P_ARLineItemForCorrespondence view from COMPOSITE
P_ARLineItemForCorrespondence view union_all COMPOSITE
P_ARProcessFlowJournalEntryDoc view_entity from CONSUMPTION Journal Entry for AR process flow
P_AU_StRpBASGLBal view from COMPOSITE
P_AU_StRpPaytTmesRptgDoc1 view_entity from COMPOSITE
P_AU_StRpPaytTmesRptgPaidInvc0 view inner COMPOSITE
P_AU_STRPPAYTTMESRPTGPartPay view_entity from COMPOSITE
P_AU_StRpPTRPaidInvcSPP view inner COMPOSITE
P_AU_StRpPTRPrtlyPaidInvcSPP0 view inner COMPOSITE
P_AU_StRpPTRPrtlyPaidInvcSPP1 view inner COMPOSITE
P_AU_StRpTPARFullyPaidInvcDoc view inner COMPOSITE
P_AU_StRpTPARPrtlyPaidInvcDoc view inner COMPOSITE
P_BadDebtReserveCustomers view from COMPOSITE
P_BG_SAFTINVOICEITEMCOUNT view_entity from CONSUMPTION
P_BG_SAFTPAYMENTITEM view_entity inner CONSUMPTION
P_BG_SAFTPURINVOICEHEADER view_entity inner CONSUMPTION
P_BG_SAFTPURINVOICEITEM view_entity inner CONSUMPTION
P_BG_SAFTSALESINVOICEHEADER view_entity inner CONSUMPTION
P_BG_SAFTSALESINVOICEITEM view_entity inner CONSUMPTION
P_BG_VATPartnerInfo view_entity inner COMPOSITE
P_BOPAcctgDocAnlys0 view from COMPOSITE
P_BOPRblsPyblsItemBase view_entity from COMPOSITE
P_CalculatedAllwncCustomers view from COMPOSITE
P_CcpCustLineItem view from COMPOSITE CCP customer line items
P_ClearedItem1 view from CONSUMPTION
P_CN_CADEAcctgDocPayableItem view from COMPOSITE
P_CN_CADEAcctgDocRblItem view from COMPOSITE
P_CN_JOURNALENTRYITEM view union_all CONSUMPTION
P_CO_DIANCFinPurchasingGLAcct view_entity inner CONSUMPTION
P_CO_DIANFrmt1007JrnlItmWthBP3 view_entity inner CONSUMPTION
P_CO_DIANStRpRevnOffsetAccount view from CONSUMPTION Format 1007 - Revenue Offsetting Account
P_CO_DIANXRefIDByBP view from CONSUMPTION All Formats - Xref ID by BP
P_CollectionsInvoiceNote view from COMPOSITE
P_CollsAcctDoc view inner COMPOSITE
P_CrdtMRblsItemHedgedAmount1 view_entity from COMPOSITE Receivables Item (by datetime)
P_CrExp view from COMPOSITE
P_CrExpFi view from COMPOSITE
P_CrExpFiMain view from COMPOSITE
P_CustomerLineItemPayer_10 view_entity from COMPOSITE
P_CustomerPostingDoc view_entity from CONSUMPTION
P_CUSTOMERVENDORLINEITEM1 view from COMPOSITE
P_DebitOpenItemForSituation view from COMPOSITE
P_DebitorPostingDoc view_entity from CONSUMPTION
P_DebtorCreditorRblsPyblsItem view from COMPOSITE
P_DeltaOpenItem view from CONSUMPTION
P_DeltaResidualOpenItem view from CONSUMPTION
P_DeltaResidualOpenItem view inner CONSUMPTION
P_DwnPaytReqItem view_entity union_all COMPOSITE Down Payment Request Items
P_ES_CreditMemoCube view_entity from COMPOSITE View for Credit memo documents
P_ES_PTRBillOfExchange view_entity from COMPOSITE
P_ES_PTRClearingDateBoE view_entity from COMPOSITE
P_Fa_Flowitem view left_outer BASIC
P_FARMLVD_ACCDOCITM view from CONSUMPTION Accounting Document Key
P_FinCorr1DownPaymentItem view_entity from COMPOSITE
P_FinCorrCustomerDownPayment view_entity inner COMPOSITE
P_FirstDbtrCrdtrRblsPyblMinItm view from COMPOSITE
P_FirstDbtrCrdtrRblsPyblsItem view from COMPOSITE
P_ForeignCurrencySuspicious view from COMPOSITE
P_FR_AuditFECOplAcctgDocItem view from CONSUMPTION France Audit File (FEC) – BSEG data
P_FR_OverdueInvoiceItem view from COMPOSITE
P_FR_OverduePaymentItem view from COMPOSITE
P_GB_PAYTPRACTICEPERF1 view from COMPOSITE
P_GLOvwJrnlEntrItmToBeVerify01 view union_all COMPOSITE
P_HR_CustomerItemPartPmnt view_entity from COMPOSITE
P_HR_FIRSTDBTRCRDTRRBLSPYBLMIN view_entity from COMPOSITE
P_HU_EVAT_DownPayments view_entity from CONSUMPTION
P_ID_AcctDocBusinessPartner view_entity from COMPOSITE
P_ID_CREDITMEMO view_entity inner COMPOSITE
P_ID_StRpAcctgDocItem view_entity from COMPOSITE
P_ID_StRpVATOutGLAccount view_entity from COMPOSITE
P_IN_IncgInvcAcctgDocHlthChk view_entity union COMPOSITE
P_IN_OutgInvcAcctgDocHlthChk view_entity union COMPOSITE Outgoing Invoice GST India health check
P_InitialOpenItem view from CONSUMPTION
P_InitialResidualOpenItem view from CONSUMPTION
P_InitialResidualOpenItem view inner CONSUMPTION
P_IT_StRpWHTItemExcldAcctAmt view_entity from COMPOSITE Italy WHT Excluded Account Amount
P_JournalEntryItemHistory view from COMPOSITE
P_JP_CentralBkPaytWithItems view from CONSUMPTION View for Japan Central Bank Payment Detail Items
P_JP_TradeCreditBalanceItems view from CONSUMPTION View for Trade Credit Check Detail Items
P_KZ_VATRetInDoc view left_outer CONSUMPTION
P_KZ_VATRetOutDoc view left_outer COMPOSITE
P_LstMiFIAcctgDocItmByDocument view from COMPOSITE
P_LU_SAFTJournalItemTaxAbs view inner COMPOSITE
P_MLColl_AcctgDocItemCleared view from COMPOSITE
P_MLColl_AcctgDocItemOpen view from COMPOSITE
P_MX_DefTaxDocSupplierDetails view from COMPOSITE
P_MX_DefTaxPaymentDocument view inner COMPOSITE
P_MX_OperationalAcctDocItem view inner CONSUMPTION
P_MY_CREDITMEMO view_entity inner COMPOSITE
P_MY_JournalEntryItem view from COMPOSITE
P_MY_StRpTaxItemWithProduct view_entity inner COMPOSITE
P_MY_StRpTaxItemWOProduct view inner COMPOSITE
P_MY_TxItmWithSlsDeductionProd view inner COMPOSITE
P_NO_SAFTTaxAmountSum view_entity inner COMPOSITE
P_NonMngdPurchasingSpend1 view from CONSUMPTION Non Managed Spend
P_NonMngdPurchasingSpend2 view inner CONSUMPTION Non Managed Spend
P_NonMngdPurchasingSpend3 view inner CONSUMPTION Non Managed Spend
P_OperationalAcctgDocBrowser view from COMPOSITE
P_OperationalAcctgDocBrowser view union_all COMPOSITE
P_OplAcctgDocItemCreditSum view from COMPOSITE
P_OplAcctgDocItemDebitSum view from COMPOSITE
P_PaymentReceiptException view left_outer BASIC
P_PaymentReceiptRelatedDoc view left_outer COMPOSITE
P_PayReqnAmount view from COMPOSITE
P_PayReqnLineItems view from COMPOSITE
P_PayReqnLineItems view union_all COMPOSITE
P_PAYREQNSUPLRCUSTLINEITEM view from COMPOSITE
P_PaytReceiptJournalEntry view from COMPOSITE
P_PAYTRECEIPTPAYMENTDOCITEM1 view from COMPOSITE
P_PH_AssetDocItem view from COMPOSITE
P_PH_CASCashItem view from COMPOSITE
P_PH_CASCashItem2 view_entity from COMPOSITE
P_PH_ClearingDocTaxInfo view from COMPOSITE
P_PH_ImportationSummaryItem view_entity inner COMPOSITE
P_PH_InputTaxAllocation view from COMPOSITE
P_PH_IsPaymentIndicator view from COMPOSITE
P_PH_PaytClrdReceivablePyblItm view from COMPOSITE
P_PH_PaytClrdReceivablePyblItm view left_outer COMPOSITE
P_PH_PaytOpnReceivablePyblItm view from COMPOSITE
P_PH_PaytOpnReceivablePyblItm view left_outer COMPOSITE
P_PH_PRDocumentInfo view left_outer COMPOSITE
P_PH_PRWithhodlingTaxInfo1 view inner COMPOSITE
P_PL_ExcessDelayAccountingItem view inner COMPOSITE Accounting data for Customer and Vendor
P_Pl_OverdueInvoicesHlp view from CONSUMPTION Helper view for Overdue Invoices
P_PL_SAFTAcctgInvoiceItem view inner COMPOSITE
P_PL_SAFTDocItemVat view inner COMPOSITE
P_PL_SAFTDocumentItemText view from COMPOSITE
P_PL_SAFTInvcHeaderBscVersion2 view_entity inner COMPOSITE
P_PL_SAFTInvoiceHeaderBasic view inner COMPOSITE
P_PL_SAFTJOURNALPARTNERINFO view_entity inner CONSUMPTION
P_PL_SAFTMapTaxCode view inner COMPOSITE
P_PODOWNPAYTBSEG view from CONSUMPTION Private View for BSEG table
P_PT_BOPAcctDocItemConfign view_entity from COMPOSITE
P_PT_BOPCustSuplrBalance view_entity from COMPOSITE
P_PT_BOPPartialPaymentItem view_entity inner COMPOSITE
P_PT_BusinessPartner_Delivery view_entity from COMPOSITE Business Partner Delivery Country
P_PT_DocItemPartner view from CONSUMPTION View to select all partner and customer line item
P_PT_DocItemWIT view from CONSUMPTION Query to extract only WIT item
P_RblsItmForKeyDteDuePerd1 view inner COMPOSITE
P_RblsItmForKeyDteDuePerd1a view from COMPOSITE
P_RblsItmForKeyDteDuePerd1a view left_outer COMPOSITE
P_RblsItmForKeyDteDuePerd4A view inner COMPOSITE
P_RblsItmForKeyDtePerd1_WSJ view_entity from COMPOSITE
P_ReceivablesItemHedgedAmount1 view from COMPOSITE
P_RO_SAFTBsad view from COMPOSITE BSAD
P_RO_SAFTBSAK view from COMPOSITE BSAK
P_RO_SAFTNTRBSEGTAXINFO view_entity from CONSUMPTION
P_RO_SAFTNTRPurInvItem view_entity inner CONSUMPTION
P_RO_SAFTNTRSlsInvItem view_entity inner CONSUMPTION
P_RO_SAFTOplAcctgDocItmBase view from CONSUMPTION RO SAFT bseg
P_RO_SAFTPaymentHeader view inner CONSUMPTION
P_RO_SAFTPaymnetItemNew view inner CONSUMPTION SAFT RO Payment Item
P_RO_SAFTPurInvItem view inner CONSUMPTION
P_RO_SAFTPurInvItemAmount view_entity inner CONSUMPTION
P_RO_SAFTPURINVITEMTOTAL view_entity inner CONSUMPTION
P_RO_SAFTSalesInvoiceItem view inner CONSUMPTION
P_RO_SAFTSLSINVITEMTOTAL view_entity inner CONSUMPTION
P_RO_SAFTSlsInvoiceItemAmount view_entity inner CONSUMPTION
P_RO_StRpDeferredItem view left_outer CONSUMPTION RO: VAT 300 Deferred Items
P_RU_AdvancePaymentDocument view from CONSUMPTION
P_RU_AdvancePaymentDocument view union_all CONSUMPTION
P_RU_DownPaymentClearing view inner CONSUMPTION
P_RU_DownPaymentClearing view union_all CONSUMPTION
P_RU_DownPaymentClearing1 view from CONSUMPTION
P_RU_DownPaymentClearing2 view from CONSUMPTION
P_Ru_FinDocStructuralDivision3 view from CONSUMPTION
P_Ru_FinDocStructuralDivision4 view from CONSUMPTION
P_RU_FIRSTACCDOCITEMPARTNR view from COMPOSITE First Item with Partner
P_RU_GtdFromPOMM8N view inner COMPOSITE
P_RU_GtdFromSgtxt1 view from COMPOSITE
P_RU_Invoice view inner CONSUMPTION
P_RU_InvoiceClearing view left_outer CONSUMPTION
P_RU_InvoiceClearing1 view from CONSUMPTION
P_RU_InvoiceClearingDocItem view from CONSUMPTION
P_RU_MaterialRcptDateMM3 view inner CONSUMPTION
P_RU_MaterialRcptDateMM4 view inner CONSUMPTION
P_RU_MaterialRcptDateMMMvtAccD view from CONSUMPTION
P_RU_MaterialRcptDateMMwoPO view from CONSUMPTION
P_RU_MaterialReceiptMM view from COMPOSITE
P_RU_MaterialReceiptMM view inner COMPOSITE
P_RU_OperAcctgDocItemNegPost view from CONSUMPTION
P_RU_PartnerInAccDocument view inner COMPOSITE Partner in Accounting Document
P_RU_PaymentDocument2 view inner CONSUMPTION
P_RU_RecnclnDocDet000 view from CONSUMPTION Document Dtermination - Helper base view
P_Ru_RecnclnDocDet002 view from CONSUMPTION
P_RU_SuplrCustAccDocItem001 view from CONSUMPTION
P_RU_SuplrCustAcctgDocItem0 view from CONSUMPTION
P_RU_SuplrInvcAcctgItem1 view inner CONSUMPTION
P_RU_VATInvoiceClearingDP view from CONSUMPTION
P_RU_VATInvoiceClearingDP view inner CONSUMPTION
P_RU_VATInvoiceClearingPR view from CONSUMPTION
P_RU_VatSalesPurchaseLedgers5 view left_outer CONSUMPTION
P_SAFTJournalItemTaxAbs view inner COMPOSITE
P_SE_PTRSupplierInvoiceItem view_entity from CONSUMPTION
P_SG_OperationalAcctgDocItem view from COMPOSITE
P_SI_FirstDbtrCrdtrRblsPyblMin view_entity from COMPOSITE
P_SK_CustRefDocNumVH view from COMPOSITE
P_SK_StRpVATCSClearingInfo view inner COMPOSITE
P_SK_StRpVATCSClearingInfo view union_all COMPOSITE
P_SK_VATLedgerClearingInfo view_entity inner COMPOSITE
P_SK_VATLedgerClearingInfo view_entity union_all COMPOSITE
P_SK_VendRefDocNumVH view from COMPOSITE
P_StRpBPTaxItem0 view from COMPOSITE
P_StRpBPTaxItem13 view from COMPOSITE
P_StRpBPTaxItemX3 view_entity from COMPOSITE
P_StRpTaxItmWithEUTaxClass6 view from COMPOSITE
P_SuplrPaytBlkDocItmWthPurOrd view from CONSUMPTION
P_SupplierLineItemPayee10 view_entity from COMPOSITE
P_TH_CreditMemo view_entity from COMPOSITE
P_TH_StRpDeferTaxPayment view_entity inner COMPOSITE
P_TH_StRpTaxItems view left_outer COMPOSITE
P_TH_StRpTaxPaymentReturn view inner COMPOSITE
P_TW_TaxItem view left_outer COMPOSITE
P_TW_TaxItemDeletionOption view left_outer COMPOSITE
P_UpdatedResidualOpenItem view from CONSUMPTION
P_USFedOplAcctgDocItem view_entity from BASIC
R_ManageJournalEntryItem view_entity from COMPOSITE Journal Entry Item

Fields (247)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,BillingDocument,ClearedAccountingDocument,ClearingAccountingDocument,Documentid,DownPayment,GoodsRcptAccountingDocument,Invoice,InvoiceAccountingDocument,InvoiceNumber,InvoiceReference,OpenItemAccountingDocument,ProcessFlowNodeDocument 140
KEY AccountingDocumentItem AccountingDocumentItem,ClearedAccountingDocumentItem,ClearingAccountingDocumentItem,InvoiceItemReference,OpenItemAccountingDocumentItem,ParentProcessFlowNodeDocItem 101
KEY ClearingAccountingDocument ClearingAccountingDocument,DownPaymentClearing,II_ClearingAccountingDocument 26
KEY ClearingFiscalYear ClearingFiscalYear 2
KEY ClearingInfoCompanyCode ClearingCompanyCode 2
KEY CompanyCode CompanyCode,DownPaymentCompanyCode,InvoiceCompanyCode,OpenItemCompanyCode,SourceCompanyCode 137
KEY Customer APARAccount,Customer,CustomerSupplierAccount,II_Customer,kunnr 60
KEY FiscalYear ClearedFiscalYear,ClearingFiscalYear,DownPaymentFiscalYear,FiscalYear,GoodsRcptFiscalYear,InvoiceFiscalYear,InvoiceReferenceFiscalYear,OpenItemFiscalYear 139
KEY GLAccount GLAccount,PaymentGLAccount 41
KEY InvoiceItemReference AccountingDocumentItem,DownPaymentItem,InvoiceItemReference 25
KEY InvoiceReference AccountingDocument,ClearedAccountingDocument,DownPayment,InvoiceReference,RefInvcInvoiceReference 41
KEY InvoiceReferenceFiscalYear ClearedFiscalYear,DownPaymentFiscalYear,FiscalYear,InvoiceReferenceFiscalYear 36
KEY LedgerGLLineItem LedgerGLLineItem 3
KEY OriginalReferenceDocument OriginalReferenceDocument 6
KEY PostingDate budat,GoodsRcptPostingDate,II_PostingDate,PostingDate 69
KEY Product Material,Product 9
KEY PurchasingDocument PurchaseOrder,PurchasingDocument 13
KEY PurchasingDocumentItem PurchasingDocumentItem 12
KEY ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 4
KEY ReferenceDocumentType ReferenceDocumentType 7
KEY Supplier BusinessPartner,Creditor,CustomerSupplierAccount,lifnr,Supplier 48
KEY TaxCode DownPaymentTaxCode,TaxCode 19
KEY TaxItemGroup TaxItemGroup 8
KEY TaxType TaxType 3
_AccountingDocumentCategory _AccountingDocumentCategory 1
_AccountingDocumentType _AccountingDocumentType 5
_BudgetPeriod _BudgetPeriod 1
_ChartOfAccounts _ChartOfAccounts 4
_ChartOfAccountsText _ChartOfAccountsText 2
_ClearingJournalEntry _ClearingJournalEntry 1
_CompanyCode _CompanyCode 23
_CompanyCodeCurrency _CompanyCodeCurrency 6
_ControllingArea _ControllingArea 2
_ControllingAreaText _ControllingAreaText 2
_Customer _Customer 16
_DebitCreditCode _DebitCreditCode 5
_FinancialAccountType _FinancialAccountType 5
_FiscalPeriod _FiscalPeriod 2
_FiscalYear _FiscalYear 15
_FixedAsset _FixedAsset 1
_FunctionalArea _FunctionalArea 1
_FunctionalCurrency _FunctionalCurrency 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 3
_GLAccountInCompanyCode _GLAccountInCompanyCode 6
_JournalEntry _JournalEntry 15
_JournalEntryItemOneTimeData _JournalEntryItemOneTimeData 1
_Material _Material 2
_OffsettingAccount _OffsettingAccount 1
_OffsettingAccountType _OffsettingAccountType 1
_OffsettingChartOfAccounts _OffsettingChartOfAccounts 1
_OneTimeAccountBP _OneTimeAccountBP 2
_PaymentDifferenceReason _PaymentDifferenceReason 2
_Plant _Plant 2
_Product _Product 3
_ProductText _ProductText 3
_PurchasingDocument _PurchasingDocument 2
_PurchasingDocumentItem _PurchasingDocumentItem 2
_ReferenceDocumentType _ReferenceDocumentType 3
_SalesDoc _SalesDoc 1
_SalesDocItem _SalesDocItem 1
_SalesDocument _SalesDocument 2
_SalesDocumentItem _SalesDocumentItem 1
_SpecialGLCode _SpecialGLCode 5
_Supplier _Supplier 11
_SupplyingCountry _SupplyingCountry 1
_TransactionCurrency _TransactionCurrency 8
AbsltAmountInPaymentCurrency AbsltAmountInPaymentCurrency 1
AbsltAmtInAdditionalCurrency1 AbsltAmtInAdditionalCurrency1 1
AbsltAmtInAdditionalCurrency2 AbsltAmtInAdditionalCurrency2 1
AbsltAmtInBalanceTransacCrcy AbsltAmtInBalanceTransacCrcy 1
AbsltAmtInFunctionalCurrency AbsltAmtInFunctionalCurrency 1
AbsoluteAmountInCoCodeCrcy AbsoluteAmountInCoCodeCrcy 1
AbsoluteAmountInTransacCrcy AbsoluteAmountInTransacCrcy 1
AccountAssignmentNumber AccountAssignmentNumber 1
AccountingDocumentCategory AccountingDocumentCategory 10
AccountingDocumentItemRef AccountingDocumentItemRef 3
AccountingDocumentItemType AccountingDocumentItemType 5
AccountingDocumentType AccountingDocumentType,blart,DownPaymentType 38
AccountType AccountType 2
AdditionalCurrency1 AdditionalCurrency1 6
AdditionalCurrency2 AdditionalCurrency2 6
AlternativeGLAccount AlternativeGLAccount 2
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 1
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency,AmountInReportingCurrency,BalanceAmountInCoCodeCrcy,CostCenterAmount,II_AmountInCompanyCodeCurrency,OpenDueAmountInDisplayCrcy,PartialPaymentAmtInDspCrcy,TaxBaseAmountInCoCodeCrcy,TotalAmountInCoCodeCrcy 46
AmountInFunctionalCurrency AmountInFunctionalCurrency 3
AmountInTransactionCurrency AmountInTransactionCurrency,II_AmountInTransactionCurrency 40
AssetContract AssetContract 1
AssignmentReference AssignmentReference,EndorsedCheckNumber,II_AssignmentReference 21
BalanceTransactionCurrency BalanceTransactionCurrency 1
BaseUnit BaseUnit,QuantityUnit,UnitOfMeasure 8
BillingDocument BillingDocument,II_BillingDocument 16
BPBankAccountInternalID BPBankAccountInternalID,SupplierBankType 3
BranchCode BranchCode 3
BudgetPeriod BudgetPeriod 2
BusinessArea BusinessArea 6
BusinessPlace bupla,BusinessPlace 12
BusinessProcess BusinessProcess 1
CashDiscAbsltAmtInCoCodeCrcy CashDiscAbsltAmtInCoCodeCrcy 1
CashDiscount1Days CashDiscount1Days,II_CashDiscount1Days,RefInvcCashDiscount1Days 17
CashDiscount1DueDate CashDiscount1DueDate 4
CashDiscount1Percent CashDiscount1Percent,II_CashDiscount1Percent 18
CashDiscount2Days CashDiscount2Days,II_CashDiscount2Days,RefInvcCashDiscount2Days 17
CashDiscount2DueDate CashDiscount2DueDate 4
CashDiscount2Percent CashDiscount2Percent,II_CashDiscount2Percent 18
CashDiscountAbsoluteAmount CashDiscountAbsoluteAmount 1
CashDiscountAbsoluteBaseAmount CashDiscountAbsoluteBaseAmount 1
CashDiscountAmount CashDiscountAmount,ClearedCashDiscountAmount,II_CashDiscountAmount 15
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy 3
CashDiscountBaseAmount CashDiscountBaseAmount,II_CashDiscountBaseAmount 10
CashFlowType CashFlowType 1
ChartOfAccounts ChartOfAccounts 15
ClearingCreationDate ClearingCreationDate,II_ClearingCreationDate 6
ClearingDate ClearingDate,II_ClearingDate,PaymentDate,ReportingDate 36
ClearingDocFiscalYear ClearingDocFiscalYear,DownPaymentClearingFiscalYear,II_ClearingDocFiscalYear 18
ClearingIsReversed ClearingIsReversed 1
ClearingItem ClearingItem 2
ClearingJournalEntry ClearingAccountingDocument,ClearingJournalEntry 27
ClearingJournalEntryFiscalYear ClearingDocFiscalYear,ClearingJournalEntryFiscalYear 15
CommitmentItem CommitmentItemShortID 1
CommitmentItemShortID CommitmentItemShortID 1
CompanyCodeCurrency CompanyCodeCurrency,CreditCompanyCodeCurrency,Currency,DebitCompanyCodeCurrency,DisplayCurrency,II_CompanyCodeCurrency 67
ControllingArea ControllingArea 6
CostCenter CostCenter 4
CostElement CostElement 1
CostObject CostObject 1
CreditControlArea CreditControlArea 5
CreditControlAreaCurrency CreditControlAreaCurrency 1
CustomerIsInExecution CustomerIsInExecution 1
CustomerSupplierCountry CustomerSupplierCountry 1
DebitCreditCode DebitCreditCode,DownPaymentDebitCreditCode,II_DebitCreditCode,InvoiceDebitCreditCode,RefInvcDebitCreditCode 49
DelivOfGoodsDestCountry DelivOfGoodsDestCountry 5
DelivOfGoodsOriginCountry DelivOfGoodsOriginCountry 1
DocumentDate DocumentDate,GoodsRcptDocumentDate,II_DocumentDate,RefInvcDocumentDate 43
DocumentItemText DocumentItemText,II_DocumentItemText,PaymentNote 35
DueCalculationBaseDate DueCalculationBaseDate,II_DueCalculationBaseDate,RefInvcDueCalculationBaseDate 22
DunningLevel DunningLevel 2
FinancialAccountType AccountType,FinancialAccountType,RefInvcFinancialAccountType 52
FinancialTransactionType FinancialTransactionType 2
FiscalPeriod FiscalPeriod 15
FixedAsset FixedAsset 2
FixedCashDiscount FixedCashDiscount,II_FixedCashDiscount 11
FollowOnDocumentType FollowOnDocumentType 14
FunctionalArea FunctionalArea 6
FunctionalCurrency FunctionalCurrency 3
Fund Fund 4
FundedProgram FundedProgram 3
FundsCenter FundsCenter 2
GrantID GrantID 2
HedgedAbsoluteAmount HedgedAbsoluteAmount 1
HedgedAmount HedgedAmount 1
HouseBank HouseBank 6
HouseBankAccount HouseBankAccount 4
IN_GSTPartner IN_GSTPartner 2
IN_GSTPlaceOfSupply IN_GSTPlaceOfSupply 2
IN_HSNOrSACCode IN_HSNOrSACCode 5
InventoryValuationType InventoryValuationType 1
InvoiceAbsltAmtInCoCodeCrcy InvoiceAbsltAmtInCoCodeCrcy 1
InvoiceAbsltAmtInFrgnCurrency InvoiceAbsltAmtInFrgnCurrency 1
IsAutomaticallyCreated IsAutomaticallyCreated 2
IsEUTriangularDeal IsEUTriangularDeal 3
IsNegativePosting IsNegativePosting 8
IsOpenItemManaged IsOpenItemManaged 2
IsSalesRelated IsSalesRelated 4
IsUsedInPaymentTransaction IsUsedInPaymentTransaction 23
LastDunningDate LastDunningDate 2
MasterFixedAsset MasterFixedAsset 1
Material Material 6
MaterialPriceControl MaterialPriceControl 1
NetDueDate CashDiscount1DueDate,II_NetDueDate,NetDueDate,RefInvcNetDueDate 27
NetPaymentAbsoluteAmount NetPaymentAbsoluteAmount 1
NetPaymentAmount NetPaymentAmount 2
NetPaymentDays II_NetPaymentDays,NetPaymentDays,RefInvcNetPaymentDays 18
NonDcblTaxAbsltAmtInCoCodeCrcy NonDcblTaxAbsltAmtInCoCodeCrcy 1
NonDcblTaxAbsltAmtInTransCrcy NonDcblTaxAbsltAmtInTransCrcy 1
OffsettingAccount OffsettingAccount 2
OffsettingAccountType OffsettingAccountType 2
OffsettingChartOfAccounts OffsettingChartOfAccounts 1
OplAcctgDocItmCntrySpcfcRef1 OplAcctgDocItmCntrySpcfcRef1 1
OrderID OrderID 3
OriginalTaxAbsoluteBaseAmount OriginalTaxAbsoluteBaseAmount 1
OriglTxAbsltBaseAmountInCCCrcy OriglTxAbsltBaseAmountInCCCrcy 1
OriglTxAbsltBaseAmtInAddlCrcy1 OriglTxAbsltBaseAmtInAddlCrcy1 1
OriglTxAbsltBaseAmtInAddlCrcy2 OriglTxAbsltBaseAmtInAddlCrcy2 1
PartnerCompany PartnerCompany 7
PaymentBlockingReason II_PaymentBlockingReason,PaymentBlockingReason 17
PaymentDifferenceReason II_PaymentDifferenceReason,PaymentDifferenceReason 13
PaymentMethod PaymentMethod 13
PaymentReason PaymentReason 1
PaymentReference IL_IdentifierCashPaymentItem,PaymentReference 9
PaymentTerms II_PaymentTerms,PaymentTerms 21
PersonnelNumber PersonnelNumber 2
PlannedAbsltAmtInTransCrcy PlannedAbsltAmtInTransCrcy 1
PlanningLevel PlanningLevel 1
Plant Plant 6
PostingKey PostingKey 7
ProfitCenter ProfitCenter 4
ProjectNetwork ProjectNetwork 1
Quantity Quantity 4
RealEstateObject RealEstateObject 1
Reference1IDByBusinessPartner Reference1IDByBusinessPartner 4
Reference2IDByBusinessPartner Reference2IDByBusinessPartner 3
Reference3IDByBusinessPartner BusinessPartnerFullName,BusinessPartnerName,Reference3IDByBusinessPartner,TaxNumberLineItem 6
Region Region 1
SalesDocument SalesDocument 4
SalesDocumentItem SalesDocumentItem 3
Segment Segment 3
SettlementReferenceDate SettlementReferenceDate 1
SpecialGLCode RelatedSpecialGLCode,SpecialGLCode 29
SpecialGLTransactionType ReltdSpclGLTransacType,SpecialGLTransactionType 13
StateCentralBankPaymentReason StateCentralBankPaymentReason 1
SupplyingCountry SupplyingCountry 5
TaxAbsltAmountInCoCodeCrcy TaxAbsltAmountInCoCodeCrcy 1
TaxAbsltAmtInAddlCurrency1 TaxAbsltAmtInAddlCurrency1 1
TaxAbsltAmtInAddlCurrency2 TaxAbsltAmtInAddlCurrency2 1
TaxAbsltBaseAmountInCoCodeCrcy TaxAbsltBaseAmountInCoCodeCrcy 1
TaxAbsltBaseAmountInTransCrcy TaxAbsltBaseAmountInTransCrcy 1
TaxAbsoluteAmount TaxAbsoluteAmount 1
TaxAmount TaxAmount 6
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 7
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 2
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 2
TaxBrkdwnAbsltAmt1InCoCodeCrcy TaxBrkdwnAbsltAmt1InCoCodeCrcy 1
TaxBrkdwnAbsltAmt1InTransCrcy TaxBrkdwnAbsltAmt1InTransCrcy 1
TaxBrkdwnAbsltAmt2InCoCodeCrcy TaxBrkdwnAbsltAmt2InCoCodeCrcy 1
TaxBrkdwnAbsltAmt2InTransCrcy TaxBrkdwnAbsltAmt2InTransCrcy 1
TaxBrkdwnAbsltAmt3InCoCodeCrcy TaxBrkdwnAbsltAmt3InCoCodeCrcy 1
TaxBrkdwnAbsltAmt3InTransCrcy TaxBrkdwnAbsltAmt3InTransCrcy 1
TaxCountry TaxCountry 5
TaxDeterminationDate TaxDeterminationDate 2
TaxJurisdiction TaxJurisdiction 4
TaxSection TaxSection 2
TransactionCurrency Currency,II_TransactionCurrency,rwcur,TransactionCurrency 52
TransactionTypeDetermination TransactionTypeDetermination 6
TreasuryContractType TreasuryContractType 1
UnadjustedDebitCreditCode UnadjustedDebitCreditCode 3
ValnDiffAbsltAmtInAddlCrcy1 ValnDiffAbsltAmtInAddlCrcy1 1
ValnDiffAbsltAmtInAddlCrcy2 ValnDiffAbsltAmtInAddlCrcy2 1
ValnDiffAbsltAmtInCoCodeCrcy ValnDiffAbsltAmtInCoCodeCrcy 1
ValuationArea ValuationArea 2
ValueDate ValueDate 2
VATRegistration BPTaxNumber,VATRegistration 17
WBSElementInternalID WBSElementInternalID 2
WhldgTaxExemptionAbsltAmount WhldgTaxExemptionAbsltAmount 1
WithholdingTaxAbsoluteAmount WithholdingTaxAbsoluteAmount 1
WithholdingTaxAbsoluteBaseAmt WithholdingTaxAbsoluteBaseAmt 1
WithholdingTaxCode WithholdingTaxCode 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Operational Accounting Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPERATIONALACCTGDOCITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGFISCALYEAR,
    CLEARINGINFOCOMPANYCODE,
    COMPANYCODE,
    CUSTOMER,
    FISCALYEAR,
    GLACCOUNT,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    LEDGERGLLINEITEM,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    PRODUCT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    SUPPLIER,
    TAXCODE,
    TAXITEMGROUP,
    TAXTYPE,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _BUDGETPERIOD,
    _CHARTOFACCOUNTS,
    _CHARTOFACCOUNTSTEXT,
    _CLEARINGJOURNALENTRY,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _CONTROLLINGAREATEXT,
    _CUSTOMER,
    _DEBITCREDITCODE,
    _FINANCIALACCOUNTTYPE,
    _FISCALPERIOD,
    _FISCALYEAR,
    _FIXEDASSET,
    _FUNCTIONALAREA,
    _FUNCTIONALCURRENCY,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _JOURNALENTRY,
    _JOURNALENTRYITEMONETIMEDATA,
    _MATERIAL,
    _OFFSETTINGACCOUNT,
    _OFFSETTINGACCOUNTTYPE,
    _OFFSETTINGCHARTOFACCOUNTS,
    _ONETIMEACCOUNTBP,
    _PAYMENTDIFFERENCEREASON,
    _PLANT,
    _PRODUCT,
    _PRODUCTTEXT,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _REFERENCEDOCUMENTTYPE,
    _SALESDOC,
    _SALESDOCITEM,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _SPECIALGLCODE,
    _SUPPLIER,
    _SUPPLYINGCOUNTRY,
    _TRANSACTIONCURRENCY,
    ABSLTAMOUNTINPAYMENTCURRENCY,
    ABSLTAMTINADDITIONALCURRENCY1,
    ABSLTAMTINADDITIONALCURRENCY2,
    ABSLTAMTINBALANCETRANSACCRCY,
    ABSLTAMTINFUNCTIONALCURRENCY,
    ABSOLUTEAMOUNTINCOCODECRCY,
    ABSOLUTEAMOUNTINTRANSACCRCY,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEMREF,
    ACCOUNTINGDOCUMENTITEMTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETCONTRACT,
    ASSIGNMENTREFERENCE,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BILLINGDOCUMENT,
    BPBANKACCOUNTINTERNALID,
    BRANCHCODE,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPLACE,
    BUSINESSPROCESS,
    CASHDISCABSLTAMTINCOCODECRCY,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1DUEDATE,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2DUEDATE,
    CASHDISCOUNT2PERCENT,
    CASHDISCOUNTABSOLUTEAMOUNT,
    CASHDISCOUNTABSOLUTEBASEAMOUNT,
    CASHDISCOUNTAMOUNT,
    CASHDISCOUNTAMTINCOCODECRCY,
    CASHDISCOUNTBASEAMOUNT,
    CASHFLOWTYPE,
    CHARTOFACCOUNTS,
    CLEARINGCREATIONDATE,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CLEARINGISREVERSED,
    CLEARINGITEM,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMMITMENTITEM,
    COMMITMENTITEMSHORTID,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTELEMENT,
    COSTOBJECT,
    CREDITCONTROLAREA,
    CREDITCONTROLAREACURRENCY,
    CUSTOMERISINEXECUTION,
    CUSTOMERSUPPLIERCOUNTRY,
    DEBITCREDITCODE,
    DELIVOFGOODSDESTCOUNTRY,
    DELIVOFGOODSORIGINCOUNTRY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    DUECALCULATIONBASEDATE,
    DUNNINGLEVEL,
    FINANCIALACCOUNTTYPE,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FIXEDASSET,
    FIXEDCASHDISCOUNT,
    FOLLOWONDOCUMENTTYPE,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GRANTID,
    HEDGEDABSOLUTEAMOUNT,
    HEDGEDAMOUNT,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    IN_GSTPARTNER,
    IN_GSTPLACEOFSUPPLY,
    IN_HSNORSACCODE,
    INVENTORYVALUATIONTYPE,
    INVOICEABSLTAMTINCOCODECRCY,
    INVOICEABSLTAMTINFRGNCURRENCY,
    ISAUTOMATICALLYCREATED,
    ISEUTRIANGULARDEAL,
    ISNEGATIVEPOSTING,
    ISOPENITEMMANAGED,
    ISSALESRELATED,
    ISUSEDINPAYMENTTRANSACTION,
    LASTDUNNINGDATE,
    MASTERFIXEDASSET,
    MATERIAL,
    MATERIALPRICECONTROL,
    NETDUEDATE,
    NETPAYMENTABSOLUTEAMOUNT,
    NETPAYMENTAMOUNT,
    NETPAYMENTDAYS,
    NONDCBLTAXABSLTAMTINCOCODECRCY,
    NONDCBLTAXABSLTAMTINTRANSCRCY,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OFFSETTINGCHARTOFACCOUNTS,
    OPLACCTGDOCITMCNTRYSPCFCREF1,
    ORDERID,
    ORIGINALTAXABSOLUTEBASEAMOUNT,
    ORIGLTXABSLTBASEAMOUNTINCCCRCY,
    ORIGLTXABSLTBASEAMTINADDLCRCY1,
    ORIGLTXABSLTBASEAMTINADDLCRCY2,
    PARTNERCOMPANY,
    PAYMENTBLOCKINGREASON,
    PAYMENTDIFFERENCEREASON,
    PAYMENTMETHOD,
    PAYMENTREASON,
    PAYMENTREFERENCE,
    PAYMENTTERMS,
    PERSONNELNUMBER,
    PLANNEDABSLTAMTINTRANSCRCY,
    PLANNINGLEVEL,
    PLANT,
    POSTINGKEY,
    PROFITCENTER,
    PROJECTNETWORK,
    QUANTITY,
    REALESTATEOBJECT,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE2IDBYBUSINESSPARTNER,
    REFERENCE3IDBYBUSINESSPARTNER,
    REGION,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SEGMENT,
    SETTLEMENTREFERENCEDATE,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    STATECENTRALBANKPAYMENTREASON,
    SUPPLYINGCOUNTRY,
    TAXABSLTAMOUNTINCOCODECRCY,
    TAXABSLTAMTINADDLCURRENCY1,
    TAXABSLTAMTINADDLCURRENCY2,
    TAXABSLTBASEAMOUNTINCOCODECRCY,
    TAXABSLTBASEAMOUNTINTRANSCRCY,
    TAXABSOLUTEAMOUNT,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBRKDWNABSLTAMT1INCOCODECRCY,
    TAXBRKDWNABSLTAMT1INTRANSCRCY,
    TAXBRKDWNABSLTAMT2INCOCODECRCY,
    TAXBRKDWNABSLTAMT2INTRANSCRCY,
    TAXBRKDWNABSLTAMT3INCOCODECRCY,
    TAXBRKDWNABSLTAMT3INTRANSCRCY,
    TAXCOUNTRY,
    TAXDETERMINATIONDATE,
    TAXJURISDICTION,
    TAXSECTION,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    TREASURYCONTRACTTYPE,
    UNADJUSTEDDEBITCREDITCODE,
    VALNDIFFABSLTAMTINADDLCRCY1,
    VALNDIFFABSLTAMTINADDLCRCY2,
    VALNDIFFABSLTAMTINCOCODECRCY,
    VALUATIONAREA,
    VALUEDATE,
    VATREGISTRATION,
    WBSELEMENTINTERNALID,
    WHLDGTAXEXEMPTIONABSLTAMOUNT,
    WITHHOLDINGTAXABSOLUTEAMOUNT,
    WITHHOLDINGTAXABSOLUTEBASEAMT,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, CLEARINGACCOUNTINGDOCUMENT, CLEARINGFISCALYEAR, CLEARINGINFOCOMPANYCODE, COMPANYCODE, CUSTOMER, FISCALYEAR, GLACCOUNT, INVOICEITEMREFERENCE, INVOICEREFERENCE, INVOICEREFERENCEFISCALYEAR, LEDGERGLLINEITEM, ORIGINALREFERENCEDOCUMENT, POSTINGDATE, PRODUCT, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, REFERENCEDOCUMENTLOGICALSYSTEM, REFERENCEDOCUMENTTYPE, SUPPLIER, TAXCODE, TAXITEMGROUP, TAXTYPE)
);