User manual BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART XI 3.2 FOR SAP SOLUTIONS 12.2.0.0
Lastmanuals offers a socially driven service of sharing, storing and searching manuals related to use of hardware and software : user guide, owner's manual, quick start guide, technical datasheets... DON'T FORGET : ALWAYS READ THE USER GUIDE BEFORE BUYING !!!
If this document matches the user guide, instructions manual or user manual, feature sets, schematics you are looking for, download it now. Lastmanuals provides you a fast and easy access to the user manual BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART XI 3.2. We hope that this BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART XI 3.2 user guide will be useful to you.
Lastmanuals help download the user guide BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART XI 3.2.
Manual abstract: user guide BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART XI 3.2FOR SAP SOLUTIONS 12.2.0.0
Detailed instructions for use are in the User's Guide.
[. . . ] SAP BusinessObjects Accounts Payable Rapid Mart XI 3. 2, version for SAP solutions - User Guide
Version 12. 2. 0. 0
October 2009
Copyright
© Copyright 2009 SAP AG. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
Trademarks
All rights reserved. [. . . ] The Currency source indicates which currency was used as a source for the 2nd or 3rd Local currency. The exchange rate is determined from this source currency to the 2nd or 3rd local currency. Standard Values:
· ·
1 = Translation taking first local currency as basis, i. e. , the main Local Currency or Company Code Currency was used as the currency source. 2 = Translation taking transaction (or document) currency as basis.
Currency Types Currency Types for 2nd and 3rd Local Currencies. Key identifying the role of a currency in the R/3 System. In addition to the local currency as house currency, you can manage parallel currencies with the following currency types:
200
SAP BusinessObjects Accounts Payable Rapid Mart XI 3. 2 for SAP solutions User Guide
Universe SAP Master Data Universe
5
· · · ·
Group currency Hard currency Index currency Global company currency
Monetary Currencies The Rapid Marts maintain various currencies, including:
· · ·
Benefit Currency - The monetary currency associated with personnel administration. Controlling Area Currency - The monetary currency assigned to the controlling area Group Currency - Group currency is used in the consolidated financial statements. Before the consolidation process can be completed all values in the individual financial statements must be translated from the local or transaction currency into group currency. Local (Company Code) Currency - The monetary currency assigned to the company code Transaction (Document) Currency - The monetary currency of each individual transaction document. Update Currency - Used for Euro conversion in European Union: The update currency is the currency, in addition to the local (company) currency, in which the transaction figures are updated in the general ledger. You specify whether the document or account currencies should also be the update currency in the G/L account master record.
· · ·
Monetary Exchange Rates These are the conversion rates used to convert one currency to another. They are used to compute global currency amounts in the universe.
MRP
Material Resource Planning - A term for procedures in requirements planning that take into account and plan every future requirement during the creation of order proposals such as independent requirements, and dependent requirements. Contains the following sub-classes: Mrp Controller The person responsible for a group of materials in MRP in a plant or company. Material that takes part in material requirements planning must be assigned to an MRP controller.
SAP BusinessObjects Accounts Payable Rapid Mart XI 3. 2 for SAP solutions User Guide
201
5
Universe SAP Master Data Universe
Mrp Element Type A term for all objects displayed as items in the MRP list or in the stock and requirements list. Such objects include planned orders, purchase orders, reservations, and sales orders. Mrp Group The MRP group, groups material from the material requirements planning point of view to allocate them control parameters for planning. The control parameters include the strategy group, the planning horizon and the creation indicator for the planning run. Mrp Lot Size A key that defines which lot-sizing procedure the system uses for calculating the quantity to procure in the MRP run. Mrp Profile A collection of data required for updating the material master record for planning. The MRP profile contains the necessary MRP data for the material master. This simplifies updating the material master record. When creating or changing a material master, the data in the MRP profile is copied automatically to the material master. The MRP profile defines:
· · ·
Which fields are mandatory when entering MRP data Values of these fields Which values can be overwritten (default values) or not (fixed values)
Mrp Type A key that controls the MRP procedure (MRP or reorder point) used for planning a material. [. . . ] of Reconciliation account in G/L accounting SKB1. SAKNR - Account Code (Reconciliation account in G/L accounting) LFA1-BBBNR -- International location number (part 1) LFA1-BBBSR -- International location number (part 2) Date that this row was loaded into the data warehouse Time that this row was loaded into the data warehouse
NVARCSTR
1
0
0
yes
22
NVARCSTR
60
0
0
yes
23
NVARCSTR
10
0
0
yes
24
NVARCSTR
7
0
0
yes
25
NVARCSTR
5
0
0
yes
26
LOAD_DATE
DATETIME
24
0
9
yes
27
LOAD_TIME
NVARCSTR
10
0
0
yes
28
ONETIME_ACCT_FLA G
LFA1. XCPDK - One Time Account flag
NVARCSTR
1
0
0
yes
29
OUR_ACCT_NUM
LFB1. EIKTO -- Our account number at the vendor
NVARCSTR
12
0
0
yes
30
PAYMNT_BLOCK_D ESCR PAYMNT_BLOCK_FLA G_CENTRAL
T008T. TEXTL - Payment Block Description
NVARCSTR
20
0
0
yes
31
LFA1. SPERZ - Central Payment Block
NVARCSTR
1
0
0
yes
32
PAYMNT_BLOCK_ID
LFB1. ZAHLS -- Block key for payment
NVARCSTR
1
0
0
yes
33
PAYMNT_TERM_DE SCR
TVZBT. VTEXT - Standard Payment term description
NVARCSTR
50
0
0
yes
34
PAYMNT_TERM_ID
LFB1. ZTERM - Payment terms key
NVARCSTR
4
0
0
yes
Rapid Mart Data Schema
66
Appendix Table Column Details
A
35
PLANT_ID
LFA1-WERKS Plant
NVARCSTR
4
0
0
yes
36
PLANT_NAME
T001W. NAME1 - Plant Name
NVARCSTR
30
0
0
yes
37
POR_NUM
LFA1. ESRNR -- POR subscriber number
NVARCSTR
11
0
0
yes
38
POST_BLOCK_FLAG
LFB1. SPERR - Company Code Level Posting Block
NVARCSTR
1
0
0
yes
39
POST_BLOCK_FLAG_ CENTRAL PURCH_BLOCK_FLAG _CENTRAL
LFA1. SPERR - Central Posting Block
NVARCSTR
1
0
0
yes
40
LFA1. SPERM - Central Purchasing Block
NVARCSTR
1
0
0
yes
41
SOLE_PROPR_FLAG
LFA1. STKZN -- Indicator if partner is a sole proprietor
NVARCSTR
1
0
0
yes
42
TAX_JURISDIC_NUM
LFA1. TXJCD -- Jurisdiction for tax calculation - NVARCSTR tax jurisdiction code
15
0
0
yes
43
TAX_NUM_01
LFA1. STCD1 -- Tax number 1
NVARCSTR
16
0
0
yes
44
TAX_NUM_02
LFA1. STCD2 -- Tax number 2
NVARCSTR
11
0
0
yes
45
VAT_REGISTRTN_NU M VENDOR_FULL_NA ME
LFA1. STCEG -- VAT registration number
NVARCSTR
20
0
0
yes
46
LFA1. NAME1+ LFA1. LIFNR - Full Name
NVARCSTR
120
0
0
yes
47
VENDOR_ID
PK
LFA1. LIFNR
NVARCSTR
10
0
0
no
48
VENDOR_ID_ALT_PA YEE
LFA1. LNRZA -- Account number of the alternative payee
NVARCSTR
10
0
0
yes
49
VENDOR_NAME
LFA1. NAME1 - Vendor Name 1
NVARCSTR
40
0
0
yes
Rapid Mart Data Schema
67
Appendix Table Column Details
A
VENDOR_FIN_DOC_FACT
BKPF / BSEG - Payables related Financial Documents
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
ACCT_TYPE_ID
BSEG-KOART - Account type
NVARCSTR
10
0
0
yes
2
ALLOCTN_ID
BSEG-ZUONR - Allocation number
NVARCSTR
18
0
0
yes
3
AMT_LOC
BSEG-DMBTR - Amount in local currency
DECIMAL
48
13
2
yes
4
AMT_TAX_LOC
BSEG-MWSTS - Tax amount in local currency DECIMAL
48
13
2
yes
5
AMT_TAX_TRX
BSEG-WMWST - Tax amount in document currency BSEG-WRBTR - Amount in document currency
DECIMAL
48
13
2
yes
6
AMT_TRX
DECIMAL
48
13
2
yes
7
ASSET_MAIN_ID
BSEG-ANLN1 - Asset main number
NVARCSTR
12
0
0
yes
8
ASSET_SUB_ID
BSEG-ANLN2 - Asset sub-number
NVARCSTR
4
0
0
yes
9
BUS_AREA_ID
BKPF-GSBER - Business area
NVARCSTR
4
0
0
yes
10
CHANGE_DATE
BKPF-AEDAT - Date of the last document change by transaction
DATETIME
24
0
9
yes
11
CLEARED_DATE
BSEG-AUGDT - Clearing date
DATETIME
24
0
9
yes
12
CLEARED_FLAG
"O" = Open, "C" = Cleared (Closed)
NVARCSTR
1
0
0
yes
13
CLEARNG_DOC_ID
BSEG-AUGBL - Document number of the clearing document
NVARCSTR
10
0
0
yes
14
CMPNY_CODE_ID
PK
BKPF-BUKRS - Company code
NVARCSTR
4
0
0
no
15
COST_CNTR_ID
BSEG-KOSTL - Cost center
NVARCSTR
10
0
0
yes
16
CTRL_AREA_ID
BSEG-KOKRS - Controlling area
NVARCSTR
4
0
0
yes
Rapid Mart Data Schema
68
Appendix Table Column Details
A
17
CURR_ID_GBL
Global Currency ID
NVARCSTR
5
0
0
yes
18
CURR_ID_GRP
BKPF-KZWRS - Currency key for the group currency
NVARCSTR
5
0
0
yes
19
CURR_ID_LOC
Local (Company code) Currency ID
NVARCSTR
5
0
0
yes
20
CURR_ID_TRX
BKPF-WAERS - Currency key
NVARCSTR
5
0
0
yes
21
DOC_DATE
PK
BKPF-BLDAT - Date of the document
DATETIME
24
0
9
no
22
DOC_TYPE_ID
BKPF-BLART - Document type
NVARCSTR
2
0
0
yes
23
DR_CR_ID
BSEG-SHKZG - Debit/credit indicator
NVARCSTR
10
0
0
yes
24
ENTRY_DATE
BKPF-CPUDT - Accounting document entry date
DATETIME
24
0
9
yes
25
EXCH_TYPE_ID_GBL
Global Exch. Rate Type
NVARCSTR
4
0
0
yes
26
FIN_DOC_ID
PK
BKPF-BELNR - Accounting document number NVARCSTR
10
0
0
no
27
FIN_DOC_STATUS_ID
BKPF-BSTAT - Document status
NVARCSTR
10
0
0
yes
28
FISC_PERIOD
PK
BKPF-MONAT - Fiscal period
INTEGER
4
0
0
no
29
FISC_YEAR
PK
BKPF-GJAHR - Fiscal year
INTEGER
4
0
0
no
30
FISC_YR_VARIANT_ID
Fiscal Year Variant in SAP
NVARCSTR
2
0
0
yes
31
INTERNAL_ORDER_ID
BSEG-AUFNR - Order number
NVARCSTR
12
0
0
yes
32
LINE_ITEM_ID
PK
BSEG-BUZEI - Line item number within the accounting document
NVARCSTR
3
0
0
no
33
LINE_ITEM_TXT
BSEG-SGTXT - Line item text
NVARCSTR
50
0
0
yes
34
LOAD_DATE
Load date
DATETIME
24
0
9
yes
Rapid Mart Data Schema
69
Appendix Table Column Details
A
35
LOAD_TIME
Load Time
NVARCSTR
8
0
0
yes
36
MATERIAL_ID
BSEG-MATNR - Material number
NVARCSTR
18
0
0
yes
37
PLANT_ID
BSEG. WERKS - Plant
NVARCSTR
4
0
0
yes
38
POST_DATE
PK
BKPF-BUDAT - Posting date in the document
DATETIME
24
0
9
no
39
POST_KEY_ID
BSEG-BSCHL - Posting key
NVARCSTR
2
0
0
yes
40
PURCH_DOC_ID
BSEG-EBELN - Purchasing document number NVARCSTR
10
0
0
yes
41
PURCH_LINE_ITEM_I D
BSEG-EBELP - Item number of purchasing document
NVARCSTR
5
0
0
yes
42
REF_DOC_ID
BKPF-XBLNR - Reference document number
NVARCSTR
16
0
0
yes
43
SPECL_GL_ID
BSEG-UMSKZ - Special G/L indicator
NVARCSTR
1
0
0
yes
44
SPECL_GL_TRX_TYP E TRADING_PARTNER_I D
BSEG-UMSKS - Special G/L transaction type
NVARCSTR
1
0
0
yes
45
BSEG-VBUND - Trading partner ID
NVARCSTR
6
0
0
yes
46
UPDT_DATE
BKPF-UPDDT - Date of the last document update BSEG-LIFNR - Vendor (creditor) account number
DATETIME
24
0
9
yes
47
VENDOR_ID
NVARCSTR
10
0
0
yes
Rapid Mart Data Schema
70
Appendix Table Column Details
A
VENDOR_FIN_DOC_FACT_BAD
BKPF / BSEG - Invalid Payables related Financial Documents
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
ACCT_TYPE_ID
BSEG-KOART - Account type
NVARCSTR
10
0
0
yes
2
ALLOCTN_ID
BSEG-ZUONR - Allocation number
NVARCSTR
18
0
0
yes
3
AMT_LOC
BSEG-DMBTR - Amount in local currency
DECIMAL
48
13
2
yes
4
AMT_TAX_LOC
BSEG-MWSTS - Tax amount in local currency DECIMAL
48
13
2
yes
5
AMT_TAX_TRX
BSEG-WMWST - Tax amount in document currency BSEG-WRBTR - Amount in document currency
DECIMAL
48
13
2
yes
6
AMT_TRX
DECIMAL
48
13
2
yes
7
ASSET_MAIN_ID
BSEG-ANLN1 - Asset main number
NVARCSTR
12
0
0
yes
8
ASSET_SUB_ID
BSEG-ANLN2 - Asset sub-number
NVARCSTR
4
0
0
yes
9
BUS_AREA_ID
BKPF-GSBER - Business area
NVARCSTR
4
0
0
yes
10
CHANGE_DATE
BKPF-AEDAT - Date of the last document change by transaction
NVARCSTR
10
0
0
yes
11
CLEARED_DATE
BSEG-AUGDT - Clearing date
NVARCSTR
10
0
0
yes
12
CLEARED_FLAG
"O" = Open, "C" = Cleared (Closed)
NVARCSTR
1
0
0
yes
13
CLEARNG_DOC_ID
BSEG-AUGBL - Document number of the clearing document
NVARCSTR
10
0
0
yes
14
CMPNY_CODE_ID
PK
BKPF-BUKRS - Company code
NVARCSTR
4
0
0
no
15
COST_CNTR_ID
BSEG-KOSTL - Cost center
NVARCSTR
10
0
0
yes
16
CTRL_AREA_ID
BSEG-KOKRS - Controlling area
NVARCSTR
4
0
0
yes
Rapid Mart Data Schema
71
Appendix Table Column Details
A
17
CURR_ID_GBL
Global Currency ID
NVARCSTR
5
0
0
yes
18
CURR_ID_GRP
BKPF-KZWRS - Currency key for the group currency
NVARCSTR
5
0
0
yes
19
CURR_ID_LOC
Local (Company code) Currency ID
NVARCSTR
5
0
0
yes
20
CURR_ID_TRX
BKPF-WAERS - Currency key
NVARCSTR
5
0
0
yes
21
DI_ERROR_ACTN
DI Error Action
NVARCSTR
1
0
0
yes
22
DI_ERROR_COLUMN
DI Error Columns
NVARCSTR
500
0
0
yes
23
DOC_DATE
PK
BKPF-BLDAT - Date of the document
NVARCSTR
10
0
0
no
24
DOC_TYPE_ID
BKPF-BLART - Document type
NVARCSTR
2
0
0
yes
25
DR_CR_ID
BSEG-SHKZG - Debit/credit indicator
NVARCSTR
1
0
0
yes
26
ENTRY_DATE
BKPF-CPUDT - Accounting document entry date
NVARCSTR
10
0
0
yes
27
EXCH_TYPE_ID_GBL
Global Exch. Rate Type
NVARCSTR
4
0
0
yes
28
FIN_DOC_ID
PK
BKPF-BELNR - Accounting document number NVARCSTR
10
0
0
no
29
FIN_DOC_STATUS_ID
BKPF-BSTAT - Document status
NVARCSTR
10
0
0
yes
30
FISC_PERIOD
PK
BKPF-MONAT - Fiscal period
INTEGER
4
0
0
no
31
FISC_YEAR
PK
BKPF-GJAHR - Fiscal year
DECIMAL
48
28
0
no
32
FISC_YR_VARIANT_ID
Fiscal Year Variant in SAP
NVARCSTR
2
0
0
yes
33
INTERNAL_ORDER_ID
BSEG-AUFNR - Order number
NVARCSTR
12
0
0
yes
34
LINE_ITEM_ID
PK
BSEG-BUZEI - Line item number within the accounting document
NVARCSTR
3
0
0
no
Rapid Mart Data Schema
72
Appendix Table Column Details
A
35
LINE_ITEM_TXT
BSEG-SGTXT - Line item text
NVARCSTR
50
0
0
yes
36
LOAD_DATE
PK
Load date
DATETIME
24
0
9
no
37
LOAD_TIME
Load Time
NVARCSTR
8
0
0
yes
38
MATERIAL_ID
BSEG-MATNR - Material number
NVARCSTR
18
0
0
yes
39
PLANT_ID
BSEG. WERKS - Plant
NVARCSTR
4
0
0
yes
40
POST_DATE
PK
BKPF-BUDAT - Posting date in the document
NVARCSTR
10
0
0
no
41
POST_KEY_ID
BSEG-BSCHL - Posting key
NVARCSTR
2
0
0
yes
42
PURCH_DOC_ID
BSEG-EBELN - Purchasing document number NVARCSTR
10
0
0
yes
43
PURCH_LINE_ITEM_I D
BSEG-EBELP - Item number of purchasing document
NVARCSTR
5
0
0
yes
44
REF_DOC_ID
BKPF-XBLNR - Reference document number
NVARCSTR
16
0
0
yes
45
SPECL_GL_ID
BSEG-UMSKZ - Special G/L indicator
NVARCSTR
1
0
0
yes
46
SPECL_GL_TRX_TYP E TRADING_PARTNER_I D
BSEG-UMSKS - Special G/L transaction type
NVARCSTR
1
0
0
yes
47
BSEG-VBUND - Trading partner ID
NVARCSTR
6
0
0
yes
48
UPDT_DATE
BKPF-UPDDT - Date of the last document update BSEG-LIFNR - Vendor (creditor) account number
NVARCSTR
10
0
0
yes
49
VENDOR_ID
NVARCSTR
10
0
0
yes
Rapid Mart Data Schema
73
Appendix Table Column Details
A
VENDOR_ITEM_AP_BALANCE_VIEW
The view determines the Open AP Bal per fiscal period.
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
AMT_PER_ROLLING_ LOC
Sum Local Currency Rolling Periods Amount
DECIMAL
48
28
7
yes
2
AMT_TTL_DUE_LOC
Sum of (Local Currency Amount + Local Currency Tax Amount)
DECIMAL
48
28
7
yes
3
AMT_TTL_LOC
Sum of Local Currency Amount
DECIMAL
48
28
7
yes
4
AMT_TTL_SALES_LO C
Sum of Local Currency Sales Amount
DECIMAL
48
28
7
yes
5
AMT_TTL_TAX_LOC
Sum of Local Currency Tax Amount
DECIMAL
48
28
7
yes
6
CMPNY_CODE_ID
Company code
NVARCSTR
4
0
0
no
7
FISC_PERIOD
Fiscal period
INTEGER
4
4
0
yes
8
FISC_YEAR
Fiscal year
INTEGER
4
4
0
no
9
VENDOR_ID
Vendor
NVARCSTR
10
0
0
no
Rapid Mart Data Schema
74
Appendix Table Column Details
A
VENDOR_ITEM_FACT
BSIK / BSAK - Open and Closed Vendor Items
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
ACCTNG_CLERK_ID
SKB1. BUSAB - Accounting clerk ID
NVARCSTR
2
0
0
yes
2
AGING_INTERVAL_ID
Aging Interval ID
DECIMAL
48
28
0
yes
3
ALLOCATN_ID
PK
Allocation ID
NVARCSTR
18
0
0
no
4
AMT_DISCNT_TAKEN _LOC AMT_DUE_IN_E_DAY S_LOC AMT_DUE_IN_F_DAY S_LOC AMT_DUE_IN_G_DAY S_LOC AMT_DUE_OVER_G _DAYS_LOC AMT_ELIGBL_FOR_DI SCNT_TRX
Discount amount taken
DECIMAL
48
13
2
yes
5
Value of the invoice if paid within the first forecast period Value of the invoice if paid within the second forecast period Value of the invoice if paid within the third forecast period
DECIMAL
48
13
2
yes
6
DECIMAL
48
13
2
yes
7
DECIMAL
48
13
2
yes
8
Amount due in more than interval "G" days
DECIMAL
48
13
2
yes
9
Amount of invoice that can be discounted as appropriate
DECIMAL
48
13
2
yes
10
AMT_LOC
Amount in local (company) currency Local currency amount paid during the first discount period (includes any discounts applicable) Local currency amount paid after the first and during the second discount period (includes any discounts applicable) Paid after due date Local currency amount paid before due date and after any discount periods (includes only non-time-related discounts Local currency amount paid by due date (includes any discounts applicable) Local currency amount if the first measuring period after net due date has past
DECIMAL
48
13
2
yes
11
AMT_PAID_DISCNT_P ER01_LOC AMT_PAID_DISCNT_P ER02_LOC
DECIMAL
48
13
2
yes
12
DECIMAL
48
13
2
yes
13
AMT_PAID_LATE_LOC
DECIMAL
48
13
2
yes
14
AMT_PAID_NET_LOC
DECIMAL
48
13
2
yes
15
AMT_PAID_ON_TIME_ LOC AMT_PAST_DUE_GT_ A_LOC
DECIMAL
48
13
2
yes
16
DECIMAL
48
13
2
yes
Rapid Mart Data Schema
75
Appendix Table Column Details AMT_PAST_DUE_GT_ B_LOC AMT_PAST_DUE_GT_ C_LOC AMT_PAST_DUE_GT_ D_LOC AMT_PD_GT_A_LATE _LOC AMT_PD_GT_B_LATE _LOC AMT_PD_GT_C_LATE _LOC AMT_PD_GT_D_LATE _LOC Local currency amount if the second measuring DECIMAL period after net due date has past Local currency amount if the third measuring period after net due date has past Local currency amount if the fourth measuring period after net due date has past Local currency amount paid after the first measuring period after due date Local currency amount paid after the second measuring period after due date Local currency amount paid after the third measuring period after due date Local currency amount paid after the fourth measuring period after due date
A
17
48
13
2
yes
18
DECIMAL
48
13
2
yes
19
DECIMAL
48
13
2
yes
20
DECIMAL
48
13
2
yes
21
DECIMAL
48
13
2
yes
22
DECIMAL
48
13
2
yes
23
DECIMAL
48
13
2
yes
24
AMT_TAX_LOC
Tax amount in local (company) currency
DECIMAL
48
13
2
yes
25
AMT_TAX_TRX
Tax amount in document currency
DECIMAL
48
13
2
yes
26
AMT_TRX
Amount in document currency
DECIMAL
48
13
2
yes
27
AMT_TTL_PAST_DUE _LOC
Local currency amount where net due date is past BSIK. PSWBT or BSAK. PSWBT - Update Currency Amt. Past Due * Number of Days Past Due
DECIMAL
48
13
2
yes
28
AMT_UPDT
DECIMAL
48
13
2
yes
29
AMT_WEIGHT_PAST_ DUE_LOC
DECIMAL
48
15
2
yes
30
BANK_ID_HOUSE
ID for one house bank
NVARCSTR
5
0
0
yes
31
BASELINE_DATE
Date from which all due and late dates are calculated Document number of the associated billing document
DATETIME
24
0
9
yes
32
BILLING_DOC_ID
NVARCSTR
10
0
0
yes
33
BUS_AREA_ID
Business area
NVARCSTR
4
0
0
yes
34
CASH_DISCNT_PRCN T_01
Discount Percent if paid by first discount period DECIMAL
48
5
3
yes
Rapid Mart Data Schema
76
Appendix Table Column Details CASH_DISCNT_PRCN T_02 Discount Percent if paid by second discount period T001. KTOPL - Chart of Accounts (Company Code)
A
35
DECIMAL
48
5
3
yes
36
CHART_OF_ACCT_ID
NVARCSTR
4
0
0
yes
37
CLEARED_DATE
PK
Date document cleared
DATETIME
24
0
9
no
38
CLEARED_FLAG
"O" if item is open; "C" if item is cleared
NVARCSTR
1
0
0
yes
39
CLEARNG_DOC_ID
PK
Document number of the clearing document
NVARCSTR
10
0
0
no
40
CMPNY_CODE_ID
PK
Company code
NVARCSTR
4
0
0
no
41
CURR_ID_GBL
Global Currency ID from $G_GLOBAL_CURRENCY variable
NVARCSTR
5
0
0
yes
42
CURR_ID_GRP
BKPF. KZWRS - Group Currency ID
NVARCSTR
5
0
0
yes
43
CURR_ID_LOC
BKPF. HWAER - Local Currency ID
NVARCSTR
5
0
0
yes
44
CURR_ID_TRX
Currency type of the document
NVARCSTR
5
0
0
yes
45
CURR_ID_UPDT
BSIK. PSWSL or BSAK. PSWSL - Update Currency ID Number of days after NEW NET DUE DATE amount was paid Number of days the item was/is open: LOADDATE - POSTING_DATE if still open; CLEARING_DATE - POSTING_DATE if cleared.
NVARCSTR
5
0
0
yes
46
DAYS_LATE
DECIMAL
48
28
0
yes
47
DAYS_OPEN
DECIMAL
48
28
0
yes
48
DAYS_PAST_DUE
Number of days since due date if item still open DECIMAL and past due
48
28
0
yes
49
DISCNT_PERIOD_01
Number of days in the first discount period
DECIMAL
48
28
0
yes
50
DISCNT_PERIOD_02
Number of days in the second discount period
DECIMAL
48
28
0
yes
51
DOC_DATE
Date of the actual document
DATETIME
24
0
9
yes
52
DOC_TYPE_ID
Financial document type
NVARCSTR
2
0
0
yes
Rapid Mart Data Schema
77
Appendix Table Column Details
A
53
DR_CR_ID
Debit or credit indicator
NVARCSTR
10
0
0
yes
54
ENTRY_DATE
Date of entry by accounting
DATETIME
24
0
9
yes
55
EXCH_TYPE_ID_GBL
Global Exchg. [. . . ]
DISCLAIMER TO DOWNLOAD THE USER GUIDE BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART XI 3.2 Lastmanuals offers a socially driven service of sharing, storing and searching manuals related to use of hardware and software : user guide, owner's manual, quick start guide, technical datasheets... In any way can't Lastmanuals be held responsible if the document you are looking for is not available, incomplete, in a different language than yours, or if the model or language do not match the description. Lastmanuals, for instance, does not offer a translation service. Click on "Download the user manual" at the end of this Contract if you accept its terms, the downloading of the manual BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART XI 3.2 will begin.