BIL_S_IL_PRT_INTERFACE SAP (Invoice Lists: Interface Structure for Adobe Print) Structure details

Dictionary Type: Structure
Description: Invoice Lists: Interface Structure for Adobe Print




ABAP Code to SELECT data from BIL_S_IL_PRT_INTERFACE
Related tables to BIL_S_IL_PRT_INTERFACE
Access table BIL_S_IL_PRT_INTERFACE




Structure field list including key, data, relationships and ABAP select examples

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. .

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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
HEAD_DETAIL 0
VBRK 0
MANDTClient MANDTCLNT3MANDT
VBELNBilling Document VBELN_VFCHAR10ALPHAVBELNVF
FKARTBilling Type FKARTCHAR4FKART
FKTYPBilling category FKTYPCHAR1FKTYP
VBTYPSD document category VBTYPCHAR1VBTYP
WAERKSD Document Currency WAERKCUKY5WAERSFWS
VKORGSales Organization VKORGCHAR4VKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2VTWEGVTWC_VTWEG
KALSMSales and Distribution: Pricing Procedure in Pricing KALSMASDCHAR6KALSM
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
VSBEDShipping Conditions VSBEDCHAR2VSBED
FKDATBilling date for billing index and printout FKDATDATS8DATUM
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
POPERPosting period POPERNUMC3POPERPOPR
KONDAPrice group (customer) KONDACHAR2KONDAVKA
KDGRPCustomer group KDGRPCHAR2KDGRPVKD
BZIRKSales district BZIRKCHAR6BZIRKBZI
PLTYPPrice list type PLTYPCHAR2PLTYPVPL
INCO1Incoterms (Part 1) INCO1CHAR3INCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
EXPKZExport indicator EXPKZCHAR1EXPKZ
RFBSKStatus for transfer to accounting RFBSKCHAR1RFBSK
MRNKZManual invoice maintenance MRNKZCHAR1XFELD
KURRFExchange rate for FI postings KURRFDEC9(5) KURRF
CPKURID:Exchange rate setting (no new rate determ.in bill.doc.) CPKURCHAR1CPKUR
VALTGAdditional value days VALTGNUMC2TAGE2
VALDTFixed value date VALDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZLSCHPayment Method SCHZW_BSEGCHAR1ZLSCH
KTGRDAccount assignment group for this customer KTGRDCHAR2KTGRD
LAND1Country of Destination LLANDCHAR3LAND1VLL
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
COUNCCounty Code COUNCCHAR3COUNC
CITYCCity Code CITYCCHAR4CITYC
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
TAXK1Tax classification 1 for customer TAXK1CHAR1TAXKD
TAXK2Tax classification 2 for customer TAXK2CHAR1TAXKD
TAXK3Tax classification 3 for customer TAXK3CHAR1TAXKD
TAXK4Tax Classification 4 Customer TAXK4CHAR1TAXKD
TAXK5Tax classification 5 for customer TAXK5CHAR1TAXKD
TAXK6Tax classification 6 for customer TAXK6CHAR1TAXKD
TAXK7Tax classification 7 for customer TAXK7CHAR1TAXKD
TAXK8Tax classification 8 for customer TAXK8CHAR1TAXKD
TAXK9Tax classification 9 for customer TAXK9CHAR1TAXKD
NETWRNet Value in Document Currency NETWRCURR15(2) WERTV8
ZUKRICombination criteria in the billing document DZUKRICHAR40CHAR40
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERZETEntry time ERZETTIMS6UZEIT
ERDATDate on Which Record Was Created ERDATDATS8DATUM
STAFOUpdate group for statistics update STAFOCHAR6ALPHASTAFOMCF
KUNRGPayer KUNRGCHAR10ALPHAKUNNR
KUNAGSold-to party KUNAGCHAR10ALPHAKUNNRVAG
MABERDunning Area MABERCHAR2MABER
STWAEStatistics currency STWAECUKY5WAERS
EXNUMNumber of foreign trade data in MM and SD documents EXNUMCHAR10EXNUM
STCEGVAT Registration Number STCEGCHAR20STCEG
AEDATChanged On AEDATDATS8DATUM
SFAKNCancelled billing document number SFAKNCHAR10ALPHAVBELNVF
KNUMAAgreement (various conditions grouped together) KNUMACHAR10ALPHAKNUMAVMBO
FKART_RLInvoice list type FKART_RLCHAR4FKART
FKDAT_RLBilling date for the invoice list FKDAT_RLDATS8DATUM
KURSTExchange Rate Type KURSTCHAR4KURSTKUT
MSCHLDunning key MSCHLCHAR1MSCHL
MANSPDunning block MANSPCHAR1MANSP
SPARTDivision SPARTCHAR2SPARTSPAC_SPART
KKBERCredit control area KKBERCHAR4KKBERKKB
KNKLICustomer's account number with credit limit reference KNKLICHAR10ALPHAKUNNR
CMWAECurrency key of credit control area WAERS_CMCUKY5WAERS
CMKUFCredit data exchange rate at billing document rate CMKUFDEC9(5) KURRF
HITYP_PRHierarchy type for pricing HITYP_PRCHAR1HITYP
BSTNK_VFCustomer purchase order number BSTKDCHAR35BSTKD
VBUNDCompany ID of trading partner RASSCCHAR6ALPHARCOMPPGS
FKART_ABAccrual billing type FKART_ABCHAR4FKART
KAPPLApplication KAPPLCHAR2KAPPLKAP
LANDTXTax departure country LANDTXCHAR3LAND1LND
STCEG_HOrigin of sales tax ID number STCEG_HCHAR1STCEG_H
STCEG_LCountry of Sales Tax ID Number STCEG_LCHAR3LAND1LND
XBLNRReference Document Number XBLNR_V1CHAR16XBLNR1
ZUONRAssignment number ORDNR_VCHAR18ZUONR
MWSBKTax amount in document currency MWSBPCURR13(2) WERTV7
LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
FKSTOBilling document is cancelled FKSTOCHAR1XFELD
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
RPLNRNumber of payment card plan type RPLNRCHAR10FPLNR
LCNUMFinancial doc. processing: Internal financial doc. number LCNUMCHAR10ALPHALCNUMAKN
J_1AFITPTax type J_1AFITP_DCHAR2J_1AFITP
KURRF_DATTranslation Date WWERT_DDATS8DATUM
AKWAECurrency key for letter-of-credit procg in foreign trade AKWAECUKY5WAERSFWS
AKKURExchange rate for letter-of-credit procg in foreign trade AKKURDEC9(5) KURRF
KIDNOPayment Reference KIDNOCHAR30CHAR30
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
NUMPGNumber of pages of invoice J_1ANOPGNUMC3J_1ANOPG
BUPLABusiness Place BUPLACHAR4J_1BBRANCH
VKONTContract Account Number CORR_VKONT_KKCHAR12ALPHACORR_VKONT_KK
FKK_DOCSTATAdditional Status Transfer to Fin. Accounting (Res. RFBSK) DOCSTAT_KKCHAR1DOCSTAT_KK
NRZASCharacter Field of Length 12 CHAR12CHAR12CHAR12
SPE_BILLING_INDEWM Billing Indicator /SPE/DE_BILLING_INDCHAR1/SPE/DE_BILLING_IND
VTREFReference Specifications from Contract CORR_VTREF_KKCHAR20ALPHACORR_VTREF_KK
FK_SOURCE_SYSSource System FK_SOURCE_SYSCHAR10ALPHALOGSYS
FKTYP_CRMBilling Category in CRM FKTYP_CRMCHAR1FKTYP
STGRDReason for Reversal STGRDCHAR2STGRDFSG
VBTYP_EXTExtension of SD Document Category TDD_VBTYP_EXTCHAR4DOM_VBTYP_EXT
.INCLU--AP 0
DPC_RELFlag: DPC relevant /SAPPCE/DPC_RELCHAR1CHAR01
.INCLU--AP 0
AD01BASDOCInitial document AD01BASDOCCHAR10ALPHAVBELN
AD01FAREGRule for billing AD01FAREGCHAR1AD01FAREG
.INCLU--AP 0
VCHRNMBRVoucher Number AD04VCHNRNUMC8AD04VCHNR
.INCLU--AP 0
SWENRBusiness Entity Number HB_SWENRCHAR8SWENRSWENRWEH
SMENRNumber of Sales Unit HB_SMENRCHAR8SMENRSMENRMEH
PHASESales Phase HB_SPHSECHAR11HBS_PHASE
MTLAURMarker for Low Income Housing HB_MTLAURCHAR1HBS_MTLAUR
STAGEConstruction Stage HB_STAGEINT410INT4
HB_CONT_REASONContingency data HB_CONTCHAR2CHAR2
HB_EXPDATEExpiration date HB_EXPDATS8DATS
HB_RESDATEResolution date HB_RESDATS8DATS
.INCLU--AP 0
J_3GKBAULETM-Relevant Indicator J_3GKBAULCHAR1J_3GKBAUL
J_3GKENIEIndicator for I(nternal) or E(xternal) Posting J_3GKENIECHAR1J_3GKENIE
KUNWEShip-to party KUNWECHAR10ALPHAKUNNR
.INCLU--AP 0
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
PAY_TYPESEPA: Transaction Type SEPA_PAY_TYPECHAR1SEPA_PAY_TYPE
SEPONSEPA-Relevance SD_SEPA_FLAGCHAR1SD_SEPA_FLAG
MNDVGSEPA-Relevance SD_SEPA_FLAGCHAR1SD_SEPA_FLAG
.INCLU--AP 0
SPPAYMPayment Form for Special Payment Method SPPAYMCHAR2SPPAYM
SPPORDSales Order for Special Payment Method SPPORDCHAR10ALPHAVBELN
.INCLU--AP 0
UPDKZUpdate indicator UPDKZ_DCHAR1UPDKZ
HIPOSItem number of the SD document POSNRNUMC6POSNR
SELKZSelection flag SELKZCHAR1SELKZ
NAMRGName 1 NAME1_GPCHAR35NAME
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
ADRNRAddress ADRNRCHAR10ALPHAADRNR
UVALSGenerally incomplete UVALLCHAR1XFELD
UVPRSIncomplete with respect to pricing UVPRSCHAR1XFELD
BOKREIndicator: Customer Is Rebate-Relevant BOKRECHAR1XFELD
NUMKINumber range in the case of internal number assignment NUMKICHAR2NUMKR
VBPANZNumber of items in Sales and Distribution document VBPANZINT410TABIX
RRRELRevenue recognition category RR_RELTYPCHAR1RR_RELTYP
SFAKN_RDCancelled billing document number SFAKNCHAR10ALPHAVBELNVF
MSR_ACTIVEAdvanced Returns Management Active MSR_ACTIVECHAR1MSR_ACTIVE
TVKO 0
MANDTClient MANDTCLNT3MANDT
VKORGSales Organization VKORGCHAR4VKORGVKOC_VKORG
WAERSStatistics currency WAERS_VCUKY5WAERS
BUKRSCompany code of the sales organization VKBUKCHAR4BUKRS
ADRNRAddress ADRNRCHAR10ALPHAADRNR
TXNAM_ADRText name for form text module short address TXNAM_ADRCHAR16TXNAM16
TXNAM_KOPText name for form text module letter header TXNAM_KOPCHAR16TXNAM16
TXNAM_FUSText name for formula text module footer lines TXNAM_FUSCHAR16TXNAM16
TXNAM_GRUText name for form text module: Greeting TXNAM_GRUCHAR16TXNAM16
VKOAUReference sales org.for sales doc.types (by sales area) VKOAUCHAR4VKORGVKO
KUNNRCustomer number for intercompany billing KUNIVCHAR10ALPHAKUNNR
BOAVORebate processing active in the sales organization BOAVOCHAR1XFELD
VKOKLSales organization calendar VKOKLCHAR2WFCID
EKORGPurchasing Organization EKORGCHAR4EKORGEKO
EKGRPPurchasing Group EKGRPCHAR3EKGRPEKG
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
BSARTOrder Type (Purchasing) BSARTCHAR4BSARTBSA
BSTYPPurchasing Document Category BSTYPCHAR1BSTYP
BWARTMovement Type (Inventory Management) BWARTWECHAR3BWARTBWE
LGORTStorage Location LGORT_DCHAR4LGORTLAG
TXNAM_SDBText names for layout-set module SDS sender TXNAM_SDBCHAR16TXNAM16
MWSKZTax code for SD documents J_1AMWSKZCHAR2MWSKZ
XSTCEGDetermining the VAT registration number XSTCEGCHAR1XSTCEG
J_1ANUTIMETime of numbering for deliveries J_1ANUTIMECHAR1J_1ANUTIME
MAXBIMaximum Number of Items in Billing Document MAXBINUMC3NUM03
.INCLU--AP 0
PLAUFZPrice protection period /SAPHT/SW_PLAUFZNUMC3NUM3
PLAUEZUnit for price protection /SAPHT/SW_PLAUEZCHAR1KDZEH
PAYER_ADDRESS 0
ADRNRAddress ADRNRCHAR10ALPHAADRNR
ANREDForm of address ANRED_VPCHAR15ANRED
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
STRASHouse number and street STRAS_GPCHAR35TEXT35
LAND1Country Key LAND1_GPCHAR3LAND1C_LAND1
PSTLZPostal Code PSTLZCHAR10PSTLZ
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
PFORTPO Box city PFORT_GPCHAR35TEXT35
ORT01City ORT01_GPCHAR35TEXT35
ORT02District ORT02_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
CITYCCity Code CITYCCHAR4CITYC
COUNCCounty Code COUNCCHAR3COUNC
PFACHPO Box PFACHCHAR10PFACH
TELF1First telephone number TELF1CHAR16TEXT16
TELF2Second telephone number TELF2CHAR16TEXT16
TELBXTelebox number TELBXCHAR15TEXT15
TELFXFax Number TELFXCHAR31TEXT31
TELTXTeletex number TELTXCHAR30TEXT30
TELX1Telex number TELX1CHAR30TEXT30
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
LZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
HAUSNHouse Number HSNMRNUMC6NUMC6
PARGEPartner's gender PARGECHAR1GESCH
NAME_LISTName of list display NAME_LISTCHAR35NAME
TXJCDTax Jurisdiction TXJCDCHAR15TXJCDTXJ
ADRNPPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
ADDRESS_TYPEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
DUEFLStatus of data transfer into subsequent release DUEFL_BASCHAR1DUEFL_BAS
STOCKFloor STOCKCHAR6STOCK
STRS2House number and street STRAS_GPCHAR35TEXT35
STRASNAStreet Name (Without House Number) STRAS_NACHAR35TEXT35
EMAIL_ADDRE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
MOBNUMFirst Mobile Telephone No.: Dialing Code + Number AD_MBNMBR1CHAR30CHAR30
CONDITIONS 0
VBTYP_TEXTShort Text for Fixed Values VAL_TEXTCHAR60DDTEXT
SENDING_COUNTRYSending country for processing address SLANDCHAR3LAND1
REPEATSingle-Character Indicator CHAR1CHAR1CHAR1
ZTERM_TX1Text (80 Characters) TEXT80CHAR80TEXT80UEB
ZTERM_TX2Text (80 Characters) TEXT80CHAR80TEXT80UEB
ZTERM_TX3Text (80 Characters) TEXT80CHAR80TEXT80UEB
NET_VALUENet Value in Document Currency NETWRCURR15(2) WERTV8
GROSS_VALUEGross Value of Billing Document in Document Currency BRTWR_FKCURR15(2) WERTV8
TAX_VALUETax amount in document currency MWSBPCURR13(2) WERTV7
NET_VALUE_FDValue of Remuneration List Condition of Indiv. Billing Doc. KWERT_RLCURR13(2) WERTV7
GROSS_VALUE_FDGross Value of Invoice List Item BRTWERT_RLCURR13(2) WERTV7
TAX_VALUE_FDAmount of Tax in Remuneration List Condition MWSBP_RLCURR13(2) WERTV7
SUM_NET_VALUENet Value in Document Currency NETWRCURR15(2) WERTV8
SUM_GROSS_VALUEGross Value of Billing Document in Document Currency BRTWR_FKCURR15(2) WERTV8
SUM_TAX_VALUETax amount in document currency MWSBPCURR13(2) WERTV7
SUM_NET_VALUE_FDValue of Remuneration List Condition of Indiv. Billing Doc. KWERT_RLCURR13(2) WERTV7
SUM_GROSS_VALUE_FDGross Value of Invoice List Item BRTWERT_RLCURR13(2) WERTV7
SUM_TAX_VALUE_FDTax amount in document currency MWSBPCURR13(2) WERTV7
DOC_CURRENCYSD Document Currency WAERKCUKY5WAERSFWS
EX_CONDITIONSCheckbox XFELDCHAR1XFELD
ITEM_DETAIL 0

Key field Non-key field



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).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!