I_BUSINESSPLACE
Business Place Information
I_BUSINESSPLACE is a CDS View in S/4HANA. Business Place Information. It contains 58 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_BusinessPlace | view | from | BASIC | Business Place |
| C_BusinessPlaceDP | view_entity | from | CONSUMPTION | Business Place Information |
| C_BusinessPlaceVH | view | from | CONSUMPTION | Business Place Value Help |
| I_BusinessPlaceVH | view_entity | from | BASIC | Value for Business Place |
| I_PaytReceiptBusinessPlaceVH | view | from | BASIC | Payment Receipt Business Place |
| P_KR_BusinessPlace | view | from | COMPOSITE | KR ACR: Business Place Information temp view |
Fields (58)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPlace | Branch | 1 |
| KEY | CompanyCode | CompanyCode | 1 |
| AddressID | AddressNumber | 1 | |
| AR_PrefixForFiscalBranch | AR_PrefixForFiscalBranch | 1 | |
| BR_AutomAddDataIsImplemented | BR_AutomAddDataIsImplemented | 1 | |
| BR_BPCompanySizeType | BR_BPCompanySizeType | 1 | |
| BR_BPLegalNatureType | BR_BPLegalNatureType | 1 | |
| BR_BusinessPlaceCFOPCategory | BR_BusinessPlaceCFOPCategory | 1 | |
| BR_BusinessPlacePartOfCNPJ_2 | BR_BusinessPlacePartOfCNPJ_2 | 1 | |
| BR_CNAE | BR_CNAE | 1 | |
| BR_DecimalPlacesInPrcgInclv | BR_DecimalPlacesInPrcgInclv | 1 | |
| BR_ICMSIsContributor | BR_ICMSIsContributor | 1 | |
| BR_ICMSSTIsContributor | BR_ICMSSTIsContributor | 1 | |
| BR_ICMSTaxPayerType | BR_ICMSTaxPayerType | 1 | |
| BR_IndustryMainType | BR_IndustryMainType | 1 | |
| BR_IPIIsContributor | BR_IPIIsContributor | 1 | |
| BR_ISSIsContributor | BR_ISSIsContributor | 1 | |
| BR_NFPrintedIsOnSinglePage | BR_NFPrintedIsOnSinglePage | 1 | |
| BR_NFSrceOfDangerousGoodsData | BR_NFSrceOfDangerousGoodsData | 1 | |
| BR_NIREDate | BR_NIREDate | 1 | |
| BR_NIREIdentifier | BR_NIREIdentifier | 1 | |
| BR_PISAndCOFINSDeclnRegimen | BR_PISAndCOFINSDeclnRegimen | 1 | |
| BR_PISIsContributor | BR_PISIsContributor | 1 | |
| BR_SoclScrtyFinceIsContributor | BR_SoclScrtyFinceIsContributor | 1 | |
| BR_SUFRAMACode | BR_SUFRAMACode | 1 | |
| BR_TaxDeclarationType | BR_TaxDeclarationType | 1 | |
| BR_TaxRegimenCode | BR_TaxRegimenCode | 1 | |
| BusinessPlaceActivity | BusinessPlaceActivity | 1 | |
| BusinessPlaceDescription | BusinessPlaceName | 1 | |
| BusinessPlaceStateTaxNumber | BusinessPlaceStateTaxNumber | 1 | |
| BusinessType | BusinessType | 2 | |
| BusinessTypeList | BusinessTypeList | 2 | |
| BusPlaceMunicipalTaxNumber | BusPlaceMunicipalTaxNumber | 1 | |
| CN_BusinessPlaceEndDate | CN_BusinessPlaceEndDate | 1 | |
| CN_BusinessPlaceStartDate | CN_BusinessPlaceStartDate | 1 | |
| CN_ChinaBusinessPlaceIsEnabled | CN_ChinaBusinessPlaceIsEnabled | 1 | |
| CN_TaxRegnNmbr | CN_TaxRegnNmbr | 1 | |
| CN_TxInvcDeclnInvcSyncIsEnbld | CN_TxInvcDeclnInvcSyncIsEnbld | 1 | |
| CN_TxInvcDeclnVATConncnIsEnbld | CN_TxInvcDeclnVATConncnIsEnbld | 1 | |
| CN_TxInvcMngVATConncnIsEnbld | CN_TxInvcMngVATConncnIsEnbld | 1 | |
| DistrictTaxOffice | DistrictTaxOffice | 2 | |
| IN_BusinessPlaceClassification | IN_BusinessPlaceClassification | 1 | |
| IN_GSTIdentificationNumber | IN_GSTIdentificationNumber | 1 | |
| IndustryType | IndustryType | 2 | |
| IndustryTypeList | IndustryTypeList | 2 | |
| KR_TaxBusinessCode | KR_TaxBusinessCode | 2 | |
| NatlTaxServiceRegnNumber | NatlTaxServiceRegnNumber | 2 | |
| PH_ElctrncDocCertificateNumber | PH_ElctrncDocCertificateNumber | 1 | |
| PH_TaxIdentificationNumber | PH_TaxIdentificationNumber | 1 | |
| ResponsibleDepartmentName | ResponsibleDepartmentName | 2 | |
| ResponsiblePersonEmailAddress1 | ResponsiblePersonEmailAddress,ResponsiblePersonEmailAddress1 | 2 | |
| ResponsiblePersonName | ResponsiblePersonName | 2 | |
| SignerOfTaxInvoice | SignerOfTaxInvoice | 1 | |
| TaxInvoiceRepresentativeName | TaxInvoiceRepresentativeName | 2 | |
| TaxInvoiceRepresentativeName1 | TaxInvoiceRepresentativeName1 | 2 | |
| TaxNumber1 | TaxNumber1 | 1 | |
| TaxNumber2 | TaxNumber2 | 1 | |
| TH_BusinessPlace | TH_BusinessPlace | 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.
-- Business Place Information
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPLACE (
BUSINESSPLACE,
COMPANYCODE,
ADDRESSID,
AR_PREFIXFORFISCALBRANCH,
BR_AUTOMADDDATAISIMPLEMENTED,
BR_BPCOMPANYSIZETYPE,
BR_BPLEGALNATURETYPE,
BR_BUSINESSPLACECFOPCATEGORY,
BR_BUSINESSPLACEPARTOFCNPJ_2,
BR_CNAE,
BR_DECIMALPLACESINPRCGINCLV,
BR_ICMSISCONTRIBUTOR,
BR_ICMSSTISCONTRIBUTOR,
BR_ICMSTAXPAYERTYPE,
BR_INDUSTRYMAINTYPE,
BR_IPIISCONTRIBUTOR,
BR_ISSISCONTRIBUTOR,
BR_NFPRINTEDISONSINGLEPAGE,
BR_NFSRCEOFDANGEROUSGOODSDATA,
BR_NIREDATE,
BR_NIREIDENTIFIER,
BR_PISANDCOFINSDECLNREGIMEN,
BR_PISISCONTRIBUTOR,
BR_SOCLSCRTYFINCEISCONTRIBUTOR,
BR_SUFRAMACODE,
BR_TAXDECLARATIONTYPE,
BR_TAXREGIMENCODE,
BUSINESSPLACEACTIVITY,
BUSINESSPLACEDESCRIPTION,
BUSINESSPLACESTATETAXNUMBER,
BUSINESSTYPE,
BUSINESSTYPELIST,
BUSPLACEMUNICIPALTAXNUMBER,
CN_BUSINESSPLACEENDDATE,
CN_BUSINESSPLACESTARTDATE,
CN_CHINABUSINESSPLACEISENABLED,
CN_TAXREGNNMBR,
CN_TXINVCDECLNINVCSYNCISENBLD,
CN_TXINVCDECLNVATCONNCNISENBLD,
CN_TXINVCMNGVATCONNCNISENBLD,
DISTRICTTAXOFFICE,
IN_BUSINESSPLACECLASSIFICATION,
IN_GSTIDENTIFICATIONNUMBER,
INDUSTRYTYPE,
INDUSTRYTYPELIST,
KR_TAXBUSINESSCODE,
NATLTAXSERVICEREGNNUMBER,
PH_ELCTRNCDOCCERTIFICATENUMBER,
PH_TAXIDENTIFICATIONNUMBER,
RESPONSIBLEDEPARTMENTNAME,
RESPONSIBLEPERSONEMAILADDRESS1,
RESPONSIBLEPERSONNAME,
SIGNEROFTAXINVOICE,
TAXINVOICEREPRESENTATIVENAME,
TAXINVOICEREPRESENTATIVENAME1,
TAXNUMBER1,
TAXNUMBER2,
TH_BUSINESSPLACE,
PRIMARY KEY (BUSINESSPLACE, COMPANYCODE)
);
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