I_PurCtrAddressWD
Contract Address Info with Draft
I_PurCtrAddressWD is a Transactional CDS View that provides data about "Contract Address Info with Draft" in SAP S/4HANA. It reads from 1 data source (I_PurCtrAddress) and exposes 55 fields with key fields PurchaseContract, PurchaseContractItem. It has 5 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurCtrAddress | Document | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_PurchaseContractItemWD | _PurchaseContractItemWD | _PurchaseContractItemWD.PurchaseContractItem = $projection.PurchaseContractItem and _PurchaseContractItemWD.PurchaseContract = $projection.PurchaseContract |
| [1..1] | I_PurchaseContractWD | _PurchaseContractWD | _PurchaseContractWD.PurchaseContract = $projection.PurchaseContract |
| [0..1] | I_Country | _Country | $projection.Country = _Country.Country |
| [0..1] | I_Region | _Region | $projection.Region = _Region.Region and $projection.Country = _Region.Country |
| [1..1] | I_TimeZone | _TimeZone | _TimeZone.TimeZoneID = $projection.AddressTimeZone association[0..1] to I_LanguageText as _LanguageText on _LanguageText.Language = $projection.CorrespondenceLanguage and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPURCTRITMADRSWD | view | |
| EndUserText.label | Contract Address Info with Draft | view | |
| ObjectModel.transactionalProcessingEnabled | true | view | |
| ObjectModel.writeDraftPersistence | PURCTR_ITM_ADR_D | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view |
Fields (55)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseContract | I_PurCtrAddress | PurchaseContract | |
| KEY | PurchaseContractItem | I_PurCtrAddress | PurchaseContractItem | |
| AddressID | I_PurCtrAddress | AddressID | ||
| PurchaseContractItemForEdit | I_PurCtrAddress | PurchaseContractItem | ||
| AddressIDForEdit | I_PurCtrAddress | AddressID | ||
| PurchaseContractForEdit | I_PurCtrAddress | PurchaseContract | ||
| Plant | I_PurCtrAddress | Plant | ||
| CareOfName | I_PurCtrAddress | CareOfName | ||
| AdditionalStreetSuffixName | I_PurCtrAddress | AdditionalStreetSuffixName | ||
| CorrespondenceLanguage | I_PurCtrAddress | CorrespondenceLanguage | ||
| PrfrdCommMediumType | I_PurCtrAddress | PrfrdCommMediumType | ||
| POBox | I_PurCtrAddress | POBox | ||
| POBoxIsWithoutNumber | I_PurCtrAddress | POBoxIsWithoutNumber | ||
| POBoxPostalCode | I_PurCtrAddress | POBoxPostalCode | ||
| POBoxLobbyName | I_PurCtrAddress | POBoxLobbyName | ||
| POBoxDeviatingCityName | I_PurCtrAddress | POBoxDeviatingCityName | ||
| POBoxDeviatingRegion | I_PurCtrAddress | POBoxDeviatingRegion | ||
| POBoxDeviatingCountry | I_PurCtrAddress | POBoxDeviatingCountry | ||
| DeliveryServiceTypeCode | I_PurCtrAddress | DeliveryServiceTypeCode | ||
| DeliveryServiceNumber | I_PurCtrAddress | DeliveryServiceNumber | ||
| AddressTimeZone | I_PurCtrAddress | AddressTimeZone | ||
| FullName | I_PurCtrAddress | FullName | ||
| CityName | I_PurCtrAddress | CityName | ||
| District | I_PurCtrAddress | District | ||
| CityCode | I_PurCtrAddress | CityCode | ||
| HomeCityName | I_PurCtrAddress | HomeCityName | ||
| PostalCode | I_PurCtrAddress | PostalCode | ||
| CompanyPostalCode | I_PurCtrAddress | CompanyPostalCode | ||
| StreetName | I_PurCtrAddress | StreetName | ||
| StreetPrefixName | I_PurCtrAddress | StreetPrefixName | ||
| AdditionalStreetPrefixName | I_PurCtrAddress | AdditionalStreetPrefixName | ||
| StreetSuffixName | I_PurCtrAddress | StreetSuffixName | ||
| HouseNumber | I_PurCtrAddress | HouseNumber | ||
| HouseNumberSupplementText | I_PurCtrAddress | HouseNumberSupplementText | ||
| Building | I_PurCtrAddress | Building | ||
| Floor | I_PurCtrAddress | Floor | ||
| RoomNumber | I_PurCtrAddress | RoomNumber | ||
| Country | I_PurCtrAddress | Country | ||
| Region | I_PurCtrAddress | Region | ||
| County | I_PurCtrAddress | County | ||
| FormOfAddress | I_PurCtrAddress | FormOfAddress | ||
| ConsigneeName3 | I_PurCtrAddress | ConsigneeName3 | ||
| ConsigneeName4 | I_PurCtrAddress | ConsigneeName4 | ||
| TaxJurisdiction | I_PurCtrAddress | TaxJurisdiction | ||
| TransportZone | I_PurCtrAddress | TransportZone | ||
| PhoneNumber | I_PurCtrAddress | PhoneNumber | ||
| MobilePhoneNumber | I_PurCtrAddress | MobilePhoneNumber | ||
| FaxNumber | I_PurCtrAddress | FaxNumber | ||
| EmailAddress | I_PurCtrAddress | EmailAddress | ||
| _Country | _Country | |||
| _Region | _Region | |||
| _TimeZone | _TimeZone | |||
| _LanguageText | _LanguageText | |||
| _PurchaseContractWD | _PurchaseContractWD | |||
| _PurchaseContractItemWD | _PurchaseContractItemWD |
@AbapCatalog.sqlViewName: 'IPURCTRITMADRSWD'
@EndUserText.label: 'Contract Address Info with Draft'
@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.writeDraftPersistence: 'PURCTR_ITM_ADR_D'
@VDM.viewType: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view I_PurCtrAddressWD
as select from I_PurCtrAddress as Document
association [1..1] to I_PurchaseContractItemWD as _PurchaseContractItemWD
// //on _PurchaseContractItemWD.ManualDeliveryAddressID = $projection.ActiveAddressID
on _PurchaseContractItemWD.PurchaseContractItem = $projection.PurchaseContractItem
and _PurchaseContractItemWD.PurchaseContract = $projection.PurchaseContract
association [1..1] to I_PurchaseContractWD as _PurchaseContractWD on _PurchaseContractWD.PurchaseContract = $projection.PurchaseContract
association [0..1] to I_Country as _Country on $projection.Country = _Country.Country
association [0..1] to I_Region as _Region on $projection.Region = _Region.Region
and $projection.Country = _Region.Country
association [1..1] to I_TimeZone as _TimeZone on _TimeZone.TimeZoneID = $projection.AddressTimeZone
association[0..1] to I_LanguageText as _LanguageText
on _LanguageText.Language = $projection.CorrespondenceLanguage
and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage
{
key Document.PurchaseContract,
key Document.PurchaseContractItem,
Document.AddressID,
Document.PurchaseContractItem as PurchaseContractItemForEdit,
Document.AddressID as AddressIDForEdit,
Document.PurchaseContract as PurchaseContractForEdit,
Document.Plant,
Document.CareOfName,
Document.AdditionalStreetSuffixName,
Document.CorrespondenceLanguage,
Document.PrfrdCommMediumType,
Document.POBox,
Document.POBoxIsWithoutNumber,
Document.POBoxPostalCode,
Document.POBoxLobbyName,
Document.POBoxDeviatingCityName,
Document.POBoxDeviatingRegion,
Document.POBoxDeviatingCountry,
Document.DeliveryServiceTypeCode,
Document.DeliveryServiceNumber,
@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
Document.AddressTimeZone,
Document.FullName,
Document.CityName,
Document.District,
Document.CityCode,
Document.HomeCityName,
Document.PostalCode,
Document.CompanyPostalCode,
Document.StreetName,
Document.StreetPrefixName,
Document.AdditionalStreetPrefixName,
Document.StreetSuffixName,
Document.HouseNumber,
Document.HouseNumberSupplementText,
Document.Building,
Document.Floor,
Document.RoomNumber,
Document.Country,
Document.Region,
Document.County,
Document.FormOfAddress,
Document.ConsigneeName3,
Document.ConsigneeName4,
Document.TaxJurisdiction,
Document.TransportZone,
Document.PhoneNumber,
Document.MobilePhoneNumber,
Document.FaxNumber,
Document.EmailAddress,
_Country,
_Region,
_TimeZone,
_LanguageText,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
_PurchaseContractWD,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
_PurchaseContractItemWD
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCTRADDRESS"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_LANGUAGETEXT",
"I_PURCHASECONTRACTITEMWD",
"I_PURCHASECONTRACTWD",
"I_REGION",
"I_TIMEZONE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA