P_BUSINESSPLACE

CDS View

P_BUSINESSPLACE is a CDS View in S/4HANA. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BusinessPlace view from BASIC Business Place
I_BusinessPlaceVH view_entity from BASIC Value for Business Place
I_CN_TaxEntity view from BASIC CN Tax Entity
P_BusinessPlace_VH view from BASIC
P_RecrrgSuplrInvcBusPlaceVH view from BASIC

Fields (16)

KeyField CDS FieldsUsed in Views
KEY branch CN_TaxEntityID 1
KEY bukrs CompanyCode 1
buscode KR_TaxBusinessCode 1
department_name ResponsibleDepartmentName 1
gestyp BusinessTypeList 1
indtypn IndustryTypeList 1
kr_bustype BusinessType 1
kr_indtype IndustryType 1
kr_repres TaxInvoiceRepresentativeName 1
kr_taxoff DistrictTaxOffice 1
name BusinessPlaceName,CN_TaxParEntityTxt 1
ntsnumber NatlTaxServiceRegnNumber 1
person_email1 ResponsiblePersonEmailAddress1 1
person_name ResponsiblePersonName 1
represn TaxInvoiceRepresentativeName1 1
tax_reg_nmbr CN_TaxRegnNmbr 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BUSINESSPLACE (
    BRANCH,
    BUKRS,
    BUSCODE,
    DEPARTMENT_NAME,
    GESTYP,
    INDTYPN,
    KR_BUSTYPE,
    KR_INDTYPE,
    KR_REPRES,
    KR_TAXOFF,
    NAME,
    NTSNUMBER,
    PERSON_EMAIL1,
    PERSON_NAME,
    REPRESN,
    TAX_REG_NMBR,
    PRIMARY KEY (BRANCH, BUKRS)
);