Accounts receivable open item - Cockpit

In Scope

Technical: OPEN_ITEM_AR | ID: SAP-FI-OPEN_ITEM_AR-ACCOUNTS_RECEIVABLE_OPEN_ITEM

Migrates customer open items (outstanding receivables) from legacy systems into SAP S/4HANA to ensure accurate opening balances and enable continuation of accounts receivable processes post-migration. This object enables correct reconciliation...

See how this object fits into Finance

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Unknown
Typical Sources: Legacy ERPLegacy FI SystemData WarehouseAR Subledger SystemSpreadsheetStand-alone AR SystemLegacy ERP SubledgerLegacy General Ledger Trial BalanceAccounts Receivable ModuleSpreadsheet/CSV ExtractLegacy Accounts Receivable SubledgerSpreadsheetsCustomer Billing SystemTreasury SystemLegacy Accounting SystemCRM SystemsCustom Spreadsheets

Classification

Information Type: Transaction
Object Type: cockpit

Target Structure

Load Approach: Table
Target Objects: BSID

Field Definitions(5)

Rules & Considerations(129)

Sample Load Data(3)

_scenario	BUKRSRPK	MANDTRPK	FB01	FB02	FB03	BELNR	BKTXT	BLART	BLDAT	BUDAT	BUZEI	DMBTR	GJAHR	GSBER	HKONT	KOSTL	KUNNR	PARVT	PRCTR	REBZG	REBZJ	REBZZ	SGTXT	SHKZG	UMSKZ	WAERS	WRBTR	XBLNR	ZFBDT	ZLSCH	ZLSNR	ZTERM	ZUONR	DueDate	VORGANG	Currency	Customer	Reference	Assignment	CompanyCode	PostingDate	DocumentDate	DocumentType	HKONT_OFFSET	PaymentTerms	LEGACY_DOC_ID	LINE_ITEM_NUM	AmountInLocalCurrency
Example values from field definitions	1000	100	RV12345678	Z1	Q3 Services Rendered	0100000001	Migration Open Item 03/20	DR	20250315	20250315	001	1000.00	2025	SAMP	0015000000	C1000	0000123456	SA	P1000	SAMPLE	0001	0001	Invoice 12345 for Consulting Services	S	A	USD	1000.00	INV2025030001	20250315	D	SAM	0001	INV2025030001	20240415	S	USD	100100	INVOICE-2024-001	20240315100100	1000	20240316	20240315	DR	1400000000	0001	INV_2023_000123	001	1500.00
Historical closed invoice with payment received	2000	200	RV12345679	Z2	Q2 Services Rendered	0100000002	Closed Open Item 05/2023	DR	20230515	20230515	001	2000.00	2023	—	0015000000	C2000	0000123456	—	P1001	—	—	—	Invoice 67890 for Consulting Services	S	A	GBP	2000.00	INV2023050002	20230514	D	—	0002	INV2023050002	20230601	—	USD	100100	INVOICE-2023-002	20230515100101	1000	20230502	20230501	DR	1400000000	0002	INV_2023_000456	002	2200.00
Minimal data historical record with required fields only	3000	100	—	—	—	0100000003	—	DR	20210801	20210801	001	1500.00	2021	—	0015000003	—	0000654321	—	P1002	—	—	—	—	U	—	EUR	1000.02	—	20210730	—	—	0003	—	20240628	—	USD	100102	—	—	2000	20240529	20240528	DT	1400000003	—	INV_2021_000789	001	1500.02

Example values from field definitions

BUKRSRPK: 1000
MANDTRPK: 100
FB01: RV12345678
FB02: Z1
FB03: Q3 Services Rendered
BELNR: 0100000001
BKTXT: Migration Open Item 03/20
BLART: DR
BLDAT: 20250315
BUDAT: 20250315
BUZEI: 001
DMBTR: 1000.00
GJAHR: 2025
GSBER: SAMP
HKONT: 0015000000
KOSTL: C1000
KUNNR: 0000123456
PARVT: SA
PRCTR: P1000
REBZG: SAMPLE
REBZJ: 0001
REBZZ: 0001
SGTXT: Invoice 12345 for Consulting Services
SHKZG: S
UMSKZ: A
WAERS: USD
WRBTR: 1000.00
XBLNR: INV2025030001
ZFBDT: 20250315
ZLSCH: D
ZLSNR: SAM
ZTERM: 0001
ZUONR: INV2025030001
DueDate: 20240415
VORGANG: S
Currency: USD
Customer: 100100
Reference: INVOICE-2024-001
Assignment: 20240315100100
CompanyCode: 1000
PostingDate: 20240316
DocumentDate: 20240315
DocumentType: DR
HKONT_OFFSET: 1400000000
PaymentTerms: 0001
LEGACY_DOC_ID: INV_2023_000123
LINE_ITEM_NUM: 001
AmountInLocalCurrency: 1500.00

Historical closed invoice with payment received

BUKRSRPK: 2000
MANDTRPK: 200
FB01: RV12345679
FB02: Z2
FB03: Q2 Services Rendered
BELNR: 0100000002
BKTXT: Closed Open Item 05/2023
BLART: DR
BLDAT: 20230515
BUDAT: 20230515
BUZEI: 001
DMBTR: 2000.00
GJAHR: 2023
GSBER: —
HKONT: 0015000000
KOSTL: C2000
KUNNR: 0000123456
PARVT: —
PRCTR: P1001
REBZG: —
REBZJ: —
REBZZ: —
SGTXT: Invoice 67890 for Consulting Services
SHKZG: S
UMSKZ: A
WAERS: GBP
WRBTR: 2000.00
XBLNR: INV2023050002
ZFBDT: 20230514
ZLSCH: D
ZLSNR: —
ZTERM: 0002
ZUONR: INV2023050002
DueDate: 20230601
VORGANG: —
Currency: USD
Customer: 100100
Reference: INVOICE-2023-002
Assignment: 20230515100101
CompanyCode: 1000
PostingDate: 20230502
DocumentDate: 20230501
DocumentType: DR
HKONT_OFFSET: 1400000000
PaymentTerms: 0002
LEGACY_DOC_ID: INV_2023_000456
LINE_ITEM_NUM: 002
AmountInLocalCurrency: 2200.00

Minimal data historical record with required fields only

BUKRSRPK: 3000
MANDTRPK: 100
FB01: —
FB02: —
FB03: —
BELNR: 0100000003
BKTXT: —
BLART: DR
BLDAT: 20210801
BUDAT: 20210801
BUZEI: 001
DMBTR: 1500.00
GJAHR: 2021
GSBER: —
HKONT: 0015000003
KOSTL: —
KUNNR: 0000654321
PARVT: —
PRCTR: P1002
REBZG: —
REBZJ: —
REBZZ: —
SGTXT: —
SHKZG: U
UMSKZ: —
WAERS: EUR
WRBTR: 1000.02
XBLNR: —
ZFBDT: 20210730
ZLSCH: —
ZLSNR: —
ZTERM: 0003
ZUONR: —
DueDate: 20240628
VORGANG: —
Currency: USD
Customer: 100102
Reference: —
Assignment: —
CompanyCode: 2000
PostingDate: 20240529
DocumentDate: 20240528
DocumentType: DT
HKONT_OFFSET: 1400000003
PaymentTerms: —
LEGACY_DOC_ID: INV_2021_000789
LINE_ITEM_NUM: 001
AmountInLocalCurrency: 1500.02

Rule Validation Summary

Source Rule Count: 129
Governed Rule Count: 129

All objects