I_ACCOUNTINGDOCUMENT

CDS View
34 Fields 95 CDS Views

Accounting Document

I_ACCOUNTINGDOCUMENT is a CDS View in S/4HANA. Accounting Document. It contains 34 fields. 95 CDS views read from this table.

CDS Views using this table (95)

ViewTypeJoinVDMDescription
C_ID_StRpVATExportCube view from CONSUMPTION Cube View for ID Exports VAT Report
C_ID_StRpVATImportCube view from CONSUMPTION Cube View for ID Imports VAT Report
C_ID_StRpVATInb view from CONSUMPTION Tax Items for ID VAT IN Statutory Report
C_ID_StRpVATOut view from CONSUMPTION ID VAT OUT Statutory Report view
C_ResetClearing view inner CONSUMPTION Reset clearings
C_RO_SAFTPurInvoiceHeader view inner CONSUMPTION Purchase invoice header for RO SAFT
C_RO_SAFTSalesInvoiceHeader view inner CONSUMPTION Sales invoice header for RO SAFT
C_RU_BPBalRecnclnItm view left_outer CONSUMPTION FI RU Business Partner Reconciliation Report Items
C_SuplrDueInvcBlkdSitn view left_outer CONSUMPTION Situation for Blocked and Due Supplier Invoices
C_SuplrInvcBlkdSitn view left_outer CONSUMPTION Situation for Blocked Supplier Invoices
CIC_DeltaOpenItem view_entity inner Proj. View on Delta Open Item
CIC_DeltaResidualOpenItem view_entity inner Proj. View on Open Item Delta
CIC_InitialOpenItem view_entity inner Proj. View on Initial Open Item
CIC_InitialResidualOpenItem view_entity inner Proj. View on Initial Residual Open Item
CIC_UpdatedOpenItem view_entity inner Proj. View on Updated Open Item
CIC_UpdatedResidualOpenItem view_entity inner Proj. View on Residual Item Update
FCLM_FI_STAGING_AREA view left_outer FI Staging Area
I_AccountingDocumentStdVH view from COMPOSITE Accounting Document
I_AR_StRpTaxItem view left_outer COMPOSITE Argentina VAT Tax Line Item Calculation
I_CrcyAdjmtItemToBeVerified view left_outer COMPOSITE Union View of Crcy Adjmt to be verified
I_GLJrnlEntryItemAmount view from COMPOSITE View to Calculate Line Item Amount
I_GLJrnlEntryItemToBeVerified view left_outer COMPOSITE Union View of LI in GL JE to be verified
I_ID_StRpVATReturnInCube view from COMPOSITE Indonesia VAT Return In - Cube
I_IN_STODocument view left_outer COMPOSITE STO GR verified Documents for Invoice
I_NL_SAFTBusinessPartner view inner COMPOSITE SAF-T NL Business Partner
I_PaymentBatchPaymentDocument view_entity inner COMPOSITE Payment Batch Payment Documents
I_PH_SuplrCustJournalCube view left_outer COMPOSITE PH CAS Supplier Customer Journal Cube
I_RO_SAFTMatlDocHeader view_entity inner COMPOSITE RO SAFT Material Document Header
I_RO_SAFTPurchaseInvoice view from COMPOSITE RO SAFT Purchase Invoice
I_RO_SAFTSalesInvoice view from COMPOSITE RO SAFT Sales Invoice
I_RO_SAFTStkMovementHeader view from COMPOSITE Romania SAFT Stock Movement Header
I_SAFTAccountingHeader view from COMPOSITE SAF-T Accounting Header
I_WrntyClaimAccountingDocument view from BASIC Warranty Claim Accounting Document
P_ACCOUNTING_DOC view from COMPOSITE Accounting document
P_AR_LengthOfRefDoc view from COMPOSITE
P_Arbsitmopenitm view inner COMPOSITE
P_BillingDocProcFlow11 view inner CONSUMPTION
P_BillingDocProcFlow21 view inner CONSUMPTION
P_BillingDocProcFlowC11 view inner CONSUMPTION
P_BillingDocProcFlowC21 view inner CONSUMPTION
P_CanclnBillingDocProcFlow01 view inner CONSUMPTION
P_CanclnBillingDocProcFlow11 view inner CONSUMPTION
P_CreditMemoReqProcFlow21 view inner CONSUMPTION
P_CreditMemoReqProcFlow31 view inner CONSUMPTION
P_CustRetProcFlow21 view inner CONSUMPTION
P_CustRetProcFlow31 view inner CONSUMPTION
P_CustRetProcFlow41 view inner CONSUMPTION
P_DebitMemoReqProcFlow21 view inner CONSUMPTION
P_DebitMemoReqProcFlow31 view inner CONSUMPTION
P_DEFTAX_ITEM_2 view left_outer CONSUMPTION
P_DeltaOpenItem view inner CONSUMPTION
P_DeltaResidualOpenItem view inner CONSUMPTION
P_FCLM_BSEG_FLWLVL view_entity from BASIC Document item with flow level
P_GLOvwJrnlEntrItmToBeVerify01 view left_outer COMPOSITE
P_GLOvwJrnlEntrItmToBeVerify03 view from COMPOSITE
P_GLOvwJrnlEntrItmToBeVerify03 view union_all COMPOSITE
P_InitialOpenItem view inner CONSUMPTION
P_InitialResidualOpenItem view inner CONSUMPTION
P_JP_ARDocumentHeaderList view inner COMPOSITE
P_JP_CentralBkPaytWithItems view left_outer CONSUMPTION View for Japan Central Bank Payment Detail Items
P_JP_GRDocumentHeader view inner COMPOSITE
P_JP_IRDocumentHeader view inner COMPOSITE
P_Mpoduevenpay view inner COMPOSITE
P_PaymentRcptRelatedADocType view inner TRANSACTIONAL
P_PH_CASCashItem view inner COMPOSITE
P_PH_ClearingDocTaxInfo view left_outer COMPOSITE
P_PH_IsPaymentIndicator view inner COMPOSITE
P_PH_PaytClrdReceivablePyblItm view left_outer COMPOSITE
P_PH_PaytOpnReceivablePyblItm view inner COMPOSITE
P_PH_PRDocumentInfo view left_outer COMPOSITE
P_PL_SAFTTaxVATDeclnBasic view union CONSUMPTION
P_PT_DocItemPartner view inner CONSUMPTION View to select all partner and customer line item
P_PT_PAYORGON view left_outer COMPOSITE
P_RO_SAFTPurInvItem view inner CONSUMPTION
P_Ru_FinDocStructuralDivision2 view from CONSUMPTION
P_RU_FinStmAccountingDocument view from COMPOSITE
P_RU_VatSPLedgerImCD1 view from COMPOSITE
P_SalesContractProcessFlow31 view inner COMPOSITE Contract process flow level 3-1
P_SalesContractProcessFlow41 view inner COMPOSITE Contract process flow level 4-1
P_SalesContractProcessFlow50 view inner COMPOSITE Contract process flow level 5-0
P_SalesSchedgAgrmtProcFlow31 view inner CONSUMPTION
P_SalesSchedgAgrmtProcFlow32 view inner CONSUMPTION
P_SK_CABsetTaxItem view_entity left_outer COMPOSITE
P_SlsOrdProcFlow21 view inner CONSUMPTION
P_SlsOrdProcFlow31 view inner CONSUMPTION
P_SlsOrdProcFlow41 view inner CONSUMPTION
P_SlsQtanProcFlow31 view inner CONSUMPTION
P_SlsQtanProcFlow41 view inner CONSUMPTION
P_SOFAProcFlow21 view inner COMPOSITE
P_SOFAProcFlow31 view inner COMPOSITE
P_SOFAProcFlow41 view inner COMPOSITE
P_TR_StRpInputTaxItemLog view left_outer CONSUMPTION
P_TW_TaxItem view left_outer COMPOSITE
P_UpdatedOpenItem view inner CONSUMPTION
P_UpdatedResidualOpenItem view inner CONSUMPTION

Fields (34)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,SourceAccountingDocument,SubsequentDocument 41
KEY CompanyCode CompanyCode 39
KEY DocumentReferenceID AlternativeReferenceDocument,DocumentReferenceID,ExternalDocumentID,ExternalDocumentReferenceID 10
KEY FiscalYear FiscalYear,SourceFiscalYear 42
KEY PostingDate PaymentPostingDate,PostingDate 13
KEY TaxReportingDate TaxReportingDate 5
_AccountingDocumentType _AccountingDocumentType 1
AccountingDocCreatedByUser AccountingDocCreatedByUser,CreatedByUser 7
AccountingDocumentCategory AccountingDocumentCategory 3
AccountingDocumentCreationDate AccountingDocumentCreationDate,CreationDate,OpenItemCreationDate 18
AccountingDocumentHeaderText AccountingDocumentHeaderText 20
AccountingDocumentType AccountingDocumentType 13
CompanyCodeCurrency CompanyCodeCurrency 7
CreationTime CreationTime,OpenItemCreationTime 17
Currency Currency,StatisticsCurrency,TransactionCurrency 7
DocumentDate BillingDate,DocumentDate,InvoiceDate 10
ExchangeRate ExchangeRate 3
ExchangeRateDate ExchangeRateDate 2
FiscalPeriod FiscalPeriod 8
IsReversal IsReversal 2
IsReversed IsReversed 2
LastChangeDate LastChangeDate 8
Ledger Ledger 1
LedgerGroup LedgerGroup 1
OriginalReferenceDocument OriginalReferenceDocument 5
ParkingDate ParkingDate 1
ParkingTime ParkingTime 1
Reference1InDocumentHeader Reference1InDocumentHeader 3
Reference2InDocumentHeader Reference2InDocumentHeader 3
ReferenceDocumentType ReferenceDocumentType 1
ReversalReason ReversalReason 2
ReverseDocument ReverseDocument 3
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
TransactionCode TransactionCode 1

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.

-- Accounting Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACCOUNTINGDOCUMENT (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    DOCUMENTREFERENCEID,
    FISCALYEAR,
    POSTINGDATE,
    TAXREPORTINGDATE,
    _ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODECURRENCY,
    CREATIONTIME,
    CURRENCY,
    DOCUMENTDATE,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    FISCALPERIOD,
    ISREVERSAL,
    ISREVERSED,
    LASTCHANGEDATE,
    LEDGER,
    LEDGERGROUP,
    ORIGINALREFERENCEDOCUMENT,
    PARKINGDATE,
    PARKINGTIME,
    REFERENCE1INDOCUMENTHEADER,
    REFERENCE2INDOCUMENTHEADER,
    REFERENCEDOCUMENTTYPE,
    REVERSALREASON,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    TRANSACTIONCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, DOCUMENTREFERENCEID, FISCALYEAR, POSTINGDATE, TAXREPORTINGDATE)
);

Learn More