Sap Bw / Bi Dmd - Corporate Credit Analysis
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sap Bw / Bi Dmd - Corporate Credit Analysis as PDF for free.
More details
- Words: 4,707
- Pages: 74
Version No. Document Owner Document Reference Author(s) Date Created Status
Version History Version History
0.5 Ajay Uppal Corporate Credit Analysis Data Model Ramesh Vuppula, Ajay Uppal 8/6/2007 Initial
Author 0.1 Ramesh Vuppula, Ajay Uppal 0.2 Ajay Uppal 0.3 Ajay Uppal 0.4 Ajay Uppal 0.5 Ajay Uppal 0.6 0.7 0.8 4.0
Date Change Ref 8/6/2006 8/20/2006 9/14/2006 9/21/2006 9/30/2006
Description Initial Draft Changes Changes Changes Approved
Data Flow Diagram for Data Model Corporate Credit Analysis
InfoCube ZFI_C07
Daily
Update Rules in BW
8ZFI_O09
8ZFI_O10
ODS objects in BW Update Rules in BW
InfoSource in BW
Daily Update
ZTD_S_PAY_LOT_001
ZTD_S_PAY_RUN_001
ZTD_S_PAY_LOT_001
ZTD_S_PAY_RUN_001
Transfer Rules in BW
DataSource in ISU
FI_O10
Daily
8ZFI_O12
8ZFI_O11
Daily Update
AY_RUN_001
ZTD_S_PAY_RETURN S_001
AY_RUN_001
ZTD_S_PAY_RETURNS_ 001
ZTD_S_PAY_REFUNDS_ 001
ZTD_S_PAY_REFUNDS_0 01
High Level Star Schema Diagram for Data Model Corporate Credit Analysis
7. Payment Data 1.Payment method 2.Document Type 3.DataSource Identifier 8. Employee Data 1.Credit Controller 2.BP in a BP Relationship ('Partner 2') 9. Payment Statuses 1.Status of Repayment Request 2.Payment Lot Status
10. Returns Lot 1.Returns Lot
11. Returns Statuses 1.Item Dunning Lock 2.Item Payment Lock 3.Incoming Payment Lock for CA 4.Document Has Been Reversed 12. Returns Data 1.Return Reason 2.Short Key for a House Bank
6. Payment Run 1.Payment Run ID 2.Payment Lock Reason
5. Payment Lot 1.Payment Lot
Facts/ KPIs
1. Amount in Transaction Currency 2.Assigned Amount in Transaction Currency 3.Payment Amount 4.Contract Account Dunning Lock: Days 5.Clearing Amount in Transaction Currency 6.Exchange rate for FI postings 7.Amount in Local Currency with +/- Signs 8.Clarified Amount in Local Currency 9.Return Amount 10.Item Dunning Lock: Days 11.Incoming Payment Lock: Days 12.Partial Amount
13.Refund Repayment Number 1.Repayment Request
14. Time 1. Calendar Year/We 2. Calendar Year/Mo
5. Payment Lot Payment Lot
ncy on Currency
1. Business Partner 1. Business Partner 2.Contract Account (PartnerDependent Data)
2. Contract Account 1.Contract Account (PartnerIndependent Data)
ck: Days on Currency
h +/- Signs ency
3. Organisational Data 1. Company code 2.Country key 3. Division
ys 4. Dates 1.Date ID of Mass Activity 2.Posting date in the document 3.Document Date
14. Time 1. Calendar Year/Week 2. Calendar Year/Month
InfoObjects for Corporate Credit Analysis Description:
Technical Name:
Type
Attributes Text
Hierarchy
Business Partner Contract Account (Partner-Dependent Data)
0BPARTNER 0FC_ACCNTBP
CHAR(10) CHAR(10)
X X
Contract Account (Partner-Independent Data)
0CACONT_ACC
CHAR(12)
X
Company code Country key Division
0COMP_CODE 0COUNTRY 0DIVISION
CHAR(4) CHAR(3) CHAR(2)
X
Date ID of Mass Activity Posting date in the document Document Date
0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
DATS DATS DATS
Payment Lot
ZCHPAYLOT
CHAR(12)
Payment Run ID Payment Lock Reason
ZPAYRUNID ZCHPAYLCK
CHAR(5) Char(1)
Payment method Document Type DataSource Identifier
0PYMT_METH ZDOCTYPE ZCHDS_ID
CHAR(1) CHAR(2) CHAR(6)
X
X X X
Credit Controller BP in a BP Relationship ('Partner 2')
ZCHCRCNTR 0BPARTNER2
CHAR(10) CHAR(10)
X X
X X
Status of Repayment Request Payment Lot Status
ZCHSTREPY ZCHPAYLST
Char(1) Char(1)
Returns Lot
ZCHRTNLOT
CHAR(12)
Item Dunning Lock
ZCNDLKREA
Char(1)
Characteristics X
X
X X X
X
X X X
X
X X
X
X X
Item Payment Lock Incoming Payment Lock for CA Document Has Been Reversed
ZCH_PYLCK ZCHINPYLK ZCHDOCREV
Char(1) Char(1) Char(1)
X X X
Return Reason Short Key for a House Bank
ZCHRTNRSN ZCHHSBANK
Char(3) Char(5)
X X
Repayment Request
ZCHRPYREQ
CHAR(10)
Calendar Year/Week Calendar Year/Month
0CALWEEK 0CALMONTH
NUMC(6) NUMC(6)
Description:
Technical Name:
Type
Aggr.
Amount in Transaction Currency Assigned Amount in Transaction Currency Payment Amount Contract Account Dunning Lock: Days Clearing Amount in Transaction Currency Exchange rate for FI postings Amount in Local Currency with +/- Signs Clarified Amount in Local Currency Return Amount Item Dunning Lock: Days Incoming Payment Lock: Days Partial Amount
ZKFAMT_TC ZKFASSAMT 0FC_TO_PAY ZKFCA_DLK ZKFCLGAMT 0EXRATE_ACC 0DEB_CRE_LC ZKFCLRAMT ZKFRTNAMT ZKFDLKITM ZKFINPYLK ZKFPRTAMT
CURR CURR CURR INT4 CURR DEC CURR CURR CURR INT4 INT4 CURR
SUM SUM SUM SUM SUM SUM SUM SUM SUM SUM SUM SUM
Time Characteristics X
Key Figures
Excep. Aggr. Ref. Char
InfoCube & Update Rules for FIDT07: Corporate Credit Analysis Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea InfoCube Update Rule
Description: Infoarea for Finance & Credit Operation FIDT07: Corporate Credit Analysis Payment Lot Analysis
Technical Name: ZIA_FI ZFI_C07 8ZFI_O09
Dimensions 1)
Description Business Partner
Technical Name ZFI_C071
Update Rule Method
Business Partner Contract Account (Partner-Dependent Data)
0BPARTNER 0FC_ACCNTBP
SC SC
Contract Account
ZFI_C072
2)
Contract Account (Partner-Independent Data) 0CACONT_ACC 3)
4)
Organisational Data
ZFI_C073
Company code Country key Division
0COMP_CODE 0COUNTRY 0DIVISION
Dates Date ID of Mass Activity Posting date in the document Document Date
ZFI_C074 0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
SC
SC
SC SC
5)
6)
7)
8)
9)
Payment Lot
ZFI_C075
Payment Lot
ZCHPAYLOT
Payment Data
ZFI_C077
Payment method Document Type DataSource Identifier
0PYMT_METH ZDOCTYPE ZCHDS_ID
Employee Data
ZFI_C078
Credit Controller BP in a BP Relationship ('Partner 2')
ZCHCRCNTR 0BPARTNER2
Payment Statuses
ZFI_C079
Status of Repayment Request Payment Lot Status
ZCHSTREPY ZCHPAYLST
Time
ZFI_C07T
Calendar Year/Week Calendar Year/Month
0CALWEEK 0CALMONTH
Payment method Country key Corporate Account Team Partner:Partner Type
0FC_ACCNTBP__0PYMT_METH 0FC_ACCNTBP__0COUNTRY 0BPARTNER__ZCHCUSTCL 0BPARTNER__0BP_TYPE
Description:
Technical Name:
Type
Payment Amount Amount in Local Currency with +/- Signs
0FC_TO_PAY 0DEB_CRE_LC
SC SC
SC C
R R
SC
SC SC
Navigational Attributes
Key Figures
Assigned Amount in Transaction Currency Clarified Amount in Local Currency Partial Amount Exchange rate for FI postings
ZKFASSAMT ZKFCLRAMT ZKFPRTAMT 0EXRATE_ACC
SC SC SC SC
Key Figures 1) 2)
Open Item Number of Document Items
0FC_OI 0DOC_ITEMS
Source Key Figure Source Key Figure
Not present in Delivered BC, to be enhanced Present in Delivered BC Not present in Delivered BC, to be enhanced and custom InfoObject to be created Not Required
Details
PAYLOT
Derive Credit Con Derive Acc. Mgr
InfoCube & Update Rules for FIDT07: Corporate Credit Analysis Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea InfoCube Update Rule
Description: Infoarea for Finance & Credit Operation FIDT07: Corporate Credit Analysis Payment RUN Analysis
Dimensions 1)
Description Business Partner Business Partner Contract Account (Partner-Dependent Data)
2)
Contract Account Contract Account (Partner-Independent Data)
3)
Organisational Data Company code Country key Division
4)
Dates Date ID of Mass Activity Posting date in the document Document Date
5)
Payment Run Payment Run ID Payment Lock Reason
6)
Payment Data Payment method Document Type DataSource Identifier
7)
Employee Data Credit Controller BP in a BP Relationship ('Partner 2')
8)
Payment Statuses Status of Repayment Request
9)
Time Calendar Year/Week Calendar Year/Month
Navigational Attributes Payment method Country key Corporate Account Team Partner:Partner Type Description: Key Figures Amount in Transaction Currency Clearing Amount in Transaction Currency
Key Figures 1) 2)
Open Item Number of Document Items
Not present in Delivered BC, to be enhanced Present in Delivered BC Not present in Delivered BC, to be enhanced and custom In Not Required
Technical Name: ZIA_FI ZFI_C07 8ZFI_O10 Technical Name ZFI_C071
Update Rule Method Details
0BPARTNER 0FC_ACCNTBP
SC SC
ZFI_C072 0CACONT_ACC
SC
ZFI_C073 0COMP_CODE 0COUNTRY 0DIVISION
SC SC SC
ZFI_C074 0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
SC SC SC
ZFI_C076 ZPAYRUNID ZCHPAYLCK
SC SC
ZFI_C077 0PYMT_METH ZDOCTYPE ZCHDS_ID
SC SC C
PAYRUN
R R
Derive Credit Con Derive Acc. Mgr
ZFI_C078 ZCHCRCNTR 0BPARTNER2
ZFI_C079 ZCHSTREPY ZFI_C07T 0CALWEEK 0CALMONTH
SC SC
0FC_ACCNTBP__0PYMT_METH 0FC_ACCNTBP__0COUNTRY 0BPARTNER__ZCHCUSTCL 0BPARTNER__0BP_TYPE Technical Name: ZKFAMT_TC ZKFCLGAMT
SC SC
0FC_OI 0DOC_ITEMS
Source Key Figure Source Key Figure
BC, to be enhanced BC, to be enhanced and custom InfoObject to be created
InfoCube & Update Rules for FIDT07: Corporate Credit Analysis Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea InfoCube Update Rule
Description: Infoarea for Finance & Credit Operation FIDT07: Corporate Credit Analysis Payment RETURNS Analysis
Dimensions 1)
Description Business Partner Business Partner Contract Account (Partner-Dependent Data)
2)
Contract Account Contract Account (Partner-Independent Data)
3)
Organisational Data Company code Country key Division
4)
Dates Date ID of Mass Activity Posting date in the document Document Date
5)
Returns Lot Returns Lot
6)
Returns Statuses Item Dunning Lock Item Payment Lock Incoming Payment Lock for CA Document Has Been Reversed
7)
Returns Data Return Reason Short Key for a House Bank
8)
Payment Data Payment method Document Type DataSource Identifier
9)
Employee Data Credit Controller BP in a BP Relationship ('Partner 2')
10)
Payment Statuses Status of Repayment Request
11)
Time Calendar Year/Week Calendar Year/Month
Navigational Attributes Payment method Country key Corporate Account Team Partner:Partner Type Description: Key Figures Partial Amount Return Amount Item Dunning Lock: Days Incoming Payment Lock: Days Contract Account Dunning Lock: Days
Key Figures 1) 2)
Open Item Number of Document Items
nalysis
Not present in Delivered BC, to be enhanced Present in Delivered BC Not present in Delivered BC, to be enhanced and custom Not Required
Technical Name: ZIA_FI ZFI_C07 8ZFI_O11 Technical Name ZFI_C071
Update Rule Method Details
0BPARTNER 0FC_ACCNTBP
SC SC
ZFI_C072 0CACONT_ACC
SC
ZFI_C073 0COMP_CODE 0COUNTRY 0DIVISION ZFI_C074 0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
SC
SC SC
ZFI_C07A ZCHRTNLOT
SC
ZFI_C07B ZCNDLKREA ZCH_PYLCK ZCHINPYLK ZCHDOCREV
SC SC SC SC
ZFI_C07C ZCHRTNRSN ZCHHSBANK
SC SC
ZFI_C077 0PYMT_METH ZDOCTYPE ZCHDS_ID
SC R
RETURN
ZFI_C078 ZCHCRCNTR 0BPARTNER2
R R
ZFI_C079 ZCHSTREPY ZFI_C07T 0CALWEEK 0CALMONTH
SC SC
0FC_ACCNTBP__0PYMT_METH 0FC_ACCNTBP__0COUNTRY 0BPARTNER__ZCHCUSTCL 0BPARTNER__0BP_TYPE Technical Name: ZKFPRTAMT ZKFRTNAMT ZKFDLKITM ZKFINPYLK ZKFCA_DLK
SC SC SC SC SC
Derive Credit Con Derive Acc. Mgr
0FC_OI 0DOC_ITEMS
Source Key Figure Source Key Figure
BC, to be enhanced BC, to be enhanced and custom InfoObject to be created
InfoCube & Update Rules for FIDT07: Corporate Credit Analysis Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea InfoCube Update Rule
Description: Infoarea for Finance & Credit Operation FIDT07: Corporate Credit Analysis Payment RUFUND Analysis
Dimensions 1)
Description Business Partner Business Partner Contract Account (Partner-Dependent Data)
2)
Contract Account Contract Account (Partner-Independent Data)
3)
Organisational Data Company code Country key Division
4)
Dates Date ID of Mass Activity Posting date in the document Document Date
5)
Refund Repayment Number Repayment Request
6)
Payment Data Payment method Document Type DataSource Identifier
7)
Employee Data Credit Controller BP in a BP Relationship ('Partner 2')
8)
Payment Statuses Status of Repayment Request
9)
Time Calendar Year/Week Calendar Year/Month
Navigational Attributes Payment method Country key Corporate Account Team Partner:Partner Type Description: Key Figures Amount in Local Currency with +/- Signs Assigned Amount in Transaction Currency
Key Figures 1) 2)
Open Item Number of Document Items
Not present in Delivered BC, to be enhanced Present in Delivered BC Not present in Delivered BC, to be enhanced and custom In Not Required
Technical Name: ZIA_FI ZFI_C07 8ZFI_O12 Technical Name ZFI_C071
Update Rule Method Details
0BPARTNER 0FC_ACCNTBP
SC SC
ZFI_C072 0CACONT_ACC
SC
ZFI_C073 0COMP_CODE 0COUNTRY 0DIVISION ZFI_C074 0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
SC SC
SC
ZFI_C07D ZCHRPYREQ
SC
ZFI_C077 0PYMT_METH ZDOCTYPE ZCHDS_ID
SC SC C
REFUND
R R
Derive Credit Con Derive Acc. Mgr
ZFI_C078 ZCHCRCNTR 0BPARTNER2
ZFI_C079 ZCHSTREPY
SC
ZFI_C07T 0CALWEEK 0CALMONTH
SC SC
0FC_ACCNTBP__0PYMT_METH 0FC_ACCNTBP__0COUNTRY 0BPARTNER__ZCHCUSTCL 0BPARTNER__0BP_TYPE Technical Name: 0DEB_CRE_LC ZKFASSAMT
SC SC
0FC_OI 0DOC_ITEMS
Source Key Figure Source Key Figure
BC, to be enhanced BC, to be enhanced and custom InfoObject to be created
ODS & Update Rules for FIDT07: Corporate Credit Analysis LOT Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Update Rule Type Addition Overwrite No Update
Object InfoArea ODS Update Rule
Description: Finance & Credit Operation Payment Lot Analysis Payment Lot Data
Technical Name ZIA_FI ZFI_O09 ZTD_S_PAY_LOT_001
Key Fields
Description Payment Lot Payment Lot Item
Technical Name ZCHPAYLOT ZCHPAYITM
Update Rule Method Details Overwrite Overwrite
Data Fields
Description
Technical Name
Update Rule Type
Business Partner Contract Account (Partner-Independent Data) Contract Account (Partner-Dependent Data) Partial Clarification Exists for Payment Reconciliation Key Company code Business area Document Type Document Date Value Date Clearing Reason Changed by Changed On Time of Last Change
0BPARTNER 0CACONT_ACC 0FC_ACCNTBP ZCHPARTCL 0FC_FIKEY 0COMP_CODE 0BUS_AREA ZDOCTYPE 0DOC_DATE ZCHVALDAT 0FC_CLEARR 0CHANGEDBY 0AEDAT 0CH_AT
SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
Check sent back Post Payment on Account Clarify Payment Transaction Clarification Document Number Clarification Account Posting Date of Clarifcation Document Contract Account Document Number Name of person who created the object Date on which the record was created Time Created Payment Lot Status Payment Amount Amount in Local Currency with +/- Signs Assigned Amount in Transaction Currency Clarified Amount in Local Currency Partial Amount Exchange rate for FI postings Currency key Local currency Posting date in the document
ZCHPCHKBK ZCHPSTPOA ZCHCLAPAY ZCHCLADOC ZCHCLARAC ZCHPSDTCL ZCHCA_DOC 0CREATEDBY 0CREATEDON 0CREA_TIME ZCHPAYLST 0FC_TO_PAY 0DEB_CRE_LC ZKFASSAMT ZKFCLRAMT ZKFPRTAMT 0EXRATE_ACC 0CURRENCY 0LOC_CURRCY 0PSTNG_DATE
SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
ODS & Update Rules for FIDT07: Corporate Credit Analysis RUN Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea ODS Update Rule
Description: Finance & Credit Operation Payment Run Analysis Payment Run Data
Technical Name ZIA_FI ZFI_O10 ZTD_S_PAY_RUN_001
Key Fields
Description Date ID of Mass Activity Payment Run ID Source of the payment Indicator: Only Proposal Run Sequential Payment Number Job Number Paid Document Category Paid Document Reference
Technical Name 0FC_RUNDATE ZPAYRUNID ZCHPSRCPY ZCHPRPRUN ZCHSPAYNO ZCHJOB_NO ZCHPDOCCT ZCHPDOCRF
Data Fields
Description Reference to Business Partner Business Partner Contract Account Category Contract Account Reference Contract Account (Partner-Dependent Data) Contract Account (Partner-Independent Data) Document Date Due date for net payment Payment Lock Reason Company code Business area Division Document Type Value Date Payment method Country key Application Component Amount in Transaction Currency Clearing Amount in Transaction Currency Currency key Posting date in the document
Technical Name ZCHBP_REF 0BPARTNER 0FC_ACCTCAT ZCHCA_REF 0CACONT_ACC 0FC_ACCNTBP 0DOC_DATE 0NETDUEDATE ZCHPAYLCK 0COMP_CODE 0BUS_AREA 0DIVISION ZDOCTYPE ZCHVALDAT 0PYMT_METH 0COUNTRY 0CAAPPLK ZKFASSAMT ZKFCLGAMT 0CURRENCY 0PSTNG_DATE
Update Rule Type Addition Overwrite No Update
AY_RUN_001 Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
Update Rule Type SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
ODS & Update Rules for FIDT07: Corporate Credit Analysis RETURNS Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea ODS Update Rule
Description: Finance & Credit Operation Payment Returns Analysis Payment Return Data
Technical Name ZIA_FI ZFI_O11 ZTD_S_PAY_RETURNS_001
Key Fields
Description Business Partner Contract Account (Partner-Independent Data) Return Document Number
Technical Name 0BPARTNER 0CACONT_ACC ZCHRT_DOC
Data Fields
Description Contract Account (Partner-Dependent Data) Returns Lot Returns Item Contract Account Document Number Posting date in the document Document Date Value Date Return Reason Payment Form Number Document Has Been Reversed Short Key for a House Bank Calculate Graduated Charges Item Dunning Lock Item Payment Lock Incoming Payment Lock for CA Delete Incoming Payment Method Account Delete Outgoing Payment Method Account Event to Create Correspondence Delete Pay Method in Item Document Type Change Payment Method in Item Currency key Partial Amount Return Amount Incoming Payment Lock: Days Contract Account Dunning Lock: Days Company code Item Dunning Lock: Days
Technical Name 0FC_ACCNTBP ZCHRTNLOT ZCHRTNITM ZCHCA_DOC 0PSTNG_DATE 0DOC_DATE ZCHVALDAT ZCHRTNRSN ZCHPYFORM ZCHDOCREV ZCHHSBANK ZCHCALCHG ZCNDLKREA ZCH_PYLCK ZCHINPYLK ZCHDELPYM ZCHDLOPYM ZCH_CORR ZCHDPYITM ZDOCTYPE ZCHCPYITM 0CURRENCY ZKFPRTAMT ZKFRTNAMT ZKFINPYLK ZKFCA_DLK 0COMP_CODE ZKFDLKITM
Update Rule Type Addition Overwrite No Update
AY_RETURNS_001 Update Rule Method Overwrite Overwrite Overwrite
Details
Update Rule Type SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
ODS & Update Rules for FIDT07: Corporate Credit Analysis REFUND Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea ODS Update Rule
Description: Finance & Credit Operation Payment Refunds Analysis Payment Refund Data
Technical Name ZIA_FI ZFI_O12 ZTD_S_PAY_REFUNDS_001
Key Fields
Description Repayment Request
Technical Name ZCHRPYREQ
Data Fields
Description Company code Due date for net payment Reference for Bank Details Payment method Country key Payment Document Number Posting date in the document Name of person who created the object Entry Date Time Created Status of Repayment Request Refund Document Number Payment Lock Reason Changed by Changed On Time of Last Change Business Partner Contract Account (Partner-Independent Data) Document Type Contract Account (Partner-Dependent Data) Local currency Currency key Assigned Amount in Transaction Currency Amount in Local Currency with +/- Signs
Technical Name 0COMP_CODE 0NETDUEDATE ZCHREFBNK 0PYMT_METH 0COUNTRY ZCHPAYDOC 0PSTNG_DATE 0CREATEDBY 0ENTRYDATE 0CREA_TIME ZCHSTREPY CHRFNDDOC ZCHPAYLCK 0CHANGEDBY 0AEDAT 0CH_AT 0BPARTNER 0CACONT_ACC ZDOCTYPE 0FC_ACCNTBP 0LOC_CURRCY 0CURRENCY ZKFASSAMT 0DEB_CRE_LC
Update Rule Type Addition Overwrite No Update
AY_REFUNDS_001 Update Rule Method Overwrite
Details
Update Rule Type SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
InfoSource & Transfer Rules for FIDT07: Corporate Credit Analysis LOT Transfer Rule Type InfoObject Constant Formula Routine No Assignment
IO C F R NA
Object Application Component InfoSource
Description Technical Name InfoSources for Finance (Transaction ZAC_TR_FI Data) Payment Lot Data ZTD_S_PAY_LOT_001
Description Payment Lot Payment Lot Item Business Partner Contract Account Contract Acct (PD) Payment Amount Debit/Credit Amount Assigned Amt Clarified Amt in LC Partial Clarifictn. Partial Amount Reconciliation Key Company code Business area Document Type Currency Exch.rate-acct. Posting date Document Date
Communication Structure Technical Name ZCHPAYLOT ZCHPAYITM 0BPARTNER 0CACONT_ACC 0FC_ACCNTBP 0FC_TO_PAY 0DEB_CRE_LC ZKFASSAMT ZKFCLRAMT ZCHPARTCL ZKFPRTAMT 0FC_FIKEY 0COMP_CODE 0BUS_AREA ZDOCTYPE 0CURRENCY 0EXRATE_ACC 0PSTNG_DATE 0DOC_DATE
Transfer Structure DataSource Field
Transfer Rule Type
Description
IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO
Payment Lot Item number in a payment lot Business Partner Number Contract Account Number Business Partner Number Payment amount in transaction currency Amount In Local Currency With +/- Signs Assigned Amount in Transaction Currency Clarified Amount In Local Currency Partial Clarifications Exist For Payment Partial Amount that Refers to the Specified Selection Reconciliation Key for General Ledger Company Code Business Area Document Type Currency Key Exchange rate Posting Date in the Document Document Date in Document
KEYZ1 POSZA GPART VKONT GPART BETRZ BETRH BETRK BETRL XTKLA TBETR FIKEY BUKRS GSBER BLART WAERS KURSF BUDAT BLDAT
Value Date Clearing Reason Changed by Changed On Last Changed At Check sent back Post Paymnt on Acct Clarify Paymnt Trans Clarification Doc No Clarificatn Account Pstg Date Clarif Doc Contract Acct Doc No Created by Created on Time Payment Lot Status Local currency
ZCHVALDAT 0FC_CLEARR 0CHANGEDBY 0AEDAT 0CH_AT ZCHPCHKBK ZCHPSTPOA ZCHCLAPAY ZCHCLADOC ZCHCLARAC ZCHPSDTCL ZCHCA_DOC 0CREATEDBY 0CREATEDON 0CREA_TIME ZCHPAYLST 0LOC_CURRCY
IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO
Value date Clearing Reason Name of person who changed object Date of Last Change Time at Which the Object Was Last Changed Check was or will be sent back Post Payment on Account Clarify Payment Transaction Number of Clarification Document Clarification Account Posting date of clarif. doc Number of Contract Accts Rec. & Payable Doc. Name of Person who Created the Object Date on which the record was created Time at which the object was created Status of the payment lot 0CURRENCY
VALUT AUGRD AENAM AEDAT AETIM XRUES XAKON XKLAE KLAEB KLAEH KLAED OPBEL ERNAM ERDAT ERTIM STAZS LOC_CURRCY
Selection Enabled Yes Yes No No No No No No No No No No No No No No No No No
No No No Yes Yes No No No No No No No Yes No Yes No No
InfoSource & Transfer Rules for FIDT07: Corporate Credit Analysis RUN Transfer Rule Type InfoObject Constant Formula Routine No Assignment
IO C F R NA
Object Application Component InfoSource
Description Technical Name InfoSources for Finance (Transaction ZAC_TR_FI Data) Payment Run Data ZTD_S_PAY_RUN_001
Description 0FC_RUNDATE ZPAYRUNID ZCHPSRCPY ZCHPRPRUN ZCHSPAYNO 0FC_ACCTCAT ZCHCA_REF ZCHPDOCCT ZCHPDOCRF ZCHBP_REF 0PSTNG_DATE 0NETDUEDATE 0CURRENCY ZKFAMT_TC ZKFCLGAMT ZCHPAYLCK 0COMP_CODE 0BUS_AREA 0DIVISION ZDOCTYPE ZCHVALDAT 0PYMT_METH 0COUNTRY ZCHJOB_NO 0DOC_DATE 0CACONT_ACC 0BPARTNER 0CAAPPLK 0FC_ACCNTBP
Communication Structure Technical Name Run Date Payment Run ID Source of payment Proposal Run Ind. Sequential Paymnt No Contract Acct Categ. Contract Account Ref Paid Doc Category Paid Doc Reference Reference to BP Posting date Net due date Currency Amt in Trans. Curr. Clearing Amount in T Payment Lock Reason Company code Business area Division Document Type Value Date Payment method Country Job Number Document Date Contract Account Business Partner Application Comp. Contract Acct (PD)
Transfer Rule Type IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO R R C R
RUN
AY_RUN_001
Description
Transfer Structure DataSource Field
Date ID ZZLAUFD Identification for the payment run ZZLAUFI Source of the payment data ZZORIGN Indicator: Only Proposal Run? ZZXVORL Sequential payment number ZZPAYNO Contract Account Category ZZACC1T Reference to Contract Account ZZACC1R Category for paid document ZZDOC2T Reference to Paid Document ZZDOC2R Reference to Business Partner Giving Payment Instruction ZZGPA2R Posting Date in the Document ZZBUDAT Due Date of Payment ZZFAEDT Currency Key ZZWAERS Amount in Transaction Currency with +/- Sign ZZBETRW Clearing Amount in Transaction Currency (With +/- Sign)ZZAUGBW Lock Reason for Automatic Payment ZZZLSPR Company Code ZZBUKRS Business Area ZZGSBER Division ZZSPART Document Type ZZBLART Value date ZZVALUT Payment Method ZZRZAWE Country Key ZZLAND1 Additional distinguishing criterion from payments ZZSUBNO Document Date in Document ZZBLDAT Fill 0CACONT_ACC with ZZACC1R 0CACONT_ACC Fill 0BPARTNER with ZZGPA2R fi BPARTNER R Fill 0FC_ACCNTBP with ZZGPA2R 0FC_ACCNTBP
Selection Enabled Yes Yes No No No No No No No No No No No No No No No No No No No No No No No No No No No
ZZBLDAT
InfoSource & Transfer Rules for FIDT07: Corporate Credit Analysis RETURNS Transfer Rule Type InfoObject Constant Formula Routine No Assignment
IO C F R NA
Object Application Component InfoSource
Description Technical Name InfoSources for Finance (Transaction ZAC_TR_FI Data) Payment Return Data ZTD_S_PAY_RETURNS_001
Description Business Partner Contract Account Return Document No. Returns Lot Returns Item Contract Acct Doc No Partial Amount Return Amount Currency Posting date Document Date Value Date Return Reason Payment Form Number Document Reversed Calculate Charges Item Dunning Lock Itm Dunning Lck Days Item Payment Lock Inc Paymnt Lck: Days CA Dunn Lock: Days Inc. Payment Lock CA Del Inc. Pay Mthd Del Out. Pay Mthd Create Correspndence Del Pay Mthd Item Chg Pay Mthd Item Document Type Company code Key for House Bank Contract Acct (PD)
Communication Structure Technical Name 0BPARTNER 0CACONT_ACC ZCHRT_DOC ZCHRTNLOT ZCHRTNITM ZCHCA_DOC ZKFPRTAMT ZKFRTNAMT 0CURRENCY 0PSTNG_DATE 0DOC_DATE ZCHVALDAT ZCHRTNRSN ZCHPYFORM ZCHDOCREV ZCHCALCHG ZCNDLKREA ZKFDLKITM ZCH_PYLCK ZKFINPYLK ZKFCA_DLK ZCHINPYLK ZCHDELPYM ZCHDLOPYM ZCH_CORR ZCHDPYITM ZCHCPYITM ZDOCTYPE 0COMP_CODE ZCHHSBANK 0FC_ACCNTBP
Transfer Rule Type IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO
ZCHCALCHG ZCNDLKREA ZKFDLKITM ZCH_PYLCK ZKFINPYLK ZKFCA_DLK ZCHINPYLK ZCHDELPYM ZCHDLOPYM ZCH_CORR ZCHDPYITM ZCHCPYITM ZDOCTYPE 0COMP_CODE ZCHHSBANK
RETURNS
AY_RETURNS_001 Transfer Structure Description Business Partner Number Contract Account Number Number of the return document Returns Lot Item number in a returns lot Number of Contract Accts Rec. & Payable Doc. Partial Amount Of Return Return amount Currency Key Posting Date in the Document Document Date in Document Value date Return reason Payment Form Number Document Has Been Reversed Calculate Graduated Charges Dunning Lock Reason for Line Item Item dunning lock: days Payment lock reason for item Payment lock for incoming payments: Duration in days Contract acct dunn. lock: days Reason for incoming payment block for contract account Delete payment method with account instead of changing Returns Activity: Delete Outgoing Payment Method in Account Activate Event for Creating Correspondence Delete Payment Method in Item Change Pymt Meth. in Item Document Type Company Code Short key for a house bank Business Partner Number
Transfer Structure DataSource Field GPART VKONT RLBEL KEYR1 POSRA OPBEL BETRWR BETRR WAERS BUDAT BLDAT VALUT RLGRD NRZAS XSTOR XGEBS MSPOP MSPOP_DAYS PSPOP PSPOP_DAYS MSPKO_DAYS EZSKO XDELEZAWE XDELAZAWE BCORR XDELPZAWE XCORPZAWE BLART BUKRS HBKID GPART
Selection Enabled No No No No No No No No No Yes Yes No No No No No No No No No No No No No No No No No No No No
InfoSource & Transfer Rules for FIDT07: Corporate Credit Analysis REFUND Transfer Rule Type InfoObject Constant Formula Routine No Assignment
IO C F R NA
Object Application Component InfoSource
Description Technical Name InfoSources for Finance (Transaction ZAC_TR_FI Data) Payment Refund Data ZTD_S_PAY_REFUNDS_001
Description Repayment Request Company code Currency Assigned Amt Debit/Credit Amount Net due date Ref.for Bank Details Payment method Payment Doc Number Posting date Created by Entry Date Time Status of Repay Requ Refund Doc Number Payment Lock Reason Changed by Changed On Last Changed At Business Partner Contract Account Document Type Key for House Bank Local currency 0COUNTRY Contract Acct (PD)
Communication Structure Technical Name ZCHRPYREQ 0COMP_CODE 0CURRENCY ZKFASSAMT 0DEB_CRE_LC 0NETDUEDATE ZCHREFBNK 0PYMT_METH ZCHREFUND 0PSTNG_DATE 0CREATEDBY 0ENTRYDATE 0CREA_TIME ZCHSTREPY CHRFNDDOC ZCHPAYLCK 0CHANGEDBY 0AEDAT 0CH_AT 0BPARTNER 0CACONT_ACC ZDOCTYPE ZCHHSBANK 0LOC_CURRCY Country 0FC_ACCNTBP
Transfer Rule Type IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO C IO
ZDOCTYPE ZCHHSBANK
REFUND
AY_REFUNDS_001
Description
Transfer Structure DataSource Field
Repayment request NRZAA Company Code BUKRS Currency Key WAERS Amount in Transaction Currency with +/- Sign BETRW Amount In Local Currency With +/- Signs BETRH Due date for net payment FAEDN Reference Specifications for Bank Details BKREF Payment Method PYMET Number of Payment Document PYBEL Posting Date in the Document BUDAT Name of Person who Created the Object ERNAM Accounting Document Entry Date CPUDT Time of Entry CPUTM Status of Repayment Request STARA Document number of posting made to refund clearing account ANFBL Lock Reason for Automatic Payment SPZAH Name of person who changed object AENAM Date of Last Change AEDAT Time changed AETIM Business Partner Number GPART Contract Account Number VKONT Document Type BLART Short key for a house bank HBKID 0CURRENCY LOC_CURRCY GB Business Partner Number GPART
Selection Enabled No No No No No No No No No No No Yes No No No No No Yes No No No No No No No No
DataSource & Enhancements for FIDT07: Corporate Credit Analysis
Transaction Data Source Based View/FM/Query Application Component Extract Structure Append Structures Upload Method Selection Parameters
Transaction Data Source Based View/FM/Query Application Component Extract Structure Append Structures Upload Method Selection Parameters
Transaction Data Source Based View/FM/Query Application Component Extract Structure Append Structures Upload Method Selection Parameters
Description
Technical Name
BW Payment Lot Extractor Functional Module FI-CA Extract structure for payment lot
ZTD_S_PAY_LOT_001 ZUFI_PAYMENT_LOT_EXTRACTOR FI-CA ZSUFI_PAYMENT_LOT_EXTRACT
Full Upload Date of Last Change Time at Which the Object Was Last Changed Date on which the record was created Name of Person who Created the Object Payment Lot Item number in a payment lot
F AEDAT AETIM ERDAT ERNAM KEYZ1 POSZA
Description FI-CA: BW Payment RunExtractor Table - BW Payment Run Extractor DPAYH & DPAYP FI-CA Generated Table for View ZVPAYMENT_RUN
Technical Name ZTD_S_PAY_RUN_001 ZVPAYMENT_RUN FI-CA ZOXI2D0040
Full Upload Date ID Identification for the payment run
F ZZLAUFD ZZLAUFI
Description FI-CA: BW Payment Returns Extractor Table- BW Payment Returns Extractor DFKKRH & DFKKRK FI-CA Generated Table for View ZVPAYMENT_RET
Technical Name ZTD_S_PAY_RETURNS_001 ZVPAYMENT_RET FI-CA ZOXBID0032
Full Upload Document Date in Document
F BLDAT
Transaction Data Source Based View/FM/Query Application Component Extract Structure Append Structures Upload Method Selection Parameters
Posting Date in the Document
BUDAT
Description BW Payment Refunds Extractor Functional Module FI-CA Payment Refunds Extractor structure
Technical Name ZTD_S_PAY_REFUNDS_001 ZUFI_PAYMENT_REFUNDS_EXTRACTOR FI-CA ZSUFI_PAYMENT_REFUNDS_EXTRACT
Full Upload Date of Last Change Accounting Document Entry Date
F AEDAT CPUDT
Roles & Workbooks for FIDT07: Corporate Credit Analysis
Role
Description Authorization Object Support team role for business support in production/Finance/Corporate Debtors/Corporate Credit Report
Users
Queries
Description Corporate Credit Report
Technical Name FIN1_COR_DEB_CORP_CREDIT
Workbooks
Description Corporate Credit Report
Technical Name 4648LGFSD4OKIZ0R9M5I64FZ1
Version History Version History
0.5 Ajay Uppal Corporate Credit Analysis Data Model Ramesh Vuppula, Ajay Uppal 8/6/2007 Initial
Author 0.1 Ramesh Vuppula, Ajay Uppal 0.2 Ajay Uppal 0.3 Ajay Uppal 0.4 Ajay Uppal 0.5 Ajay Uppal 0.6 0.7 0.8 4.0
Date Change Ref 8/6/2006 8/20/2006 9/14/2006 9/21/2006 9/30/2006
Description Initial Draft Changes Changes Changes Approved
Data Flow Diagram for Data Model Corporate Credit Analysis
InfoCube ZFI_C07
Daily
Update Rules in BW
8ZFI_O09
8ZFI_O10
ODS objects in BW Update Rules in BW
InfoSource in BW
Daily Update
ZTD_S_PAY_LOT_001
ZTD_S_PAY_RUN_001
ZTD_S_PAY_LOT_001
ZTD_S_PAY_RUN_001
Transfer Rules in BW
DataSource in ISU
FI_O10
Daily
8ZFI_O12
8ZFI_O11
Daily Update
AY_RUN_001
ZTD_S_PAY_RETURN S_001
AY_RUN_001
ZTD_S_PAY_RETURNS_ 001
ZTD_S_PAY_REFUNDS_ 001
ZTD_S_PAY_REFUNDS_0 01
High Level Star Schema Diagram for Data Model Corporate Credit Analysis
7. Payment Data 1.Payment method 2.Document Type 3.DataSource Identifier 8. Employee Data 1.Credit Controller 2.BP in a BP Relationship ('Partner 2') 9. Payment Statuses 1.Status of Repayment Request 2.Payment Lot Status
10. Returns Lot 1.Returns Lot
11. Returns Statuses 1.Item Dunning Lock 2.Item Payment Lock 3.Incoming Payment Lock for CA 4.Document Has Been Reversed 12. Returns Data 1.Return Reason 2.Short Key for a House Bank
6. Payment Run 1.Payment Run ID 2.Payment Lock Reason
5. Payment Lot 1.Payment Lot
Facts/ KPIs
1. Amount in Transaction Currency 2.Assigned Amount in Transaction Currency 3.Payment Amount 4.Contract Account Dunning Lock: Days 5.Clearing Amount in Transaction Currency 6.Exchange rate for FI postings 7.Amount in Local Currency with +/- Signs 8.Clarified Amount in Local Currency 9.Return Amount 10.Item Dunning Lock: Days 11.Incoming Payment Lock: Days 12.Partial Amount
13.Refund Repayment Number 1.Repayment Request
14. Time 1. Calendar Year/We 2. Calendar Year/Mo
5. Payment Lot Payment Lot
ncy on Currency
1. Business Partner 1. Business Partner 2.Contract Account (PartnerDependent Data)
2. Contract Account 1.Contract Account (PartnerIndependent Data)
ck: Days on Currency
h +/- Signs ency
3. Organisational Data 1. Company code 2.Country key 3. Division
ys 4. Dates 1.Date ID of Mass Activity 2.Posting date in the document 3.Document Date
14. Time 1. Calendar Year/Week 2. Calendar Year/Month
InfoObjects for Corporate Credit Analysis Description:
Technical Name:
Type
Attributes Text
Hierarchy
Business Partner Contract Account (Partner-Dependent Data)
0BPARTNER 0FC_ACCNTBP
CHAR(10) CHAR(10)
X X
Contract Account (Partner-Independent Data)
0CACONT_ACC
CHAR(12)
X
Company code Country key Division
0COMP_CODE 0COUNTRY 0DIVISION
CHAR(4) CHAR(3) CHAR(2)
X
Date ID of Mass Activity Posting date in the document Document Date
0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
DATS DATS DATS
Payment Lot
ZCHPAYLOT
CHAR(12)
Payment Run ID Payment Lock Reason
ZPAYRUNID ZCHPAYLCK
CHAR(5) Char(1)
Payment method Document Type DataSource Identifier
0PYMT_METH ZDOCTYPE ZCHDS_ID
CHAR(1) CHAR(2) CHAR(6)
X
X X X
Credit Controller BP in a BP Relationship ('Partner 2')
ZCHCRCNTR 0BPARTNER2
CHAR(10) CHAR(10)
X X
X X
Status of Repayment Request Payment Lot Status
ZCHSTREPY ZCHPAYLST
Char(1) Char(1)
Returns Lot
ZCHRTNLOT
CHAR(12)
Item Dunning Lock
ZCNDLKREA
Char(1)
Characteristics X
X
X X X
X
X X X
X
X X
X
X X
Item Payment Lock Incoming Payment Lock for CA Document Has Been Reversed
ZCH_PYLCK ZCHINPYLK ZCHDOCREV
Char(1) Char(1) Char(1)
X X X
Return Reason Short Key for a House Bank
ZCHRTNRSN ZCHHSBANK
Char(3) Char(5)
X X
Repayment Request
ZCHRPYREQ
CHAR(10)
Calendar Year/Week Calendar Year/Month
0CALWEEK 0CALMONTH
NUMC(6) NUMC(6)
Description:
Technical Name:
Type
Aggr.
Amount in Transaction Currency Assigned Amount in Transaction Currency Payment Amount Contract Account Dunning Lock: Days Clearing Amount in Transaction Currency Exchange rate for FI postings Amount in Local Currency with +/- Signs Clarified Amount in Local Currency Return Amount Item Dunning Lock: Days Incoming Payment Lock: Days Partial Amount
ZKFAMT_TC ZKFASSAMT 0FC_TO_PAY ZKFCA_DLK ZKFCLGAMT 0EXRATE_ACC 0DEB_CRE_LC ZKFCLRAMT ZKFRTNAMT ZKFDLKITM ZKFINPYLK ZKFPRTAMT
CURR CURR CURR INT4 CURR DEC CURR CURR CURR INT4 INT4 CURR
SUM SUM SUM SUM SUM SUM SUM SUM SUM SUM SUM SUM
Time Characteristics X
Key Figures
Excep. Aggr. Ref. Char
InfoCube & Update Rules for FIDT07: Corporate Credit Analysis Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea InfoCube Update Rule
Description: Infoarea for Finance & Credit Operation FIDT07: Corporate Credit Analysis Payment Lot Analysis
Technical Name: ZIA_FI ZFI_C07 8ZFI_O09
Dimensions 1)
Description Business Partner
Technical Name ZFI_C071
Update Rule Method
Business Partner Contract Account (Partner-Dependent Data)
0BPARTNER 0FC_ACCNTBP
SC SC
Contract Account
ZFI_C072
2)
Contract Account (Partner-Independent Data) 0CACONT_ACC 3)
4)
Organisational Data
ZFI_C073
Company code Country key Division
0COMP_CODE 0COUNTRY 0DIVISION
Dates Date ID of Mass Activity Posting date in the document Document Date
ZFI_C074 0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
SC
SC
SC SC
5)
6)
7)
8)
9)
Payment Lot
ZFI_C075
Payment Lot
ZCHPAYLOT
Payment Data
ZFI_C077
Payment method Document Type DataSource Identifier
0PYMT_METH ZDOCTYPE ZCHDS_ID
Employee Data
ZFI_C078
Credit Controller BP in a BP Relationship ('Partner 2')
ZCHCRCNTR 0BPARTNER2
Payment Statuses
ZFI_C079
Status of Repayment Request Payment Lot Status
ZCHSTREPY ZCHPAYLST
Time
ZFI_C07T
Calendar Year/Week Calendar Year/Month
0CALWEEK 0CALMONTH
Payment method Country key Corporate Account Team Partner:Partner Type
0FC_ACCNTBP__0PYMT_METH 0FC_ACCNTBP__0COUNTRY 0BPARTNER__ZCHCUSTCL 0BPARTNER__0BP_TYPE
Description:
Technical Name:
Type
Payment Amount Amount in Local Currency with +/- Signs
0FC_TO_PAY 0DEB_CRE_LC
SC SC
SC C
R R
SC
SC SC
Navigational Attributes
Key Figures
Assigned Amount in Transaction Currency Clarified Amount in Local Currency Partial Amount Exchange rate for FI postings
ZKFASSAMT ZKFCLRAMT ZKFPRTAMT 0EXRATE_ACC
SC SC SC SC
Key Figures 1) 2)
Open Item Number of Document Items
0FC_OI 0DOC_ITEMS
Source Key Figure Source Key Figure
Not present in Delivered BC, to be enhanced Present in Delivered BC Not present in Delivered BC, to be enhanced and custom InfoObject to be created Not Required
Details
PAYLOT
Derive Credit Con Derive Acc. Mgr
InfoCube & Update Rules for FIDT07: Corporate Credit Analysis Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea InfoCube Update Rule
Description: Infoarea for Finance & Credit Operation FIDT07: Corporate Credit Analysis Payment RUN Analysis
Dimensions 1)
Description Business Partner Business Partner Contract Account (Partner-Dependent Data)
2)
Contract Account Contract Account (Partner-Independent Data)
3)
Organisational Data Company code Country key Division
4)
Dates Date ID of Mass Activity Posting date in the document Document Date
5)
Payment Run Payment Run ID Payment Lock Reason
6)
Payment Data Payment method Document Type DataSource Identifier
7)
Employee Data Credit Controller BP in a BP Relationship ('Partner 2')
8)
Payment Statuses Status of Repayment Request
9)
Time Calendar Year/Week Calendar Year/Month
Navigational Attributes Payment method Country key Corporate Account Team Partner:Partner Type Description: Key Figures Amount in Transaction Currency Clearing Amount in Transaction Currency
Key Figures 1) 2)
Open Item Number of Document Items
Not present in Delivered BC, to be enhanced Present in Delivered BC Not present in Delivered BC, to be enhanced and custom In Not Required
Technical Name: ZIA_FI ZFI_C07 8ZFI_O10 Technical Name ZFI_C071
Update Rule Method Details
0BPARTNER 0FC_ACCNTBP
SC SC
ZFI_C072 0CACONT_ACC
SC
ZFI_C073 0COMP_CODE 0COUNTRY 0DIVISION
SC SC SC
ZFI_C074 0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
SC SC SC
ZFI_C076 ZPAYRUNID ZCHPAYLCK
SC SC
ZFI_C077 0PYMT_METH ZDOCTYPE ZCHDS_ID
SC SC C
PAYRUN
R R
Derive Credit Con Derive Acc. Mgr
ZFI_C078 ZCHCRCNTR 0BPARTNER2
ZFI_C079 ZCHSTREPY ZFI_C07T 0CALWEEK 0CALMONTH
SC SC
0FC_ACCNTBP__0PYMT_METH 0FC_ACCNTBP__0COUNTRY 0BPARTNER__ZCHCUSTCL 0BPARTNER__0BP_TYPE Technical Name: ZKFAMT_TC ZKFCLGAMT
SC SC
0FC_OI 0DOC_ITEMS
Source Key Figure Source Key Figure
BC, to be enhanced BC, to be enhanced and custom InfoObject to be created
InfoCube & Update Rules for FIDT07: Corporate Credit Analysis Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea InfoCube Update Rule
Description: Infoarea for Finance & Credit Operation FIDT07: Corporate Credit Analysis Payment RETURNS Analysis
Dimensions 1)
Description Business Partner Business Partner Contract Account (Partner-Dependent Data)
2)
Contract Account Contract Account (Partner-Independent Data)
3)
Organisational Data Company code Country key Division
4)
Dates Date ID of Mass Activity Posting date in the document Document Date
5)
Returns Lot Returns Lot
6)
Returns Statuses Item Dunning Lock Item Payment Lock Incoming Payment Lock for CA Document Has Been Reversed
7)
Returns Data Return Reason Short Key for a House Bank
8)
Payment Data Payment method Document Type DataSource Identifier
9)
Employee Data Credit Controller BP in a BP Relationship ('Partner 2')
10)
Payment Statuses Status of Repayment Request
11)
Time Calendar Year/Week Calendar Year/Month
Navigational Attributes Payment method Country key Corporate Account Team Partner:Partner Type Description: Key Figures Partial Amount Return Amount Item Dunning Lock: Days Incoming Payment Lock: Days Contract Account Dunning Lock: Days
Key Figures 1) 2)
Open Item Number of Document Items
nalysis
Not present in Delivered BC, to be enhanced Present in Delivered BC Not present in Delivered BC, to be enhanced and custom Not Required
Technical Name: ZIA_FI ZFI_C07 8ZFI_O11 Technical Name ZFI_C071
Update Rule Method Details
0BPARTNER 0FC_ACCNTBP
SC SC
ZFI_C072 0CACONT_ACC
SC
ZFI_C073 0COMP_CODE 0COUNTRY 0DIVISION ZFI_C074 0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
SC
SC SC
ZFI_C07A ZCHRTNLOT
SC
ZFI_C07B ZCNDLKREA ZCH_PYLCK ZCHINPYLK ZCHDOCREV
SC SC SC SC
ZFI_C07C ZCHRTNRSN ZCHHSBANK
SC SC
ZFI_C077 0PYMT_METH ZDOCTYPE ZCHDS_ID
SC R
RETURN
ZFI_C078 ZCHCRCNTR 0BPARTNER2
R R
ZFI_C079 ZCHSTREPY ZFI_C07T 0CALWEEK 0CALMONTH
SC SC
0FC_ACCNTBP__0PYMT_METH 0FC_ACCNTBP__0COUNTRY 0BPARTNER__ZCHCUSTCL 0BPARTNER__0BP_TYPE Technical Name: ZKFPRTAMT ZKFRTNAMT ZKFDLKITM ZKFINPYLK ZKFCA_DLK
SC SC SC SC SC
Derive Credit Con Derive Acc. Mgr
0FC_OI 0DOC_ITEMS
Source Key Figure Source Key Figure
BC, to be enhanced BC, to be enhanced and custom InfoObject to be created
InfoCube & Update Rules for FIDT07: Corporate Credit Analysis Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea InfoCube Update Rule
Description: Infoarea for Finance & Credit Operation FIDT07: Corporate Credit Analysis Payment RUFUND Analysis
Dimensions 1)
Description Business Partner Business Partner Contract Account (Partner-Dependent Data)
2)
Contract Account Contract Account (Partner-Independent Data)
3)
Organisational Data Company code Country key Division
4)
Dates Date ID of Mass Activity Posting date in the document Document Date
5)
Refund Repayment Number Repayment Request
6)
Payment Data Payment method Document Type DataSource Identifier
7)
Employee Data Credit Controller BP in a BP Relationship ('Partner 2')
8)
Payment Statuses Status of Repayment Request
9)
Time Calendar Year/Week Calendar Year/Month
Navigational Attributes Payment method Country key Corporate Account Team Partner:Partner Type Description: Key Figures Amount in Local Currency with +/- Signs Assigned Amount in Transaction Currency
Key Figures 1) 2)
Open Item Number of Document Items
Not present in Delivered BC, to be enhanced Present in Delivered BC Not present in Delivered BC, to be enhanced and custom In Not Required
Technical Name: ZIA_FI ZFI_C07 8ZFI_O12 Technical Name ZFI_C071
Update Rule Method Details
0BPARTNER 0FC_ACCNTBP
SC SC
ZFI_C072 0CACONT_ACC
SC
ZFI_C073 0COMP_CODE 0COUNTRY 0DIVISION ZFI_C074 0FC_RUNDATE 0PSTNG_DATE 0DOC_DATE
SC SC
SC
ZFI_C07D ZCHRPYREQ
SC
ZFI_C077 0PYMT_METH ZDOCTYPE ZCHDS_ID
SC SC C
REFUND
R R
Derive Credit Con Derive Acc. Mgr
ZFI_C078 ZCHCRCNTR 0BPARTNER2
ZFI_C079 ZCHSTREPY
SC
ZFI_C07T 0CALWEEK 0CALMONTH
SC SC
0FC_ACCNTBP__0PYMT_METH 0FC_ACCNTBP__0COUNTRY 0BPARTNER__ZCHCUSTCL 0BPARTNER__0BP_TYPE Technical Name: 0DEB_CRE_LC ZKFASSAMT
SC SC
0FC_OI 0DOC_ITEMS
Source Key Figure Source Key Figure
BC, to be enhanced BC, to be enhanced and custom InfoObject to be created
ODS & Update Rules for FIDT07: Corporate Credit Analysis LOT Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Update Rule Type Addition Overwrite No Update
Object InfoArea ODS Update Rule
Description: Finance & Credit Operation Payment Lot Analysis Payment Lot Data
Technical Name ZIA_FI ZFI_O09 ZTD_S_PAY_LOT_001
Key Fields
Description Payment Lot Payment Lot Item
Technical Name ZCHPAYLOT ZCHPAYITM
Update Rule Method Details Overwrite Overwrite
Data Fields
Description
Technical Name
Update Rule Type
Business Partner Contract Account (Partner-Independent Data) Contract Account (Partner-Dependent Data) Partial Clarification Exists for Payment Reconciliation Key Company code Business area Document Type Document Date Value Date Clearing Reason Changed by Changed On Time of Last Change
0BPARTNER 0CACONT_ACC 0FC_ACCNTBP ZCHPARTCL 0FC_FIKEY 0COMP_CODE 0BUS_AREA ZDOCTYPE 0DOC_DATE ZCHVALDAT 0FC_CLEARR 0CHANGEDBY 0AEDAT 0CH_AT
SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
Check sent back Post Payment on Account Clarify Payment Transaction Clarification Document Number Clarification Account Posting Date of Clarifcation Document Contract Account Document Number Name of person who created the object Date on which the record was created Time Created Payment Lot Status Payment Amount Amount in Local Currency with +/- Signs Assigned Amount in Transaction Currency Clarified Amount in Local Currency Partial Amount Exchange rate for FI postings Currency key Local currency Posting date in the document
ZCHPCHKBK ZCHPSTPOA ZCHCLAPAY ZCHCLADOC ZCHCLARAC ZCHPSDTCL ZCHCA_DOC 0CREATEDBY 0CREATEDON 0CREA_TIME ZCHPAYLST 0FC_TO_PAY 0DEB_CRE_LC ZKFASSAMT ZKFCLRAMT ZKFPRTAMT 0EXRATE_ACC 0CURRENCY 0LOC_CURRCY 0PSTNG_DATE
SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
ODS & Update Rules for FIDT07: Corporate Credit Analysis RUN Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea ODS Update Rule
Description: Finance & Credit Operation Payment Run Analysis Payment Run Data
Technical Name ZIA_FI ZFI_O10 ZTD_S_PAY_RUN_001
Key Fields
Description Date ID of Mass Activity Payment Run ID Source of the payment Indicator: Only Proposal Run Sequential Payment Number Job Number Paid Document Category Paid Document Reference
Technical Name 0FC_RUNDATE ZPAYRUNID ZCHPSRCPY ZCHPRPRUN ZCHSPAYNO ZCHJOB_NO ZCHPDOCCT ZCHPDOCRF
Data Fields
Description Reference to Business Partner Business Partner Contract Account Category Contract Account Reference Contract Account (Partner-Dependent Data) Contract Account (Partner-Independent Data) Document Date Due date for net payment Payment Lock Reason Company code Business area Division Document Type Value Date Payment method Country key Application Component Amount in Transaction Currency Clearing Amount in Transaction Currency Currency key Posting date in the document
Technical Name ZCHBP_REF 0BPARTNER 0FC_ACCTCAT ZCHCA_REF 0CACONT_ACC 0FC_ACCNTBP 0DOC_DATE 0NETDUEDATE ZCHPAYLCK 0COMP_CODE 0BUS_AREA 0DIVISION ZDOCTYPE ZCHVALDAT 0PYMT_METH 0COUNTRY 0CAAPPLK ZKFASSAMT ZKFCLGAMT 0CURRENCY 0PSTNG_DATE
Update Rule Type Addition Overwrite No Update
AY_RUN_001 Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
Update Rule Type SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
ODS & Update Rules for FIDT07: Corporate Credit Analysis RETURNS Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea ODS Update Rule
Description: Finance & Credit Operation Payment Returns Analysis Payment Return Data
Technical Name ZIA_FI ZFI_O11 ZTD_S_PAY_RETURNS_001
Key Fields
Description Business Partner Contract Account (Partner-Independent Data) Return Document Number
Technical Name 0BPARTNER 0CACONT_ACC ZCHRT_DOC
Data Fields
Description Contract Account (Partner-Dependent Data) Returns Lot Returns Item Contract Account Document Number Posting date in the document Document Date Value Date Return Reason Payment Form Number Document Has Been Reversed Short Key for a House Bank Calculate Graduated Charges Item Dunning Lock Item Payment Lock Incoming Payment Lock for CA Delete Incoming Payment Method Account Delete Outgoing Payment Method Account Event to Create Correspondence Delete Pay Method in Item Document Type Change Payment Method in Item Currency key Partial Amount Return Amount Incoming Payment Lock: Days Contract Account Dunning Lock: Days Company code Item Dunning Lock: Days
Technical Name 0FC_ACCNTBP ZCHRTNLOT ZCHRTNITM ZCHCA_DOC 0PSTNG_DATE 0DOC_DATE ZCHVALDAT ZCHRTNRSN ZCHPYFORM ZCHDOCREV ZCHHSBANK ZCHCALCHG ZCNDLKREA ZCH_PYLCK ZCHINPYLK ZCHDELPYM ZCHDLOPYM ZCH_CORR ZCHDPYITM ZDOCTYPE ZCHCPYITM 0CURRENCY ZKFPRTAMT ZKFRTNAMT ZKFINPYLK ZKFCA_DLK 0COMP_CODE ZKFDLKITM
Update Rule Type Addition Overwrite No Update
AY_RETURNS_001 Update Rule Method Overwrite Overwrite Overwrite
Details
Update Rule Type SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
ODS & Update Rules for FIDT07: Corporate Credit Analysis REFUND Update Rule Method Source Characteristics Constant Master Data Attribute Formula Routine Initial Value
SC C MDA F R IV
Object InfoArea ODS Update Rule
Description: Finance & Credit Operation Payment Refunds Analysis Payment Refund Data
Technical Name ZIA_FI ZFI_O12 ZTD_S_PAY_REFUNDS_001
Key Fields
Description Repayment Request
Technical Name ZCHRPYREQ
Data Fields
Description Company code Due date for net payment Reference for Bank Details Payment method Country key Payment Document Number Posting date in the document Name of person who created the object Entry Date Time Created Status of Repayment Request Refund Document Number Payment Lock Reason Changed by Changed On Time of Last Change Business Partner Contract Account (Partner-Independent Data) Document Type Contract Account (Partner-Dependent Data) Local currency Currency key Assigned Amount in Transaction Currency Amount in Local Currency with +/- Signs
Technical Name 0COMP_CODE 0NETDUEDATE ZCHREFBNK 0PYMT_METH 0COUNTRY ZCHPAYDOC 0PSTNG_DATE 0CREATEDBY 0ENTRYDATE 0CREA_TIME ZCHSTREPY CHRFNDDOC ZCHPAYLCK 0CHANGEDBY 0AEDAT 0CH_AT 0BPARTNER 0CACONT_ACC ZDOCTYPE 0FC_ACCNTBP 0LOC_CURRCY 0CURRENCY ZKFASSAMT 0DEB_CRE_LC
Update Rule Type Addition Overwrite No Update
AY_REFUNDS_001 Update Rule Method Overwrite
Details
Update Rule Type SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC SC
Update Rule Method Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite Overwrite
Details
InfoSource & Transfer Rules for FIDT07: Corporate Credit Analysis LOT Transfer Rule Type InfoObject Constant Formula Routine No Assignment
IO C F R NA
Object Application Component InfoSource
Description Technical Name InfoSources for Finance (Transaction ZAC_TR_FI Data) Payment Lot Data ZTD_S_PAY_LOT_001
Description Payment Lot Payment Lot Item Business Partner Contract Account Contract Acct (PD) Payment Amount Debit/Credit Amount Assigned Amt Clarified Amt in LC Partial Clarifictn. Partial Amount Reconciliation Key Company code Business area Document Type Currency Exch.rate-acct. Posting date Document Date
Communication Structure Technical Name ZCHPAYLOT ZCHPAYITM 0BPARTNER 0CACONT_ACC 0FC_ACCNTBP 0FC_TO_PAY 0DEB_CRE_LC ZKFASSAMT ZKFCLRAMT ZCHPARTCL ZKFPRTAMT 0FC_FIKEY 0COMP_CODE 0BUS_AREA ZDOCTYPE 0CURRENCY 0EXRATE_ACC 0PSTNG_DATE 0DOC_DATE
Transfer Structure DataSource Field
Transfer Rule Type
Description
IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO
Payment Lot Item number in a payment lot Business Partner Number Contract Account Number Business Partner Number Payment amount in transaction currency Amount In Local Currency With +/- Signs Assigned Amount in Transaction Currency Clarified Amount In Local Currency Partial Clarifications Exist For Payment Partial Amount that Refers to the Specified Selection Reconciliation Key for General Ledger Company Code Business Area Document Type Currency Key Exchange rate Posting Date in the Document Document Date in Document
KEYZ1 POSZA GPART VKONT GPART BETRZ BETRH BETRK BETRL XTKLA TBETR FIKEY BUKRS GSBER BLART WAERS KURSF BUDAT BLDAT
Value Date Clearing Reason Changed by Changed On Last Changed At Check sent back Post Paymnt on Acct Clarify Paymnt Trans Clarification Doc No Clarificatn Account Pstg Date Clarif Doc Contract Acct Doc No Created by Created on Time Payment Lot Status Local currency
ZCHVALDAT 0FC_CLEARR 0CHANGEDBY 0AEDAT 0CH_AT ZCHPCHKBK ZCHPSTPOA ZCHCLAPAY ZCHCLADOC ZCHCLARAC ZCHPSDTCL ZCHCA_DOC 0CREATEDBY 0CREATEDON 0CREA_TIME ZCHPAYLST 0LOC_CURRCY
IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO
Value date Clearing Reason Name of person who changed object Date of Last Change Time at Which the Object Was Last Changed Check was or will be sent back Post Payment on Account Clarify Payment Transaction Number of Clarification Document Clarification Account Posting date of clarif. doc Number of Contract Accts Rec. & Payable Doc. Name of Person who Created the Object Date on which the record was created Time at which the object was created Status of the payment lot 0CURRENCY
VALUT AUGRD AENAM AEDAT AETIM XRUES XAKON XKLAE KLAEB KLAEH KLAED OPBEL ERNAM ERDAT ERTIM STAZS LOC_CURRCY
Selection Enabled Yes Yes No No No No No No No No No No No No No No No No No
No No No Yes Yes No No No No No No No Yes No Yes No No
InfoSource & Transfer Rules for FIDT07: Corporate Credit Analysis RUN Transfer Rule Type InfoObject Constant Formula Routine No Assignment
IO C F R NA
Object Application Component InfoSource
Description Technical Name InfoSources for Finance (Transaction ZAC_TR_FI Data) Payment Run Data ZTD_S_PAY_RUN_001
Description 0FC_RUNDATE ZPAYRUNID ZCHPSRCPY ZCHPRPRUN ZCHSPAYNO 0FC_ACCTCAT ZCHCA_REF ZCHPDOCCT ZCHPDOCRF ZCHBP_REF 0PSTNG_DATE 0NETDUEDATE 0CURRENCY ZKFAMT_TC ZKFCLGAMT ZCHPAYLCK 0COMP_CODE 0BUS_AREA 0DIVISION ZDOCTYPE ZCHVALDAT 0PYMT_METH 0COUNTRY ZCHJOB_NO 0DOC_DATE 0CACONT_ACC 0BPARTNER 0CAAPPLK 0FC_ACCNTBP
Communication Structure Technical Name Run Date Payment Run ID Source of payment Proposal Run Ind. Sequential Paymnt No Contract Acct Categ. Contract Account Ref Paid Doc Category Paid Doc Reference Reference to BP Posting date Net due date Currency Amt in Trans. Curr. Clearing Amount in T Payment Lock Reason Company code Business area Division Document Type Value Date Payment method Country Job Number Document Date Contract Account Business Partner Application Comp. Contract Acct (PD)
Transfer Rule Type IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO R R C R
RUN
AY_RUN_001
Description
Transfer Structure DataSource Field
Date ID ZZLAUFD Identification for the payment run ZZLAUFI Source of the payment data ZZORIGN Indicator: Only Proposal Run? ZZXVORL Sequential payment number ZZPAYNO Contract Account Category ZZACC1T Reference to Contract Account ZZACC1R Category for paid document ZZDOC2T Reference to Paid Document ZZDOC2R Reference to Business Partner Giving Payment Instruction ZZGPA2R Posting Date in the Document ZZBUDAT Due Date of Payment ZZFAEDT Currency Key ZZWAERS Amount in Transaction Currency with +/- Sign ZZBETRW Clearing Amount in Transaction Currency (With +/- Sign)ZZAUGBW Lock Reason for Automatic Payment ZZZLSPR Company Code ZZBUKRS Business Area ZZGSBER Division ZZSPART Document Type ZZBLART Value date ZZVALUT Payment Method ZZRZAWE Country Key ZZLAND1 Additional distinguishing criterion from payments ZZSUBNO Document Date in Document ZZBLDAT Fill 0CACONT_ACC with ZZACC1R 0CACONT_ACC Fill 0BPARTNER with ZZGPA2R fi BPARTNER R Fill 0FC_ACCNTBP with ZZGPA2R 0FC_ACCNTBP
Selection Enabled Yes Yes No No No No No No No No No No No No No No No No No No No No No No No No No No No
ZZBLDAT
InfoSource & Transfer Rules for FIDT07: Corporate Credit Analysis RETURNS Transfer Rule Type InfoObject Constant Formula Routine No Assignment
IO C F R NA
Object Application Component InfoSource
Description Technical Name InfoSources for Finance (Transaction ZAC_TR_FI Data) Payment Return Data ZTD_S_PAY_RETURNS_001
Description Business Partner Contract Account Return Document No. Returns Lot Returns Item Contract Acct Doc No Partial Amount Return Amount Currency Posting date Document Date Value Date Return Reason Payment Form Number Document Reversed Calculate Charges Item Dunning Lock Itm Dunning Lck Days Item Payment Lock Inc Paymnt Lck: Days CA Dunn Lock: Days Inc. Payment Lock CA Del Inc. Pay Mthd Del Out. Pay Mthd Create Correspndence Del Pay Mthd Item Chg Pay Mthd Item Document Type Company code Key for House Bank Contract Acct (PD)
Communication Structure Technical Name 0BPARTNER 0CACONT_ACC ZCHRT_DOC ZCHRTNLOT ZCHRTNITM ZCHCA_DOC ZKFPRTAMT ZKFRTNAMT 0CURRENCY 0PSTNG_DATE 0DOC_DATE ZCHVALDAT ZCHRTNRSN ZCHPYFORM ZCHDOCREV ZCHCALCHG ZCNDLKREA ZKFDLKITM ZCH_PYLCK ZKFINPYLK ZKFCA_DLK ZCHINPYLK ZCHDELPYM ZCHDLOPYM ZCH_CORR ZCHDPYITM ZCHCPYITM ZDOCTYPE 0COMP_CODE ZCHHSBANK 0FC_ACCNTBP
Transfer Rule Type IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO
ZCHCALCHG ZCNDLKREA ZKFDLKITM ZCH_PYLCK ZKFINPYLK ZKFCA_DLK ZCHINPYLK ZCHDELPYM ZCHDLOPYM ZCH_CORR ZCHDPYITM ZCHCPYITM ZDOCTYPE 0COMP_CODE ZCHHSBANK
RETURNS
AY_RETURNS_001 Transfer Structure Description Business Partner Number Contract Account Number Number of the return document Returns Lot Item number in a returns lot Number of Contract Accts Rec. & Payable Doc. Partial Amount Of Return Return amount Currency Key Posting Date in the Document Document Date in Document Value date Return reason Payment Form Number Document Has Been Reversed Calculate Graduated Charges Dunning Lock Reason for Line Item Item dunning lock: days Payment lock reason for item Payment lock for incoming payments: Duration in days Contract acct dunn. lock: days Reason for incoming payment block for contract account Delete payment method with account instead of changing Returns Activity: Delete Outgoing Payment Method in Account Activate Event for Creating Correspondence Delete Payment Method in Item Change Pymt Meth. in Item Document Type Company Code Short key for a house bank Business Partner Number
Transfer Structure DataSource Field GPART VKONT RLBEL KEYR1 POSRA OPBEL BETRWR BETRR WAERS BUDAT BLDAT VALUT RLGRD NRZAS XSTOR XGEBS MSPOP MSPOP_DAYS PSPOP PSPOP_DAYS MSPKO_DAYS EZSKO XDELEZAWE XDELAZAWE BCORR XDELPZAWE XCORPZAWE BLART BUKRS HBKID GPART
Selection Enabled No No No No No No No No No Yes Yes No No No No No No No No No No No No No No No No No No No No
InfoSource & Transfer Rules for FIDT07: Corporate Credit Analysis REFUND Transfer Rule Type InfoObject Constant Formula Routine No Assignment
IO C F R NA
Object Application Component InfoSource
Description Technical Name InfoSources for Finance (Transaction ZAC_TR_FI Data) Payment Refund Data ZTD_S_PAY_REFUNDS_001
Description Repayment Request Company code Currency Assigned Amt Debit/Credit Amount Net due date Ref.for Bank Details Payment method Payment Doc Number Posting date Created by Entry Date Time Status of Repay Requ Refund Doc Number Payment Lock Reason Changed by Changed On Last Changed At Business Partner Contract Account Document Type Key for House Bank Local currency 0COUNTRY Contract Acct (PD)
Communication Structure Technical Name ZCHRPYREQ 0COMP_CODE 0CURRENCY ZKFASSAMT 0DEB_CRE_LC 0NETDUEDATE ZCHREFBNK 0PYMT_METH ZCHREFUND 0PSTNG_DATE 0CREATEDBY 0ENTRYDATE 0CREA_TIME ZCHSTREPY CHRFNDDOC ZCHPAYLCK 0CHANGEDBY 0AEDAT 0CH_AT 0BPARTNER 0CACONT_ACC ZDOCTYPE ZCHHSBANK 0LOC_CURRCY Country 0FC_ACCNTBP
Transfer Rule Type IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO IO C IO
ZDOCTYPE ZCHHSBANK
REFUND
AY_REFUNDS_001
Description
Transfer Structure DataSource Field
Repayment request NRZAA Company Code BUKRS Currency Key WAERS Amount in Transaction Currency with +/- Sign BETRW Amount In Local Currency With +/- Signs BETRH Due date for net payment FAEDN Reference Specifications for Bank Details BKREF Payment Method PYMET Number of Payment Document PYBEL Posting Date in the Document BUDAT Name of Person who Created the Object ERNAM Accounting Document Entry Date CPUDT Time of Entry CPUTM Status of Repayment Request STARA Document number of posting made to refund clearing account ANFBL Lock Reason for Automatic Payment SPZAH Name of person who changed object AENAM Date of Last Change AEDAT Time changed AETIM Business Partner Number GPART Contract Account Number VKONT Document Type BLART Short key for a house bank HBKID 0CURRENCY LOC_CURRCY GB Business Partner Number GPART
Selection Enabled No No No No No No No No No No No Yes No No No No No Yes No No No No No No No No
DataSource & Enhancements for FIDT07: Corporate Credit Analysis
Transaction Data Source Based View/FM/Query Application Component Extract Structure Append Structures Upload Method Selection Parameters
Transaction Data Source Based View/FM/Query Application Component Extract Structure Append Structures Upload Method Selection Parameters
Transaction Data Source Based View/FM/Query Application Component Extract Structure Append Structures Upload Method Selection Parameters
Description
Technical Name
BW Payment Lot Extractor Functional Module FI-CA Extract structure for payment lot
ZTD_S_PAY_LOT_001 ZUFI_PAYMENT_LOT_EXTRACTOR FI-CA ZSUFI_PAYMENT_LOT_EXTRACT
Full Upload Date of Last Change Time at Which the Object Was Last Changed Date on which the record was created Name of Person who Created the Object Payment Lot Item number in a payment lot
F AEDAT AETIM ERDAT ERNAM KEYZ1 POSZA
Description FI-CA: BW Payment RunExtractor Table - BW Payment Run Extractor DPAYH & DPAYP FI-CA Generated Table for View ZVPAYMENT_RUN
Technical Name ZTD_S_PAY_RUN_001 ZVPAYMENT_RUN FI-CA ZOXI2D0040
Full Upload Date ID Identification for the payment run
F ZZLAUFD ZZLAUFI
Description FI-CA: BW Payment Returns Extractor Table- BW Payment Returns Extractor DFKKRH & DFKKRK FI-CA Generated Table for View ZVPAYMENT_RET
Technical Name ZTD_S_PAY_RETURNS_001 ZVPAYMENT_RET FI-CA ZOXBID0032
Full Upload Document Date in Document
F BLDAT
Transaction Data Source Based View/FM/Query Application Component Extract Structure Append Structures Upload Method Selection Parameters
Posting Date in the Document
BUDAT
Description BW Payment Refunds Extractor Functional Module FI-CA Payment Refunds Extractor structure
Technical Name ZTD_S_PAY_REFUNDS_001 ZUFI_PAYMENT_REFUNDS_EXTRACTOR FI-CA ZSUFI_PAYMENT_REFUNDS_EXTRACT
Full Upload Date of Last Change Accounting Document Entry Date
F AEDAT CPUDT
Roles & Workbooks for FIDT07: Corporate Credit Analysis
Role
Description Authorization Object Support team role for business support in production/Finance/Corporate Debtors/Corporate Credit Report
Users
Queries
Description Corporate Credit Report
Technical Name FIN1_COR_DEB_CORP_CREDIT
Workbooks
Description Corporate Credit Report
Technical Name 4648LGFSD4OKIZ0R9M5I64FZ1
Related Documents
Sap Bw / Bi Dmd - Corporate Credit Analysis
April 2020 4
Bi Credit
June 2020 1
Bw Nterview - Sap Bw F.a.q
November 2019 33
Sap Bw Questions.docx
November 2019 19
Credit Analysis
June 2020 3
Sap Bw Reporting
October 2019 25More Documents from "Suraj Reddy"
Architecture And Roadmap
June 2020 2
Improvesapcrmeffectivity
April 2020 2
Sap Bi 7 Innovation Centre: By: Ajay Uppal
April 2020 1
Sap Esoa
April 2020 3
Checklist For Sap Application Maintenance Estimation
April 2020 1