CDS Views for ACDOCA table

Overview

ACDOCA is a standard SAP S/4HANA table that stores Universal Journal Entry Line Items data. The following is a list of CDS Views for ACDOCA table.

A CDS view is a CDS entity that implements a view and is defined in a CDS data definition. They are defined for existing database tables, views, or other non-abstract CDS entities.

Using CDS views, you can rearrange and rename table fields to meet application-specific requirements. They are used to define rich semantic data models.

ACDOCA CDS Views

The following table gives you an overview of the released standard CDS views for ACDOCA table in S/4HANA 2020.

CDS View NameSQL View NameDescription
ACE_ACEPSOIT_ACDOCA_CHECK_02ACEV_ACDOCACHK2check ACEPSOIT against ACDOCA 02
ACE_ACDOCA_MIGACEV_ACDOCAMIGCompatibility view for ACEPSOIT
ACE_ACDOCA_REF_DOC_TOTAL_01ACEV_ACDOCAT1Calculate total amount for summarized case
FGL_BCF_HIST_PER0BCFV_HIST_PER0Current year's account (BS and RE)
FGL_BCF_HIST_PRFY_BSBCFV_PRFY_BSPrevious year's accounts(BS and RE)
FGL_BCF_HIST_PRFY_PLBCFV_PRFY_PLPrevious year's PL accounts
BH_ACDOCA_FOR_PRIMA_NOTABHACDFORPRIMNOTML quantity in ACDOCA for prima nota
E_JOURNALENTRYITEMEFIJOURNALENTITInclude View for Journal Entry Item
FAA_ANEA1FAAV_ANEA1Internal: Summarize on SLALITTYPE Level
FAA_ANEKFAAV_ANEKCompatibility View for Table ANEK
FAA_ANEK_ADD_ANFAAV_ANEK_ADD_ANInternal: Determination of Additional Fields for ANLN1
FAA_ANEK_ADD_GRFAAV_ANEK_ADD_GRInternal: Determination of Additional Fields for ANLGR
FAAV_ANEK_BZDATFAAV_ANEK_BZDATDetermination of Field BZDAT for ANLN1
FAAV_ANEK_BZDAT_GRFAAV_ANEK_BZD_GRDetermination of Field BZDAT for ANLN1
FAA_ANEK_MSL_ANFAAV_ANEK_MSL_ANInternal: To determine quantity for ANLN1
FAA_ANEK_MSL_GRFAAV_ANEK_MSL_GRInternal: This view is to determine quantity for ANLGR
FAAV_ANEK_MWSKZFAAV_ANEK_MWSKZInternal: Determination of MWSKZ
FAAV_ANEK_MWSKZ_GRFAAV_ANEK_MWS_GRInternal: Determination of MWSKZ
FAAV_ANEK_PAROB1FAAV_ANEK_PAROB1Determination of Field PAROB1
FAAV_ANEK_PAROB1_GRFAAV_ANEK_PAR_GRDetermination of Field PAROB1
FAAV_ANEK_SBUSAFAAV_ANEK_SBUSAInternal: Determination of PARGB for ANLN1
FAAV_ANEK_SBUSA_GRFAAV_ANEK_SBU_GRInternal: Determination of PARGB for ANLN1
FAAV_ANEK_SGTXTFAAV_ANEK_SGTXTInternal: Determination of PARGB for ANLN1
FAAV_ANEK_SGTXT_GRFAAV_ANEK_SGT_GRInternal: Determination of PARGB for ANLN1
FAAV_ANEK_ZUONRFAAV_ANEK_ZUONRDetermination of Field ZUONR for ANLN1
FAAV_ANEK_ZUONR_GRFAAV_ANEK_ZUO_GRDetermination of Field ZUONR for ANLN1
FAA_ANEP1FAAV_ANEP1Internal: Summarize on SLALITTYPE Level
FAA_ANLC1_ADOCFAAV_ANLC1_ADOCFAA_ANLC1_ADOC ( Internal View )
FAA_ANLC1_P_ADOCFAAV_ANLC1_PADOCFAA_ANLC1_ADOC ( Internal View )
FAA_ANLC_AFBLPE_POPFAAV_ANLC_POPCondense poper information for ANLC-AFBLPE
FAA_ANLP1FAAV_ANLP1Internal: Summarize on SLALITTYPE Level
FAA_ANLP_KOSTLFAAV_ANLP_KOSTLDetermine KOSTL for ANLP records
FAA_ANLP_POPERFAAV_ANLP_POPERInternal:
FAA_LINEITEMSFAAV_LINEITEMS
FAA_PLAN_VALUESFAAV_PLAN_VALUESPlanned and Posted Values per Asset and Value Type
FAA_SIL_AWKEYFAAV_SIL_AWKEYFixed Asset Value Information - Handled By Asset Accounting
FAC_ACDOCAFACFIACDOCAReuse View for ACDOCA
FACVD_RJET_WLI_07FACV_RJET_WLI_07Creating sums of amounts from acdoca
FAC_DART_Z3_JOURNALENTRYITEMFAC_DZJOURNALIMInclude View for Journal Entry Item
FCO_ABR_BEL04_AFCOV_ABRBEL04ASettlement actual costs
FCO_ABR_BEL_LD_AFCOV_ABRBELLDASettlement actual costs per ledger
FCO_ABR_BEL_04_AFCOV_ABR_BEL_04ASettlement actual costs
FCOV_ARCCOAFCOV_ARCCOAAnalyse ACDOCA for CO-Archiving / Aging
FCO_AVC_PS_AGGRFCOV_AVC_PS_AGGRAvaily Ctrl for PS: ACDOCA Aggregation
FCO_MIG_CHECK_COEP11_L1FCOV_CHECK4_L1Check ACDOCA-records against COEP-records with WRTTP=11
FCO_COR_HSL_PREFCOV_COR_HSL_PRE.
FCO_MIG_ACDOCAFCOV_MIG_ACDOCA.
FGL_BCF_ANFGLV_BCF_ANBalance Carry Forward Analyze
FGL_BCF_BSFGLV_BCF_BSBalance Carry Forward: Balance Sheet
FGL_BCF_MIGFGLV_BCF_MIGEnrichment of Balances based on Open Items
FGL_BCF_PER0FGLV_BCF_PER0FGL_BCF_PER0
FGL_BCF_PLFGLV_BCF_PLBalance Carry Forward - Profit and Loss
FGL_BCF_PRFYFGLV_BCF_PRFYFGL_BCF_PRFY
FGL_BCF_PROTFGLV_BCF_PROTBalance Carry Forward: Protocol
FGL_GLSI_ACDFGLV_GLSI_ACDDDL source of the view FGLV_GLSI_ACD
FGL_MAP_AMOUNTFGLV_MAP_AMOUNTMap Amount Fields from Source ACDOCA to Target ACDOCA
FGL_MIG_ACDFGLV_MIG_ACDGL Delta Entries - Lines Items (Customer Fields Mapping)
FGL_MIG_SOURCE_DFGLV_MIG_SOURCEDDetermination of FI-GL Source Table for Aggregates
FGL_SIL_DOCFGLV_SIL_DOCSIL: New documents in a target ledger
FGL_SIL_OIFGLV_SIL_OISIL: Work List of Open Items, non-ledger-group-specific
FGL_SIL_RP_BASEFGLV_SIL_RP_BASESIL: Reposting Work List, Base
FGL_SIL_WLFGLV_SIL_WLSIL: Reposted documents
FINOC_ACDOCA_BUZEIFINOCV_AC_BUZEIOrganizational Change: Unique BUZEI of ACDOCA
FINOC_TRANSFER_APARFINOCV_APAROrganization Change: Transfer for AP/AR items
FINS_REV_REC_ACDOCA_BALANCEFINSRR_ACDOCABALAcdoca balance for introducing a new accounting principle
FINS_REV_REC_COSACT_VIEW1A_BASFINSRR_COSACT1ABActuals for data with CO objects
FINS_REV_REC_FLOWFINSRR_FLOWFlow of documents
FINS_REV_REC_FLOW1FINSRR_FLOW1Flow of documents
FINS_REV_REC_FLOW2FINSRR_FLOW2Flow of documents
FINS_REV_REC_POSID_RECONFINSRR_PSRECONSearch for changed PS_POSID in ACDOCA
FINS_IC_SPL_ACD_0FINSV_IC_ACD_0IC: Selection of existing UJ line items
FINS_IC_SPL_ACD_1FINSV_IC_ACD_1IC: Selection of UJ line items
FINS_IC_SPL_ACD_3FINSV_IC_ACD_3IC: Selection of UJ line items
FINS_IC_CONV_DATEFINSV_IC_CONV_DIC: Conversion dates for ACDOCA entries
FINS_IC_JE_PARTFINSV_IC_JE_PARTIC: Correction of split line items
FINS_IC_SPL_LDFINSV_IC_SPL_LDIC: Split line items with ledger
FINS_SIF_ACDOCAFINSV_SIF_ACDOCAACDOCA wrapper
FINS_ACDOCA_LINES_BASEFINS_ADC_LBBase view for number of document items
FINS_REV_REC_COS_ACTUAL_VIEWMTFINS_RRCOS_ACTMTActuals for data with CO objects
FINS_REV_REC_ACDOCA_VIEWFINS_RR_ACDOCAView on ACDOCA
FINS_REV_REC_ACDOCA_APIFINS_RR_ACDOCAPIView on ACDOCA for new project invoicing API
FINS_REV_REC_AW_INFOFINS_RR_AWINFInfo for AWREF
FINS_REV_REC_COS_ACT_DIST_REFFINS_RR_CDISREFDistinct AWREF for data with CO objects
FINS_REV_REC_CONS_CHECK_VIEWFINS_RR_CONS_CHKConsistency check of ACDOCA items
FINS_REV_REC_COSACT_VIEW1_BASFINS_RR_COSACT1BActuals for data with CO objects
FINS_REV_REC_COSACT_VIEW2_BASFINS_RR_COSACT2BActuals for data with CO objects
FINS_REV_REC_COSACT_VIEW3_BASFINS_RR_COSACT3BActuals for data with CO objects
FINS_REV_REC_COSACT_VIEW4_BASFINS_RR_COSACT4BActuals for data with CO objects
FINS_REV_REC_COS_ACT_VIEWA_BASFINS_RR_COSACTABActuals for data with CO objects
FINS_REV_REC_COSACT_VIEW_BASFINS_RR_COS_ACTBActuals for data with CO objects
FINS_REV_REC_DATA_VIEW1A_BASEFINS_RR_DATA1ABData of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW1_BASEFINS_RR_DATA1BData of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW2_BASEFINS_RR_DATA2BData of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW2CFINS_RR_DATA2CContract data of trans. based rev.recog. cumulative process.
FINS_REV_REC_DATA_VIEW3_BASEFINS_RR_DATA3BData of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEWA_BASEFINS_RR_DATAABData of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEW_BASEFINS_RR_DATABData of trans. based revenue recog. for cumulative process.
FINS_REV_REC_DATA_VIEWDFINS_RR_DATADData of trans. based revenue recog. for cumulative process.
FINS_REV_REC_OTHER_VIEW1A_BASEFINS_RR_OTHER1ABOther data for cumulative process.
FINS_REV_REC_OTHER_VIEW_BASEFINS_RR_OTHERBOther data for cumulative process.
FINS_REV_REC_PRCTR_REORG_BASEFINS_RR_PRCREO_BData trans. based revenue recog. for profit center reorg.
FINS_REV_REC_TOTAL_REVENUEFINS_RR_REVENUETotal revenue
FINS_REV_REC_UPRCTR_VIEWFINS_RR_UPRCTRpernr - origin prctr
FISVD_TRK_DOC_03FISCDSTRKDOC03Change History Line Item non-leading Ledger
FISVD_FYEARFISV_FYEARFiscal Years with posting in CompanyCode/Ledger
FISVD_GL_DOCNR_GAP_BASEFISV_GLGAPBASEBase Data from ACDOCA
FISVD_GLLIT_01FISV_GLLIT_01Faglflexa , Bseg , Bkpf
FISVD_GLLIT_04FISV_GLLIT_04GL Line Items
FISVD_GLLIT_05FISV_GLLIT_05FISVD_GLLIT_05
FISVD_LIT_BCF_1FISV_LIT_BCF_1GL LineItem: only Balance Carry Forward Items
FMLV_ACDOCA_PACKAGE_IDFMLV_A_PACK_IDRead ML-package ID from ACDOCA
FML_MIG_BCF_OL_L1FMLV_BCF_OL_L1ML-Migration: Balance Carryforward for other Ledgers
FML_MIG_CHECK1_L1FMLV_CHECK1_L1Material Ledger: Compare migrated data vs. CKMLCR - part 1
FML_MIG_CHECK2_L1FMLV_CHECK2_L1Material Ledger: Compare migrated data vs. CKMLPP - part 1
FML_MIG_CHECK3_L1FMLV_CHECK3_L1Inventory Stock: Compare migrated data vs. MBEW... - part 1
FML_INV_BASEFMLV_INV_BASEMaterial Valuation - Totals of ACDOCA Items
FML_INV_BCF_OL_L1FMLV_INV_BCF_OL1Material Valuation - Inventory Stock: BCF for other Ledgers
FML_MIG_BASEFMLV_MIG_BASEML Delta Entries - Aggregates of Lines Items
F_MMIM_ACDOCA_ELEFMMIMACDOCAELERead Universal Journal Entry Line Items
FMUSFGA_FROM_ACDOCA_CCFWDFMUSFGA_ACDOCCVLedger 95 data from ACDOCA for correction/close postings
FMUSFGA_COMPATFMUSFGA_COMPAT_VCompatibility view for FMUSFGA replace with ACDOCA
FMUSFGT_GTAS_UNIONFMUSFGT_GTAS_UVLedger 95 totals with all attributes
FMUSFGT_UNIONFMUSFGT_UNION_VCompatibility view for FMUSFGT replace with ACDOCA
GLE_ADB_KFC_ACCDOC_ITEMGLE_ADB_KFC_ITEMAverage Daily Balances - Key Figure Calculation Line Items
CLOSING_OPERATIONS_GRIR_ITEMSGRIRBSEGGR/IR Items
ICA_CONSJOURNALENTRIESICACONSJESICA: Consolidation Journal Entry Line Items
ICA_CONSJOURNALENTRIES_2ICACONSJES2ICA: Consolidation Journal Entry Line Items
ICA_GENJOURNALENTRIESICAGENJESICA: Universal Journal Entry Line Items for OP
ICA_GENJOURNALENTRIES_2ICAGENJES2ICA: Universal Journal Entry Line Items for OP
ICA_GENJOURNALENTRIES_CICAGENJESCICA: Universal Journal Entry Line Items for Cloud
ICA_GENJOURNALENTRIES_C2ICAGENJESC2ICA: Universal Journal Entry Line Items for Cloud
I_FXDASTACTUALLINEITEMIFASSETACTUALLITActual Line Items of Fixed Asset
I_PREPAYMENTPOSTEDDOCACCIPPMTACDOCPrepayment Posted Document - Accounting
I_ACMSETTLMTACCTGDATAISTTLACCTDATABasic view for Accounting Data
KKAG_ACDOCA_VIEWKKAGACDOCAAcdoca View
KKAG_ACDOCA1_VIEWKKAGACDOCA1ACDOCA view cost element assignment only
KKAG_COS_ITEM_VIEWKKAG_COS_ITEMItemized view for RA relevant input data
MMIM_MATDOCACCOUNTINGMMIMMATDOCACCAccounting Documents for Material Document
MMIM_MATDOCACCDOCFLOWMMIMMDOCACCFLOWMaterial Documents Document Flow Accounting
MMIM_MATDOCFLOWSTATUSAMMIMMDOCFLWSTATADocument Flow Status Accounting
P_ACCRUALLINEITEMPACELINEITMAccrual Line Item
P_ADDLLEDGERACCTDOCITEMHISTORYPADLEDITEMTRKDOCChange History Line Item non-leading Ledger
P_ANALYZEACCRUALPOSTINGPANALACCRPOSTGAnalyze Accrual Postings
P_ECMCA_CTR_01PECMCACTR01Get customer/vendor country per document
P_ACDOCAPFIACDOCAPrivate view on ACDOCA without logic
P_ACDOCA_COMPFIACDOCACOMP_ACDOCA_COM
P_COACTUALLINEITEMPFICOACTULITEMPrivate view for CO Actual Line Items
P_ACCRUALOBJECTJOURNALENTRYPFIDOCGet journal entries which is related to accrual objects
P_EBWOBJECTACTUALCOSTSPFIEBWOBJACTCOSTOrder Actual Cost For WIP
P_EBWOBJECTWIPRESERVESPFIEBWOBJWIPRSRVOrder Actual Cost For WIP
P_FINS_GL_DOCUMENT_AMOUNTSPFINSGLDOCAMTAmounts per Currency Type of a G/L Document
P_FINS_GL_OPENITEM_AMOUNTPFINSGLOIAMTGL Manual Clearing Worklist Item
P_FINS_GL_OPENITEMSPFINSGLOPENITEMSGL Open Items select to clearing
P_RTPCORDERACTLCSTFORSTTLLDPFIRTPCORACFSLDRTPC Order Actual Cost For Settlement with Parallel Ledgers
P_RTPCORDERACTUALCOSTPFIRTPCORACTCOSTRTPC Order Actual Cost
P_RTPCORDERACTLCOSTFORSETTLMTPFIRTPCORDACFSRTPC Order Actual Cost For Settlement
P_RTPCORDERACTLCOSTFORSTTLLDPFIRTPCORDACFSLDRTPC Order Actual Cost For Settlement with Parallel Ledgers
P_RTPCORDERDISTRIBUTEDCOSTPFIRTPCORDDPCOSTRTPC Order Distributed Cost
P_RTPCORDERSETTCOSTFORREVPFIRTPCORDSCFRRTPC Order Actual Cost For Settlement
P_RTPCORDERSETTCOSTFORREVLDPFIRTPCORDSCFRLDRTPC Order Settled Cost For Reversal with Parallel Ledgers
P_RTPCORDERFXDPRICEPRDDLVVALUEPFIRTPCORFXPRDLVRTPC Order Fixed-Price Products Delivered Value
P_RTPCORDERPOSTEDVARIANCEPFIRTPCORPOVARCRTPC Order Posted Variance
P_RTPCORDERSETTCSTFORREVLDPFIRTPCORSCFRLDRTPC Order Settled Cost For Reversal with Parallel Ledgers
P_RTPCORDERWIPRESERVEPFIRTPCORWIPRSRVRTPC Order WIP Reserve
P_FOUNDATIONAPFOUNDATIONAConsolidation Foundation View of ACDOCA
P_PURCHASEORDACCRFORTRAININGPPOACTRAINAccrual Objects for Machine Learning Training
P_REPORTEDFINANCIALDATA_RTPREPFINDRTReported Financial Data for Real-time Units
P_REALTIMEMFGORDBALANCEPRTMOBALANCEEvent-based Order Balance
P_REALTIMEMFGORDINSPPOSTEDRSRVPRTMOINSPPSTRSRVPrivate view of Event based Posted Reserves in Inspector
P_REALTIMEMFGORDINSPPOSTEDVARCPRTMOINSPPSTVARCPrivate view of Event based Posted Variance in Inspector
P_REALTIMEMFGORDINSPPOSTEDWIPPRTMOINSPPSTWIPPrivate view of Event based Posted WIP in Inspector
P_REALTIMEMFGORDERRESERVEPRTMORSRVEvent-based Order Reserves
P_REALTIMEMFGORDERWIPPRTMOWIPEvent-based Order WIP
P_REALTIMEMFGORDWIPRLVTACTCOSTPRTMOWIPRELACTEvent-based Order WIP Relevant Actual Cost
P_ACDOC_RECLASSIFIED_ITP_ACDOCRECLASSIT
P_FCT_READ_OPEN_ITEMSP_FCT_READ_OISelect Open Items from ACDOCA
P_FSTMT_ACDOC_ITEMSP_FSTMTACDOC_ITM
P_FSTMT_ACDOC_OIP_FSTMTACDOC_OI
V_ACDOCT_PER_DDLV_ACDOCT_PERPeriod sums of ACDOCA without period block
V_COEPACDOCA_AGEV_COEPACDOCA_AGECold data fom ACDOCA (only value type 04)
V_COEP_EXT_ACDOCAV_COEPEXT_ACDOCAMapping from ACDOCA to COEP_EXT
V_COEPXT_ACDOCAVV_COEPXT_ACDOCAVMapping from ACDOCA to COEP_EXT with Version
V_COEP_ACDOCA_DDLV_COEP_ACDOCAMapping from ACDOCA to COEP
V_COEP_ACDOCA_CT1V_COEP_ACDOCACT1Mapping of ACDOCA to COEP-fields - revised version - part 1
V_COEP_ACDOCA_R1V_COEP_ACDOCA_R1Mapping of ACDOCA to COEP-fields - revised version - part 1
V_COEP_SASCBV_COEP_SASCB
V_COSP_DELTA_AS_COEPV_COSP_D2_COEPCOSP Difference from Migration as COEP - BSTAT=C
V_COSP_D_AS_COEP_AGEV_COSP_D_AGETotals - Migration Deltas for Aging
V_COSP_EP_ARCH_L1V_COSP_EPA_L1COSP rebuild from archived COEP records - part 1
V_COSP_KSII_1V_COSP_KSII_1COSP for TA KSII, WRTTP=04 only
V_COSP_LVP_1V_COSP_LVP_1COSX with delta versions (parallel valuation/COGM) - part 1
V_COSP_PER_1V_COSP_PER_1COSP with delta versions (parallel valuation/COGM) - part 1
V_COSP_R_8V_COSP_R_8CO Object: Cost Totals for External Postings ("Rev.") Part 8
V_COSP_WDV_1V_COSP_WDV_1COSP with delta versions (parallel valuation/COGM) - part 1
V_COSS4W09_1V_COSS4W09_1COSP with delta versions (parallel valuation/COGM) - part 1
V_COSS_DELTA_AS_COEPV_COSS_D2_COEPCOSS Difference from Migration as COEP - BSTAT=C
V_COSS_D_AS_COEP_AGEV_COSS_D_AGECold Data: Totals - Migrated Deltas (secondary)
V_COSS_EP_ARCH_L1V_COSS_EPA_L1Rebuild COSS from archived COEP records - part 1
V_COSS_KSII_1V_COSS_KSII_1COSS for TA KSII, WRTTP=04 only
V_COSS_LVP_1V_COSS_LVP_1COSX with delta versions (parallel valuation/COGM) - part 1
V_COSS_PER_1V_COSS_PER_1COSP with delta versions (parallel valuation/COGM) - part 1
V_COSS_R_8V_COSS_R_8CO Object: Cost Totals for Internal Postings ("Rev.") Part 8
V_COSS_W11_1V_COSS_W11_1COSS for WRTTP=11 only
V_COSS_WDV_1V_COSS_WDV_1COSS with delta versions (parallel valuation/COGM) - part 1
V_COSS_X_PER_1V_COSS_X_PER1COSP with delta versions (parallel valuation/COGM) - part 1
V_COSX_ACDOCAV_COSX_ACDOCACOSP with delta versions (parallel valuation/COGM) - part 1
V_COSX_LVP_1V_COSX_LVP_1COSX with delta versions (parallel valuation/COGM) - part 1