A_PurchaseContractAddress_2

DDL: A_PURCHASECONTRACTADDRESS_2 SQL: APURCTRITMADRS2 Type: view COMPOSITE
37 Fields 1 Data Sources 2 Associations

Delivery Address

A_PurchaseContractAddress_2 is a Composite CDS View that provides data about "Delivery Address" in SAP S/4HANA. It reads from 1 data source (I_PurCtrAddress) and exposes 37 fields with key fields PurchaseContract, AddressID, PurchaseContractItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurCtrAddress I_PurCtrAddress from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_PurchaseContractItem_2 _PurchaseContractItem _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem and _PurchaseContractItem.PurchaseContract = $projection.PurchaseContract
[1..1] A_PurchaseContract_2 _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName APURCTRITMADRS2 view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Delivery Address view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
OData.entitySet.name A_PurCtrAddress view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY AddressID AddressID Ship-to address
KEY PurchaseContractItem PurchaseContractItem Item
FormOfAddress FormOfAddress Title Key
FullName FullName Name
ConsigneeName3 ConsigneeName3 Name 3
ConsigneeName4 ConsigneeName4 Name 4
CareOfName CareOfName c/o
CityName CityName Name
District District Court
CityCode IATA: City
PostalCode PostalCode Postal Code
POBoxPostalCode POBoxPostalCode PO Box Postal Code
CompanyPostalCode CompanyPostalCode Company Post Cd
POBox POBox PO Box
POBoxDeviatingCityName POBoxDeviatingCityName PO Box City
StreetName StreetName Text
HouseNumber HouseNumber House Number
StreetPrefixName StreetPrefixName Street 2
AdditionalStreetPrefixName AdditionalStreetPrefixName Street 3
AdditionalStreetSuffixName AdditionalStreetSuffixName Street 5
Building Building Building code
Floor Floor Floor
RoomNumber RoomNumber Room Number
Country Country Venue: Ctry/Reg
CorrespondenceLanguage CorrespondenceLanguage Language
Region Region Venue Region
AddressTimeZone AddressTimeZone Time Zone
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
PrfrdCommMediumType PrfrdCommMediumType Comm. Method
PhoneNumber PhoneNumber Telephone no.
FaxNumber Fax Number
TransportZone TransportZone Transport Zone
HouseNumberSupplementText HouseNumberSupplementText Supplement
StreetSuffixName StreetSuffixName Street 4
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem

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 A_PurchaseContractAddress_2.
-- 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: APURCTRITMADRS2

CREATE VIEW A_PurchaseContractAddress_2 AS
SELECT
  PurchaseContract,
  AddressID,
  PurchaseContractItem,
  FormOfAddress,
  FullName,
  ConsigneeName3,
  ConsigneeName4,
  CareOfName,
  CityName,
  cast(District as ort02_gp) AS District,
  cast(CityCode as cityc) AS CityCode,
  PostalCode,
  POBoxPostalCode,
  CompanyPostalCode,
  POBox,
  POBoxDeviatingCityName,
  StreetName,
  HouseNumber,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  AdditionalStreetSuffixName,
  Building,
  Floor,
  RoomNumber,
  Country,
  CorrespondenceLanguage,
  Region,
  AddressTimeZone,
  TaxJurisdiction,
  PrfrdCommMediumType,
  PhoneNumber,
  cast(FaxNumber as telfx) AS FaxNumber,
  TransportZone,
  HouseNumberSupplementText,
  StreetSuffixName
FROM I_PurCtrAddress
LEFT OUTER JOIN A_PurchaseContractItem_2 AS _PurchaseContractItem ON _PurchaseContractItem.PurchaseContractItem = PurchaseContractItem AND _PurchaseContractItem.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_PurchaseContract_2 AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
;

Learn More