SAP Table LBBIL_HD_GEN

BIlling Header: General Data

LBBIL_HD_GEN (BIlling Header: General Data) 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_HD_GEN to other SAP tables.

LBBIL_HD_GEN table fields

Field Data element Checktable Datatype Length Decimals
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