IOA Document Number

: 0PPS_FPIA_DGDOCN_ATTR

This DataSource extracts master data attributes of IOA related documents from the following tables in the ECC source system:

FPIA_INTEREST
FPIA_FI_IDX
MM documents: RBKP
FI documents: BKPF
BSEG
FMIFIIT

Extractor: 0PPS_FPIA_GET_DGDOCN_ATTR
Extract structure OLTP: FPIA_S_PROCTIMEATT

Technical Data

Application Component	IOA Interest on Arrears (FPIA_IOA_IOA_IO)
Available as of Release	SAP FPIA Add-On based on SAP ERP 6.0 Support Package 11
Shipment	SAP Netweaver 7.00 BI Content 703 Support Package 19
Content Versions	FPIA02
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Prerequisites

The prerequisites of DataSource 0PPS_FPIA_DGDOCN_ATTR are based on the prerequisites of the FI DataSources 0PPS_FPIA_IOAIOA_LITEM_OC.

Data Modeling

Delta Update

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`ACC_DOC_EXIST`	Accounting Document Exists	`FPIA_INTEREST`	`ACC_DOC_EXIST`
`AUGDT`	Clearing Date	`BSEG`	`AUGDT`
`BELNR`	Document Number of an Invoice Document	`FPIA_INTEREST, FPIA_FI_IDX`	`BELNR`
`BELNR_MM`	Document Number of an Invoice Document	`FPIA_INTEREST`	`BELNR_MM`
`BUDAT`	Posting Date in the Document	`RBKP, VBKPF, BKPF`	`BUDAT`
`BUDAT_MM`	Posting Date in the Document	`RBKP`	`BUDAT_MM`
`BUKRS`	Company Code	`RBKP, FPIA_FI_IDX`	`BUKRS`
`CHANGED_AT`	Record Changed At (Time Stamp)	`FPIA_INTEREST`	`CHANGED_AT`
`CHANGED_BY`	Record Last Changed By	`FPIA_INTEREST`	`CHANGED_BY`
`CLIENT`	Client	`FPIA_INTEREST, FPIA_FI_IDX`	`CLIENT`
`CREATED_AT`	Record Created At (Time Stamp)	`FPIA_INTEREST`	`CREATED_AT`
`CREATED_BY`	Record Created By	`FPIA_INTEREST`	`CREATED_BY`
`EBELN`	Purchasing Document Number	`BSEG`	`EBELN`
`FIPOS`	Commitment Item	`(VBSEGS), FMIFIIT`	`FIPEX`
`FISCPER`	Fiscal year / period
`FISCVAR`	Fiscal year variant	`T001`	`PERIV`
`FPIA_IOABDAT`	IOA Start Date
`FPIA_IOADOCN`	Document Number of an Invoice Document	`FPIA_INTEREST, FPIA_FI_IDX`	`FPIA_IOADOCN`
`FPIA_IOADTYPE`	IOA Document Type
`FPIA_IOAEDAT`	IOA End Date
`FPIA_IOASTA`	BW: IOA Document Status
`FPIA_IOASTYPE`	IOA Document subtype
`FPIA_DOCDEL`	Document deleted
`GJAHR`	Fiscal Year	`FPIA_INTEREST, FPIA_FI_IDX`	`GJAHR`
`INT_DOC_EXIST`	Interest Document Exists	`FPIA_INTEREST`	`INT_DOC_EXIST`
`INV_VALIDATION_A`	Time Stamp of Invoice Validation by Accountant	`FPIA_INTEREST`	`INV_VALIDATION_A`
`INV_VALIDATION_B`	Time Stamp of Invoice Validation by Budget Responsible	`FPIA_INTEREST`	`INV_VALIDATION_B`
`LONGNUM`	Long Procurement Document Number	`/SAPPSPRO/EADD`	`LONGNUM`
`REASON_AC`	Suspension Reason of Accountant	`FPIA_INTEREST`	`REASON_AC`
`REASON_BR`	Suspension Reason of Budget Responsible	`FPIA_INTEREST`	`REASON_BR`
`REC_DATE_AC`	Date of Invoice Receipt by Accountant	`FPIA_INTEREST`	`REC_DATE_AC`
`REC_DATE_BR`	Date of Invoice Receipt by Budget Responsible	`FPIA_INTEREST`	`REC_DATE_BR`
`REINDAT`	Invoice Receipt Date	`RBKP, VBKPF`	`REINDAT`
`VZSKZ`	Interest calculation indicator	`FPIA_INTEREST`	`VZSKZ`
`ZFBDT`	Baseline Date for Due Date Calculation	`FPIA_INTEREST, FPIA_FI_IDX`	`ZFBDT`
`ZTERM`	Terms of Payment Key	`FPIA_INTEREST, FPIA_FI_IDX`	`ZTERM`

Extractor Logic

FISCPER is derived from the fiscal year variant (FISCVAR) and the fiscal year (GJAHR).

Field FPIA_IOASTYPE can have the following values:

"M" - MM invoice
"R" - FPIA_INTEREST-LINE_TYPE = ‘RT’
"I" - the document is contained in INTITIT
"J" - the document has interest documents in INTITIT
"D" - FPIA_INTEREST-LINE_TYPE = ‘DR’
"V" - FPIA_INTEREST-LINE_TYPE = ‘DC’
"C" - FPIA_INTEREST-LINE_TYPE = ‘CM’
"F" - other

A IOA start date (FPIA_IOABDAT) is derived from the invoice receipt date for a budget responsible and the baseline date for due date calculation. The default value is the baseline date for due date calculation . If the invoice receipt data for the budget responsible has been entered, the IOA start date is derived from theinvoice receipt data for the budget responsible.

A IOA end date (FPIA_IOAEDAT) is derived from the IOA start date (FPIA_IOABDAT), the clearing date (BSEG-AUGDT) and the system date (SY-DATUM). The default value is the IOA start date. If there is no IOA start date or the clearing data, the IOA end date is derived from the system date.

Field FPIA_IOADTYPE can have the following values:

"R" - FPIA_INTEREST-LINE_TYPE = ‘RT’
"M" - MM invoice
"F" - other

Field FPIA_IOASTA can have the following values:

"C" - a clearing date (BSEG-AUGDT) has been entered
"R" - the indicator for clearing reversal (BSEG-XRAGL) is selected
"P" - the document is contained in VBKPF or the invoice status of an invoice receipt (RBKP-RBSTAT) has the values of "A" (parked), "B" (parked and completed), "C" (parked and held), "D" (entered and held) or "E" (parked and released)
"O" - other

The document deleted field FPIA_DOCDEL is derived from document status. If the document is an FI document and the document status (BKPF-BSTAT) has the value "Z", or if this is an MM document and the invoice document status is "X", this field has the value "X". If not, field FPIA_DOCDEL is empty.