Vendor Line Item List - SAP Documentation

Vendor Line Item List

Query Query: /RWC/Q_BSIK_01

This query lists the vendor line items that are made available by the VirtualProvider for Table BSIK. Using the report-report interface, you can call the details for an item (query Vendor Line Item Display Detail).

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	ILM Audit Package	`/ILM/WORKP`	Variable, required entry, single value
Characteristic	Company Code	`/RWC/CBUKRS`	Variable
Characteristic	Account Number of Vendor or Creditor	`/RWC/CLIFNR`	Variable
Characteristic	Country Key	`/RWC/CLIFNR__/RWC/CLAND1_GP`	Variable
Characteristic	Postal Code	`/RWC/CLIFNR__/RWC/CPSTLZ`	Variable
Characteristic	Reconciliation Account in General Ledger	`/RWC/CLIFNR__/RWC/CAKONT`	Variable
Characteristic	Fiscal year	`0FISCYEAR`	Variable
Characteristic	Fiscal Year Variant	`0FISCVARNT`	Variable
Characteristic	Document type	`/RWC/CBLART`	Variable
Characteristic	Posting Date in the Document	`/RWC/CBUDAT`	Variable
Characteristic	Fiscal period	`/RWC/CMONAT`	Variable

Variables
Object Type	Name	Technical Name
Variable	Fiscal period	`/RWC/VMONAT`
Variable	Posting Date in the Document	`/RWC/VBUDAT`
Variable	Document type	`/RWC/VBLART`
Variable	Fiscal Year Variant	`/RWC/VFISCVARNT`
Variable	Fiscal year	`/RWC/VGJAHR`
Variable	Reconciliation Account in General Ledger	`/RWC/VAKONT`
Variable	Postal Code	`/RWC/VPSTLZ`
Variable	Country Key	`/RWC/VLAND1_GP`
Variable	Account Number of Vendor or Creditor	`/RWC/VLIFNR`
Variable	Company Code	`/RWC/VBUKRS`
Variable	Audit Package	`/RWC/VWORKP`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Company Code	`/RWC/CBUKRS`
Characteristic	Account Number of Vendor or Creditor	`/RWC/CLIFNR`
Characteristic	Reconciliation Account in General Ledger	`/RWC/CLIFNR__/RWC/CAKONT`
Characteristic	Country Key	`/RWC/CLIFNR__/RWC/CLAND1_GP`
Characteristic	Postal Code	`/RWC/CLIFNR__/RWC/CPSTLZ`
Characteristic	Assignment number	`/RWC/CDZUONR`
Characteristic	Accounting Document Number	`/RWC/CBELNR_D`
Characteristic	Fiscal year	`0FISCYEAR`
Characteristic	Document type	`/RWC/CBLART`
Characteristic	Posting Date in the Document	`/RWC/CBUDAT`
Characteristic	Document Number of the Clearing Document	`/RWC/CAUGBL`
Characteristic	Clearing Date	`/RWC/CAUGDT`
Characteristic	Posting Key	`/RWC/CBSCHL`
Characteristic	Tax on sales/purchases code	`/RWC/CMWSKZ`

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Amount in local currency	`/RWC/KDMBTR`	—
Key Figure	Amount in document currency	`/RWC/KWRBTR`	—
Key Figure	Tax Amount in Local Currency	`/RWC/KMWSTS`	—
Key Figure	Tax amount in document currency	`/RWC/KWMWST`	—
Key Figure	Amount Eligible for Cash Discount in Document Currency	`/RWC/KSKFBT`	—
Key Figure	Cash Discount Amount in Local Currency	`/RWC/KSKNTO`	—
Key Figure	Cash discount amount in document currency	`/RWC/KWSKTO`	—
Key Figure	Cash discount percentage 1	`/RWC/KDZBD1P`	—
Key Figure	Cash discount days 1	`/RWC/KDZBD1T`	—
Key Figure	Cash Discount Percentage 2	`/RWC/KDZBD2P`	—
Key Figure	Net Payment Terms Period	`/RWC/KDZBD3T`	—

Report/Report Interfaces
Name	Technical Name
Vendor Line Item Display Detail	`/RWC/Q_BSIK_02`