I_BR_BUSINESSPLACE

CDS View

Brazil Nota Fiscal Business Place

I_BR_BUSINESSPLACE is a CDS View in S/4HANA. Brazil Nota Fiscal Business Place. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BR_BusinessPlace_C view from COMPOSITE Brazil Nota Fiscal Business Place
I_BR_NFBusinessPlace_SH view from BASIC Brazil Nota Fiscal Business Place
P_BR_RptgBusinessPlaceCNPJ view from CONSUMPTION EFD - Business Place Addl Specifications

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 2
KEY Branch Branch 3
KEY CompanyCode CompanyCode 3
BR_SUFRAMACode BR_SUFRAMACode 2
BusinessPlaceActivity BusinessPlaceActivity 1
BusinessPlaceName BusinessPlaceName 1
BusinessPlaceStateTaxNumber BusinessPlaceStateTaxNumber 1
BusPlaceMunicipalTaxNumber BusPlaceMunicipalTaxNumber 1

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.

-- Brazil Nota Fiscal Business Place
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BR_BUSINESSPLACE (
    ADDRESSID,
    BRANCH,
    COMPANYCODE,
    BR_SUFRAMACODE,
    BUSINESSPLACEACTIVITY,
    BUSINESSPLACENAME,
    BUSINESSPLACESTATETAXNUMBER,
    BUSPLACEMUNICIPALTAXNUMBER,
    PRIMARY KEY (ADDRESSID, BRANCH, COMPANYCODE)
);