P_KR_BUSINESSPLACE

CDS View

P_KR_BUSINESSPLACE is a CDS View in S/4HANA. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_KR_I18NBusinessPlace view from COMPOSITE

Fields (25)

KeyField CDS FieldsUsed in Views
KEY Branch Branch 1
KEY CompanyCode CompanyCode 1
BusinessPlaceName BusinessPlaceName 1
BusinessType BusinessType 1
BusinessTypeList BusinessTypeList 1
CityName CityName 1
CorporationNumber CorporationNumber 1
DistrictTaxOffice DistrictTaxOffice 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
IndustryType IndustryType 1
IndustryTypeList IndustryTypeList 1
KR_TaxBusinessCode KR_TaxBusinessCode 1
MobilePhoneNumber MobilePhoneNumber 1
NatlTaxServiceRegnNumber NatlTaxServiceRegnNumber 1
PhoneNumber PhoneNumber 1
PostalCode PostalCode 1
ResponsibleDepartmentName ResponsibleDepartmentName 1
ResponsiblePersonEmailAddress ResponsiblePersonEmailAddress 1
ResponsiblePersonName ResponsiblePersonName 1
StreetName StreetName 1
TaxInvoiceRepresentativeName TaxInvoiceRepresentativeName 1
TaxInvoiceRepresentativeName1 TaxInvoiceRepresentativeName1 1
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 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_KR_BUSINESSPLACE (
    BRANCH,
    COMPANYCODE,
    BUSINESSPLACENAME,
    BUSINESSTYPE,
    BUSINESSTYPELIST,
    CITYNAME,
    CORPORATIONNUMBER,
    DISTRICTTAXOFFICE,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    INDUSTRYTYPE,
    INDUSTRYTYPELIST,
    KR_TAXBUSINESSCODE,
    MOBILEPHONENUMBER,
    NATLTAXSERVICEREGNNUMBER,
    PHONENUMBER,
    POSTALCODE,
    RESPONSIBLEDEPARTMENTNAME,
    RESPONSIBLEPERSONEMAILADDRESS,
    RESPONSIBLEPERSONNAME,
    STREETNAME,
    TAXINVOICEREPRESENTATIVENAME,
    TAXINVOICEREPRESENTATIVENAME1,
    TAXNUMBER1,
    TAXNUMBER2,
    PRIMARY KEY (BRANCH, COMPANYCODE)
);