J_1BBRANCH SAP (Business Place) Table details

Dictionary Type: Table
Description: Business Place




ABAP Code to SELECT data from J_1BBRANCH
Related tables to J_1BBRANCH
Access table J_1BBRANCH




Table field list including key, data, relationships and ABAP select examples

J_1BBRANCH is a standard SAP Table which is used to store Business Place data and is available within R/3 SAP systems depending on the version and release level.

The J_1BBRANCH table consists of various fields, each holding specific information or linking keys about Business Place data available in SAP. These include BUKRS (Company Code), BRANCH (Business Place), NAME (Name), CGC_BRANCH (CNPJ Business Place).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP J_1BBRANCH table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
BRANCHBusiness Place J_1BBRANC_CHAR4J_1BBRANCH
NAMEName NAME1CHAR30TEXT30
CGC_BRANCHCNPJ Business Place J_1BCGCBRANUMC4J_1BCGCBRA
STATE_INSCState Tax Number J_1BSTAINSCHAR18J_1BSTAINS
MUNIC_INSCMunicipal Tax Number J_1BMUNINSCHAR20J_1BMUNINS
INDUSTRYBusiness Place CFOP Category J_1BINDUS2CHAR2ALPHAJ_1BINDUS2
SINGLENota Fiscal Printed on Single Page J_1BSINGLECHAR1XFELD
ADRNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
NFDECDecimal Places in Price Inclusive of ICMS J_1BNFDECNUMC1J_1BNFDEC
KR_REPRESName of Representative REPRESCHAR10REPRES
KR_BUSTYPEType of Business GESTYPCHAR30BUSTYPEGESTYP
KR_INDTYPEType of Industry INDTYPCHAR30INDUSTYPEINDTYP
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
KR_TAXOFFDistrict Tax Office TAXOFFCHAR3TAXOFFICETAXOFF
PAC01Print Authorization Code J_1APACCHAR14J_1APAC
VDP01Print Authorization Code: Valid-To Date J_1APACVDDATS8DATUM
PAC02Print Authorization Code J_1APACCHAR14J_1APAC
VDP02Print Authorization Code: Valid-To Date J_1APACVDDATS8DATUM
IPICONTRIBUTORIPI contributor J_1BIPICONTRIBUTORCHAR1XFELD
IDSIGNSigner of the Tax Invoice IDSIGNCHAR30TEXT30
SOURE_DANGERGOODNota Fiscal: Source of Dangerous Goods Data J_1B_SOURCE_DANGER_GOODS_DATACHAR1J_1B_SOURCE_DANGER_GOODS_DATA
SUFRAMASuframa Code J_1BSUFRAMACHAR9Assigned to domainJ_1BSUFRAMA
NIRENIRE ID J_1BNIRENUMC11J_1BNIRE
NIREDTNIRE Date J_1BNIREDTDATS8DATUM
SPEDACTINDSPED Activity Indicator J_1BSPEDACTINDCHAR1Assigned to domainJ_1BSPEDACTIND
CNAECNAE J_1BCNAECHAR7J_1BTCNAEJ_1BCNAE
LEGALNATLegal Nature J_1BLEGALNATNUMC4J_1BTLEGALNATJ_1BLEGALNAT
CRTNCRT Number J_1BCRTNCHAR1Assigned to domainJ_1BCRTN
ICMSTAXPAYICMS Taxpayer J_1BICMSTAXPAYCHAR2J_1BTICMSTAXPAYJ_1BICMSTAXPAY
INDTYPIndustry Main Type J_1BINDTYPCHAR2J_1BTINDTYPJ_1BINDTYP
TDTTax Declaration Type J_1BTDTCHAR2J_1BTTDTJ_1BTDT
COMSIZECompany Size J_1BCOMSIZECHAR2J_1BTCOMSIZEJ_1BCOMSIZE
DECREGPCDeclaration Regimen for PIS/COFINS J_1BDECREGPCCHAR2J_1BTDECREGPCJ_1BDECREGPC

Key field Non-key field



How do I retrieve data from SAP table J_1BBRANCH using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1BBRANCH to SELECT all data from the table
DATA: WA_J_1BBRANCH TYPE J_1BBRANCH.

SELECT SINGLE *
FROM J_1BBRANCH
INTO CORRESPONDING FIELDS OF WA_J_1BBRANCH
WHERE...

How to access SAP table J_1BBRANCH

Within an ECC or HANA version of SAP you can also view further information about J_1BBRANCH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!