SAP Table INVOICE_S_PRT_INTERFACE

Billing Document: Interface Structure for Adobe Print

INVOICE_S_PRT_INTERFACE (Billing Document: Interface Structure for Adobe Print) 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 INVOICE_S_PRT_INTERFACE to other SAP tables.

Source: INVOICE_S_PRT_INTERFACE (Billing Document: Interface Structure for Adobe Print)

INVOICE_S_PRT_INTERFACE table fields

Field Data element Checktable Datatype Length Decimals
HEAD_DETAIL INVOICE_S_PRT_HEAD_DETAIL STRU 0 0
VBDKR VBDKR STRU 0 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
VKORG Sales Organization VKORG CHAR 4 0
SPRAS_VKO Language Key SPRAS LANG 1 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
WAERS Currency Key WAERS CUKY 5 0
WAERK SD Document Currency WAERK CUKY 5 0
ANRED Title ANRED CHAR 15 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0
KNUMV Number of the document condition KNUMV CHAR 10 0
VSBED Shipping Conditions VSBED CHAR 2 0
VSBED_BEZ Description of the shipping conditions VSBED_BEZ CHAR 20 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
INCO1_BEZ Incoterm description INCO1_BEZ CHAR 30 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZTERM_BEZ Description of terms of payment DZTERM_BEZ CHAR 30 0
ZTERM_TX1 Text (80 Characters) TEXT80 CHAR 80 0
ZTERM_TX2 Text (80 Characters) TEXT80 CHAR 80 0
ZTERM_TX3 Text (80 Characters) TEXT80 CHAR 80 0
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 0
KURST Exchange Rate Type KURST CHAR 4 0
NETWR Net Value in Document Currency NETWR CURR 15 2
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
HERKL Country of origin of the material HERKL CHAR 3 0
LLAND Country of Destination LLAND CHAR 3 0
ALAND Departure country (country from which the goods are sent) ALAND CHAR 3 0
SLAND Sending country for processing address SLAND CHAR 3 0
TDNAME Name TDOBNAME CHAR 70 0
ADRNR Address number AD_ADDRNUM CHAR 10 0
ADRNP Person number AD_PERSNUM CHAR 10 0
ADDRESS_TYPE Address type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPE CHAR 1 0
1 Organization, Company
2 Private address
3 Contact person (in company)
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PFORT PO Box city PFORT_GP CHAR 35 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
LAND1 Country Key LAND1 CHAR 3 0
SPRAS Language Key SPRAS LANG 1 0
PSTLZ Postal Code PSTLZ CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
ORT02 District ORT02_GP CHAR 35 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
KUNWE Ship-to party KUNWE CHAR 10 0
ANRED_WE Title ANRED CHAR 15 0
ADRNR_WE Address number AD_ADDRNUM CHAR 10 0
ADRNP_WE Person number AD_PERSNUM CHAR 10 0
ADDRESS_TYPE_WE Address type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPE CHAR 1 0
1 Organization, Company
2 Private address
3 Contact person (in company)
NAME1_WE Name 1 NAME1_GP CHAR 35 0
NAME2_WE Name 2 NAME2_GP CHAR 35 0
NAME3_WE Name 3 NAME3_GP CHAR 35 0
NAME4_WE Name 4 NAME4_GP CHAR 35 0
STRAS_WE House number and street STRAS_GP CHAR 35 0
PFACH_WE PO Box PFACH CHAR 10 0
PFORT_WE PO Box city PFORT_GP CHAR 35 0
PSTL2_WE P.O. Box Postal Code PSTL2 CHAR 10 0
LAND1_WE Country Key LAND1 CHAR 3 0
SPRAS_WE Language Key SPRAS LANG 1 0
PSTLZ_WE Postal Code PSTLZ CHAR 10 0
ORT01_WE City ORT01_GP CHAR 35 0
ORT02_WE District ORT02_GP CHAR 35 0
REGIO_WE Region (State, Province, County) REGIO CHAR 3 0
VBELN_VL Delivery VBELN_VL CHAR 10 0
KUNRG Payer KUNRG CHAR 10 0
KUNAG Sold-to party KUNAG CHAR 10 0
KUNRE Bill-to party KUNRE CHAR 10 0
LFDAT Delivery date LFDAT DATS 8 0
LEDAT Delivery Creation Date LEDAT DATS 8 0
BRGEW Gross weight BRGEW_15 QUAN 15 3
NTGEW Net weight NTGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI UNIT 3 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH UNIT 3 0
VBELN_VAUF Order VBELN_VAUF CHAR 10 0
AUDAT_VAUF Sales order date AUDAT_VAUF DATS 8 0
VGBEL Document number of the reference document VGBEL CHAR 10 0
VBTYP 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
BSTNK Customer purchase order number BSTNK CHAR 20 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BSTZD Purchase order number supplement BSTZD CHAR 4 0
IHREZ Your Reference IHREZ CHAR 12 0
SKFBK Amount from billing document qualifying for cash discount SKFBK CURR 15 2
STCEG VAT Registration Number STCEG CHAR 20 0
STCEG_T001 VAT Registration Number STCEG CHAR 20 0
STCEG_WE VAT Registration Number STCEG CHAR 20 0
STCEG_L Country of Sales Tax ID Number STCEG_L CHAR 3 0
STCEG_H Origin of sales tax ID number STCEG_H CHAR 1 0
A Ship-to party
B Payer
C Sold-to party
D Payer (KNAS segment)
E Manually entered or changed
F Entered manually in order
G Own VAT reg. no. in dest. country
H Payer for tax receiving country from order
I Sold-to party for tax receiving country from order
J Sold to party (segment KNAS)
VAT_T001Z Parameter value PAVAL CHAR 48 0
UVALL General incompletion status of the header UVALL_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALS Total incompletion status of all items in general UVALL_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPRS Document is incomplete with respect to pricing UVPRS_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KNUMA Agreement (various conditions grouped together) KNUMA CHAR 10 0
ZUONR Assignment number ORDNR_V CHAR 18 0
FKART_RL Invoice list type FKART_RL CHAR 4 0
FKDAT_RL Billing date for the invoice list FKDAT_RL DATS 8 0
FKTYP 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
FKART Billing Type FKART CHAR 4 0
VSART Shipping type VERSART CHAR 2 0
VSART_BEZ Description of the Shipping Type VERSARTBEZ CHAR 20 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
KAPPL Application KAPPL CHAR 2 0
P_SPLIT Split terms of payment P_SPLIT CHAR 1 0
TEXT Char 80 CHAR80 CHAR 80 0
BUKRS Company Code BUKRS CHAR 4 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
VBELN_VAG Sales and Distribution Document Number VBELN CHAR 10 0
AGDAT Date on Which Record Was Created ERDAT DATS 8 0
VBELN_VKT Sales and Distribution Document Number VBELN CHAR 10 0
KTDAT Date on Which Record Was Created ERDAT DATS 8 0
VBELN_VG2 Sales and Distribution Document Number VBELN CHAR 10 0
G2DAT Date on Which Record Was Created ERDAT DATS 8 0
VGTYP 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
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
LANDTX Tax departure country LANDTX CHAR 3 0
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
LICNO Tax exemption license number LICNO CHAR 20 0
LICDT Date license granted LICDT DATS 8 0
SFAKN Cancelled billing document number SFAKN CHAR 10 0
KURRF Exchange rate for FI postings KURRF DEC 9 5
KURRF_DAT Translation Date WWERT_D DATS 8 0
MWSBK Tax amount in document currency MWSBP CURR 13 2
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
NO_VKBUR Single-Character Indicator CHAR1 CHAR 1 0
NO_ABLAD Single-Character Indicator CHAR1 CHAR 1 0
VBUND Company ID VBUND CHAR 6 0
KNKLI Customer's account number with credit limit reference KNKLI CHAR 10 0
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
VKONT Contract Account Number CORR_VKONT_KK CHAR 12 0
REPEAT_HU General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
COUNTER_HU Text (10 Characters) TEXT10 CHAR 10 0
CCNUM_HU Number of Carbon Copies IDHUCCNUM NUMC 3 0
EXNUM Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
EXPVZ Mode of Transport for Foreign Trade EXPVZ CHAR 1 0
ZOLLA Customs Office: Office of Exit/Entry for Foreign Trade DZOLLS CHAR 6 0
ZOLLB Customs office: Office of destination for foreign trade DZOLLB CHAR 6 0
ZOLL1 Customs office: Customs office 1 for foreign trade DZOLL1 CHAR 6 0
ZOLL2 Customs office: Customs office 2 for foreign trade DZOLL2 CHAR 6 0
ZOLL3 Customs office: Customs office 3 for foreign trade DZOLL3 CHAR 6 0
ZOLL4 Customs office: Customs office 4 for foreign trade DZOLL4 CHAR 6 0
ZOLL5 Customs office: Customs office 5 for foreign trade DZOLL5 CHAR 6 0
ZOLL6 Customs office: Customs office 6 for foreign trade DZOLL6 CHAR 6 0
KZGBE Indicator for means of transport crossing the border KZGBE CHAR 30 0
KZABE Indicator for the means of transport at departure KZABE CHAR 30 0
STGBE Origin of Means of Transport when Crossing the Border STGBE CHAR 3 0
STABE Country of Origin of the Means of Transport at Departure STABE CHAR 3 0
CONTA ID: Goods cross border in a container CONTA CHAR 1 0
0 Goods do not cross the border in a container
1 Goods cross the border in a container
GRWCU Currency of statistical values for foreign trade GRWCU CUKY 5 0
EXPVZ_BEZ Description BEZEI20 CHAR 20 0
LANDX Country Name LANDX CHAR 15 0
LANDA Departure country (country from which the goods are sent) ALAND CHAR 3 0
XEGLD Indicator: European Union Member? XEGLD CHAR 1 0
X Yes
NULL No
FREIH Indicator: Free Trade Area for Legal Control FREIH CHAR 1 0
NULL No free trading zone
1 ASEAN
2 EFTA
3 NAFTA
4 MERCOSUR
EWRCO ID: European Economic Area (rel. for export control) EWRCO CHAR 1 0
X Yes
NULL No
USC05 USA: Five-Digit Country Code (SED: Schedule C Code) USC05 CHAR 5 0
JAP05 Japan: Five digit country code (MITI customs declaration) JAP05 CHAR 5 0
ALANX Country Name LANDX CHAR 15 0
ALANA Departure country (country from which the goods are sent) ALAND CHAR 3 0
LASTA Departure country (country from which the goods are sent) ALAND CHAR 3 0
LASTG Departure country (country from which the goods are sent) ALAND CHAR 3 0
ALSRE Currency of export license EXWAE CUKY 5 0
ALSCH Departure country (country from which the goods are sent) ALAND CHAR 3 0
IEVER Domestic Mode of Transport for Foreign Trade IEVER CHAR 1 0
WZOCU Currency of customs values for import procg in foreign trade WZOCU CUKY 5 0
LADEL Place of loading/unloading for foreign trade LADEL CHAR 40 0
TEXT1 Description BEZEI40 CHAR 40 0
TEXT2 Description BEZEI40 CHAR 40 0
TEXT3 Description BEZEI40 CHAR 40 0
EXDAR Export document: Export document type for foreign trade EXDAR CHAR 10 0
EXDAA Export document: Official number of export document EXDAA CHAR 25 0
EXDAB Export document: Valid-to number of export document EXDAB CHAR 25 0
EXDTA T document: Type of T document for foreign trade EXDTA CHAR 10 0
EXDT2 T document: Official number of T document for foreign trade EXDT2 CHAR 25 0
EXDTB T doc.: Official no. for next page of T doc. f.foreign trade EXDTB CHAR 25 0
EXDT5 CAP: Official number of T5 document for foreign trade EXDT5 CHAR 25 0
PRONU Invoice: Number of invoice document for import processing PRONU CHAR 25 0
PRODA Invoice: Date of invoice document for import processing PRODA DATS 8 0
VORPA Preliminary document: Document type for foreign trade procg VORPA CHAR 10 0
VORDA Preliminary document: Date of preliminary doc.f.import procg VORDA DATS 8 0
VORNU Preliminary document: No. of preliminary doc.f.import procg VORNU CHAR 25 0
BEHOE Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
KENNU Preliminary document: Customs office/ID number for import KENNU CHAR 6 0
VOISO Prelim. doc.: ISO code of ctry issuing the preliminary doc. VOISO CHAR 2 0
LCNUM Financial doc. processing: Internal financial doc. number LCNUM CHAR 10 0
AUSFU Exporter for import processing in foreign trade AUSFU CHAR 10 0
LAZL1 Customs office: Country of customs office for foreign trade LAZLS CHAR 3 0
LAZL2 Customs office: Country of customs office for foreign trade LAZLS CHAR 3 0
LAZL3 Customs office: Country of customs office for foreign trade LAZLS CHAR 3 0
LAZL4 Customs office: Country of customs office for foreign trade LAZLS CHAR 3 0
LAZL5 Customs office: Country of customs office for foreign trade LAZLS CHAR 3 0
LAZL6 Customs office: Country of customs office for foreign trade LAZLS CHAR 3 0
AZOLL Customs office: Export customs office for foreign trade AZOLL CHAR 6 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
BSTKD_E Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
BSTDK_E Ship-to party's PO date BSTDK_E DATS 8 0
BSARK_E Ship-to party purchase order type BSARK_E CHAR 4 0
IHREZ_E Ship-to party character IHREZ_E CHAR 12 0
DPEND Net Value in Document Currency NETWR CURR 15 2
DPVAL Net Value in Document Currency NETWR CURR 15 2
DPNET Net Value in Document Currency NETWR CURR 15 2
DPMWS Tax amount in document currency MWSBP CURR 13 2
DPMWS_END Tax amount in document currency MWSBP CURR 13 2
CCVAL Net Value in Document Currency NETWR CURR 15 2
RPLNR Number of payment card plan type RPLNR CHAR 10 0
KIDNO Payment Reference KIDNO CHAR 30 0
XBLNR Reference Document Number XBLNR_V1 CHAR 16 0
BUPLA Business Place BUPLA CHAR 4 0
FITYP_BU Tax type J_1AFITP_D CHAR 2 0
FITPT_BU Text (30 Characters) TEXT30 CHAR 30 0
STCD1_BU Tax Number 1 STCD1 CHAR 16 0
STCD2_BU Tax Number 2 STCD2 CHAR 11 0
STC2T_BU Text (12 characters) TEXT12 CHAR 12 0
STCDT_BU Tax Number Type J_1ATOID CHAR 2 0
FOUDT_BU Character Field Length = 10 CHAR10 CHAR 10 0
PRACD_BU Print Authorization Code J_1APAC CHAR 14 0
VDPCD_BU Print Authorization Code: Valid-To Date J_1APACVD DATS 8 0
STCD1_RE Tax Number 1 STCD1 CHAR 16 0
STCD2_RE Tax Number 2 STCD2 CHAR 11 0
STCDT_RE Tax Number Type J_1ATOID CHAR 2 0
FITYP_RE Tax type J_1AFITP_D CHAR 2 0
FORID_RE Tax Code for Foreign Nationals J_1AFOPID CHAR 13 0
BLART Document Type BLART CHAR 2 0
BLKLS Document Class J_1ADOCCL_ CHAR 1 0
TXTDCL Text (30 Characters) TEXT30 CHAR 30 0
STC2T_RE Text (12 characters) TEXT12 CHAR 12 0
TELF1_RE First telephone number TELF1 CHAR 16 0
STKZU_RE Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
STCD1_WE Tax Number 1 STCD1 CHAR 16 0
GAWRD Gross Amount in Words GAWRD CHAR 255 0
WADAT_IST_LF Actual Goods Movement Date WADAT_IST DATS 8 0
BANKS_RE Bank country key BANKS CHAR 3 0
BANKL_RE Bank Keys BANKK CHAR 15 0
BANKN_RE Bank account number BANKN CHAR 18 0
TXTFU_RE Footer Text Name in Word Processing TXTFU_001G CHAR 16 0
AUGRU_TEXT Description BEZEI40 CHAR 40 0
XBLNR_VL Reference Document Number XBLNR_LIKP CHAR 25 0
XBLNR_VG2 Reference Document Number XBLNR1 CHAR 16 0
NETWR_VG2 Net value of the billing item in document currency NETWR_FP CURR 15 2
MWSBK_VG2 Tax amount in document currency MWSBP CURR 13 2
J_1HNETWR_DIF Net value of the billing item in document currency NETWR_FP CURR 15 2
J_1HMWSBK_DIF Tax amount in document currency MWSBP CURR 13 2
PAYAM Amount Due PAYAM CURR 15 2
PAYNT Net Amount Due PAYNT CURR 15 2
PAYTA Tax Due PAYTA CURR 15 2
CI_RATNR Sequential Number of Installment to be Paid RATNR NUMC 2 0
CI_DUE_DATE Bill of Exchange Due Date WEFAE DATS 8 0
CI_NUMBER Credit Invoice Number J_1ACINUM CHAR 10 0
CI_ISSUE_DATE Date on which Credit Invoice is Issued J_1ACI_ISS_DATE DATS 8 0
BARCODE Barcode for billing document (Argentina) J_1ABARCODE NUMC 40 0
PRTCHR Character to be printed on the document J_1APCHAR CHAR 1 0
STCD3_RE Tax Number 3 STCD3 CHAR 18 0
STCD4_RE Tax Number 4 STCD4 CHAR 18 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0
STCD1_T001N Tax Number for Plants Abroad STCD1_001N CHAR 16 0
SPE_BILLING_IND EWM Billing Indicator /SPE/DE_BILLING_IND CHAR 1 0
NULL No Invoice Before Goods Issue
A Direct Billing (Immediately Billing and Printing)
B Wait for Billing Request
MSR_ID Process Identification Number MSR_PROCESS_ID CHAR 10 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
T001G T001G STRU 0 0
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
PROGRAMM ABAP Program Name PROGNAME CHAR 40 0
TXTID Sender Variant TXTID_001G CHAR 2 0
TXTKO Header Text Name in Word Processing TXTKO_001G CHAR 16 0
TXTFU Footer Text Name in Word Processing TXTFU_001G CHAR 16 0
TXTUN Text Name for the Signature TXTUN_001G CHAR 16 0
TXTAB Text Name for the Sender Details in the Letter Window TXTAB_001G CHAR 16 0
TTXID Text ID TDID CHAR 4 0
HEADER Smart Forms: Name of Header Text in Text Processing FSF_HEADER CHAR 30 0
FOOTER Smart Forms: Name of Footer in Text Processing FSF_FOOTER CHAR 30 0
SENDER Smart Forms: Name of Sender Text in Text Processing FSF_SENDER CHAR 30 0
GREETINGS Smart Forms: Name of Greeting in Text Processing FSF_GREETINGS CHAR 30 0
LOGO URL for PDF Logo FURL_LOGO CHAR 255 0
GRAPH URL for PDF Graphic FURL_GRAPHIC CHAR 255 0
TVKO TVKO STRU 0 0
MANDT Client MANDT CLNT 3 0
VKORG Sales Organization VKORG CHAR 4 0
WAERS Statistics currency WAERS_V CUKY 5 0
BUKRS Company code of the sales organization VKBUK CHAR 4 0
ADRNR Address ADRNR CHAR 10 0
TXNAM_ADR Text name for form text module short address TXNAM_ADR CHAR 16 0
TXNAM_KOP Text name for form text module letter header TXNAM_KOP CHAR 16 0
TXNAM_FUS Text name for formula text module footer lines TXNAM_FUS CHAR 16 0
TXNAM_GRU Text name for form text module: Greeting TXNAM_GRU CHAR 16 0
VKOAU Reference sales org.for sales doc.types (by sales area) VKOAU CHAR 4 0
KUNNR Customer number for intercompany billing KUNIV CHAR 10 0
BOAVO Rebate processing active in the sales organization BOAVO CHAR 1 0
X Yes
NULL No
VKOKL Sales organization calendar VKOKL CHAR 2 0
EKORG Purchasing Organization EKORG CHAR 4 0
EKGRP Purchasing Group EKGRP CHAR 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
WERKS Plant WERKS_D CHAR 4 0
BSART Order Type (Purchasing) BSART CHAR 4 0
BSTYP Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
BWART Movement Type (Inventory Management) BWARTWE CHAR 3 0
LGORT Storage Location LGORT_D CHAR 4 0
TXNAM_SDB Text names for layout-set module SDS sender TXNAM_SDB CHAR 16 0
MWSKZ Tax code for SD documents J_1AMWSKZ CHAR 2 0
XSTCEG Determining the VAT registration number XSTCEG CHAR 1 0
NULL according to priority rule
A generally from sold-to party
B generally from payer
C according to priority rule, dest. country from ship-to party
J_1ANUTIME Time of numbering for deliveries J_1ANUTIME CHAR 1 0
1 Creation of delivery document
3 Goods issue done
MAXBI Maximum Number of Items in Billing Document MAXBI NUMC 3 0
PLAUFZ Price protection period /SAPHT/SW_PLAUFZ NUMC 3 0
PLAUEZ Unit for price protection /SAPHT/SW_PLAUEZ CHAR 1 0
1 Day
2 Week
3 Month
4 Year
CONDITIONS KOMVD_T TTYP 0 0
DOWN_PAYMENTS SDACCDPC_T TTYP 0 0
PAYMENT_CARDS BIL_T_PRT_PAYMENT_CARDS TTYP 0 0
VBTYP_TEXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
VGTYP_TEXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
REPEAT Single-Character Indicator CHAR1 CHAR 1 0
LOGO_URL Logo URL LOGO_URL STRG 0 0
GROSS_VALUE Gross value BRTWR CURR 11 2
DOC_CURRENCY SD Document Currency WAERK CUKY 5 0
HEAD_TDNAME TDIC text name TDNAME CHAR 16 0
HEAD_TDOBJECT Texts: Application Object TDOBJECT CHAR 10 0
HEAD_TDID Text ID TDID CHAR 4 0
HEAD_TDSPRAS Language key TDSPRAS LANG 1 0
FOOT_TDNAME TDIC text name TDNAME CHAR 16 0
FOOT_TDOBJECT Texts: Application Object TDOBJECT CHAR 10 0
FOOT_TDID Text ID TDID CHAR 4 0
FOOT_TDSPRAS Language key TDSPRAS LANG 1 0
EX_CONDITIONS Checkbox XFELD CHAR 1 0
X Yes
NULL No
EX_DOWN_PAYMENTS Checkbox XFELD CHAR 1 0
X Yes
NULL No
EX_PAYMENT_CARDS Checkbox XFELD CHAR 1 0
X Yes
NULL No
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
BNKA BNKA STRU 0 0
MANDT Client MANDT CLNT 3 0
BANKS Bank country key BANKS CHAR 3 0
BANKL Bank Keys BANKK CHAR 15 0
ERDAT Date on which the record was created ERDAT_BF DATS 8 0
ERNAM Name of person who created the object ERNAM_BF CHAR 12 0
BANKA Name of bank BANKA CHAR 60 0
PROVZ Region (State, Province, County) REGIO CHAR 3 0
STRAS House number and street STRAS_GP CHAR 35 0
ORT01 City ORT01_GP CHAR 35 0
SWIFT SWIFT/BIC for International Payments SWIFT CHAR 11 0
BGRUP Bank group (bank network) BGRUP CHAR 2 0
XPGRO Post Office Bank Current Account XPGRO CHAR 1 0
X Yes
NULL No
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
BNKLZ Bank number BANKL CHAR 15 0
PSKTO Post office bank current account number PSKTO_CH CHAR 16 0
ADRNR Address number AD_ADDRNUM CHAR 10 0
BRNCH Bank Branch BRNCH CHAR 40 0
CHKME Check digit calculation method CHECKMETH CHAR 4 0
VERS Format of File with Bank Data VERS_BF CHAR 3 0
BICKY Key of a BIC+ data record (Swift) PRQ_BICKY CHAR 12 0
RCCODE Routing control code PRQ_RCC CHAR 15 0
HDATUM_TX1 Date SXPGDATE CHAR 10 0
HDATUM_TX2 Date SXPGDATE CHAR 10 0
HDATUM_TX3 Date SXPGDATE CHAR 10 0
ITEM_DETAIL INVOICE_T_PRT_ITEM_DETAIL TTYP 0 0