Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

LBBIL_INVOICE SAP (Billing Data: Transfer Structure to Smart Forms) Structure details

Dictionary Type: Structure
Description: Billing Data: Transfer Structure to Smart Forms

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

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

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

LBBIL_INVOICE 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 "Billing Data: Transfer Structure to Smart Forms" 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_LBBIL_INVOICE TYPE LBBIL_INVOICE.

The LBBIL_INVOICE table consists of various fields, each holding specific information or linking keys about Billing Data: Transfer Structure to Smart Forms data available in SAP. These include BIL_NUMBER (Sales and Distribution Document Number), SOLD_TO_PARTY (Sold-to party), SHIP_TO_PARTY (Ship-to party), BILL_TO_PARTY (Bill-to party).. 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 LBBIL_INVOICE 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
HD_GEN				0
BIL_NUMBER	Sales and Distribution Document Number	VBELN	CHAR	10		ALPHA	VBELN	AUN
SOLD_TO_PARTY	Sold-to party	KUNAG	CHAR	10		ALPHA	KUNNR	VAG
SHIP_TO_PARTY	Ship-to party	KUNWE	CHAR	10		ALPHA	KUNNR
BILL_TO_PARTY	Bill-to party	KUNRE	CHAR	10		ALPHA	KUNNR	KUN
PAYER	Payer	KUNRG	CHAR	10		ALPHA	KUNNR
SP_VAT	VAT Registration Number	STCEG	CHAR	20			STCEG
T001_VAT	VAT Registration Number	STCEG	CHAR	20			STCEG
T001Z_VAT	Parameter value	PAVAL	CHAR	48			TEXT48
INCOTERMS1	Incoterms (Part 1)	INCO1	CHAR	3			INCO1
INCOTERMS2	Incoterms (Part 2)	INCO2	CHAR	28			INCO2
SHIP_COND	Shipping Conditions	VSBED	CHAR	2			VSBED
TERMS_PAYM	Terms of Payment Key	DZTERM	CHAR	4			ZTERM
VAL_DAY	Additional value days	VALTG	NUMC	2			TAGE2
VAL_DATE	Fixed value date	VALDT	DATS	8			DATUM
BIL_WAERK	SD Document Currency	WAERK	CUKY	5			WAERS	FWS
BIL_NETWR	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
BIL_DISC	Amount from billing document qualifying for cash discount	SKFBK	CURR	15(2)			WERTV8
BIL_TAX	Tax amount in document currency	MWSBP	CURR	13(2)			WERTV7
BIL_VBTYPE	SD document category	VBTYP	CHAR	1			VBTYP
BIL_CAT	Billing category	FKTYP	CHAR	1			FKTYP
BIL_TYPE	Billing Type	FKART	CHAR	4			FKART
BIL_DATE	Billing date for billing index and printout	FKDAT	DATS	8			DATUM
BRT_WEIGHT	Gross weight	BRGEW_15	QUAN	15(3)			MENG15
NET_WEIGHT	Net weight	NTGEW_15	QUAN	15(3)			MENG15
UNIT_OF_WEIGHT	Weight Unit	GEWEI	UNIT	3		CUNIT	MEINS
VOLUME	Volume	VOLUM_15	QUAN	15(3)			MENG15
VOLUMEUNIT	Volume unit	VOLEH	UNIT	3		CUNIT	MEINS
BIL_EDATE	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
BIL_ENAME	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
BIL_SCHEMA	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	KALSM_D	CHAR	6			KALSM
KOND_NUMB	Number of the document condition	KNUMV	CHAR	10			KNUMV
BIL_APPL	Application	KAPPL	CHAR	2			KAPPL	KAP
IL_TYPE	Invoice list type	FKART_RL	CHAR	4			FKART
IL_DATE	Billing date for the invoice list	FKDAT_RL	DATS	8			DATUM
MAT_LAND	Country of origin of the material	HERKL	CHAR	3			LAND1	LND
DLV_LAND	Country of Destination	LLAND	CHAR	3			LAND1	VLL
SHP_LAND	Departure country (country from which the goods are sent)	ALAND	CHAR	3			LAND1	VAL
LANDTX	Tax departure country	LANDTX	CHAR	3			LAND1	LND
SFAKN	Cancelled billing document number	SFAKN	CHAR	10		ALPHA	VBELN	VF
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
EXNUM	Number of foreign trade data in MM and SD documents	EXNUM	CHAR	10			EXNUM
KIDNO	Payment Reference	KIDNO	CHAR	30			CHAR30
BUPLA	Business Place	BUPLA	CHAR	4			J_1BBRANCH
RPLNR	Number of payment card plan type	RPLNR	CHAR	10			FPLNR
DPVAL	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
CCVAL	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
XEGLD_L1	Indicator: European Union Member?	XEGLD	CHAR	1			XFELD
XEGLD_CO	Indicator: European Union Member?	XEGLD	CHAR	1			XFELD
DPNET	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
DPEND	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
DPMWS_END	Tax amount in document currency	MWSBP	CURR	13(2)			WERTV7
DPMWS	Tax amount in document currency	MWSBP	CURR	13(2)			WERTV7
XFILKD	Branch/head office relationship	XFILKD_VF	CHAR	1			XFILKD_VF
STCD1_T001N	Tax Number for Plants Abroad	STCD1_001N	CHAR	16			STCD1
XEGDR	Indicator: Triangular deal within the EU ?	XEGDR	CHAR	1			XFELD
KNUMA	Agreement (various conditions grouped together)	KNUMA	CHAR	10		ALPHA	KNUMA		VMBO
MNDID	Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35			ID035
HD_GEN_DESCRIPT				0
BIL_NUMBER	Sales and Distribution Document Number	VBELN	CHAR	10		ALPHA	VBELN	AUN
NAME_SHIP_COND	Description of the shipping conditions	VSBED_BEZ	CHAR	20			TEXT20
NAME_INCOTERMS1	Incoterm description	INCO1_BEZ	CHAR	30			TEXT30
NAME_BILL_TYPE	Billing type description	FKART_BEZ	CHAR	20			TEXT20
NAME_PAYMTERM	Description of terms of payment	DZTERM_BEZ	CHAR	30			TEXT30
NAME_PTERMS1	Text (80 Characters)	TEXT80	CHAR	80			TEXT80UEB
NAME_PTERMS2	Text (80 Characters)	TEXT80	CHAR	80			TEXT80UEB
NAME_PTERMS3	Text (80 Characters)	TEXT80	CHAR	80			TEXT80UEB
P_SPLIT	Split terms of payment	P_SPLIT	CHAR	1			CHAR1
ZFBDT	Baseline Date for Due Date Calculation	DZFBDT	DATS	8			DATUM
HD_ORG				0
BIL_NUMBER	Sales and Distribution Document Number	VBELN	CHAR	10		ALPHA	VBELN	AUN
SALESORG	Sales Organization	VKORG	CHAR	4			VKORG	VKO	C_VKORG
SALESORG_ADR	Address	ADRNR	CHAR	10		ALPHA	ADRNR
SALESORG_SPRAS	Language Key	SPRAS	LANG	1		ISOLA	SPRAS	SPR	H_T002
DISTRB_CHANNEL	Distribution Channel	VTWEG	CHAR	2			VTWEG	VTW	C_VTWEG
DIVISION	Division	SPART	CHAR	2			SPART	SPA	C_SPART
COMP_CODE	Company Code	BUKRS	CHAR	4			BUKRS	BUK	C_T001
HD_REF				0
BIL_NUMBER	Sales and Distribution Document Number	VBELN	CHAR	10		ALPHA	VBELN	AUN
FAK_DATE	Billing date for billing index and printout	FKDAT	DATS	8			DATUM
DELIV_NUMB	Delivery	VBELN_VL	CHAR	10		ALPHA	VBELN	VL
DELIV_DATE	Delivery date	LFDAT	DATS	8			DATUM
DELIV_LEDAT	Delivery Creation Date	LEDAT	DATS	8			DATUM
ORDER_NUMB	Order	VBELN_VAUF	CHAR	10		ALPHA	VBELN	AUF
ORDER_DATE	Sales order date	AUDAT_VAUF	DATS	8			DATUM
ALLOC_ZUONR	Assignment number	ORDNR_V	CHAR	18			ZUONR
ACCOUNT_NUMB	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
CANC_NUMB	Cancelled billing document number	SFAKN	CHAR	10		ALPHA	VBELN	VF
VBELN_VAG	Sales and Distribution Document Number	VBELN	CHAR	10		ALPHA	VBELN	AUN
VAG_DAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
VBELN_VKT	Sales and Distribution Document Number	VBELN	CHAR	10		ALPHA	VBELN	AUN
VKT_DAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
VGTYP	Activity or element category	VGTYP	CHAR	3			VORG_TYP
VBELN_VG2	Sales and Distribution Document Number	VBELN	CHAR	10		ALPHA	VBELN	AUN
VG2_DAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
PURCH_NO	Customer purchase order number	BSTKD	CHAR	35			BSTKD
PURCH_DATE	Customer purchase order date	BSTDK	DATS	8			DATUM
PO_SUPPLEM	Purchase order number supplement	BSTZD	CHAR	4			BSTZD
CUST_REFERENCE	Your Reference	IHREZ	CHAR	12			TEXT12
REF_DOC	Document number of the reference document	VGBEL	CHAR	10		ALPHA	VBELN
REF_DOC_TYPE	Document category of preceding SD document	VBTYP_V	CHAR	1			VBTYP
PURCH_NO_C	Customer purchase order number	BSTKD	CHAR	35			BSTKD
PO_METHOD	Customer purchase order type	BSARK	CHAR	4			BSARK
PURCH_NO_S	Ship-to Party's Purchase Order Number	BSTKD_E	CHAR	35			BSTKD
PO_DAT_S	Ship-to party's PO date	BSTDK_E	DATS	8			DATUM
PO_METH_S	Ship-to party purchase order type	BSARK_E	CHAR	4			BSARK
REF_1_S	Ship-to party character	IHREZ_E	CHAR	12			TEXT12
HD_KOMK				0
BIL_NUMBER	Billing Document	VBELN_VF	CHAR	10		ALPHA	VBELN	VF
KNUMV	Number of the document condition	KNUMV	CHAR	10			KNUMV
VKORG	Sales Organization	VKORG	CHAR	4			VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2			VTWEG	VTW	C_VTWEG
SPART	Division	SPART	CHAR	2			SPART	SPA	C_SPART
BZIRK	Sales district	BZIRK	CHAR	6			BZIRK	BZI
VKGRP	Sales Group	VKGRP	CHAR	3			VKGRP	VKG
BRSCH	Industry key	BRSCH	CHAR	4			BRSCH
VKBUR	Sales Office	VKBUR	CHAR	4			VKBUR	VKB
KONDA	Price group (customer)	KONDA	CHAR	2			KONDA	VKA
KDGRP	Customer group	KDGRP	CHAR	2			KDGRP	VKD
PLTYP	Price list type	PLTYP	CHAR	2			PLTYP	VPL
ALAND	Departure country (country from which the goods are sent)	ALAND	CHAR	3			LAND1	VAL
WKREG	Region in which plant is located	WKREG	CHAR	3			REGIO
WKCOU	County in which plant is located	WKCOU	CHAR	3			CHAR3
WKCTY	City in which plant is located	WKCTY	CHAR	4			CHAR4
BUKRS	Company Code	BUKRS	CHAR	4			BUKRS	BUK	C_T001
SUPOS	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
FKWRT	Cumulative guaranteed discount (not used)	FKWRT	CURR	15(2)			WERTV8
WAERK	SD Document Currency	WAERK	CUKY	5			WAERS	FWS
HD_ADR				0
HD_PART_ADD				0
HD_CARD				0
HD_PAY				0
HD_KOND				0
HD_FIN				0
HD_TECH				0
HD_DOWNPAY				0
IT_GEN				0
IT_ADR				0
IT_PRICE				0
IT_KOND				0
IT_REF				0
IT_REFDLV				0
IT_REFORD				0
IT_REFPURORD				0
IT_REFVAG				0
IT_REFVG2				0
IT_REFVKT				0
IT_TECH				0
IT_FIN				0
IT_CONFITM				0
IT_CONFBATCH				0
MSR_HD				0
BIL_NUMBER	Billing Document	VBELN_VF	CHAR	10		ALPHA	VBELN	VF
MSR_ID	Process Identification Number	MSR_PROCESS_ID	CHAR	10		ALPHA	MSR_PROCESS_ID
MSR_IT				0
SEPA_MANDATE				0
MANDT	Client	MANDT	CLNT	3			MANDT
MGUID	SEPA Mandate: GUID of Mandate	SEPA_MGUID	RAW	16
MNDID	Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35			ID035
MVERS	SEPA Mandate: Version of Mandate (0 = Current Version)	SEPA_MVERS	NUMC	4			NUM04
SIGN_CITY	Location of Signature	SEPA_SIGN_CITY	CHAR	40			TEXT40
SIGN_DATE	Date of Signature	SEPA_SIGN_DATE	DATS	8			DATUM
PAY_TYPE	SEPA: Transaction Type	SEPA_PAY_TYPE	CHAR	1			SEPA_PAY_TYPE
VAL_FROM_DATE	SEPA: Validity Date of Mandate (From)	SEPA_VAL_FROM_DATE	DATS	8			DATUM
VAL_TO_DATE	SEPA: Validity Date of Mandate (To)	SEPA_VAL_TO_DATE	DATS	8			DATUM
STATUS	SEPA: Mandate Status	SEPA_STATUS	CHAR	1			SEPA_STATUS
B2B	SEPA-Mandate: B2B Mandate	SEPA_B2B	CHAR	1			XFELD
REASON_CODE	Reason Code for Status Change	SEPA_REASON_CODE	CHAR	3			SEPA_REASON_CODE
ERNAM	User who Created the Current Version of the Mandate	SEPA_ERNAM	CHAR	12			SYCHAR12
ERDAT	Date on Which the Current Mandate Version was Created	SEPA_ERDAT	DATS	8			DATUM
ERTIM	Time at Which the Current Mandate Version was Created	SEPA_ERTIM	TIMS	6			UZEIT
CHG_REASON	SEPA: Reason for Change	SEPA_CHG_REASON	CHAR	5			SEPA_CHG_REASON
ORIGIN	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
ORIGIN_REC_CRDID	SEPA Mandate: Original Creditor ID of Mandate	SEPA_CRDID_ORIGIN	CHAR	35			ID035
ORIGIN_MNDID	SEPA Mandate: Original Mandate of Mandate	SEPA_MNDID_ORIGIN	CHAR	35			ID035
GLOCK	Global Lock Set in Mandate	SEPA_GLOCK	CHAR	1			BOOLEAN
GLOCK_VAL_FROM	Global Mandate Lock - Valid From	SEPA_GLOCK_VAL_FROM_DATE	DATS	8			DATUM
GLOCK_VAL_TO	Global Mandate Lock - Valid Until	SEPA_GLOCK_VAL_TO_DATE	DATS	8			DATUM
ANWND	SEPA: Application for Which Mandate Relevant	SEPA_ANWND	CHAR	1			SEPA_ANWND
ORI_ERNAM	User who Created the Original Mandate	SEPA_ORI_ERNAM	CHAR	12			SYCHAR12
ORI_ERDAT	Date on Which Original Mandate Created	SEPA_ORI_ERDAT	DATS	8			DATUM
ORI_ERTIM	Time when Original Mandate Was Created	SEPA_ORI_ERTIM	TIMS	6			UZEIT
REF_TYPE	SEPA Mandate: Reference Type	SEPA_REF_TYPE	CHAR	10			OJ_NAME	OBJ
REF_ID	SEPA Mandate: Reference ID	SEPA_REF_ID	CHAR	70			SWO_TYPEID
REF_DESC	Text Field	TEXT50	CHAR	50			TEXT50
SND_TYPE	SEPA Mandate: Sender Type	SEPA_SND_TYPE	CHAR	10			OJ_NAME	OBJ
SND_ID	SEPA Mandate: Sender ID	SEPA_SND_ID	CHAR	70			SWO_TYPEID
SND_NAME1	Last name of business partner (person)	BU_NAMEP_L	CHAR	40			BU_NAME
SND_NAME2	First name of business partner (person)	BU_NAMEP_F	CHAR	40			BU_NAME
SND_STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
SND_HOUSENUM	House Number	AD_HSNM1	CHAR	10			TEXT10
SND_POSTAL	City postal code	AD_PSTCD1	CHAR	10			CHAR10
SND_CITY	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
SND_COUNTRY	Country Key	LAND1	CHAR	3			LAND1	LND
SND_IBAN	IBAN (International Bank Account Number)	IBAN	CHAR	34			IBAN
SND_BIC	SWIFT/BIC for International Payments	SWIFT	CHAR	11			SWIFT
SND_DIR_NAME	SEPA: Name of Alternative Debtor	SEPA_PAYMENT_FOR	CHAR	40			BU_NAME
SND_LANGUAGE	Language Key	LANGU	LANG	1		ISOLA	SPRAS
SND_DIR_ID	SEPA: ID of Alternative Debtor	SEPA_SND_DIR_ID	CHAR	70			SWO_TYPEID
SND_DEBTOR_ID	SEPA: ID Number of Sender (External Reference)	SEPA_SND_DEBTOR_ID	CHAR	35			ID035
REC_TYPE	SEPA Mandate: Recipient Type	SEPA_REC_TYPE	CHAR	10			OJ_NAME	OBJ
REC_ID	SEPA Mandate: Recipient ID	SEPA_REC_ID	CHAR	70			SWO_TYPEID
REC_NAME1	Name 1 of organization	BU_NAMEOR1	CHAR	40			BU_NAME
REC_NAME2	Name 2 of organization	BU_NAMEOR2	CHAR	40			BU_NAME
REC_CRDID	Creditor Identification Number	SEPA_CRDID	CHAR	35			ID035
REC_STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
REC_HOUSENUM	House Number	AD_HSNM1	CHAR	10			TEXT10
REC_POSTAL	City postal code	AD_PSTCD1	CHAR	10			CHAR10
REC_CITY	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
REC_COUNTRY	Country Key	LAND1	CHAR	3			LAND1	LND
REC_DIR_NAME	SEPA: Name of Alternative Payee	SEPA_REC_DIR_NAME	CHAR	40			BU_NAME
REC_DIR_ID	SEPA: ID of Alternative Payee	SEPA_REC_DIR_ID	CHAR	70			SWO_TYPEID
FIRSTUSE_DATE	SEPA Mandate: Date of First Use	SEPA_FIRSTUSE_DATE	DATS	8			DATUM
FIRSTUSE_DOCTYPE	SEPA Mandate: Type of First Usage	SEPA_FIRSTUSE_DOCTYPE	CHAR	10			OJ_NAME	OBJ
FIRSTUSE_DOCID	SEPA Mandate: ID of First Usage	SEPA_FIRSTUSE_DOCID	CHAR	70			SWO_TYPEID	OBJ
LASTUSE_DATE	SEPA Mandate: Date of Last Use	SEPA_LASTUSE_DATE	DATS	8			DATUM
LASTUSE_DOCTYPE	SEPA Mandate: Type of Last Usage	SEPA_LASTUSE_DOCTYPE	CHAR	10			OJ_NAME	OBJ
LASTUSE_DOCID	SEPA Mandate: ID of Last Usage	SEPA_LASTUSE_DOCID	CHAR	70			SWO_TYPEID	OBJ
FIRSTUSE_PAYRUN	SEPA Mandate: ID of Payment Run of First Use	SEPA_FIRSTUSE_PAYRUNID	CHAR	16			CHAR16
ORGF1	SEPA Mandate: Internal Organizational Data	SEPA_ORG_ID	CHAR	20			CHAR20
ORGF2	SEPA Mandate: Internal Organizational Data	SEPA_ORG_ID	CHAR	20			CHAR20
ORGF3	SEPA Mandate: Internal Organizational Data	SEPA_ORG_ID_LONG	CHAR	35			CHAR35
ORGF4	SEPA Mandate: Internal Organizational Data	SEPA_ORG_ID_LONG	CHAR	35			CHAR35
.INCLU--AP				0
/SAPF15/F15_BW		/SAPF15/BEWIRTSCHAFTER	CHAR	8			/SAPF15/BEWIRTSCHAFTER		/SAPF15/BEWIRT
/SAPF15/F15_KZ		/SAPF15/KASSENZEICHEN	CHAR	12			CHAR12
/SAPF15/GUID		/SAPF15/GUID	RAW	16			SYSUUID
.INCLU--AP				0
CONTRACT_ID	BKK: SEPA Mandate Contract ID	BKK_DTE_MND_CONTRACT_ID	CHAR	50			BKK_MANDATE_CONTRACT
CONTRACT_DESC	BKK:SEPA Mandate Contract Description	BKK_DTE_MND_CONTRACT_DESC	CHAR	50			BKK_MANDATE_CONTRACT
BANK_CRDTR	Bank Is Creditor	BKK_DTE_MND_BANK_CRDTR	CHAR	1			XFELD
.INCLU--AP				0
LAUFD	Date ID	LAUFD_KK	DATS	8			DATUM
LAUFI	Additional Identification Characteristic	LAUFI_KK	CHAR	6			LAUFI_KK

Key field

Non-key field

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

As LBBIL_INVOICE 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 LBBIL_INVOICE as there is no data to select.

How to access SAP table LBBIL_INVOICE

Within an ECC or HANA version of SAP you can also view further information about LBBIL_INVOICE 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!