P_BUSINESSPLACE
P_BUSINESSPLACE is a CDS View in S/4HANA. It contains 54 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BusinessPlace | view | from | BASIC | Business Place Information |
| I_CN_TaxEntity | view | from | BASIC | CN Tax Entity |
| P_BusinessPlace_VH | view | from | BASIC | |
| P_RecrrgSuplrInvcBusPlaceVH | view | from | BASIC |
Fields (54)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | bukrs | CompanyCode | 1 |
| aut_add_data_imp | BR_AutomAddDataIsImplemented | 1 | |
| branch_long | TH_BusinessPlace | 1 | |
| bupla_class | IN_BusinessPlaceClassification | 1 | |
| buscode | KR_TaxBusinessCode | 1 | |
| cgc_branch | BR_BusinessPlacePartOfCNPJ | 1 | |
| cnae | BR_CNAE | 1 | |
| cnbp_enabled | CN_ChinaBusinessPlaceIsEnabled | 1 | |
| cofinscontributor | BR_SoclScrtyFinceIsContributor | 1 | |
| comsize | BR_BPCompanySizeType | 1 | |
| crtn | BR_TaxRegimenCode | 1 | |
| decld_drct_conn_enbld | CN_TxInvcDeclnVATConncnIsEnbld,CN_VATDecldDrctConncnIsEnbld | 2 | |
| decregpc | BR_PISAndCOFINSDeclnRegimen | 1 | |
| department_name | ResponsibleDepartmentName | 1 | |
| edoc_ph_certid | PH_ElctrncDocCertificateNumber | 1 | |
| gestyp | BusinessTypeList | 1 | |
| gstcd | PH_TaxIdentificationNumber | 1 | |
| gstin | IN_GSTIdentificationNumber | 1 | |
| icmscontributor | BR_ICMSIsContributor | 1 | |
| icmsstcontributor | BR_ICMSSTIsContributor | 1 | |
| icmstaxpay | BR_ICMSTaxPayerType | 1 | |
| idsign | SignerOfTaxInvoice | 1 | |
| indtyp | BR_IndustryMainType | 1 | |
| indtypn | IndustryTypeList | 1 | |
| industry | BR_BusinessPlaceCFOPCategory | 1 | |
| invc_postg_sync_enbld | CN_TxInvcDeclnInvcSyncIsEnbld,CN_VATPostingSyncIsEnbld | 2 | |
| ipicontributor | BR_IPIIsContributor | 1 | |
| isscontributor | BR_ISSIsContributor | 1 | |
| kr_bustype | BusinessType | 1 | |
| kr_indtype | IndustryType | 1 | |
| kr_repres | TaxInvoiceRepresentativeName | 1 | |
| kr_taxoff | DistrictTaxOffice | 1 | |
| legalnat | BR_BPLegalNatureType | 1 | |
| mng_drct_conn_enbld | CN_TxInvcMngVATConncnIsEnbld,CN_VATDirectConnectionIsEnbld | 2 | |
| munic_insc | BusPlaceMunicipalTaxNumber | 1 | |
| name | BusinessPlaceName,CN_TaxParEntityTxt | 1 | |
| nfdec | BR_DecimalPlacesInPrcgInclv | 1 | |
| nire | BR_NIREIdentifier | 1 | |
| niredt | BR_NIREDate | 1 | |
| ntsnumber | NatlTaxServiceRegnNumber | 1 | |
| person_email1 | ResponsiblePersonEmailAddress1 | 1 | |
| person_name | ResponsiblePersonName | 1 | |
| piscontributor | BR_PISIsContributor | 1 | |
| prefix | AR_PrefixForFiscalBranch | 1 | |
| represn | TaxInvoiceRepresentativeName1 | 1 | |
| single | BR_NFPrintedIsOnSinglePage | 1 | |
| soure_dangergood | BR_NFSrceOfDangerousGoodsData | 1 | |
| spedactind | BusinessPlaceActivity | 1 | |
| state_insc | BusinessPlaceStateTaxNumber | 1 | |
| suframa | BR_SUFRAMACode | 1 | |
| tax_reg_nmbr | CN_TaxRegnNmbr | 2 | |
| tdt | BR_TaxDeclarationType | 1 | |
| valid_from | CN_BusinessPlaceStartDate | 1 | |
| valid_to | CN_BusinessPlaceEndDate | 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 (
BUKRS,
AUT_ADD_DATA_IMP,
BRANCH_LONG,
BUPLA_CLASS,
BUSCODE,
CGC_BRANCH,
CNAE,
CNBP_ENABLED,
COFINSCONTRIBUTOR,
COMSIZE,
CRTN,
DECLD_DRCT_CONN_ENBLD,
DECREGPC,
DEPARTMENT_NAME,
EDOC_PH_CERTID,
GESTYP,
GSTCD,
GSTIN,
ICMSCONTRIBUTOR,
ICMSSTCONTRIBUTOR,
ICMSTAXPAY,
IDSIGN,
INDTYP,
INDTYPN,
INDUSTRY,
INVC_POSTG_SYNC_ENBLD,
IPICONTRIBUTOR,
ISSCONTRIBUTOR,
KR_BUSTYPE,
KR_INDTYPE,
KR_REPRES,
KR_TAXOFF,
LEGALNAT,
MNG_DRCT_CONN_ENBLD,
MUNIC_INSC,
NAME,
NFDEC,
NIRE,
NIREDT,
NTSNUMBER,
PERSON_EMAIL1,
PERSON_NAME,
PISCONTRIBUTOR,
PREFIX,
REPRESN,
SINGLE,
SOURE_DANGERGOOD,
SPEDACTIND,
STATE_INSC,
SUFRAMA,
TAX_REG_NMBR,
TDT,
VALID_FROM,
VALID_TO,
PRIMARY KEY (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