Full sales invoices
The SIHL import template is not a comprehensive template, this configuration is submitted for information purposes. This template enables the import of three analytical dimension types and all ten invoicing elements.
Tables used
This template can be used in import and export modes. The data is updated in the following tables :
| Table |
Table description |
|---|---|
|
BPARTNER [BPR] |
|
|
BPCUSTMVT [MVC] |
Customer transactions |
|
BPCUSTOMER [BPC] |
|
|
BPDLVCUST [BPD] |
|
|
CONTSERV [CON] |
|
|
CPTANALIN [CAL] |
Analytical accounting lines |
|
FACILITY [FCY] |
|
|
GACCCODE [CAC] |
|
|
GACCOUNT [GAC] |
|
|
GTYPACCENT [GTE] |
|
|
HDKTASKINV [HDI] |
Consumptions to be invoiced |
|
ITMBPC [ITU] |
|
|
ITMCATEG [ITG] |
|
|
ITMFACILIT [ITF] |
|
|
ITMMASTER [ITM] |
|
|
ITMMVT [ITV] |
Product-site totals |
|
ITMSALES [ITS] |
|
|
ITMWRH [ITW] |
|
|
PRICSTRUCT [PRS] |
|
|
SALESREP [REP] |
|
|
SDELIVERY [SDH] |
|
|
SDELIVERYD [SDD] |
Delivery detail |
|
SERREQUEST [SRE] |
|
|
SFOOTINV [SFI] |
|
|
SINVOICE [SIH] |
Sales invoices |
|
SINVOICED [SID] |
Sales invoice detail |
|
SINVOICEV [SIV] |
Costing sales invoice |
|
SORDER [SOH] |
|
|
SORDERP [SOP] |
Sales orders - price |
|
SORDERQ [SOQ] |
Sales orders - quantities |
|
SPRICLINK [SPK] |
Sales price list search |
|
SPRICLIST [SPL] |
Customer price lists |
|
SRETURND [SRD] |
Sales return detail |
|
STOCK [STO] |
Stock |
|
STOJOU [STJ] |
Stock journal |
|
STOLOT [STL] |
Lot numbers |
|
SVCRFOOT [SVF] |
Sales document - footer el. |
|
SVCRVAT [SVV] |
Sales document - tax |
|
TABCUR [TCU] |
|
|
TABPRTMOD [TPM] |
|
|
TABSIVTYP [TSV] |
|
|
TABUNIT [TUN] |
|
|
WAREHOUSE [WRH] |