Select data from sap tables J1
Display SAP table details
J11DABE1 - TR-EDT: Transfer of Flow Data
J11SDA1 - Send Structure for TR-EDT Receiever Structure JBIUDA1
J11SDAB - Send Structure for TR-EDT Receiver Structure JBIUDAB
J11SPA1 - Send Structure for TR-EDT Receiver Structure JBIUPA1
J11TRDSVV - RF-VV R/2 Loans: Master Data
J11TRGPVV - RF-FAM R/2 Business Partner
J1BCONALV - Consignmenet Settlament Brazil ALV display structure
J1BSDIC_ISMINBR - Append structure for IS-Mining Brazil
J1BSEQLAW - Sequence number for taxlaw messages (Brazil)
J1B_APPEND_LOC_AB - Country Fields for Brazil Localization
J1B_ERROR_DDA - Master Table for DDA_Brazil (Segment G)
J1B_ERROR_DDA_S - Structure for DDA_Brazil (Segment G)
J1B_NF_ODATA_EXTENSION2 - Extensions2 for XML file
J1B_NF_XML_A - NF-e Block A / Layout (Tag intNFe)
J1B_NF_XML_B - NF-e Block B / Identification (Tag: Ide)
J1B_NF_XML_B1 - NF-e Block B1 / Access key
J1B_NF_XML_B12 - Nota Fiscal Eletronica / NFe - reference documents
J1B_NF_XML_B12_V20 - Nota Fiscal Eletronica - reference documents, Version 2.0
J1B_NF_XML_BADI_B12_V20 - NF-e BAdI - reference documents, Version 2.0
J1B_NF_XML_BADI_HEADER - NFe XML Header fields / structures filled via BADI
J1B_NF_XML_BADI_HEADER_V20 - NFe XML Header fields/structures filled via BADI, Vers. 2.0
J1B_NF_XML_BADI_ITEM - NFe XML Item fields / Structures filled via BADI
J1B_NF_XML_BADI_ITEM_V20 - NFe XML Item fields/structures filled via BADI, Version 2.0
J1B_NF_XML_C - NF-e Block C / Issuer identification / Tag: emit
J1B_NF_XML_C1 - NF-e Block C1 / Issuer identification / Tag: enderEmit
J1B_NF_XML_D - NF-e Block D / Authorities data (blank from ERP) Tag avulsa
J1B_NF_XML_E - NF-e Block E / Ident.ship-from / ship-to / Tag: dest
J1B_NF_XML_E1 - NF-e Block E1 / Ident.ship-from / ship-to / Tag: enderDest
J1B_NF_XML_EXTENSION1 - Extensions1 for XML file
J1B_NF_XML_EXTENSION2 - Extensions2 for XML file
J1B_NF_XML_F - NF-e Block F / Ident.different ship from / Tag: retirada
J1B_NF_XML_G - NF-e Block G / Different ship to location / Tag entrega
J1B_NF_XML_H - NF-e Block H / Products and Services of the NF-e /Tag: det
J1B_NF_XML_H1 - NF-e Block H1 / Products and Services of the NF-e /Tag: prod
J1B_NF_XML_H1_OLD - NF-e Block H1 / Products and Services of the NF-e /Tag: prod
J1B_NF_XML_H2 - NF-e Block H2 / Import Declaration /Tag: DI
J1B_NF_XML_H3 - NF-e Block H2 / Import Declaration Add. Data /Tag: ADI
J1B_NF_XML_H3_V20 - NF-e Block H2 / Imp. Decl. Add. Data /Tag: ADI, Vers. 2
J1B_NF_XML_H4 - NF-e Block H4/ Import Declaration
J1B_NF_XML_HEADER - Nota Fiscal Eletronica / NF-e Data - HEADER (1:1)
J1B_NF_XML_HEADER_V20 - Nota Fiscal Eletronica / NF-e Data - HEADER (1:1), Vers. 2
J1B_NF_XML_HEADER_V20_SUGAR - NF-e Data - HEADER - Version 2 - Sugar Cane
J1B_NF_XML_H_OLD - NF-e Block H / Products and Services of the NF-e /Tag: det
J1B_NF_XML_I - NF-e Block I / New Vehicles /Tag: veic
J1B_NF_XML_ITEM - Nota Fiscal Eletronica / NF-e Data - Item (1:n)
J1B_NF_XML_ITEM_OLD - Nota Fiscal Eletronica / NF-e Data - Item (1:n)
J1B_NF_XML_ITEM_V110_OIL - Nota Fiscal Eletronica / NF-e Data Item Version 1.10 IS-Oil
J1B_NF_XML_ITEM_V20 - Nota Fiscal Eletronica / NF-e Data - Item (1:n) - Vers. 2.0
J1B_NF_XML_ITEM_V20_INTER - Nota Fiscal Eletronica / NF-e Data ITEM: Interstate Vers 2.0
J1B_NF_XML_J - NF-e Block J / Medicaments /Tag: med
J1B_NF_XML_K - NF-e Block H4 / Guns / Tag: gun
J1B_NF_XML_K_V20 - NF-e Block H4 / Guns / Tag: gun, Version 2
J1B_NF_XML_L - NF-e Block L / Taxes /Tag: impostos
J1B_NF_XML_L1 - NF-e Block L1 / Taxes ICMS /Tag: ICMS
J1B_NF_XML_L1_00 - NF-e Block L1_00 / Taxes ICMS /Tag: ICMS00
J1B_NF_XML_L1_10 - NF-e Block L1_10 / Taxes ICMS /Tag: ICMS10
J1B_NF_XML_L1_20 - NF-e Block L1_20 / Taxes ICMS /Tag: ICMS20
J1B_NF_XML_L1_2R - NF-e Block L1_2R - Vers 2.0
J1B_NF_XML_L1_30 - NF-e Block L1_30 / Taxes ICMS /Tag: ICMS30
J1B_NF_XML_L1_40 - NF-e Block L1_40 / Taxes ICMS /Tag: ICMS40
J1B_NF_XML_L1_51 - NF-e Block L1_51 / Taxes ICMS /Tag: ICMS51
J1B_NF_XML_L1_60 - NF-e Block L1_60 / Taxes ICMS /Tag: ICMS60
J1B_NF_XML_L1_70 - NF-e Block L1_70 / Taxes ICMS /Tag: ICMS70
J1B_NF_XML_L1_90 - NF-e Block L1_90 / Taxes ICMS /Tag: ICMS90
J1B_NF_XML_M - NF-e Block M / Taxes SubTrib /Tag: ICMSST
J1B_NF_XML_N - NF-e Block N / Taxes IPI /Tag: IPI
J1B_NF_XML_N0 - NF-e Block N0 / Taxes IPI /Tag: IPI
J1B_NF_XML_N1 - NF-e Block N1 / Taxes IPI /Tag: IPITrip
J1B_NF_XML_N2 - NF-e Block N2 / Taxes IPI /Tag: IPINT
J1B_NF_XML_NLACRE - NF-e Transport Carrier Volumes (VOL))/Tag: nLacre
J1B_NF_XML_O - NF-e Block O / Taxes Import /Tag: II
J1B_NF_XML_OBS - NF-e XML, Authority / Company Free Usage Fields Group
J1B_NF_XML_OBS_CONT - NF-e XML, Company Free Usage Fields Group
J1B_NF_XML_OBS_FISCO - NF-e XML, Authority Free Usage Fields Group
J1B_NF_XML_P - NF-e Block P / Taxes PIS /Tag: PIS
J1B_NF_XML_P1 - NF-e Block P1/ Taxes PIS /Tag: PISAlig
J1B_NF_XML_P2 - NF-e Block P2 / Taxes PIS /Tag: PISQtde
J1B_NF_XML_P3 - NF-e Block P2 / Taxes PIS /Tag: PISNT
J1B_NF_XML_P4 - NF-e Block P4 / Taxes PIS /Tag: PISOutr
J1B_NF_XML_P5 - NF-e Block P5 / Taxes PIS /Tag: PISST - Selling Zona Franca
J1B_NF_XML_PICMSINTER - Interstate tax rate of UF involved
J1B_NF_XML_PROC_REF - NF-e XML, Referenced Processes
J1B_NF_XML_Q - NF-e Block Q / Taxes COFINS /Tag: COFINS
J1B_NF_XML_Q1 - NF-e Block Q1 / Taxes COFINS /Tag: COFINSAlig
J1B_NF_XML_Q2 - NF-e Block Q2/ Taxes COFINS /Tag: COFINSQtde
J1B_NF_XML_Q3 - NF-e Block Q3 / Taxes COFINS /Tag: COFINSNT
J1B_NF_XML_Q4 - NF-e Block Q4 / Taxes COFINS /Tag: COFINS
J1B_NF_XML_Q5 - NF-e Block Q5 / Taxes COFINS /Tag: COFINSST - SD Zona Franca
J1B_NF_XML_R - NF-e Block R / Content of Tax laws /Tag:
J1B_NF_XML_REF_PROC - NF-e XML, Referenced Processes
J1B_NF_XML_RETURN - Return Information from XI
J1B_NF_XML_S - NF-e Block S / Total values / Tag: Total
J1B_NF_XML_S1 - NF-e Block S1 /Total val taxes excluding ISS / Tag: ICMSTot
J1B_NF_XML_S2 - NF-e Block S2 / Total values ISS / Tag: ISSQNTot
J1B_NF_XML_S3 - NF-e Block S3 / Total values WHT / Tag: retTrib
J1B_NF_XML_T - NF-e Block T / Transport / Tag: Transp
J1B_NF_XML_T1 - NF-e Block T1 / Transport Carrier / Tag: Transporta
J1B_NF_XML_T2 - NF-e Block T2 / Transport Carrier Vehicle /Tag: veicTransp
J1B_NF_XML_T3 - NF-e Block T3 / Transport Carrier Trailer / Tag: Reboque
J1B_NF_XML_T3_V20 - NF-e Block T3 / Transport Trailer / Tag: Reboque, Vers. 2
J1B_NF_XML_T4 - NF-e Block T4/ Transport Carrier Volumes (VOL))/Tag: vol
J1B_NF_XML_T5 - NF-e Block T5 / Transport Carrier / Tag: retTransp
J1B_NF_XML_T6 - NF-e Block T6/ Transport Carrier Volumes (VOL))/Tag: vol
J1B_NF_XML_TEC_RESP - Technically Responsible Data
J1B_NF_XML_TEC_RESP_CTE - Technically Responsible Data
J1B_NF_XML_U - NF-e Block U / Cobrança / Tag: cobr
J1B_NF_XML_U1 - NF-e Block U1 / Cobrança fatura / Tag: fat
J1B_NF_XML_U2 - NF-e Block U2 / Cobrança duplicata / Tag:dup
J1B_NF_XML_U3 - NF-e Block U2 / Cobrança duplicata / Tag:dup
J1B_NF_XML_V - NF-e Block V / Additional Information / Tag: infAdic
J1B_NF_XML_W - NF-e Block W / Impor t / Export / Tag: COMEX
J1B_NF_XML_W1 - NF-e Block W / Import / Tag: Importa
J1B_NF_XML_W2 - NF-e Block W / Export / Tag: Exporta
J1B_NF_XML_X - NF-e Block / Taxes ISS /Tag: ISSQN
J1B_NF_XML_Z - NF-e Block Z /Additional Data - Document numbers from ERP
J1B_NF_XML_ZC_DEDUC - NF-e XML, Sugar Cane - Deductions Group (new with vers. 2)
J1B_NF_XML_ZC_FORDIA - NF-e XML, Daily Sugar Cane Supply Group (new with version 2)
J1B_SUSAGE - Customer Usage Measurement
J1IGSUBCAUTOV - Generated Table for View
J1I_CERT_SUMMTAB - Form 16A TDS Certificate Summary table
J1I_CHALL_SUMMTAB - Form 16A Challan Summary
Return Table index