CDS Views for Fiori UI for Accounts Receivable (FI-FIO-AR)

CDS View NameDescriptionSQL View Name
C_APARINTERESTDOCUMENTInterest RunCAPARINTDOC
C_APARINTERESTDOCUMENTITEMInterest Run ItemCAPARINTDOCITEM
C_APARINTERESTJRNLENTRYITMJournal Entry Item Subject to InterestCAPARJORNLITM
C_ARBANKSTATEMENTManage Bank StatementCARBANKSTMNT
C_ARBANKSTATEMENTITEMManage Bank Statement ItemsCBANKSTMNTITEM
C_ARBANKSTATEMENTITMUPLOADConsumption CDS for Excel Upload Template Generation MBSCBANKSTMNTITUP
C_ARLOCKBOXBATCHManage Lockbox BatchCARLOCKBOXBATCH
C_ARLOCKBOXBATCHITEMLockbox Batch ItemCARLOCKBOXITEM
C_ARPOSTGRULEACTNAPARPosting Rule APAR Action ConsumptionCARPOSTRLAAPARTP
C_ARPOSTGRULEACTNGLPosting Rule Action ConsumptionCARPOSTRLAGLTP
C_ARPOSTGRULEACTNPAYTCATTPPosting Rule Allocation Sequence ActnCARPOSTRLAPCTP
C_ARPOSTGRULEINTERIMPOSTINGPosting Rule Interim Posting ConsumptionCARPOSTRLINTPST
C_ARPOSTGRULEPAYTCATPARAMAllocation Algorithm Parameters ConsumptionCARPAYTCATPARAM
C_ARPOSTINGRULEPosting Rule Root ConsumptionCARPOSTRLTP
C_ARPOSTINGRULECONDITIONPosting Rule Condition ConsumptionCARPOSTRLCTP
C_ARPOSTINGRULEKPIPosting Rule - KPI ConsumptionCARPOSTRLKPI
C_DUNNINGAREAConsumes I_DunningAreaCDUNAREA
E_ARBANKSTATEMENTExtension View for Bank Statement HeaderEARBANKSTMTEXT
E_ARBANKSTATEMENTITEMExtension View for Bank Statement ItemEARBANKSTMITMEXT
FARVD_BS_IT_FEBEPEnriched view on Febep for GL-PositingFEBEP_ENR
FARVD_BS_IT_GL_ML_RULESView for GL-Positing extraction for proposal of rulesGL_ML_RULES
FARVD_BS_IT_GL_POSTINGSEnriched view on FEBEP for GL-PostingsGL_POSTINGS
FDM_BSTAT_RANGEbstat rangeFDM_BSTAT_RANGE
FDM_COBJ_COUNTCollections Management Attributes with FIN KeysFDM_COBJ_COUNT
FDM_COLL_DISPCDS View for Open Clarification Cases (Process Receivable)FDM_COLL_PR_DISP
FDM_COLL_INVOICESCDS View instead of function module ...invoices_readFDM_COLL_INV_CDS
FDM_COLL_INV_HELPEROpen Invoices with BOR KeyFDM_COLL_INV_H
FDM_COLL_P2PCDS View for Promise to Pay (Process Receivable)FDM_COLL_PR_P2P
FDM_COLL_P2PSTATETTexts for Status of Promise to PayFDM_P2PSTATET
FDM_COLL_RSMCDS View for Open ResubmissionsFDM_COLL_PR_RSM
FDM_COLL_TAXTest TaxFDM_COLL_TAX
FDM_COUNT_SGLStestFDM_COUNT_SGLS
FDM_CUR_REF2FDM_CUR_REF2
FDM_DCOBJ_COUNTCollections Management Attributes with FIN KeysFDM_DCOBJ_COUNT
FDM_FLTP_INVOICESCDS View instead of Function Module ...invoices_readFDM_FLTP_INV_CDS
FDM_INV_REF2Open Invoices and References to InvoicesFDM_INV_REF2
FDM_INV_SUMSummation of Payments to InvoicesFDM_INV_SUM
FDM_MAX_DATELatest Date of Document EntryFDM_MAX_DATE
FDM_PAY_SUM2Summation of Payments to InvoicesFDM_PAY_SUM2
FDM_REF_REF2FDM_REF_REF2
FDM_TAX_SUMSummation of Payments to InvoicesFDM_TAX_SUM
FIN_ATTR_KEYp2p_attr with Invoice KeyP2P_ATTR_KEY
FIN_CLEARINGSp2p_attr with Invoice KeyFIN_CLEARINGS
FIN_DISCOUNTSp2p_attr with Invoice KeyFIN_DISCOUNTS
I_ALLOCATIONALGORITHMFXDVALBasic View for Allocation Algorithm Fixed ValueIALLOCFXDVAL
I_ALLOCATIONALGORITHMFXDVALTXTBasic View for Allocation Algorithm Fixed Value TextIALLOCFXDVALTXT
I_ALLOCATIONALGORITHMFXDVALVHValue Help for Allocation Algorithm Fixed ValueIALLOCFXDVALVH
I_ARBANKSTATEMENTITEMTPBank Statement Item BO active and draftIBANKSTMTITEMTP
I_ARBANKSTATEMENTITMUPLOADInterface CDS for Excel Upload Template Generation MBSIBANKSTMNTITUP
I_ARBANKSTATEMENTPOSTINGDATEGet BS posting date from ItemsIBSPOSTDATE
I_ARBANKSTATEMENTSTATUSInterface view for Bank Statement status descriptionIBANKSTMTSTATUS
I_ARBANKSTATEMENTTPBank Statement BO active and draftIBANKSTMTTP
I_ARLOCKBOXLockboxes at our House BanksIARLOCKBOX
I_ARLOCKBOXBATCHLock Box Batch Header DataIARLOCKBOXBATCH
I_ARLOCKBOXBATCHITEMLockbox Batch Item DataIARLOCKBOXITEM
I_ARLOCKBOXSTDVHLockboxes at our House BanksIARLOCKBOX__VH
I_ARMANUALTRANSACTIONVHManual Transaction for Bank StatementsIARMANUALTRANSVH
I_ARPOSTGRULEACTNAPARTPPosting Rule - APAR ActionIARPSTRLAAPARTP
I_ARPOSTGRULEACTNGLTPPosting Rule ActionIARPSTRLAGLTP
I_ARPOSTGRULEACTNPAYTCATTPPosting Rule - Allocation Sequence ActnIARPSTRLAPCTP
I_ARPOSTGRULECNDNATTRIBBasic view for Condition Attribute Value HelpIARPCA
I_ARPOSTGRULECNDNATTRIBTXTBasic view for Condition Attribute Value Help TextIARPCATXT
I_ARPOSTGRULECNDNATTRIBVHCondition Attribute Value HelpIARPCAVH
I_ARPOSTGRULECNDNOPTIONBasic view for Option Value HelpIAROCA
I_ARPOSTGRULECNDNOPTIONVHOption Attribute Value HelpIARPCOVH
I_ARPOSTGRULECNDNOPTTEXTBasic view for Condition Option VH TextIARPCOTEXT
I_ARPOSTGRULEINTERIMPOSTINGPosting Rule - Interim PostingIARPOSTRLINTPST
I_ARPOSTGRULEORIGINATINGTMPLPosting Rule Originating TemplatesIARPOSTRLORTMPL
I_ARPOSTGRULEPAYTCATPARAMTPParameters of Analyze As AlgorithmIARPRPTCATPARTP
I_ARPOSTGRULEPAYTTRANSCATVHValue Help for Payment Transaction CatIARPPAYTCATVH
I_ARPOSTINGRULEBasic view for Posting RuleIARPOSTRULE
I_ARPOSTINGRULECONDITIONTPPosting Rule ConditionIARPOSTRLCTP
I_ARPOSTINGRULEKPIPosting Rule - KPIIARPOSTRLKPI
I_ARPOSTINGRULETPPosting Rule RootIARPOSTRLTP
I_ARPOSTINGRULEUSERTPPosting Rule UserIARPOSTRLUTP
I_BANKSTATEMENTVHValue Help view for Bank StatementsIBANKSTATEMENTVH
I_BANKSTMNTSTSTEXTInterface view for Bank Statement status descriptionIBSTMTSTATTXT
I_OUTGOINGINCOMINGPAYTCODETEXTOutgoing and Incoming Payment TextIOUTINCPAYMENT
I_PAYMENTCLEARINGGROUPBasic view for Payment Clearing GroupsIPAYCLRGRP
I_PAYMENTCLEARINGGROUPTEXTBasic view for Payment Clearing Grp TxtIPAYCLRGRPTXT
I_PAYMENTCLEARINGGROUPVHValue Help for Payment Clearing GroupsIPAYCLRGRPVH
I_PAYMENTEXTERNALTRANSACTYPEPayment External Transaction TypeIBANKSTMTVGEXT
I_PAYMENTTRANSACTIONTYPEGROUPPayment Transaction Type GroupIBANKSTMTVGTYP
I_PAYMENTTRANSACTIONTYPEGROUPTPayment Transaction Type Group TextIBANKSTMTVGTYPT
I_POSTGRULELIFECYCLESTATUSTXTReprocessing Rules Lifecycle Status TextIPRLIFECYCSTATUS
I_REPROCESSINGRULEVHValue Help for Reprocessing RuleIREPROCRLVH
I_REPROCGRULEPOSTGPROCEDTYPETBasic view for Reprocessing Rule Posting Procedure Type TextIPSTNGPROCTYPET
P_ARBANKSTATEMENTITMUPLOADCDS View for Excel Upload Template Generation MBSPBANKSTMNTITUP
P_ARBANKSTATEMENTJOBReturns the kukey with the corresponding job name and statusPBANKSTMTJB
P_ARBANKSTATEMENTPOSTINGDATEPrivate view between I_Arbankstatementpostingdate and FEBEPPBSPOSTDATE
P_ARBANKTRANSACDOCITMCNTCount of Bank Transaction Document ItemsPARBTDTDITCNT
P_ARLOCKBOXBATCHLock Box Batch Header DataPARLOCKBOXBATCH
P_ARLOCKBOXBATCHITEMLockbox Batch Item Details AggegationPARLOCKBOXITEM
P_ARLOCKBOXBATCHITEMAGGRLockbox Batch Item Details AggegationPARLOCKBOXITMAGR
P_ARLOCKBOXBATCHLATESTLatest lockbox BatchesPARLCKBOXBTCHLST
P_ARLOCKBOXFILE_BO_BATCHAccess for LockboxFile BO Batch NodePFFOLBFBATCH
P_ARLOCKBOXFILE_BO_BATCH_TOTALAccess for LockboxFile BO Batch Total NodePFFOLBFBTCHT
P_ARLOCKBOXFILE_BO_CHECKAccess for LockboxFile BO Check NodePFFOLBFCHECK
P_ARLOCKBOXFILE_BO_REFERENCEAccess for LockboxFile BO Reference NodePFFOLBFREFERENCE
P_ARLOCKBOXFILE_BO_ROOTAccess for LockboxFile BO Root NodePFFOLBFROOT
P_ARLOCKBOXFILE_BO_ROOT_TOTALAccess for LockboxFile BO Root Total NodePFFOLBFRTTTL
P_ARLOCKBOXFILE_BO_SERVICEAccess for LockboxFile BO Service NodePFFOLBFSERVICE
P_ARLOCKBOXFILE_BO_TRAILERAccess for LockboxFile BO Trailer NodePFFOLBFTRAILER
P_ARPOSTGRULESOURCETMPLDISTDistinct selection of Soure TemplatePARPSTRLSCTPLDIS
P_ARPOSTINGRULEKPINEWESTNewest Reprocessing Rule KPIPARPOSTRLNKPI
P_BSEG_GL_POSTINGSBSEG Posting to GL AccountPBSEGGLPOST
P_COCOBKSTMNTRULEPROPOSALVHCompany Code selectable for BS Rule Proposal JobsPCCBKSTMNTPOPVH
P_GLACCOUNTTEXTView for GL account descriptionsPGLACCOUNT
P_GLACCOUNT_HIST_EXTRACTIONCDS view for historic data extractionP_GL_HIST
P_HIST_ARBANKTRANSACTIONFetch the Header Detals from FEBKOPHISTARBKTRANS
P_HIST_ARBANKTRANSACTIONITEMHistorical Bank Transaction item for rule proposalPHISTARBNKSTITEM
P_HIST_CONDITION_COUNTHistorical condition and countP_HISTCONDCNT
P_HIST_GLACC_CONDITION_COUNTHistorical GL Account with corresponding condition and countP_HISTGLCONDCNT
P_HIST_MEMOLINE_WITH_CONDITIONHistorical Memoline with condition and GL AccountP_HISTMEMOCOND
P_POSTINGPROCEDURETYPEData retrival for posting procedure TypePPSTNGPROCTYPE
P_POSTINGPROCEDURETYPEVHValue help for posting procedure typePPSTNGPROCTYPEVH
P_POSTINGPROCEDURETYPEVHTText for posting procedure typePPSTNGPROCTYPET
P_POSTING_RULES_PAYT_TRANS_CATFARVD_BS_IT_03 View, left join of feb_tatyp and feb_tatyp_cPPRPAYTRANCAT
P_PROPOSE_MEMOLINE_WITH_ORIGMemoline & ORIG for porpose rulePPROPMEMEMOLI
R_APARINTERESTDOCUMENTTPTransactional Layer of Interest RunAPARINTDOCTP
SHSM_FAP_SUPPLIERValue-Help for SuppliersSHSMFAPSUP
SHSM_FAP_SUPPLIER_COMPANYValue-Help for Suppliers in Company CodeSHSMFAPSUPCC
SHSM_FAR_CUSTOMERValue-Help for CustomersSHSMFARCUST
SHSM_FAR_CUSTOMER_COMPANYValue-Help for Customers in Company CodeSHSMFARCUSTCC
SHSM_UDM_CONTACT_PERSValue-Help for Customer ContactsSHSMUDMCONTACT
UDM_ATTR_KEYCollections Management Attributes with FIN KeysUDM_ATTR_KEY
UDM_ATTR_KEY2Collections Management Attributes with FIN KeysUDM_ATTR_KEY2

Other CDS Views