Table Abbreviation Description Module Activity code
VSQUOTE VQH Sales quote history - header Sales  

Key Description Duplicates Activity code
SQH0 SQHNUM+REVNUM No  
SQH1 BPCORD+CUSQUOREF Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ADRVAL Validated   M 4 1     LTA
AMTTAX Tax amount   MD1         KUS
APPFLG Signed   M 15 280      
AUUID Single identifier   AUUID          
BASTAX Tax basis   MD1         KUS
BPAADD Delivery address   ADR          
BPAORD Order addr code   ADR          
BPCADDLIG Address 3 ADL          
BPCCRY Country   CRY     [TCY]TCY0=[VQH]BPCCRY Block  
BPCCRYNAM Country name   NCY          
BPCCTY City   CTY          
BPCNAM Customer name 2 NAM          
BPCORD Customer   BPR     [BPR]BPR0=[VQH]BPCORD Block  
BPCPOSCOD Postal code   POS          
BPCSAT Order state   SAT          
BPDADDLIG Delivery address 3 ADL          
BPDCRY Delivery country   CRY     [TCY]TCY0=[VQH]BPDCRY Block  
BPDCRYNAM Delivery country name   NCY          
BPDCTY Delivery city   CTY          
BPDNAM Ship-to customer name 2 NAM          
BPDPOSCOD Deliv postal code   POS          
BPDSAT Delivery country   SAT          
BPIEECNUM EU identification   A 20       DEB
CCE Dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CFMLINNBR Number of validated lines   C 4        
CHGRAT Currency rate   DCB 5.6        
CHGTYP Rate type   M 15 202      
CNCNAM Order contact   AIN     [AIN]AIN0=CNCNAM Block  
CNDNAM Delivery contact   AIN     [AIN]AIN0=CNDNAM Block  
COPNBR No. copies quote   C 1        
CPY Company   CPY     [CPY]CPY0=[VQH]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[VQH]CUR Block  
CURREVFLG Current revision   M 4 1      
CUSQUOREF Quote reference   A 20        
DAYLTI Delivery LT in days   C 3        
DEP Settlement discount   TDA     [TDA]TDA0=DEP;[V]GSUPCLE Block  
DIE Dimension type code   DIE     [DIE]DIE0=[VQH]DIE Block ANA
DISCRGTYP Discount / charge type   M 10 255     SPR
DSPTOTQTY Quantity total   DCB 9.6        
DSPTOTVOL Volume aggregation   QTY          
DSPTOTWEI Weight aggregation   QTY          
DSPVOU Volume unit   UOM     [TUN]TUN0=[VQH]DSPVOU Block  
DSPWEU Weight unit   UOM     [TUN]TUN0=[VQH]DSPWEU Block  
EECICT Incoterm   ICT     [ICTH]ICT0=[VQH]EECICT Block  
EECLOC Intrastat transport location   M 15 236     DEB
EXPNUM Export number   L 8        
FFWADD Forwarding agent address   ADR          
FFWNUM Freight agent   BPT     [BPT]BPT0=[VQH]FFWNUM Block  
GEOCOD Geographic code   GEO         KUS
ICTCTY Incoterm town   CTY          
INSCTYFLG City interior flag   A 1       KUS
INVDTA Invoicing element   SFI     [SFI]SFI0=[VQH]INVDTA Other SFI
INVDTAAMT % or amt inv el   DCB 11.4       SFI
INVDTADSP Distrib key   DSP     [DSP]DSP0=INVDTADSP;1 Other SFI
INVDTALIN Invoice line element   C 2       SPR
INVDTATYP Value type   M 6 2227     SFI
LAN Language   LAN     [TLA]TLA0=[VQH]LAN Block  
LINNBR Number of lines   C 4        
ORDDAT Order date   D          
ORDNBR Number of orders   C 2        
PBYPRC Probability %   C 3        
PFMTOT Total margin   MD1          
PJT Project   PJT     [PIM]PIM0=[VQH]PJT Block  
PLISTC Structure code   PRS     [PRS]PRS0=1;PLISTC Other  
PRFNUM Proforma invoice no.   VCR          
PRITYP Price - / +tax   M 6 243      
PTE Payment term   PTE     [TPT]TPT0=PTE;[V]GCURLEG;1 Block  
QUOATI Line amt. + tax   MD1          
QUOATIL Line amt. + tax (company)   MD1          
QUODAT Quote date   D          
QUOINVATI Valuation + tax   MD1          
QUOINVATIL Costing tax incl. cy   MD1          
QUOINVNOT Valuation - tax   MD1          
QUOINVNOTL Costing tax excl. cy   MD1          
QUONOT Line amt. - tax   MD1          
QUONOTL Line amt. - tax (company)   MD1          
QUOPRN Printed quote   M 4 1      
QUOSTA Quote status   M 15 430      
REP Sales rep   REP     [REP]REP0=[VQH]REP Block REP
REVCOD Revision code   A 1        
REVNUM Revision no.   C 4        
SALFCY Sales site   FCY     [FCY]FCY0=[VQH]SALFCY Block  
SFISSTCOD SST tax code   ADI     [ADI]CODE=203;SFISSTCOD Block SFI
SINUM Integrale part no.   A 10       SMI
SOHNUM Order no.   VCR          
SOHTYP Order type   TSO     [TSO]TSO0=SOHTYP;[V]GSUPCLE Block  
SQHCFMFLG Electronic signature   M 4 1     KPO
SQHNUM Quote no.   VCR          
SQHNUMEND Final number   VCR         KPO
SQHTEX1 Quote header text   TXC          
SQHTEX2 Quote footer text   TXC          
SQHTYP Quote type   TSQ     [TSQ]TSQ0=SQHTYP;[V]GSUPCLE Block  
SQHVALDAT Validation date   D         KPO
SSTENTCOD Entity/Use   ADI     [ADI]CODE=202;SSTENTCOD Block LTA
STOFCY Shipment site   FCY     [FCY]FCY0=[VQH]STOFCY Block  
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VACBPR Tax rule   TVB     [TVB]TVB0=VACBPR;[V]GSUPCLE Block  
VLYDAT Validity date   D          
VTT Vertex transaction type   A 1       KUS