- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Business Partner (FS-BP)
- Claims Management (FS-CM)
- Collateral Management System (FS-CMS)
- Collections/Disbursements (FS-CD)
- Loans Management (FS-CML)
- Policy Management (FS-PM)
- Regulatory reporting for insurance companies (FS-SR)
- SAP Policy Management for Auto Insurance (FS-PMA)
- Value Adjustment (FS-RBD)
- msg.PM Connection (FS-MPM)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
VDCBR_RES_DATA
Table of Data Reported to Credit Bureau (Per Loan)
|
#transactional
|
Component: Loans Management
- 🔑 Keys (5)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (9)
- ☰ Categorical (4)
- Other (50)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| MANDT | Client | |
| BUKRS | Company Code | |
| RANL | Contract Number | |
| DATE_CREA | Created On | |
| TIME_CREA | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| DATE_CREA | Created On | |
| DATE_OPENED | First Entered On | |
| BILLING_DATE | Bill Creation Date | |
| FCRA_DATE | Date of First Delinquency (Metro2 - Format) | |
| DATE_CLOSED | Contract End Date | |
| LAST_PAYM_DATE | Date of Last Incoming Payment | |
| DATE_OF_BIRTH | Date of Birth (Metro2 Format) | |
| DEF_PAYM_START | Start Date of Derffered Repayments (Metro2 Format) | |
| PAYM_DUE_DATE | Due Date of Final Installment (Metro2 - Format) |
| Column Name | Description | |
|---|---|---|
| PROCESS_IND | Indicator for Forwarding Data in Metro2 Format | Show values |
| CORRECTION_IND | Indicator for Forwarding Data in Metro2 Format | Show values |
| PORTFOLIO_TYPE | Loan Type | Show values |
| SPEC_PAYM_IND | Payment Arrangements (MEtro2 Format) | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| BDW | Block Length Field for Output in File | NUMC4 | |
| RDW | Record Length Field | NUMC4 | |
| TIMESTAMP | UTC Time Stamp (Metro2 Format) | CHAR15 | |
| IDENT_NO | Nuber of Data Provider | CHAR20 | |
| CYCLE_IDENT | Cycle for Reporting to Credit Bureau | CHAR02 | |
| CONSUMER_ACC_NO | Loan Number (30 Characters) (Metro2 Format) | CHAR30 | |
| ACCOUNT_TYPE | Loan Type (Metro2 Format) | T_CBR_ACCOUNT_TYPE | |
| CREDIT_LIMIT | Credit Limit in (Metro2 Format) | T_CBR_AMOUNT_METRO2 | |
| O_LOAN_AMOUNT | Loan Amount (Metro2 Format) | T_CBR_AMOUNT_METRO2 | |
| TERMS_DURATION | Loan Term (Metro2 Format) | CHAR03 | |
| TERMS_FREQUENCY | Frequency of Payment Due Date (Metro2 Format) | CHAR01 | |
| MON_PAYM_AMOUNT | Planned Monthly Payment Amount | T_CBR_AMOUNT_METRO2 | |
| ACT_PAYM_AMOUNT | Amount Paid to Current Date (Metro2 Format) | T_CBR_AMOUNT_METRO2 | |
| ACCOUNT_STATUS | Loan Status (Metro2-Format) | CHAR02 | |
| PAYMENT_RATING | Payment Rating | CHAR01 | |
| PAYM_HIST_PROFIL | Payment History (Metro2 -Format) | CHAR24 | |
| SPECIAL_COMMENT | Comment Key (Metro2 Format) | CHAR02 | |
| COMPL_COND_CODE | Comment Key (Metro2 Format) | CHAR02 | |
| CURRENT_BALANCE | Balance on Current Date (Metro2 - Format) | T_CBR_AMOUNT_METRO2 | |
| AMOUNT_PAST_DUE | Payments Past Due (Metro2 Format) | T_CBR_AMOUNT_METRO2 | |
| CHARGE_OFF_AM | Charge-Off Amount (Metro2 Format) | T_CBR_AMOUNT_METRO2 | |
| RESERVE | Reserve Bytes (Length 17) | CHAR17 | |
| CONS_TRANS_TYPE | Changes to Borrower | CHAR01 | |
| SURNAME | Last Name (Metro2 Format) | CHAR25 | |
| FIRST_NAME | First Name (Metro2 Format) | CHAR20 | |
| MIDDLE_NAME | Middle Name (Metro2 Format) | CHAR20 | |
| GENERATION_CODE | Generation Code (Metro2 Format) | CHAR01 | |
| SOCIAL_SEC_NO | Social Security Number (Metro2 Format) | CHAR9 | |
| TEL_NUMBER | Telephone Number (Metro2 Format) | NUMC10 | |
| ECOA_CODE | Business Partner Role for Loan (Metro2 Format) | CHAR01 | |
| CONS_INFO_IND | Bankruptcy Phase of Business Partner (Metro2 Format) | CHAR02 | |
| COUNTRY_CODE | Country/Region Key (Metro2 Format) | CHAR02 | |
| FIRST_ADR_LINE | Address Line (Metro2 Format) | CHAR32 | |
| SECOND_ADR_LINE | Address Line (Metro2 Format) | CHAR32 | |
| CITY | City (Metro2 Format) | CHAR20 | |
| STATE | State Identification (Metro 2 Format) | CHAR02 | |
| POSTAL_CODE | Postal Code (Metro2 Format) | CHAR9 | |
| ADR_INDICATOR | Indicator Field for Address (Metro2 Format) | CHAR01 | |
| RESID_CODE | Residence Code for Metro2 Format | CHAR01 | |
| SEGMENT_IDENT7 | Indicator for Segment | CHAR02 | |
| EMPLOYER_NAME | Name of Employer | CHAR30 | |
| EMP_FI_ADR_LINE | Address Line (Metro2 Format) | CHAR32 | |
| EMP_CITY | City (Metro2 Format) | CHAR20 | |
| EMP_STATE | State Identification (Metro 2 Format) | CHAR02 | |
| EMP_POST_CODE | Postal Code (Metro2 Format) | CHAR9 | |
| OCCUPATION | Name of Occupation (Metro2 Format) | CHAR18 | |
| RESERVE7 | Place Holder for 1 Byte | CHAR01 | |
| SEGMENT_IDENT6 | Indicator for Segment | CHAR02 | |
| PAYM_AMOUNT | Final Installment Amount (Ballon) (Metro2 Format) | T_CBR_AMOUNT_METRO2 | |
| RESERVE6 | Place Holder for 1 Byte | CHAR01 |