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

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