CDS Views for Loans Management (FS-CML)

CDS View NameDescriptionSQL View Name
I_BPCAPITALIZATIONWTHDFLTCapitalization data for Business Partner with defaultingIBPCAPTIWTDEF
I_BPDEFRLWTHDFLTDeferral data for Business Partner with defaultingIBPDEFERRALWTDEF
I_BPINTRSTONARREARSWTHDFLTInterest on Arrears for Business Partner with defaultingIBPIOAWTDEF
I_BPPAYOFFWTHDFLTPayoff data for Business Partner with defaultingIBPPAYOFFWTDEF
I_BPWRITEOFFWTHDFLTWriteoff data for Business Partner with defaultingIBPWRITEOFFWTDEF
I_BPWVRWTHDFLTWaiver data for Business Partner with defaultingIBPWAIVERWTDEF
I_BUSINESSPARTNERINCOMEBusiness Partner income weighted averageIBUSPARTWTAVGINC
I_BUSINESSPARTNERINCOMEWTHDFLTBusiness Partner income weighted average with defaultingIBPAVGINCWTHDFLT
I_LOANARCHIVINGCATEGORYLoan Archiving CategoryILARCAT
I_LOANARCHIVINGCATEGORYTEXTLoan Archiving Category - TextILARCATTXT
I_LOANASSIGNMENTCREDITORLoan Assignment CreditorILASSGNCREDTR
I_LOANASSIGNMENTCREDITORTEXTLoan Assignment Creditor - TextILASSGNCREDTRTXT
I_LOANBPGROUPINGGrouping procedure details for Business PartnerILCBPGROUPPROC
I_LOANBRANCHOFFICELoan Branch OfficeILBRNCHOFF
I_LOANBRANCHOFFICETEXTLoan Branch Office - TextILBRNCHOFFTXT
I_LOANCHGPOINTERCHANGECATLoan Change Pointer Change CategoryILCPCHGCAT
I_LOANCHGPOINTERCHANGECATTEXTLoan Change Pointer Change Category - TextILCPCHGCATTXT
I_LOANCHGPOINTERCHGSUBCATLoan Change Pointer Change Sub CategoryILCPCHGSUBCAT
I_LOANCHGPOINTERCHGSUBCATTEXTLoan Change Pointer Change Sub Category - TextILCPCHGSUBCATTXT
I_LOANCHGPOINTERPROCGGRPLoan Change Pointer Processing GroupILCPPROCGRP
I_LOANCHGPOINTERPROCGGRPTEXTLoan Change Pointer Processing Group - TextILCPPROCGRPTXT
I_LOANCHGPOINTERPROCGSTSLoan Change Pointer Processing StatusILCPPROCSTS
I_LOANCHGPOINTERPROCGSTSTEXTLoan Change Pointer Processing Status - TextILCPPROCSTSTXT
I_LOANCLASSLoan ClassILCLASS
I_LOANCLASSTEXTLoan Class - TextILCLASSTXT
I_LOANCONDITIONHEADERTYPELoan Condition Header TypeILCNDHDRTYP
I_LOANCONDITIONHEADERTYPETEXTLoan Condition Header Type - TextILCNDHDRTYPTXT
I_LOANCONTRACTLDOCHDRActual Document Header for Loan ContractILCACTLDOCHDR
I_LOANCONTRACTLDOCHDRDATAActual Document Header for Loan ContractILCACTDOCHDRD
I_LOANCONTRACTLDOCITMActual Document Item for Loan ContractILCACTLDOCITM
I_LOANCONTRACTLDOCITMDATAActual Document Item for Loan ContractILCACTDOCITMD
I_LOANCONTRACTNOTICETYPELoan Contract Notice TypeILCNTCTYP
I_LOANCONTRACTNOTICETYPETEXTLoan Contract Notice Type - TextILCNTCTYPTXT
I_LOANCONTRBPLoan Master data with Business Partner detailsILCBP
I_LOANCONTRBPCRDTWORTHWTHDFLTLoan Contract Business Partner Credit Worth with defaultingILCBPCRDWRTWTDF
I_LOANCONTRBPCURRATGRatings of Business PartnerILCBPCURRAT
I_LOANCONTRBPCURRATGWTHDFLTRating data for Business partner with defaultingILCBPRATNGWTDFLT
I_LOANCONTRBPDETWTHDFLTLoan Contract Business Partner details with defaultingILCBPDETWTHDFLT
I_LOANCONTRBPDUNWTHDFLTDunning data per Business Partner with defaultingILCBPDUNWTHDEF
I_LOANCONTRBPEMPLYMTWTHDFLTLoan Contract Business Partner Employment with defaultingILCBPEMPLYMTWTDF
I_LOANCONTRBPFINSRVCWTHDFLTLoan Contract Business Partner Financials with defaultingILCBPFINSERWTDF
I_LOANCONTRBPINCOMEWTHDFLTLoan Contract Business Partner income with defaultingILCBPINCWTDFT
I_LOANCONTRBPRTDBTMMWTHDFLTReturn Debit Memo per business partner with defaultingILCRDMWHTDFLT
I_LOANCONTRBPWTHDFLTBusiness Partner details with defaultingILCBPWTHDFLT
I_LOANCONTRBRWRNTCARRGMTLoan Contract Borrower Notice ArrangementILCBRWNTCARR
I_LOANCONTRBRWRNTCARRGMTTEXTLoan Contract Borrower Notice Arrangement - TextILCBRWNTCARRTXT
I_LOANCONTRBUSOPBusiness operation data for loansILCBUSOP
I_LOANCONTRBUSPARTRELSHPBusiness Partner relationship data for loan contractILCBPREL
I_LOANCONTRBUSPARTRELSHPDATABusiness Partner relationship data for Loan ContractILCBPRELD
I_LOANCONTRCAPTLZNWTHDFLTCapitalization data for Loan Contract with defaultingILCCAPTLZNWTDEF
I_LOANCONTRCHGPOINTERChange Pointer for Loan ContractILCCHGPTR
I_LOANCONTRCHGPOINTERDATAChange Pointer for Loan ContractILCCHGPTRD
I_LOANCONTRCNDNHDRConditon Header for Loan ContractILCCNDHDR
I_LOANCONTRCNDNHDRDATAConditon Header for Loan ContractILCCDNHDRD
I_LOANCONTRDATALoan Contract Master DataILCD
I_LOANCONTRDATABPCURRATWTHDFLTLoan Contract Business Partner Rating with defaultingILCDATBPRATWTDFT
I_LOANCONTRDEFRLWTHDFLTDeferral data for Loan Contract with defaultingILCDEFERRALWTDEF
I_LOANCONTRDUNDETDunning Details for Loan ContractILCDUNDET
I_LOANCONTRDUNWTHDFLTDunning data per Loan Contract with defaultingILCDUNWTHDEF
I_LOANCONTRGROUPINGGrouping procedure details for Loan ContractILCGROUPPROC
I_LOANCONTRINTRSTONARRSWTHDFLTInterest On Arrears data for Loan Contract with defaultingILCIOAWTDEF
I_LOANCONTRNTCADJMTTYPELoan Contract Notice Adjustment TypeILCNTCADJTYP
I_LOANCONTRNTCADJMTTYPETEXTLoan Contract Notice Adjustment Type - TextILCNTCADJTYPTXT
I_LOANCONTRPAYOFFWTHDFLTPayoff data for Loan Contract with defaultingILCPAYOFFWTDEF
I_LOANCONTRPLNDITMPlanned Items for Loan ContractILCPLNDITM
I_LOANCONTRPLNDITMDATAPlanned Items for Loan ContractILCPLNDITMD
I_LOANCONTRPOSTEDITEMDATAPosted Item for Loan ContractILCPOSTEDTIMD
I_LOANCONTRRETURNDEBITMEMOReturn Debit Memo for Loan ContractILCRDM
I_LOANCONTRRTDBTMMWTHDFLTReturn Debit Memo per Loan Contract with defaultingILCREDBMMWHTDFLT
I_LOANCONTRWRITEOFFWTHDFLTWriteoff data for Loan Contract with defaultingILCWRITEOFFWTDEF
I_LOANCONTRWVRWTHDFLTWaiver data for Loan Contract with defaultingILCWAIVERWTDEF
I_LOANCORRESPNCROLETYPELoan Correspondence Role TypeILCORROLETYP
I_LOANCORRESPNCROLETYPETEXTLoan Correspondence Role Type - TextILCORROLETYPTXT
I_LOANCSHFLWITMACTIVITYCATLoan Cash Flow Item CategoryILCFIACTCAT
I_LOANCSHFLWITMACTIVITYCATTEXTLoan Cash Flow Item Activity Category - TextILCFIACTCATTXT
I_LOANDRWGRESTRAINTTYPELoan Drawing Restraint TypeILDRWRSTTYP
I_LOANDRWGRESTRAINTTYPETEXTLoan Drawing Restraint Type - TextILDRWRSTTYPTXT
I_LOANGROUPKEY1Loan Group Key 1ILGRPKEY1
I_LOANGROUPKEY1TEXTLoan Group Key 1 - TextILGRPKEY1TXT
I_LOANGROUPKEY2Loan Group Key 2ILGRPKEY2
I_LOANGROUPKEY2TEXTLoan Group Key 2 - TextILGRPKEY2TXT
I_LOANGROUPKEY3Loan Group Key 3ILGRPKEY3
I_LOANGROUPKEY3TEXTLoan Group Key 3 - TextILGRPKEY3TXT
I_LOANGROUPKEY4Loan Group Key 4ILGRPKEY4
I_LOANGROUPKEY4TEXTLoan Group Key 4 - TextILGRPKEY4TXT
I_LOANINCGPAYTDISTRCTRLLoan Incoming Payment Distribution ControlILIPDCTRL
I_LOANINCGPAYTDISTRCTRLTEXTLoan Incoming Payment Distribution Control - TextILIPDCTRLTXT
I_LOANLENDERNOTICEARRGMTLoan Lender Notice ArrangementILLNDNOTARR
I_LOANLENDERNOTICEARRGMTTEXTLoan Lender Notice Arrangement - TextILLNDNOTARRTXT
I_LOANMANUALDUNLEVELLoan Manual Dunning LevelILMANDUNLVL
I_LOANMANUALDUNLEVELTEXTLoan Manual Dunning Level - TextILMANDUNLVLTXT
I_LOANNONACCPTCRSNLoan Non Acceptance ReasonILNONACCRSNA
I_LOANNONACCPTCRSNTEXTLoan Non Acceptance Reason - TextILNONACCRSNTXTA
I_LOANNOTICEREASONLoan Notice ReasonILNOTCRSN
I_LOANNOTICEREASONTEXTLoan Notice Reason - TextILNOTCRSNTXT
I_LOANPAYMENTSTATUSLoan Payment StatusILPAYSTAT
I_LOANPAYMENTSTATUSTEXTLoan Payment Status - TextILPAYSTATTXT
I_LOANPURPOSELoan PurposeILPURPOSE
I_LOANPURPOSETEXTLoan Purpose - TextILPURPOSETXT
I_LOANSALESREGIONLoan Sales RegionILSALESREG
I_LOANSALESREGIONTEXTLoan Sales Region - TextILSALESREGTXT
I_LOANSECURITYTYPELoan Security TypeILSECTYP
I_LOANSECURITYTYPETEXTLoan Security Type - TextILSECTYPTXT
I_LOANSPECIALPOSTINGTYPELoan Special Posting TypeILSPLPSTTYP
I_LOANSPECIALPOSTINGTYPETEXTLoan Special Posting Type - TextILSPLPSTTYPTXT
I_LOANSPECIALTREATMENTLoan Special TreatmentILSPLTREAT
I_LOANSPECIALTREATMENTTEXTLoan Special Treatment - TextILSPLTREATTXT
I_LOANTERMLoan TermILTERM
I_LOANTERMTEXTLoan Term - TextILTERMTXT
I_LOANTYPELoan TypeILTYP
I_LOANTYPEPRODTYPERELSHPLoan Type Product Type RelationshipILTYPPRDTYPREL
I_LOANTYPETEXTLoan Type - TextILTYPTXT
P_BPCAPITALIZATIONCapitalization data for Business PartnerPBPCAPITALIZATON
P_BPINTRSTONARREARSInterest on Arrears data for Business PartnerPBPIOA
P_BUSINESSPARTNERDEFERRALDeferral data for Business PartnerPBPDEFERRAL
P_BUSINESSPARTNERPAYOFFPayoff data for Business PartnerPBPPAYOFF
P_BUSINESSPARTNERWAIVERWaiver data for Business PartnerPBPWAIVER
P_BUSINESSPARTNERWRITEOFFWriteoff data for Business PartnerPBPWRITEOFF
P_LOANCONTRBPADDLDETBusiness Partner additional detailsPLCBPADDLDET
P_LOANCONTRBPCUREMPLYMTCurrent Employment of Loan Business PartnerPLCBPCUREMPLYMT
P_LOANCONTRBPCURRATGRatings of Business PartnerPLCBPCURRAT
P_LOANCONTRBPDUNNINGDunning data per Business PartnerPLCBPDUN
P_LOANCONTRBPINCOMEBusiness Partner incomePLCBPINC
P_LOANCONTRBPRETURNDEBITMEMONumber of Return Debit Memo per BPPLCBPRDM
P_LOANCONTRBPWGTDINCBusiness Partner income weightedPLCBPWGTDINC
P_LOANCONTRBUSOPCALCHeader data of Business OperationsPLCBUSOPCALC
P_LOANCONTRCAPITALIZATIONCapitalization data for Loan ContractPLCCAPITALIZATON
P_LOANCONTRDATABPINCOMELoan Contract Business Partner income weighted averagePLCBPWTAVGINC
P_LOANCONTRDEFERRALDeferral data for Loan ContractPLCDEFERRAL
P_LOANCONTRDUNAMTWGTDWTHBPDunning data per Contract for BPPLCDUNAMTWGTWTBP
P_LOANCONTRDUNCNTANDAMTDunning amount and count per ContractPLCDUNCNTANDAMT
P_LOANCONTRDUNNDunning data per Loan ContractPLCDUN
P_LOANCONTRDUNNINGDunning data per ContractPLCDUNNING
P_LOANCONTRDUNNINGDATALoan Contract Dunning dataPLCDUNNDAAT
P_LOANCONTRINTRSTONARREARSInterest on Arrears data for Loan ContractPLCIOA
P_LOANCONTRPAYOFFPayoff data for Loan ContractPLCPAYOFF
P_LOANCONTRRDMWTHBPNumber of Return Debit Memo per contract for BPPLCRDMWTHBP
P_LOANCONTRRETURNDEBITMEMONumber of Return Debit Memo per Loan ContractPLCRDM
P_LOANCONTRWAIVERWaiver data for Loan ContractPLCWAIVER
P_LOANCONTRWRITEOFFWriteoff data for Loan ContractPLCWRITEOFF
P_LOANRDMPERCONTRReturn Debit Memo per loan contractPLOANRDMPERCONTR