Tabela SB1 no Protheus

A tabela SB1 do Protheus está descrita no dicionário (SX2) como “Descrição Genérica do Produto”. Possui 294 campos e 13 índices e chave única B1_FILIAL+B1_COD. Abaixo estão tipo, tamanho e descrição de cada campo, os índices e um exemplo de consulta SQL.

Propriedades da tabela

Código

SB1

Nome

Descrição Genérica do Produto

Nome (inglês)

Product Generic Description

Compartilhamento por filial

Compartilhado

Compartilhamento por unidade

Exclusivo

Compartilhamento por empresa

Exclusivo

Chave única

B1_FILIAL+B1_COD

Campos / índices

294 / 13

Perguntas frequentes sobre a tabela SB1

O que é a tabela SB1?

É a tabela “Descrição Genérica do Produto” do ERP TOTVS Protheus, com 294 campos definidos no dicionário SX3.

Qual é a chave única da tabela SB1?

A chave única é B1_FILIAL+B1_COD.

Quais são os índices da tabela SB1?

A tabela tem 13 índices. O principal (ordem 1) usa a chave B1_FILIAL+B1_COD.

Qual é o nome físico da tabela SB1 no banco de dados?

No banco, o nome é o código da tabela seguido do código da empresa (no dicionário de referência desta consulta: SB1990). Em ADVPL, use RetSqlName("SB1") para obter o nome correto do ambiente.

Exemplo de consulta SQL da tabela SB1

Modelo gerado a partir da estrutura da tabela. Ajuste os filtros ao seu cenário.

SELECT
    B1_FILIAL,
    B1_COD,
    B1_DESC,
    B1_TIPO,
    B1_CODITE,
    B1_UM,
    B1_LOCPAD,
    B1_GRUPO,
    B1_PICM,
    B1_IPI,
    B1_POSIPI,
    B1_ESPECIE,
    B1_EX_NCM,
    B1_EX_NBM,
    B1_ALIQISS,
    B1_CODISS,
    B1_TE,
    B1_TS,
    B1_PICMRET,
    B1_PICMENT,
    B1_IMPZFRC,
    B1_BITMAP,
    B1_SEGUM,
    B1_CONV,
    B1_TIPCONV,
    B1_ALTER,
    B1_QE,
    B1_PRV1,
    B1_EMIN,
    B1_CUSTD,
    B1_UCALSTD,
    B1_UPRC,
    B1_MCUSTD,
    B1_UCOM,
    B1_PESO,
    B1_ESTSEG,
    B1_ESTFOR,
    B1_FORPRZ,
    B1_PE,
    B1_TIPE,
    B1_LE,
    B1_LM,
    B1_CONTA,
    B1_TOLER,
    B1_CC,
    B1_ITEMCC,
    B1_FAMILIA,
    B1_QB,
    B1_PROC,
    B1_LOJPROC,
    B1_APROPRI,
    B1_TIPODEC,
    B1_ORIGEM,
    B1_CLASFIS,
    B1_FANTASM,
    B1_RASTRO,
    B1_UREV,
    B1_DATREF,
    B1_FORAEST,
    B1_COMIS,
    B1_MONO,
    B1_PERINV,
    B1_DTREFP1,
    B1_GRTRIB,
    B1_MRP,
    B1_NOTAMIN,
    B1_PRVALID,
    B1_NUMCOP,
    B1_CONINI,
    B1_CONTSOC,
    B1_IRRF,
    B1_CODBAR,
    B1_CODGTIN,
    B1_GRADE,
    B1_FORMLOT,
    B1_LOCALIZ,
    B1_FPCOD,
    B1_OPERPAD,
    B1_CONTRAT,
    B1_DESC_P,
    B1_DESC_GI,
    B1_DESC_I,
    B1_VLREFUS,
    B1_IMPORT,
    B1_VM_I,
    B1_VM_GI,
    B1_VM_P,
    B1_OPC,
    B1_ANUENTE,
    B1_CODOBS,
    B1_OBS,
    B1_SITPROD,
    B1_FABRIC,
    B1_MODELO,
    B1_SETOR,
    B1_BALANCA,
    B1_TECLA,
    B1_PRODPAI,
    B1_TIPOCQ,
    B1_SOLICIT,
    B1_GRUPCOM,
    B1_AGREGCU,
    B1_QUADPRO,
    B1_DESPIMP,
    B1_BASE3,
    B1_DESBSE3,
    B1_NUMCQPR,
    B1_CONTCQP,
    B1_REVATU,
    B1_CODEMB,
    B1_INSS,
    B1_ESPECIF,
    B1_MAT_PRI,
    B1_NALNCCA,
    B1_REDINSS,
    B1_NALSH,
    B1_ALADI,
    B1_REDIRRF,
    B1_TAB_IPI,
    B1_GRUDES,
    B1_REDPIS,
    B1_REDCOF,
    B1_DATASUB,
    B1_PCSLL,
    B1_PCOFINS,
    B1_PPIS,
    B1_MTBF,
    B1_MTTR,
    B1_FLAGSUG,
    B1_CLASSVE,
    B1_MIDIA,
    B1_QTMIDIA,
    B1_VLR_IPI,
    B1_ENVOBR,
    B1_QTDSER,
    B1_SERIE,
    B1_FAIXAS,
    B1_NROPAG,
    B1_ISBN,
    B1_TITORIG,
    B1_LINGUA,
    B1_EDICAO,
    B1_OBSISBN,
    B1_AFAMAD,
    B1_CLVL,
    B1_ATIVO,
    B1_EMAX,
    B1_PESBRU,
    B1_TIPCAR,
    B1_FRACPER,
    B1_VLR_ICM,
    B1_INT_ICM,
    B1_VLRSELO,
    B1_CODNOR,
    B1_CORPRI,
    B1_CORSEC,
    B1_NICONE,
    B1_ATRIB1,
    B1_ATRIB2,
    B1_ATRIB3,
    B1_REGSEQ,
    B1_CPOTENC,
    B1_POTENCI,
    B1_QTDACUM,
    B1_QTDINIC,
    B1_REQUIS,
    B1_SELO,
    B1_LOTVEN,
    B1_OK,
    B1_USAFEFO,
    B1_IAT,
    B1_IPPT,
    B1_CNATREC,
    B1_TNATREC,
    B1_AFASEMT,
    B1_AIMAMT,
    B1_TERUM,
    B1_AFUNDES,
    B1_VEREAN,
    B1_PIS,
    B1_GRPTIDC,
    B1_REFBAS,
    B1_UMOEC,
    B1_APOPRO,
    B1_MOPC,
    B1_UVLRC,
    B1_ESCRIPI,
    B1_VALEPRE,
    B1_GRPCST,
    B1_PMACNUT,
    B1_PMICNUT,
    B1_CEST,
    B1_DTFIMNT,
    B1_CLASSE,
    B1_MSBLQL,
    B1_VM_PROC,
    B1_GRPNATR,
    B1_TPPROD,
    B1_CRICMS,
    B1_AFABOV,
    B1_VIGENC,
    B1_TPREG,
    B1_CHASSI,
    B1_FECP,
    B1_PRODSBP,
    B1_TALLA,
    B1_MARKUP,
    B1_DIFCNAE,
    B1_VLR_PIS,
    B1_GDODIF,
    B1_LOTESBP,
    B1_QBP,
    B1_HREXPO,
    B1_USERLGA,
    B1_USERLGI,
    B1_INTEG,
    B1_GCCUSTO,
    B1_CCCUSTO,
    B1_CODPROC,
    B1_CODQAD,
    B1_DTCORTE,
    B1_COEFDCR,
    B1_DCI,
    B1_FUSTF,
    B1_DCRII,
    B1_DCR,
    B1_DCRE,
    B1_PARCEI,
    B1_VLCIF,
    B1_TIPOBN,
    B1_CRDEST,
    B1_ALFECOP,
    B1_AJUDIF,
    B1_AFACS,
    B1_ALFECRN,
    B1_ALFECST,
    B1_CFEM,
    B1_CFEMS,
    B1_PRINCMG,
    B1_PAFMD5,
    B1_FECPBA,
    B1_CFEMA,
    B1_CARGAE,
    B1_PAUTFET,
    B1_IDHIST,
    B1_CSLL,
    B1_COFINS,
    B1_TRIBMUN,
    B1_IMPNCM,
    B1_PORCPRL,
    B1_RPRODEP,
    B1_SITTRIB,
    B1_GRPTI,
    B1_VLR_COF,
    B1_ALFUMAC,
    B1_REGRISS,
    B1_AFETHAB,
    B1_FRETISS,
    B1_PRFDSUL,
    B1_BASE,
    B1_IVAAJU,
    B1_CODLAN,
    B1_ESTRORI,
    B1_DESBSE2,
    B1_FECOP,
    B1_CRICMST,
    B1_CALCFET,
    B1_BASE2,
    B1_FETHAB,
    B1_CNAE,
    B1_PR43080,
    B1_ADMIN,
    B1_CRDPRES,
    B1_TPDP,
    B1_RETOPER,
    B1_PERGART,
    B1_RICM65,
    B1_MSEXP,
    B1_TFETHAB,
    B1_RSATIVO,
    B1_REGESIM,
    B1_MEPLES,
    B1_PRDORI,
    B1_PRN944I,
    B1_SELOEN,
    B1_PRODREC,
    B1_CODANT,
    B1_TIPVEC,
    B1_GARANT,
    B1_COLOR,
    B1_EC05DB,
    B1_EC05CR,
    B1_EC06DB,
    B1_EC06CR
FROM SB1
WHERE
    D_E_L_E_T_ = ' '
    AND B1_FILIAL = 'VALOR'
    AND B1_COD = 'VALOR'
    AND B1_DESC = 'VALOR'
    AND B1_TIPO = 'VALOR'
    AND B1_CODITE = 'VALOR'
    AND B1_UM = 'VALOR'
    AND B1_LOCPAD = 'VALOR'
    AND B1_GRUPO = 'VALOR'
    AND B1_PICM = 0
    AND B1_IPI = 0
    AND B1_POSIPI = 'VALOR'
    AND B1_ESPECIE = 'VALOR'
    AND B1_EX_NCM = 'VALOR'
    AND B1_EX_NBM = 'VALOR'
    AND B1_ALIQISS = 0
    AND B1_CODISS = 'VALOR'
    AND B1_TE = 'VALOR'
    AND B1_TS = 'VALOR'
    AND B1_PICMRET = 0
    AND B1_PICMENT = 0
    AND B1_IMPZFRC = 'VALOR'
    AND B1_BITMAP = 'VALOR'
    AND B1_SEGUM = 'VALOR'
    AND B1_CONV = 0
    AND B1_TIPCONV = 'VALOR'
    AND B1_ALTER = 'VALOR'
    AND B1_QE = 0
    AND B1_PRV1 = 0
    AND B1_EMIN = 0
    AND B1_CUSTD = 0
    AND B1_UCALSTD BETWEEN '20261001' AND '20261031'
    AND B1_UPRC = 0
    AND B1_MCUSTD = 'VALOR'
    AND B1_UCOM BETWEEN '20261001' AND '20261031'
    AND B1_PESO = 0
    AND B1_ESTSEG = 0
    AND B1_ESTFOR = 'VALOR'
    AND B1_FORPRZ = 'VALOR'
    AND B1_PE = 0
    AND B1_TIPE = 'VALOR'
    AND B1_LE = 0
    AND B1_LM = 0
    AND B1_CONTA = 'VALOR'
    AND B1_TOLER = 0
    AND B1_CC = 'VALOR'
    AND B1_ITEMCC = 'VALOR'
    AND B1_FAMILIA = 'VALOR'
    AND B1_QB = 0
    AND B1_PROC = 'VALOR'
    AND B1_LOJPROC = 'VALOR'
    AND B1_APROPRI = 'VALOR'
    AND B1_TIPODEC = 'VALOR'
    AND B1_ORIGEM = 'VALOR'
    AND B1_CLASFIS = 'VALOR'
    AND B1_FANTASM = 'VALOR'
    AND B1_RASTRO = 'VALOR'
    AND B1_UREV BETWEEN '20261001' AND '20261031'
    AND B1_DATREF BETWEEN '20261001' AND '20261031'
    AND B1_FORAEST = 'VALOR'
    AND B1_COMIS = 0
    AND B1_MONO = 'VALOR'
    AND B1_PERINV = 0
    AND B1_DTREFP1 BETWEEN '20261001' AND '20261031'
    AND B1_GRTRIB = 'VALOR'
    AND B1_MRP = 'VALOR'
    AND B1_NOTAMIN = 0
    AND B1_PRVALID = 0
    AND B1_NUMCOP = 0
    AND B1_CONINI BETWEEN '20261001' AND '20261031'
    AND B1_CONTSOC = 'VALOR'
    AND B1_IRRF = 'VALOR'
    AND B1_CODBAR = 'VALOR'
    AND B1_CODGTIN = 'VALOR'
    AND B1_GRADE = 'VALOR'
    AND B1_FORMLOT = 'VALOR'
    AND B1_LOCALIZ = 'VALOR'
    AND B1_FPCOD = 'VALOR'
    AND B1_OPERPAD = 'VALOR'
    AND B1_CONTRAT = 'VALOR'
    AND B1_DESC_P = 'VALOR'
    AND B1_DESC_GI = 'VALOR'
    AND B1_DESC_I = 'VALOR'
    AND B1_VLREFUS = 0
    AND B1_IMPORT = 'VALOR'
    AND B1_OPC = 'VALOR'
    AND B1_ANUENTE = 'VALOR'
    AND B1_CODOBS = 'VALOR'
    AND B1_SITPROD = 'VALOR'
    AND B1_FABRIC = 'VALOR'
    AND B1_MODELO = 'VALOR'
    AND B1_SETOR = 'VALOR'
    AND B1_BALANCA = 'VALOR'
    AND B1_TECLA = 'VALOR'
    AND B1_PRODPAI = 'VALOR'
    AND B1_TIPOCQ = 'VALOR'
    AND B1_SOLICIT = 'VALOR'
    AND B1_GRUPCOM = 'VALOR'
    AND B1_AGREGCU = 'VALOR'
    AND B1_QUADPRO = 'VALOR'
    AND B1_DESPIMP = 'VALOR'
    AND B1_BASE3 = 'VALOR'
    AND B1_DESBSE3 = 'VALOR'
    AND B1_NUMCQPR = 0
    AND B1_CONTCQP = 0
    AND B1_REVATU = 'VALOR'
    AND B1_CODEMB = 'VALOR'
    AND B1_INSS = 'VALOR'
    AND B1_ESPECIF = 'VALOR'
    AND B1_MAT_PRI = 'VALOR'
    AND B1_NALNCCA = 'VALOR'
    AND B1_REDINSS = 0
    AND B1_NALSH = 'VALOR'
    AND B1_ALADI = 'VALOR'
    AND B1_REDIRRF = 0
    AND B1_TAB_IPI = 'VALOR'
    AND B1_GRUDES = 'VALOR'
    AND B1_REDPIS = 0
    AND B1_REDCOF = 0
    AND B1_DATASUB BETWEEN '20261001' AND '20261031'
    AND B1_PCSLL = 0
    AND B1_PCOFINS = 0
    AND B1_PPIS = 0
    AND B1_MTBF = 0
    AND B1_MTTR = 0
    AND B1_FLAGSUG = 'VALOR'
    AND B1_CLASSVE = 'VALOR'
    AND B1_MIDIA = 'VALOR'
    AND B1_QTMIDIA = 0
    AND B1_VLR_IPI = 0
    AND B1_ENVOBR = 'VALOR'
    AND B1_QTDSER = 'VALOR'
    AND B1_SERIE = 'VALOR'
    AND B1_FAIXAS = 0
    AND B1_NROPAG = 0
    AND B1_ISBN = 'VALOR'
    AND B1_TITORIG = 'VALOR'
    AND B1_LINGUA = 'VALOR'
    AND B1_EDICAO = 'VALOR'
    AND B1_OBSISBN = 'VALOR'
    AND B1_AFAMAD = 0
    AND B1_CLVL = 'VALOR'
    AND B1_ATIVO = 'VALOR'
    AND B1_EMAX = 0
    AND B1_PESBRU = 0
    AND B1_TIPCAR = 'VALOR'
    AND B1_FRACPER = 0
    AND B1_VLR_ICM = 0
    AND B1_INT_ICM = 0
    AND B1_VLRSELO = 0
    AND B1_CODNOR = 'VALOR'
    AND B1_CORPRI = 'VALOR'
    AND B1_CORSEC = 'VALOR'
    AND B1_NICONE = 'VALOR'
    AND B1_ATRIB1 = 'VALOR'
    AND B1_ATRIB2 = 'VALOR'
    AND B1_ATRIB3 = 'VALOR'
    AND B1_REGSEQ = 'VALOR'
    AND B1_CPOTENC = 'VALOR'
    AND B1_POTENCI = 0
    AND B1_QTDACUM = 0
    AND B1_QTDINIC = 0
    AND B1_REQUIS = 'VALOR'
    AND B1_SELO = 'VALOR'
    AND B1_LOTVEN = 0
    AND B1_OK = 'VALOR'
    AND B1_USAFEFO = 'VALOR'
    AND B1_IAT = 'VALOR'
    AND B1_IPPT = 'VALOR'
    AND B1_CNATREC = 'VALOR'
    AND B1_TNATREC = 'VALOR'
    AND B1_AFASEMT = 0
    AND B1_AIMAMT = 0
    AND B1_TERUM = 'VALOR'
    AND B1_AFUNDES = 0
    AND B1_VEREAN = 'VALOR'
    AND B1_PIS = 'VALOR'
    AND B1_GRPTIDC = 'VALOR'
    AND B1_REFBAS = 'VALOR'
    AND B1_UMOEC = 0
    AND B1_APOPRO = 'VALOR'
    AND B1_UVLRC = 0
    AND B1_ESCRIPI = 'VALOR'
    AND B1_VALEPRE = 'VALOR'
    AND B1_GRPCST = 'VALOR'
    AND B1_PMACNUT = 0
    AND B1_PMICNUT = 0
    AND B1_CEST = 'VALOR'
    AND B1_DTFIMNT BETWEEN '20261001' AND '20261031'
    AND B1_CLASSE = 'VALOR'
    AND B1_MSBLQL = 'VALOR'
    AND B1_GRPNATR = 'VALOR'
    AND B1_TPPROD = 'VALOR'
    AND B1_CRICMS = 'VALOR'
    AND B1_AFABOV = 0
    AND B1_VIGENC BETWEEN '20261001' AND '20261031'
    AND B1_TPREG = 'VALOR'
    AND B1_CHASSI = 'VALOR'
    AND B1_FECP = 0
    AND B1_PRODSBP = 'VALOR'
    AND B1_TALLA = 'VALOR'
    AND B1_MARKUP = 0
    AND B1_DIFCNAE = 'VALOR'
    AND B1_VLR_PIS = 0
    AND B1_GDODIF = 'VALOR'
    AND B1_LOTESBP = 0
    AND B1_QBP = 0
    AND B1_HREXPO = 'VALOR'
    AND B1_USERLGA = 'VALOR'
    AND B1_USERLGI = 'VALOR'
    AND B1_INTEG = 'VALOR'
    AND B1_GCCUSTO = 'VALOR'
    AND B1_CCCUSTO = 'VALOR'
    AND B1_CODPROC = 'VALOR'
    AND B1_CODQAD = 'VALOR'
    AND B1_DTCORTE BETWEEN '20261001' AND '20261031'
    AND B1_COEFDCR = 0
    AND B1_DCI = 'VALOR'
    AND B1_FUSTF = 'VALOR'
    AND B1_DCRII = 0
    AND B1_DCR = 'VALOR'
    AND B1_DCRE = 'VALOR'
    AND B1_PARCEI = 'VALOR'
    AND B1_VLCIF = 0
    AND B1_TIPOBN = 'VALOR'
    AND B1_CRDEST = 0
    AND B1_ALFECOP = 0
    AND B1_AJUDIF = 'VALOR'
    AND B1_AFACS = 0
    AND B1_ALFECRN = 0
    AND B1_ALFECST = 0
    AND B1_CFEM = 'VALOR'
    AND B1_CFEMS = 'VALOR'
    AND B1_PRINCMG = 0
    AND B1_PAFMD5 = 'VALOR'
    AND B1_FECPBA = 0
    AND B1_CFEMA = 0
    AND B1_CARGAE = 'VALOR'
    AND B1_PAUTFET = 0
    AND B1_IDHIST = 'VALOR'
    AND B1_CSLL = 'VALOR'
    AND B1_COFINS = 'VALOR'
    AND B1_TRIBMUN = 'VALOR'
    AND B1_IMPNCM = 0
    AND B1_PORCPRL = 'VALOR'
    AND B1_RPRODEP = 'VALOR'
    AND B1_SITTRIB = 'VALOR'
    AND B1_GRPTI = 'VALOR'
    AND B1_VLR_COF = 0
    AND B1_ALFUMAC = 0
    AND B1_REGRISS = 'VALOR'
    AND B1_AFETHAB = 0
    AND B1_FRETISS = 'VALOR'
    AND B1_PRFDSUL = 0
    AND B1_BASE = 'VALOR'
    AND B1_IVAAJU = 'VALOR'
    AND B1_CODLAN = 'VALOR'
    AND B1_ESTRORI = 'VALOR'
    AND B1_DESBSE2 = 'VALOR'
    AND B1_FECOP = 'VALOR'
    AND B1_CRICMST = 'VALOR'
    AND B1_CALCFET = 'VALOR'
    AND B1_BASE2 = 'VALOR'
    AND B1_FETHAB = 'VALOR'
    AND B1_CNAE = 'VALOR'
    AND B1_PR43080 = 0
    AND B1_ADMIN = 'VALOR'
    AND B1_CRDPRES = 0
    AND B1_TPDP = 'VALOR'
    AND B1_RETOPER = 'VALOR'
    AND B1_PERGART = 0
    AND B1_RICM65 = 'VALOR'
    AND B1_MSEXP = 'VALOR'
    AND B1_TFETHAB = 'VALOR'
    AND B1_RSATIVO = 'VALOR'
    AND B1_REGESIM = 'VALOR'
    AND B1_MEPLES = 'VALOR'
    AND B1_PRDORI = 'VALOR'
    AND B1_PRN944I = 'VALOR'
    AND B1_SELOEN = 'VALOR'
    AND B1_PRODREC = 'VALOR'
    AND B1_CODANT = 'VALOR'
    AND B1_TIPVEC = 'VALOR'
    AND B1_GARANT = 'VALOR'
    AND B1_COLOR = 'VALOR'
    AND B1_EC05DB = 'VALOR'
    AND B1_EC05CR = 'VALOR'
    AND B1_EC06DB = 'VALOR'
    AND B1_EC06CR = 'VALOR'

Outras tabelas relacionadas

• SB0 Dados Adicionais - Loja
• SB2 Saldos Físico e Financeiro
• SB3 Demandas
• SB4 Referência de Produto
• SB5 Dados Adicionais do Produto
• SB6 Saldo em Poder de Terceiros
• SB7 Lançamentos do Inventário
• SB8 Saldos por Lote
• SB9 Saldos Iniciais
• SBA Previsão de Vendas - Sigaloja
• SBB Tabela de Preço - Sigafas
• SBC Perda por OP

Dicionário Protheus · atualizado em 13/10/2026. Voltar ao índice do dicionário.