P_BUSINESSPLACE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA