Site-ul consultantilor SAP din Romania
http://sap-consulting.ro/phpbb/

D934,Jurnale TVA - Select ...BSIS,BSAS,BSEG
http://sap-consulting.ro/phpbb/viewtopic.php?f=1&t=2042		 Pagina 1 din 1
Autor:  MIRCEA BULAI [ Vin, 23-Noi-2012 11:02 ]
Subiectul mesajului:  D934,Jurnale TVA - Select ...BSIS,BSAS,BSEG
Hi, all
Pentru D394 si Jurnalele de Tva - intr_o rutina am inclus fraze select de forma de mai jos pe tabela BSIS respectiv BSAS.
Problema e ca BSIS contine peste 25.000.000 de inregistrari si fraza select / BSIS - dureaza ... dureaza ... si iar dureaza.
Intrebare:
1. Ce optimizari as mai putea efectua pentru micsorarea timpului de raspuns ?
2. Crearea de index secundar / tabela BSIS ar rezolva oare problema ? Pe ce campuri sa generez index .?
3. Cu ce tranzactie se face clearingul notelor contabile , pentru transferul lor din BSIS in BSAS . Ce efecte ar avea acest clearing asupra tranzactiilor financiare ( Ex. FBLxx).
Help me !


SELECT BSIS~BUKRS BSIS~BELNR BSIS~BUZEI BSIS~BSCHL BSIS~BUDAT BSIS~DMBTR BSIS~WRBTR BSIS~GJAHR BSIS~GSBER BSIS~HKONT BSIS~PSWBT BSIS~PSWSL BSIS~SGTXT BSIS~BLDAT BSIS~SHKZG BSIS~ZUONR BSIS~MWSKZ BSIS~XBLNR BSIS~XNEGP
INTO CORRESPONDING FIELDS OF TABLE IT_BSIS
FROM BSIS
WHERE BSIS~BUKRS = wBUKRS AND
BSIS~GJAHR between wYearMin and wYearMax and
BUDAT IN PERIOADA AND
BSIS~GSBER IN DOMENIU AND
( ( BSIS~HKONT IN KONTBALA AND
BSIS~MWSKZ IN GRUPATVA ) OR
( BSIS~HKONT = '0041111000' AND BSIS~MWSKZ = 'A4' ) ).
* Din jurnalul de cumparari - trebuie excluse inregistrarile
* cu MWSKZ = 'A4' si HKONT = '0041111000' - care trebuie
* incluse doar in jurnalul de vanzari
If TipTaxa = 'V'. " Jurnal de Cumparari
delete IT_BSIS where HKONT = '0041111000' and
MWSKZ = 'A4'.
EndIf.
** SELECTIE DOCUMENETE PE CARE SAU EFECTUAT CLEARING SI A FOST MUTATE IN BSAS
*
PERFORM ProgressShow USING 'Selectie Documente Contabile-BSAS' ' '.
Refresh it_BSAS.
SELECT BSAS~BUKRS BSAS~BELNR BSAS~BUZEI BSAS~BSCHL BSAS~BUDAT BSAS~DMBTR BSAS~WRBTR BSAS~GJAHR BSAS~GSBER BSAS~HKONT BSAS~PSWBT BSAS~PSWSL BSAS~SGTXT BSAS~BLDAT BSAS~SHKZG BSAS~ZUONR BSAS~MWSKZ BSAS~XBLNR BSAS~XNEGP
INTO CORRESPONDING FIELDS OF TABLE IT_BSAS
FROM BSAS
WHERE BSAS~BUKRS = wBUKRS AND
BSAS~GJAHR between wYearMin and wYearMax and
BUDAT IN PERIOADA AND
BSAS~GSBER IN DOMENIU AND
( ( BSAS~HKONT IN KONTBALA AND
BSAS~MWSKZ IN GRUPATVA ) OR
( BSAS~HKONT = '0041111000' AND
BSAS~MWSKZ = 'A4' ) ).
*
* Din jurnalul de cumparari - trebuie excluse inregistrarile
* cu MWSKZ = 'A4' si HKONT = '0041111000' - care trebuie
* incluse doar in jurnalul de vanzari
If TipTaxa = 'V'. " Jurnal de Cumparari
delete IT_BSAS where HKONT = '0041111000' and
MWSKZ = 'A4'.
EndIf.
Pagina 1 din 1 Ora este UTC + 2 [ DST ]
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/