I_OPERATIONALACCTGDOCITEM
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA