J_1BBRANCH

Transparent Table Customizing Table
28 Fields 7 CDS Views

Geschäftsort

J_1BBRANCH is an SAP database table in S/4HANA. Geschäftsort. It contains 28 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_BusinessPlace view from EXTENSION Extension for BusinessPlace
I_BR_BusinessPlace view from BASIC Brazil Nota Fiscal Business Place
I_Branch view from BASIC Branch
I_IN_BusinessPlace view from BASIC Value help Business Places in India
P_BusinessPlace view from BASIC Business Place
P_IN_BUSINESSPLACE view_entity from BASIC GST India Business Place
R_IN_GSTR3BSummaryAPIDetail view_entity inner BASIC GSTR3B details from Tax authority

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY branch j_1bbranc_ Business Place
KEY bupla_type glo_bupla_type_code Type Code
name name1 Name 1
validfrom glo_bupla_validfrom
validto glo_bupla_validto
cgc_branch j_1bcgcbra CNPJ Bus. Place
state_insc j_1bstains State Tax No.
munic_insc j_1bmunins Munic. Tax No.
industry j_1bindus2 BP CFOP Cat.
single j_1bsingle Single Page
adrnr adrnr Address
nfdec j_1bnfdec NF Price DecPl.
kr_repres repres Rep's Name
kr_bustype gestyp Type of Business
kr_indtype indtyp Type of Industry
stcd1 stcd1 Tax Number 1
stcd2 stcd2 Tax Number 2
stcd5 stcd5 Tax Number 5
kr_taxoff taxoff Dis. Tax Office
pac01 j_1apac Print Auth. Code
vdp01 j_1apacvd PAC Valid-To Date
pac02 j_1apac Print Auth. Code
vdp02 j_1apacvd PAC Valid-To Date
ipicontributor j_1bipicontributor IPI Contributor
idsign idsign Signer of Tax Inv
soure_dangergood j_1b_source_danger_goods_data Dangerous Goods

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Geschäftsort
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BBRANCH (
    MANDT,             -- Client [mandt]
    BUKRS,             -- Company Code [bukrs]
    BRANCH,            -- Business Place [j_1bbranc_]
    BUPLA_TYPE,        -- Type Code [glo_bupla_type_code]
    NAME,              -- Name 1 [name1]
    VALIDFROM,         -- glo_bupla_validfrom
    VALIDTO,           -- glo_bupla_validto
    CGC_BRANCH,        -- CNPJ Bus. Place [j_1bcgcbra]
    STATE_INSC,        -- State Tax No. [j_1bstains]
    MUNIC_INSC,        -- Munic. Tax No. [j_1bmunins]
    INDUSTRY,          -- BP CFOP Cat. [j_1bindus2]
    SINGLE,            -- Single Page [j_1bsingle]
    ADRNR,             -- Address [adrnr]
    NFDEC,             -- NF Price DecPl. [j_1bnfdec]
    KR_REPRES,         -- Rep's Name [repres]
    KR_BUSTYPE,        -- Type of Business [gestyp]
    KR_INDTYPE,        -- Type of Industry [indtyp]
    STCD1,             -- Tax Number 1 [stcd1]
    STCD2,             -- Tax Number 2 [stcd2]
    STCD5,             -- Tax Number 5 [stcd5]
    KR_TAXOFF,         -- Dis. Tax Office [taxoff]
    PAC01,             -- Print Auth. Code [j_1apac]
    VDP01,             -- PAC Valid-To Date [j_1apacvd]
    PAC02,             -- Print Auth. Code [j_1apac]
    VDP02,             -- PAC Valid-To Date [j_1apacvd]
    IPICONTRIBUTOR,    -- IPI Contributor [j_1bipicontributor]
    IDSIGN,            -- Signer of Tax Inv [idsign]
    SOURE_DANGERGOOD,  -- Dangerous Goods [j_1b_source_danger_goods_data]
    PRIMARY KEY (MANDT, BUKRS, BRANCH, BUPLA_TYPE)
);

Learn More