ESH_N_SOR_BPORGADDR

DDL: ESH_N_SOR_BPORGADDR SQL: ESH_L_BPORGADDR Type: view Package: VDM_SD_SLS_AUTOEXTRN
41 Fields 1 Data Sources

Anchor view -SOR_BPORGADDR

ESH_N_SOR_BPORGADDR is a CDS View that provides data about "Anchor view -SOR_BPORGADDR" in SAP S/4HANA. It reads from 1 data source (P_SLSORDREQBPORGADDR) and exposes 41 fields with key field BPADDRESSID. Part of development package VDM_SD_SLS_AUTOEXTRN.

Data Sources (1)

SourceAliasJoin Type
P_SLSORDREQBPORGADDR P_SLSORDREQBPORGADDR from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ESH_L_BPORGADDR view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY BPADDRESSID BPADDRESSID Src Address No
ADDRESSEENAME1 ADDRESSEENAME1
ADDRESSEENAME2 ADDRESSEENAME2
ADDRESSEENAME3 ADDRESSEENAME3
ADDRESSEENAME4 ADDRESSEENAME4
ADDRESSID ADDRESSID Ship-to address
BPAUTHORIZATIONGROUP BPAUTHORIZATIONGROUP
BPISBUSINESSPURPOSECOMPLETED BPISBUSINESSPURPOSECOMPLETED
BUSINESSPARTNER BUSINESSPARTNER Issuing Authority
CITYNAME CITYNAME Name
CITYNUMBER CITYNUMBER City Code
COUNTRY COUNTRY Venue: Ctry/Reg
CUSAUTHORIZATIONGROUP CUSAUTHORIZATIONGROUP AuthorizGroup
CUSISBUSINESSPURPOSECOMPLETED CUSISBUSINESSPURPOSECOMPLETED Purpose Completed
CUSTOMER CUSTOMER Sold-to Party
CUSTOMERACCOUNTGROUP CUSTOMERACCOUNTGROUP Account group
DATACONTROLLER1 DATACONTROLLER1 Data Controller
DATACONTROLLER10 DATACONTROLLER10 Data Controller
DATACONTROLLER2 DATACONTROLLER2 Data Controller
DATACONTROLLER3 DATACONTROLLER3 Data Controller
DATACONTROLLER4 DATACONTROLLER4 Data Controller
DATACONTROLLER5 DATACONTROLLER5 Data Controller
DATACONTROLLER6 DATACONTROLLER6 Data Controller
DATACONTROLLER7 DATACONTROLLER7 Data Controller
DATACONTROLLER8 DATACONTROLLER8 Data Controller
DATACONTROLLER9 DATACONTROLLER9 Data Controller
DATACONTROLLERSET DATACONTROLLERSET Data Ctrlr. Set
DISTRICTNAME DISTRICTNAME District
EMAILADDRESS1 EMAILADDRESS1
EMAILADDRESS2 EMAILADDRESS2
FAXNUMBER1 FAXNUMBER1
FAXNUMBER2 FAXNUMBER2
HOUSENUMBER HOUSENUMBER House Number
POSTALCODE POSTALCODE Postal Code
REGION REGION Venue Region
STREET STREET Street Code
STREETNAME STREETNAME Text
TELEPHONENUMBER1 TELEPHONENUMBER1
TELEPHONENUMBER2 TELEPHONENUMBER2
TELEPHONENUMBER3 TELEPHONENUMBER3
VILLAGENAME VILLAGENAME Different City

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_N_SOR_BPORGADDR.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_L_BPORGADDR

CREATE VIEW ESH_N_SOR_BPORGADDR AS
SELECT
  BPADDRESSID,
  ADDRESSEENAME1,
  ADDRESSEENAME2,
  ADDRESSEENAME3,
  ADDRESSEENAME4,
  ADDRESSID,
  BPAUTHORIZATIONGROUP,
  BPISBUSINESSPURPOSECOMPLETED,
  BUSINESSPARTNER,
  CITYNAME,
  CITYNUMBER,
  COUNTRY,
  CUSAUTHORIZATIONGROUP,
  CUSISBUSINESSPURPOSECOMPLETED,
  CUSTOMER,
  CUSTOMERACCOUNTGROUP,
  DATACONTROLLER1,
  DATACONTROLLER10,
  DATACONTROLLER2,
  DATACONTROLLER3,
  DATACONTROLLER4,
  DATACONTROLLER5,
  DATACONTROLLER6,
  DATACONTROLLER7,
  DATACONTROLLER8,
  DATACONTROLLER9,
  DATACONTROLLERSET,
  DISTRICTNAME,
  EMAILADDRESS1,
  EMAILADDRESS2,
  FAXNUMBER1,
  FAXNUMBER2,
  HOUSENUMBER,
  POSTALCODE,
  REGION,
  STREET,
  STREETNAME,
  TELEPHONENUMBER1,
  TELEPHONENUMBER2,
  TELEPHONENUMBER3,
  VILLAGENAME
FROM P_SLSORDREQBPORGADDR
;

Learn More