1. Home
  2. Resources
  3. SAP Tables
  4. LBBIL_INVOICE - Billing Data: Transfer Structure to Smart Forms

SAP Table LBBIL_INVOICE

Billing Data: Transfer Structure to Smart Forms

LBBIL_INVOICE (Billing Data: Transfer Structure to Smart Forms) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link LBBIL_INVOICE to other SAP tables.

Source: LBBIL_INVOICE (Billing Data: Transfer Structure to Smart Forms)

LBBIL_INVOICE table fields

Field Data element Checktable Datatype Length Decimals
HD_GEN LBBIL_HD_GEN STRU 0 0
BIL_NUMBER Sales and Distribution Document Number VBELN CHAR 10 0
SOLD_TO_PARTY Sold-to party KUNAG CHAR 10 0
SHIP_TO_PARTY Ship-to party KUNWE CHAR 10 0
BILL_TO_PARTY Bill-to party KUNRE CHAR 10 0
PAYER Payer KUNRG CHAR 10 0
SP_VAT VAT Registration Number STCEG CHAR 20 0
T001_VAT VAT Registration Number STCEG CHAR 20 0
T001Z_VAT Parameter value PAVAL CHAR 48 0
INCOTERMS1 Incoterms (Part 1) INCO1 CHAR 3 0
INCOTERMS2 Incoterms (Part 2) INCO2 CHAR 28 0
SHIP_COND Shipping Conditions VSBED CHAR 2 0
TERMS_PAYM Terms of Payment Key DZTERM CHAR 4 0
VAL_DAY Additional value days VALTG NUMC 2 0
VAL_DATE Fixed value date VALDT DATS 8 0
BIL_WAERK SD Document Currency WAERK CUKY 5 0
BIL_NETWR Net Value in Document Currency NETWR CURR 15 2
BIL_DISC Amount from billing document qualifying for cash discount SKFBK CURR 15 2
BIL_TAX Tax amount in document currency MWSBP CURR 13 2
BIL_VBTYPE SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
BIL_CAT Billing category FKTYP CHAR 1 0
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
BIL_TYPE Billing Type FKART CHAR 4 0
BIL_DATE Billing date for billing index and printout FKDAT DATS 8 0
BRT_WEIGHT Gross weight BRGEW_15 QUAN 15 3
NET_WEIGHT Net weight NTGEW_15 QUAN 15 3
UNIT_OF_WEIGHT Weight Unit GEWEI UNIT 3 0
VOLUME Volume VOLUM_15 QUAN 15 3
VOLUMEUNIT Volume unit VOLEH UNIT 3 0
BIL_EDATE Date on Which Record Was Created ERDAT DATS 8 0
BIL_ENAME Name of Person who Created the Object ERNAM CHAR 12 0
BIL_SCHEMA Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0
KOND_NUMB Number of the document condition KNUMV CHAR 10 0
BIL_APPL Application KAPPL CHAR 2 0
IL_TYPE Invoice list type FKART_RL CHAR 4 0
IL_DATE Billing date for the invoice list FKDAT_RL DATS 8 0
MAT_LAND Country of origin of the material HERKL CHAR 3 0
DLV_LAND Country of Destination LLAND CHAR 3 0
SHP_LAND Departure country (country from which the goods are sent) ALAND CHAR 3 0
LANDTX Tax departure country LANDTX CHAR 3 0
SFAKN Cancelled billing document number SFAKN CHAR 10 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
EXNUM Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
KIDNO Payment Reference KIDNO CHAR 30 0
BUPLA Business Place BUPLA CHAR 4 0
RPLNR Number of payment card plan type RPLNR CHAR 10 0
DPVAL Net Value in Document Currency NETWR CURR 15 2
CCVAL Net Value in Document Currency NETWR CURR 15 2
XEGLD_L1 Indicator: European Union Member? XEGLD CHAR 1 0
X Yes
NULL No
XEGLD_CO Indicator: European Union Member? XEGLD CHAR 1 0
X Yes
NULL No
DPNET Net Value in Document Currency NETWR CURR 15 2
DPEND Net Value in Document Currency NETWR CURR 15 2
DPMWS_END Tax amount in document currency MWSBP CURR 13 2
DPMWS Tax amount in document currency MWSBP CURR 13 2
XFILKD Branch/head office relationship XFILKD_VF CHAR 1 0
NULL Customer=Payer/Branch=sold-to party
A Customer=sold-to party
B Customer=Payer
STCD1_T001N Tax Number for Plants Abroad STCD1_001N CHAR 16 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
KNUMA Agreement (various conditions grouped together) KNUMA CHAR 10 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
HD_GEN_DESCRIPT LBBIL_HD_GEN_DESCRIPT STRU 0 0
BIL_NUMBER Sales and Distribution Document Number VBELN CHAR 10 0
NAME_SHIP_COND Description of the shipping conditions VSBED_BEZ CHAR 20 0
NAME_INCOTERMS1 Incoterm description INCO1_BEZ CHAR 30 0
NAME_BILL_TYPE Billing type description FKART_BEZ CHAR 20 0
NAME_PAYMTERM Description of terms of payment DZTERM_BEZ CHAR 30 0
NAME_PTERMS1 Text (80 Characters) TEXT80 CHAR 80 0
NAME_PTERMS2 Text (80 Characters) TEXT80 CHAR 80 0
NAME_PTERMS3 Text (80 Characters) TEXT80 CHAR 80 0
P_SPLIT Split terms of payment P_SPLIT CHAR 1 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
HD_ORG LBBIL_HD_ORG STRU 0 0
BIL_NUMBER Sales and Distribution Document Number VBELN CHAR 10 0
SALESORG Sales Organization VKORG CHAR 4 0
SALESORG_ADR Address ADRNR CHAR 10 0
SALESORG_SPRAS Language Key SPRAS LANG 1 0
DISTRB_CHANNEL Distribution Channel VTWEG CHAR 2 0
DIVISION Division SPART CHAR 2 0
COMP_CODE Company Code BUKRS CHAR 4 0
HD_REF LBBIL_HD_REF STRU 0 0
BIL_NUMBER Sales and Distribution Document Number VBELN CHAR 10 0
FAK_DATE Billing date for billing index and printout FKDAT DATS 8 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
DELIV_DATE Delivery date LFDAT DATS 8 0
DELIV_LEDAT Delivery Creation Date LEDAT DATS 8 0
ORDER_NUMB Order VBELN_VAUF CHAR 10 0
ORDER_DATE Sales order date AUDAT_VAUF DATS 8 0
ALLOC_ZUONR Assignment number ORDNR_V CHAR 18 0
ACCOUNT_NUMB Accounting Document Number BELNR_D CHAR 10 0
CANC_NUMB Cancelled billing document number SFAKN CHAR 10 0
VBELN_VAG Sales and Distribution Document Number VBELN CHAR 10 0
VAG_DAT Date on Which Record Was Created ERDAT DATS 8 0
VBELN_VKT Sales and Distribution Document Number VBELN CHAR 10 0
VKT_DAT Date on Which Record Was Created ERDAT DATS 8 0
VGTYP Activity or element category VGTYP CHAR 3 0
VBELN_VG2 Sales and Distribution Document Number VBELN CHAR 10 0
VG2_DAT Date on Which Record Was Created ERDAT DATS 8 0
PURCH_NO Customer purchase order number BSTKD CHAR 35 0
PURCH_DATE Customer purchase order date BSTDK DATS 8 0
PO_SUPPLEM Purchase order number supplement BSTZD CHAR 4 0
CUST_REFERENCE Your Reference IHREZ CHAR 12 0
REF_DOC Document number of the reference document VGBEL CHAR 10 0
REF_DOC_TYPE Document category of preceding SD document VBTYP_V CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
PURCH_NO_C Customer purchase order number BSTKD CHAR 35 0
PO_METHOD Customer purchase order type BSARK CHAR 4 0
PURCH_NO_S Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
PO_DAT_S Ship-to party's PO date BSTDK_E DATS 8 0
PO_METH_S Ship-to party purchase order type BSARK_E CHAR 4 0
REF_1_S Ship-to party character IHREZ_E CHAR 12 0
HD_KOMK LBBIL_HD_KOMK STRU 0 0
BIL_NUMBER Billing Document VBELN_VF CHAR 10 0
KNUMV Number of the document condition KNUMV CHAR 10 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
BZIRK Sales district BZIRK CHAR 6 0
VKGRP Sales Group VKGRP CHAR 3 0
BRSCH Industry key BRSCH CHAR 4 0
VKBUR Sales Office VKBUR CHAR 4 0
KONDA Price group (customer) KONDA CHAR 2 0
KDGRP Customer group KDGRP CHAR 2 0
PLTYP Price list type PLTYP CHAR 2 0
ALAND Departure country (country from which the goods are sent) ALAND CHAR 3 0
WKREG Region in which plant is located WKREG CHAR 3 0
WKCOU County in which plant is located WKCOU CHAR 3 0
WKCTY City in which plant is located WKCTY CHAR 4 0
BUKRS Company Code BUKRS CHAR 4 0
SUPOS Net Value in Document Currency NETWR CURR 15 2
FKWRT Cumulative guaranteed discount (not used) FKWRT CURR 15 2
WAERK SD Document Currency WAERK CUKY 5 0
HD_ADR LB_T_BIL_HD_ADR TTYP 0 0
HD_PART_ADD LB_T_BIL_HD_PART_ADD TTYP 0 0
HD_CARD LB_T_BIL_HD_CARD TTYP 0 0
HD_PAY LB_T_BIL_HD_PAY TTYP 0 0
HD_KOND LB_T_BIL_HD_KOND TTYP 0 0
HD_FIN LB_T_BIL_HD_FIN TTYP 0 0
HD_TECH LB_T_BIL_HD_TECH TTYP 0 0
HD_DOWNPAY LB_T_BIL_HD_DOWNPAY TTYP 0 0
IT_GEN LB_T_BIL_IT_GEN TTYP 0 0
IT_ADR LB_T_BIL_IT_ADR TTYP 0 0
IT_PRICE LB_T_BIL_IT_PRICE TTYP 0 0
IT_KOND LB_T_BIL_IT_KOND TTYP 0 0
IT_REF LB_T_BIL_IT_REF TTYP 0 0
IT_REFDLV LB_T_BIL_IT_REFDLV TTYP 0 0
IT_REFORD LB_T_BIL_IT_REFORD TTYP 0 0
IT_REFPURORD LB_T_BIL_IT_REFPURORD TTYP 0 0
IT_REFVAG LB_T_BIL_IT_REFVAG TTYP 0 0
IT_REFVG2 LB_T_BIL_IT_REFVG2 TTYP 0 0
IT_REFVKT LB_T_BIL_IT_REFVKT TTYP 0 0
IT_TECH LB_T_BIL_IT_TECH TTYP 0 0
IT_FIN LB_T_BIL_IT_FIN TTYP 0 0
IT_CONFITM LB_T_BIL_IT_CONFITM TTYP 0 0
IT_CONFBATCH LB_T_BIL_IT_CONFBATCH TTYP 0 0
MSR_HD MSR_S_LBBIL_HD STRU 0 0
BIL_NUMBER Billing Document VBELN_VF CHAR 10 0
MSR_ID Process Identification Number MSR_PROCESS_ID CHAR 10 0
MSR_IT MSR_T_LB_BIL_IT TTYP 0 0
SEPA_MANDATE SEPA_MANDATE STRU 0 0
MANDT Client MANDT CLNT 3 0
MGUID SEPA Mandate: GUID of Mandate SEPA_MGUID RAW 16 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
MVERS SEPA Mandate: Version of Mandate (0 = Current Version) SEPA_MVERS NUMC 4 0
SIGN_CITY Location of Signature SEPA_SIGN_CITY CHAR 40 0
SIGN_DATE Date of Signature SEPA_SIGN_DATE DATS 8 0
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1 0
1 One-Time Mandate
N Recurring Use Mandate
VAL_FROM_DATE SEPA: Validity Date of Mandate (From) SEPA_VAL_FROM_DATE DATS 8 0
VAL_TO_DATE SEPA: Validity Date of Mandate (To) SEPA_VAL_TO_DATE DATS 8 0
STATUS SEPA: Mandate Status SEPA_STATUS CHAR 1 0
0 Entered
1 Active
2 To Be Confirmed
3 Locked
4 Canceled
5 Obsolete
6 Completed
B2B SEPA-Mandate: B2B Mandate SEPA_B2B CHAR 1 0
X Yes
NULL No
REASON_CODE Reason Code for Status Change SEPA_REASON_CODE CHAR 3 0
ERNAM User who Created the Current Version of the Mandate SEPA_ERNAM CHAR 12 0
ERDAT Date on Which the Current Mandate Version was Created SEPA_ERDAT DATS 8 0
ERTIM Time at Which the Current Mandate Version was Created SEPA_ERTIM TIMS 6 0
CHG_REASON SEPA: Reason for Change SEPA_CHG_REASON CHAR 5 0
01 Mandate Reference
02 Creditors - Identification
03 Name of Creditor
071 IBAN of Paying Party in same Bank
072 IBAN of Paying Party in Different Bank
0102 Mandate Reference and Creditor Identification
ORIGIN Single-Character Indicator CHAR1 CHAR 1 0
ORIGIN_REC_CRDID SEPA Mandate: Original Creditor ID of Mandate SEPA_CRDID_ORIGIN CHAR 35 0
ORIGIN_MNDID SEPA Mandate: Original Mandate of Mandate SEPA_MNDID_ORIGIN CHAR 35 0
GLOCK Global Lock Set in Mandate SEPA_GLOCK CHAR 1 0
X true
- false
NULL unknown
GLOCK_VAL_FROM Global Mandate Lock - Valid From SEPA_GLOCK_VAL_FROM_DATE DATS 8 0
GLOCK_VAL_TO Global Mandate Lock - Valid Until SEPA_GLOCK_VAL_TO_DATE DATS 8 0
ANWND SEPA: Application for Which Mandate Relevant SEPA_ANWND CHAR 1 0
ORI_ERNAM User who Created the Original Mandate SEPA_ORI_ERNAM CHAR 12 0
ORI_ERDAT Date on Which Original Mandate Created SEPA_ORI_ERDAT DATS 8 0
ORI_ERTIM Time when Original Mandate Was Created SEPA_ORI_ERTIM TIMS 6 0
REF_TYPE SEPA Mandate: Reference Type SEPA_REF_TYPE CHAR 10 0
REF_ID SEPA Mandate: Reference ID SEPA_REF_ID CHAR 70 0
REF_DESC Text Field TEXT50 CHAR 50 0
SND_TYPE SEPA Mandate: Sender Type SEPA_SND_TYPE CHAR 10 0
SND_ID SEPA Mandate: Sender ID SEPA_SND_ID CHAR 70 0
SND_NAME1 Last name of business partner (person) BU_NAMEP_L CHAR 40 0
SND_NAME2 First name of business partner (person) BU_NAMEP_F CHAR 40 0
SND_STREET Street AD_STREET CHAR 60 0
SND_HOUSENUM House Number AD_HSNM1 CHAR 10 0
SND_POSTAL City postal code AD_PSTCD1 CHAR 10 0
SND_CITY City AD_CITY1 CHAR 40 0
SND_COUNTRY Country Key LAND1 CHAR 3 0
SND_IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
SND_BIC SWIFT/BIC for International Payments SWIFT CHAR 11 0
SND_DIR_NAME SEPA: Name of Alternative Debtor SEPA_PAYMENT_FOR CHAR 40 0
SND_LANGUAGE Language Key LANGU LANG 1 0
SND_DIR_ID SEPA: ID of Alternative Debtor SEPA_SND_DIR_ID CHAR 70 0
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) SEPA_SND_DEBTOR_ID CHAR 35 0
REC_TYPE SEPA Mandate: Recipient Type SEPA_REC_TYPE CHAR 10 0
REC_ID SEPA Mandate: Recipient ID SEPA_REC_ID CHAR 70 0
REC_NAME1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
REC_NAME2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
REC_CRDID Creditor Identification Number SEPA_CRDID CHAR 35 0
REC_STREET Street AD_STREET CHAR 60 0
REC_HOUSENUM House Number AD_HSNM1 CHAR 10 0
REC_POSTAL City postal code AD_PSTCD1 CHAR 10 0
REC_CITY City AD_CITY1 CHAR 40 0
REC_COUNTRY Country Key LAND1 CHAR 3 0
REC_DIR_NAME SEPA: Name of Alternative Payee SEPA_REC_DIR_NAME CHAR 40 0
REC_DIR_ID SEPA: ID of Alternative Payee SEPA_REC_DIR_ID CHAR 70 0
FIRSTUSE_DATE SEPA Mandate: Date of First Use SEPA_FIRSTUSE_DATE DATS 8 0
FIRSTUSE_DOCTYPE SEPA Mandate: Type of First Usage SEPA_FIRSTUSE_DOCTYPE CHAR 10 0
FIRSTUSE_DOCID SEPA Mandate: ID of First Usage SEPA_FIRSTUSE_DOCID CHAR 70 0
LASTUSE_DATE SEPA Mandate: Date of Last Use SEPA_LASTUSE_DATE DATS 8 0
LASTUSE_DOCTYPE SEPA Mandate: Type of Last Usage SEPA_LASTUSE_DOCTYPE CHAR 10 0
LASTUSE_DOCID SEPA Mandate: ID of Last Usage SEPA_LASTUSE_DOCID CHAR 70 0
FIRSTUSE_PAYRUN SEPA Mandate: ID of Payment Run of First Use SEPA_FIRSTUSE_PAYRUNID CHAR 16 0
ORGF1 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID CHAR 20 0
ORGF2 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID CHAR 20 0
ORGF3 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONG CHAR 35 0
ORGF4 SEPA Mandate: Internal Organizational Data SEPA_ORG_ID_LONG CHAR 35 0
/SAPF15/F15_BW /SAPF15/BEWIRTSCHAFTER CHAR 8 0
/SAPF15/F15_KZ /SAPF15/KASSENZEICHEN CHAR 12 0
/SAPF15/GUID /SAPF15/GUID RAW 16 0
CONTRACT_ID BKK: SEPA Mandate Contract ID BKK_DTE_MND_CONTRACT_ID CHAR 50 0
CONTRACT_DESC BKK:SEPA Mandate Contract Description BKK_DTE_MND_CONTRACT_DESC CHAR 50 0
BANK_CRDTR Bank Is Creditor BKK_DTE_MND_BANK_CRDTR CHAR 1 0
X Yes
NULL No
LAUFD Date ID LAUFD_KK DATS 8 0
LAUFI Additional Identification Characteristic LAUFI_KK CHAR 6 0