Vendor Line Items - SAP Documentation

Vendor Line Items

Query Query: 0FIN_AP_T30_Q0001

This query returns vendor line items (tables BSIK (open items) and BSAK (cleared items)) of subledger accounting. This query is based on operational data provisioning technology.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Text Item Status	`2O0FI_DOCSTAT`
Characteristic	Clearing Date	`2O0FIN_AP_T30-AUGDT`
Characteristic	Company code	`2O0COMP_CODE`
Characteristic	Vendor	`2O0CREDITOR`
Characteristic	Posting Date	`2O0FIN_AP_T30-BUDAT`

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Company code	`2O0COMP_CODE`
Characteristic	Document Type	`2O0AC_DOC_TYP`
Characteristic	Posting Date	`2O0FIN_AP_T30-BUDAT`
Characteristic	Clearing Date	`2O0FIN_AP_T30-AUGDT`
Characteristic	Special G/L Indicator	`2O0FIN_AP_T30-UMSKZ`
Characteristic	G/L Account Number	`2O0GL_ACCOUNT`
Characteristic	Payment Method	`2O0PYMT_METH`
Characteristic	Item Text	`2O0FIN_AP_T30-SGTXT`
Characteristic	Assignment number	`2O0FIN_AP_T30-ZUONR`
Characteristic	Reference Document Number	`2O0FIN_AP_T30-XBLNR`
Characteristic	Text Item Status	`2O0FI_DOCSTAT`

Variables
Object Type	Name	Technical Name
Variable	Company Code	`0S_2OCOMP_CODE_1`
Variable	Vendor	`0S_2OCREDITOR`
Variable	Open on Key Date	`0P_2ODATE_OPEN`
Variable	Item Status	`0S_2OFI_DOCSTAT`
Variable	Clearing Date	`0S_2OCLEAR_DATE_1`
Variable	Posting Date	`0S_2OPSTNG_DATE_1`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Vendor	`2O0CREDITOR`	—
Characteristic	Document no.	`2O0FIN_AP_T30-BELNR`	—
Characteristic	Item	`2O0FIN_AP_T30-BUZEI`	—
Characteristic	Document Date	`2O0FIN_AP_T30-BLDAT`	—

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Amount in FC	`20-WRSHB-WAERS`	—
Key Figure	Amount	`20-DMSHB-LCURR`	—