on 08-02-2016 7:21 PM
Bom dia Ricardo.
É possível você efetuar isso pelo gerador de consulta, segue exemplo:
Em menu - ferramentas - consultas - gerador de consultas.
Nessa tela você conseguirá inserir cada tabela.
Você conseguirá identificar o nome da tabela no SAP efetuando:
Ativando a visão do sistema: Com essa ativação, o SAP exibirá o nome da tabela e coluna.
Exemplo:
Segue uma nova.
SELECT T0.Code, T0.Name, T0.Rate, T0.UserSign, T0.ValidForAR, T0.ValidForAP, T0.TfcId, T0.Lock, T0.TaxIcms, T0.IsItmLevel, T0.CfopIn, T0.CfopOut, T0.FADebit, T1.STCCode, T1.Line_ID, T1.STACode, T1.STAType, T1.TaxOnTCode, T1.TaxOnTType, T1.EfctivRate, T1.FmlId, T1.CstCodeIn, T1.CstSuffix, T2.Code, T2.Name, T2.Rate, T2.SalesTax, T2.UseTax, T2.Type, T2.UserSign, T2.PurchTax, T2.deferrAcct, T2.NonDdctPrc, T2.NonDdctAct, T2.TaxInPrice, T2.Exempt, T2.APExpAct, T2.ARExpAct, T2.CredBala, T2.CredFG, T2.CredCG, T2.InGrossRev, T2.EfctDate, T2.SvcTaxCr, T2.MinAmount, T2.MaxAmount, T2.FlatAmount, T2.TextCode, T2.UnencumTax
FROM OSTC T0 INNER JOIN STC1 T1 ON T0.[Code] = T1.[STCCode] INNER JOIN OSTA T2 ON T1.[STACode] = T2.[Code]
Caso atender a necessidade, favor, encerre esse tópico.
Abraços!
Att,
Luiz Assis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Oi Ricardo,
Segue um exemplo:
Modifique o valor do code para o código do imposto.
SELECT T1.STCCode,T0.[Name], T0.[Rate], T0.[CfopIn], T0.[CfopOut], T0.[TaxIcms], T1.Line_ID, T1.STACode, T1.STAType, T1.TaxOnTCode, T1.TaxOnTType, T1.EfctivRate, T1.FmlId, T1.CstCodeIn, T1.CstSuffix FROM [dbo].[OSTC] T0 INNER JOIN STC1 T1 ON T0.[Code] = T1.[STCCode] WHERE T0.[Code] = ' inserir o código do imposto aqui'.
Abraços!
Att,
Luiz Assis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
tipo isso:
SELECT T1.STCCode,T0.[Name], T0.[Rate], T0.[CfopIn], T0.[CfopOut], T0.[TaxIcms], T1.Line_ID, T1.STACode, t2.name, T1.STAType, T1.TaxOnTCode, T1.TaxOnTType, T1.EfctivRate, T1.FmlId, T1.CstCodeIn, T1.CstSuffix FROM [dbo].[OSTC] T0 INNER JOIN STC1 T1 ON T0.[Code] = T1.[STCCode] T1 INNER JOIN OSTA T2 ON T1.[STACode] = T2.[Code]
Segue um nova com mais colunas.
SELECT T1.[STACode], T0.Code, T0.Name, T0.Rate, T0.UserSign, T0.ValidForAR, T0.ValidForAP, T0.TfcId, T0.Lock, T0.TaxIcms, T0.IsItmLevel, T0.CfopIn, T0.CfopOut, T0.FADebit, T1.STCCode, T1.Line_ID, T1.STACode, T1.STAType, T1.TaxOnTCode, T1.TaxOnTType, T1.EfctivRate, T1.FmlId, T1.CstCodeIn, T1.CstSuffix FROM [dbo].[OSTC] T0 INNER JOIN STC1 T1 ON T0.[Code] = T1.[STCCode]
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.