SAP BIL_S_IL_PRT_INTERFACE Invoice Lists: Interface Structure for Adobe Print Table data and field list

BIL_S_IL_PRT_INTERFACE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Invoice Lists: Interface Structure for Adobe Print" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BIL_S_IL_PRT_INTERFACE TYPE BIL_S_IL_PRT_INTERFACE.

The BIL_S_IL_PRT_INTERFACE table consists of various fields, each holding specific information or linking keys about Invoice Lists: Interface Structure for Adobe Print data available in SAP. These include VBRK (), MANDT (Client), VBELN (Billing Document), FKART (Billing Type)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

BIL_S_IL_PRT_INTERFACE structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP BIL_S_IL_PRT_INTERFACE structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BIL_S_IL_PRT_INTERFACE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
HEAD_DETAIL				0
VBRK				0
MANDT	Client	MANDT	CLNT	3			MANDT
VBELN	Billing Document	VBELN_VF	CHAR	10		ALPHA	VBELN	VF
FKART	Billing Type	FKART	CHAR	4			FKART
FKTYP	Billing category	FKTYP	CHAR	1			FKTYP
VBTYP	SD document category	VBTYP	CHAR	1			VBTYP
WAERK	SD Document Currency	WAERK	CUKY	5			WAERS	FWS
VKORG	Sales Organization	VKORG	CHAR	4			VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2			VTWEG	VTW	C_VTWEG
KALSM	Sales and Distribution: Pricing Procedure in Pricing	KALSMASD	CHAR	6			KALSM
KNUMV	Number of the document condition	KNUMV	CHAR	10			KNUMV
VSBED	Shipping Conditions	VSBED	CHAR	2			VSBED
FKDAT	Billing date for billing index and printout	FKDAT	DATS	8			DATUM
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
POPER	Posting period	POPER	NUMC	3			POPER	POPR
KONDA	Price group (customer)	KONDA	CHAR	2			KONDA	VKA
KDGRP	Customer group	KDGRP	CHAR	2			KDGRP	VKD
BZIRK	Sales district	BZIRK	CHAR	6			BZIRK	BZI
PLTYP	Price list type	PLTYP	CHAR	2			PLTYP	VPL
INCO1	Incoterms (Part 1)	INCO1	CHAR	3			INCO1
INCO2	Incoterms (Part 2)	INCO2	CHAR	28			INCO2
EXPKZ	Export indicator	EXPKZ	CHAR	1			EXPKZ
RFBSK	Status for transfer to accounting	RFBSK	CHAR	1			RFBSK
MRNKZ	Manual invoice maintenance	MRNKZ	CHAR	1			XFELD
KURRF	Exchange rate for FI postings	KURRF	DEC	9(5)			KURRF
CPKUR	ID:Exchange rate setting (no new rate determ.in bill.doc.)	CPKUR	CHAR	1			CPKUR
VALTG	Additional value days	VALTG	NUMC	2			TAGE2
VALDT	Fixed value date	VALDT	DATS	8			DATUM
ZTERM	Terms of Payment Key	DZTERM	CHAR	4			ZTERM
ZLSCH	Payment Method	SCHZW_BSEG	CHAR	1			ZLSCH
KTGRD	Account assignment group for this customer	KTGRD	CHAR	2			KTGRD
LAND1	Country of Destination	LLAND	CHAR	3			LAND1	VLL
REGIO	STATE (State, Province, County)	REGIO	CHAR	3			REGIO
COUNC	County Code	COUNC	CHAR	3			COUNC
CITYC	City Code	CITYC	CHAR	4			CITYC
BUKRS	Company Code	BUKRS	CHAR	4			BUKRS	BUK	C_T001
TAXK1	Tax classification 1 for customer	TAXK1	CHAR	1			TAXKD
TAXK2	Tax classification 2 for customer	TAXK2	CHAR	1			TAXKD
TAXK3	Tax classification 3 for customer	TAXK3	CHAR	1			TAXKD
TAXK4	Tax Classification 4 Customer	TAXK4	CHAR	1			TAXKD
TAXK5	Tax classification 5 for customer	TAXK5	CHAR	1			TAXKD
TAXK6	Tax classification 6 for customer	TAXK6	CHAR	1			TAXKD
TAXK7	Tax classification 7 for customer	TAXK7	CHAR	1			TAXKD
TAXK8	Tax classification 8 for customer	TAXK8	CHAR	1			TAXKD
TAXK9	Tax classification 9 for customer	TAXK9	CHAR	1			TAXKD
NETWR	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
ZUKRI	Combination criteria in the billing document	DZUKRI	CHAR	40			CHAR40
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
ERZET	Entry time	ERZET	TIMS	6			UZEIT
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
STAFO	Update group for statistics update	STAFO	CHAR	6		ALPHA	STAFO	MCF
KUNRG	Payer	KUNRG	CHAR	10		ALPHA	KUNNR
KUNAG	Sold-to party	KUNAG	CHAR	10		ALPHA	KUNNR	VAG
MABER	Dunning Area	MABER	CHAR	2			MABER
STWAE	Statistics currency	STWAE	CUKY	5			WAERS
EXNUM	Number of foreign trade data in MM and SD documents	EXNUM	CHAR	10			EXNUM
STCEG	VAT Registration Number	STCEG	CHAR	20			STCEG
AEDAT	Changed On	AEDAT	DATS	8			DATUM
SFAKN	Cancelled billing document number	SFAKN	CHAR	10		ALPHA	VBELN	VF
KNUMA	Agreement (various conditions grouped together)	KNUMA	CHAR	10		ALPHA	KNUMA		VMBO
FKART_RL	Invoice list type	FKART_RL	CHAR	4			FKART
FKDAT_RL	Billing date for the invoice list	FKDAT_RL	DATS	8			DATUM
KURST	Exchange Rate Type	KURST	CHAR	4			KURST	KUT
MSCHL	Dunning key	MSCHL	CHAR	1			MSCHL
MANSP	Dunning block	MANSP	CHAR	1			MANSP
SPART	Division	SPART	CHAR	2			SPART	SPA	C_SPART
KKBER	Credit control area	KKBER	CHAR	4			KKBER	KKB
KNKLI	Customer's account number with credit limit reference	KNKLI	CHAR	10		ALPHA	KUNNR
CMWAE	Currency key of credit control area	WAERS_CM	CUKY	5			WAERS
CMKUF	Credit data exchange rate at billing document rate	CMKUF	DEC	9(5)			KURRF
HITYP_PR	Hierarchy type for pricing	HITYP_PR	CHAR	1			HITYP
BSTNK_VF	Customer purchase order number	BSTKD	CHAR	35			BSTKD
VBUND	Company ID of trading partner	RASSC	CHAR	6		ALPHA	RCOMP	PGS
FKART_AB	Accrual billing type	FKART_AB	CHAR	4			FKART
KAPPL	Application	KAPPL	CHAR	2			KAPPL	KAP
LANDTX	Tax departure country	LANDTX	CHAR	3			LAND1	LND
STCEG_H	Origin of sales tax ID number	STCEG_H	CHAR	1			STCEG_H
STCEG_L	Country of Sales Tax ID Number	STCEG_L	CHAR	3			LAND1	LND
XBLNR	Reference Document Number	XBLNR_V1	CHAR	16			XBLNR1
ZUONR	Assignment number	ORDNR_V	CHAR	18			ZUONR
MWSBK	Tax amount in document currency	MWSBP	CURR	13(2)			WERTV7
LOGSYS	Logical system	LOGSYS	CHAR	10		ALPHA	LOGSYS
FKSTO	Billing document is cancelled	FKSTO	CHAR	1			XFELD
XEGDR	Indicator: Triangular deal within the EU ?	XEGDR	CHAR	1			XFELD
RPLNR	Number of payment card plan type	RPLNR	CHAR	10			FPLNR
LCNUM	Financial doc. processing: Internal financial doc. number	LCNUM	CHAR	10		ALPHA	LCNUM	AKN
J_1AFITP	Tax type	J_1AFITP_D	CHAR	2			J_1AFITP
KURRF_DAT	Translation Date	WWERT_D	DATS	8			DATUM
AKWAE	Currency key for letter-of-credit procg in foreign trade	AKWAE	CUKY	5			WAERS	FWS
AKKUR	Exchange rate for letter-of-credit procg in foreign trade	AKKUR	DEC	9(5)			KURRF
KIDNO	Payment Reference	KIDNO	CHAR	30			CHAR30
BVTYP	Partner Bank Type	BVTYP	CHAR	4			BVTYP
NUMPG	Number of pages of invoice	J_1ANOPG	NUMC	3			J_1ANOPG
BUPLA	Business Place	BUPLA	CHAR	4			J_1BBRANCH
VKONT	Contract Account Number	CORR_VKONT_KK	CHAR	12		ALPHA	CORR_VKONT_KK
FKK_DOCSTAT	Additional Status Transfer to Fin. Accounting (Res. RFBSK)	DOCSTAT_KK	CHAR	1			DOCSTAT_KK
NRZAS	Character Field of Length 12	CHAR12	CHAR	12			CHAR12
SPE_BILLING_IND	EWM Billing Indicator	/SPE/DE_BILLING_IND	CHAR	1			/SPE/DE_BILLING_IND
VTREF	Reference Specifications from Contract	CORR_VTREF_KK	CHAR	20		ALPHA	CORR_VTREF_KK
FK_SOURCE_SYS	Source System	FK_SOURCE_SYS	CHAR	10		ALPHA	LOGSYS
FKTYP_CRM	Billing Category in CRM	FKTYP_CRM	CHAR	1			FKTYP
STGRD	Reason for Reversal	STGRD	CHAR	2			STGRD	FSG
VBTYP_EXT	Extension of SD Document Category	TDD_VBTYP_EXT	CHAR	4			DOM_VBTYP_EXT
.INCLU--AP				0
DPC_REL	Flag: DPC relevant	/SAPPCE/DPC_REL	CHAR	1			CHAR01
.INCLU--AP				0
AD01BASDOC	Initial document	AD01BASDOC	CHAR	10		ALPHA	VBELN
AD01FAREG	Rule for billing	AD01FAREG	CHAR	1			AD01FAREG
.INCLU--AP				0
VCHRNMBR	Voucher Number	AD04VCHNR	NUMC	8			AD04VCHNR
.INCLU--AP				0
SWENR	Business Entity Number	HB_SWENR	CHAR	8		SWENR	SWENR	WEH
SMENR	Number of Sales Unit	HB_SMENR	CHAR	8		SMENR	SMENR	MEH
PHASE	Sales Phase	HB_SPHSE	CHAR	11			HBS_PHASE
MTLAUR	Marker for Low Income Housing	HB_MTLAUR	CHAR	1			HBS_MTLAUR
STAGE	Construction Stage	HB_STAGE	INT4	10			INT4
HB_CONT_REASON	Contingency data	HB_CONT	CHAR	2			CHAR2
HB_EXPDATE	Expiration date	HB_EXP	DATS	8			DATS
HB_RESDATE	Resolution date	HB_RES	DATS	8			DATS
.INCLU--AP				0
J_3GKBAUL	ETM-Relevant Indicator	J_3GKBAUL	CHAR	1			J_3GKBAUL
J_3GKENIE	Indicator for I(nternal) or E(xternal) Posting	J_3GKENIE	CHAR	1			J_3GKENIE
KUNWE	Ship-to party	KUNWE	CHAR	10		ALPHA	KUNNR
.INCLU--AP				0
MNDID	Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35			ID035
PAY_TYPE	SEPA: Transaction Type	SEPA_PAY_TYPE	CHAR	1			SEPA_PAY_TYPE
SEPON	SEPA-Relevance	SD_SEPA_FLAG	CHAR	1			SD_SEPA_FLAG
MNDVG	SEPA-Relevance	SD_SEPA_FLAG	CHAR	1			SD_SEPA_FLAG
.INCLU--AP				0
SPPAYM	Payment Form for Special Payment Method	SPPAYM	CHAR	2			SPPAYM
SPPORD	Sales Order for Special Payment Method	SPPORD	CHAR	10		ALPHA	VBELN
.INCLU--AP				0
UPDKZ	Update indicator	UPDKZ_D	CHAR	1			UPDKZ
HIPOS	Item number of the SD document	POSNR	NUMC	6			POSNR
SELKZ	Selection flag	SELKZ	CHAR	1			SELKZ
NAMRG	Name 1	NAME1_GP	CHAR	35			NAME
XCPDK	Indicator: Is the account a one-time account?	XCPDK	CHAR	1			XFELD
ADRNR	Address	ADRNR	CHAR	10		ALPHA	ADRNR
UVALS	Generally incomplete	UVALL	CHAR	1			XFELD
UVPRS	Incomplete with respect to pricing	UVPRS	CHAR	1			XFELD
BOKRE	Indicator: Customer Is Rebate-Relevant	BOKRE	CHAR	1			XFELD
NUMKI	Number range in the case of internal number assignment	NUMKI	CHAR	2			NUMKR
VBPANZ	Number of items in Sales and Distribution document	VBPANZ	INT4	10			TABIX
RRREL	Revenue recognition category	RR_RELTYP	CHAR	1			RR_RELTYP
SFAKN_RD	Cancelled billing document number	SFAKN	CHAR	10		ALPHA	VBELN	VF
MSR_ACTIVE	Advanced Returns Management Active	MSR_ACTIVE	CHAR	1			MSR_ACTIVE
TVKO				0
MANDT	Client	MANDT	CLNT	3			MANDT
VKORG	Sales Organization	VKORG	CHAR	4			VKORG	VKO	C_VKORG
WAERS	Statistics currency	WAERS_V	CUKY	5			WAERS
BUKRS	Company code of the sales organization	VKBUK	CHAR	4			BUKRS
ADRNR	Address	ADRNR	CHAR	10		ALPHA	ADRNR
TXNAM_ADR	Text name for form text module short address	TXNAM_ADR	CHAR	16			TXNAM16
TXNAM_KOP	Text name for form text module letter header	TXNAM_KOP	CHAR	16			TXNAM16
TXNAM_FUS	Text name for formula text module footer lines	TXNAM_FUS	CHAR	16			TXNAM16
TXNAM_GRU	Text name for form text module: Greeting	TXNAM_GRU	CHAR	16			TXNAM16
VKOAU	Reference sales org.for sales doc.types (by sales area)	VKOAU	CHAR	4			VKORG	VKO
KUNNR	Customer number for intercompany billing	KUNIV	CHAR	10		ALPHA	KUNNR
BOAVO	Rebate processing active in the sales organization	BOAVO	CHAR	1			XFELD
VKOKL	Sales organization calendar	VKOKL	CHAR	2			WFCID
EKORG	Purchasing Organization	EKORG	CHAR	4			EKORG	EKO
EKGRP	Purchasing Group	EKGRP	CHAR	3			EKGRP	EKG
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10		ALPHA	LIFNR	LIF	KRED_C
WERKS	Plant	WERKS_D	CHAR	4			WERKS	WRK	H_T001W_C
BSART	Order Type (Purchasing)	BSART	CHAR	4			BSART	BSA
BSTYP	Purchasing Document Category	BSTYP	CHAR	1			BSTYP
BWART	Movement Type (Inventory Management)	BWARTWE	CHAR	3			BWART	BWE
LGORT	Storage Location	LGORT_D	CHAR	4			LGORT	LAG
TXNAM_SDB	Text names for layout-set module SDS sender	TXNAM_SDB	CHAR	16			TXNAM16
MWSKZ	Tax code for SD documents	J_1AMWSKZ	CHAR	2			MWSKZ
XSTCEG	Determining the VAT registration number	XSTCEG	CHAR	1			XSTCEG
J_1ANUTIME	Time of numbering for deliveries	J_1ANUTIME	CHAR	1			J_1ANUTIME
MAXBI	Maximum Number of Items in Billing Document	MAXBI	NUMC	3			NUM03
.INCLU--AP				0
PLAUFZ	Price protection period	/SAPHT/SW_PLAUFZ	NUMC	3			NUM3
PLAUEZ	Unit for price protection	/SAPHT/SW_PLAUEZ	CHAR	1			KDZEH
PAYER_ADDRESS				0
ADRNR	Address	ADRNR	CHAR	10		ALPHA	ADRNR
ANRED	Form of address	ANRED_VP	CHAR	15			ANRED
NAME1	Name 1	NAME1_GP	CHAR	35			NAME
NAME2	Name 2	NAME2_GP	CHAR	35			NAME
NAME3	Name 3	NAME3_GP	CHAR	35			NAME
NAME4	Name 4	NAME4_GP	CHAR	35			NAME
STRAS	House number and street	STRAS_GP	CHAR	35			TEXT35
LAND1	Country Key	LAND1_GP	CHAR	3			LAND1		C_LAND1
PSTLZ	Postal Code	PSTLZ	CHAR	10			PSTLZ
PSTL2	P.O. Box Postal Code	PSTL2	CHAR	10			PSTLZ
PFORT	PO Box city	PFORT_GP	CHAR	35			TEXT35
ORT01	City	ORT01_GP	CHAR	35			TEXT35
ORT02	District	ORT02_GP	CHAR	35			TEXT35
REGIO	STATE (State, Province, County)	REGIO	CHAR	3			REGIO
CITYC	City Code	CITYC	CHAR	4			CITYC
COUNC	County Code	COUNC	CHAR	3			COUNC
PFACH	PO Box	PFACH	CHAR	10			PFACH
TELF1	First telephone number	TELF1	CHAR	16			TEXT16
TELF2	Second telephone number	TELF2	CHAR	16			TEXT16
TELBX	Telebox number	TELBX	CHAR	15			TEXT15
TELFX	Fax Number	TELFX	CHAR	31			TEXT31
TELTX	Teletex number	TELTX	CHAR	30			TEXT30
TELX1	Telex number	TELX1	CHAR	30			TEXT30
SPRAS	Language Key	SPRAS	LANG	1		ISOLA	SPRAS	SPR	H_T002
LZONE	Transportation zone to or from which the goods are delivered	LZONE	CHAR	10			ZONE
HAUSN	House Number	HSNMR	NUMC	6			NUMC6
PARGE	Partner's gender	PARGE	CHAR	1			GESCH
NAME_LIST	Name of list display	NAME_LIST	CHAR	35			NAME
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15			TXJCD	TXJ
ADRNP	Person number	AD_PERSNUM	CHAR	10		ALPHA	AD_PERSNUM	CDT	ADDRESS
ADDRESS_TYPE	Address type (1=Organization, 2=Person, 3=Contact person)	AD_ADRTYPE	CHAR	1			AD_ADRTYPE
DUEFL	Status of data transfer into subsequent release	DUEFL_BAS	CHAR	1			DUEFL_BAS
STOCK	Floor	STOCK	CHAR	6			STOCK
STRS2	House number and street	STRAS_GP	CHAR	35			TEXT35
STRASNA	Street Name (Without House Number)	STRAS_NA	CHAR	35			TEXT35
EMAIL_ADDR	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
MOBNUM	First Mobile Telephone No.: Dialing Code + Number	AD_MBNMBR1	CHAR	30			CHAR30
CONDITIONS				0
VBTYP_TEXT	Short Text for Fixed Values	VAL_TEXT	CHAR	60			DDTEXT
SENDING_COUNTRY	Sending country for processing address	SLAND	CHAR	3			LAND1
REPEAT	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
ZTERM_TX1	Text (80 Characters)	TEXT80	CHAR	80			TEXT80UEB
ZTERM_TX2	Text (80 Characters)	TEXT80	CHAR	80			TEXT80UEB
ZTERM_TX3	Text (80 Characters)	TEXT80	CHAR	80			TEXT80UEB
NET_VALUE	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
GROSS_VALUE	Gross Value of Billing Document in Document Currency	BRTWR_FK	CURR	15(2)			WERTV8
TAX_VALUE	Tax amount in document currency	MWSBP	CURR	13(2)			WERTV7
NET_VALUE_FD	Value of Remuneration List Condition of Indiv. Billing Doc.	KWERT_RL	CURR	13(2)			WERTV7
GROSS_VALUE_FD	Gross Value of Invoice List Item	BRTWERT_RL	CURR	13(2)			WERTV7
TAX_VALUE_FD	Amount of Tax in Remuneration List Condition	MWSBP_RL	CURR	13(2)			WERTV7
SUM_NET_VALUE	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
SUM_GROSS_VALUE	Gross Value of Billing Document in Document Currency	BRTWR_FK	CURR	15(2)			WERTV8
SUM_TAX_VALUE	Tax amount in document currency	MWSBP	CURR	13(2)			WERTV7
SUM_NET_VALUE_FD	Value of Remuneration List Condition of Indiv. Billing Doc.	KWERT_RL	CURR	13(2)			WERTV7
SUM_GROSS_VALUE_FD	Gross Value of Invoice List Item	BRTWERT_RL	CURR	13(2)			WERTV7
SUM_TAX_VALUE_FD	Tax amount in document currency	MWSBP	CURR	13(2)			WERTV7
DOC_CURRENCY	SD Document Currency	WAERK	CUKY	5			WAERS	FWS
EX_CONDITIONS	Checkbox	XFELD	CHAR	1			XFELD
ITEM_DETAIL				0

Key field

Non-key field

< BIL_S_IL_PRT_HEAD_DETAIL - Header Details for Print BIL_S_IL_PRT_ITEM_DETAIL - Items Detail for PDF Print >

How do I retrieve data from SAP structure BIL_S_IL_PRT_INTERFACE using ABAP code?

As BIL_S_IL_PRT_INTERFACE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BIL_S_IL_PRT_INTERFACE as there is no data to select.

How to access SAP table BIL_S_IL_PRT_INTERFACE

Within an ECC or HANA version of SAP you can also view further information about BIL_S_IL_PRT_INTERFACE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).