A_SalesOrderItemPartnerSimln_2
Item Partner Simulation
A_SalesOrderItemPartnerSimln_2 is a Consumption CDS View that provides data about "Item Partner Simulation" in SAP S/4HANA. It reads from 1 data source (R_SalesOrderItemPartnerTP) and exposes 56 fields with key fields SalesOrder, SalesOrderItem, PartnerFunction. It has 1 association to related views. It is exposed through 1 OData service (API_SALESORDERSIMULATION). Part of development package ODATA_SD_SALESORDER_API.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_SalesOrderItemPartnerTP | SalesOrderItemPartner | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | A_SalesOrderSimulation_2 | _SalesOrder | $projection.SalesOrder = _SalesOrder.SalesOrder |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Item Partner Simulation | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| OData.entityType.name | SalesOrderItemPartner_Type | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.query.implementedBy | ABAP:CL_SD_SO_SIMLN_RAP_V4_QRY | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| API_SALESORDERSIMULATION | API_SALESORDERSIMULATION | V4 | C2 | C1 |
Fields (56)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesOrder | R_SalesOrderItemPartnerTP | SalesOrder | |
| KEY | SalesOrderItem | R_SalesOrderItemPartnerTP | SalesOrderItem | |
| KEY | PartnerFunction | R_SalesOrderItemPartnerTP | PartnerFunction | |
| Customer | R_SalesOrderItemPartnerTP | Customer | ||
| Customer_H | ||||
| Supplier | R_SalesOrderItemPartnerTP | Supplier | ||
| Supplier_H | ||||
| Personnel | R_SalesOrderItemPartnerTP | Personnel | ||
| Personnel_H | ||||
| ContactPerson | R_SalesOrderItemPartnerTP | ContactPerson | ||
| ContactPerson_H | ||||
| ReferenceBusinessPartner | R_SalesOrderItemPartnerTP | ReferenceBusinessPartner | ||
| PartnerIsSpecificForSDDocItem | R_SalesOrderItemPartnerTP | PartnerIsSpecificForSDDocItem | ||
| BusinessPartnerName1 | ||||
| BusinessPartnerName2 | ||||
| BusinessPartnerName3 | ||||
| BusinessPartnerName4 | ||||
| StreetName | R_SalesOrderItemPartnerTP | StreetName | ||
| StreetPrefixName1 | R_SalesOrderItemPartnerTP | StreetPrefixName1 | ||
| StreetPrefixName2 | R_SalesOrderItemPartnerTP | StreetPrefixName2 | ||
| StreetSuffixName1 | R_SalesOrderItemPartnerTP | StreetSuffixName1 | ||
| StreetSuffixName2 | R_SalesOrderItemPartnerTP | StreetSuffixName2 | ||
| HouseNumber | R_SalesOrderItemPartnerTP | HouseNumber | ||
| PostalCode | R_SalesOrderItemPartnerTP | PostalCode | ||
| CityName | R_SalesOrderItemPartnerTP | CityName | ||
| DistrictName | R_SalesOrderItemPartnerTP | DistrictName | ||
| Region | R_SalesOrderItemPartnerTP | Region | ||
| Country | R_SalesOrderItemPartnerTP | Country | ||
| PhoneNumberCountry | R_SalesOrderItemPartnerTP | PhoneNumberCountry | ||
| PhoneNumber | R_SalesOrderItemPartnerTP | PhoneNumber | ||
| PhoneNumberExtension | R_SalesOrderItemPartnerTP | PhoneNumberExtension | ||
| MobilePhoneCountry | R_SalesOrderItemPartnerTP | MobilePhoneCountry | ||
| MobilePhoneNumber | R_SalesOrderItemPartnerTP | MobilePhoneNumber | ||
| FaxNumberCountry | R_SalesOrderItemPartnerTP | FaxNumberCountry | ||
| FaxNumber | R_SalesOrderItemPartnerTP | FaxNumber | ||
| FaxNumberExtension | R_SalesOrderItemPartnerTP | FaxNumberExtension | ||
| InternationalPhoneNumber | R_SalesOrderItemPartnerTP | InternationalPhoneNumber | ||
| InternationalMobilePhoneNumber | R_SalesOrderItemPartnerTP | InternationalMobilePhoneNumber | ||
| InternationalFaxNumber | R_SalesOrderItemPartnerTP | InternationalFaxNumber | ||
| POBox | R_SalesOrderItemPartnerTP | POBox | ||
| POBoxPostalCode | R_SalesOrderItemPartnerTP | POBoxPostalCode | ||
| FormOfAddress | R_SalesOrderItemPartnerTP | FormOfAddress | ||
| CorrespondenceLanguage | Correspondence Language | |||
| EmailAddress | R_SalesOrderItemPartnerTP | EmailAddress | ||
| TaxJurisdiction | R_SalesOrderItemPartnerTP | TaxJurisdiction | ||
| TransportZone | R_SalesOrderItemPartnerTP | TransportZone | ||
| UnloadingPointName | R_SalesOrderItemPartnerTP | UnloadingPointName | ||
| VATRegistration | R_SalesOrderItemPartnerTP | VATRegistration | ||
| SDDocPartnerAddrIsDocSpecific | R_SalesOrderItemPartnerTP | SDDocPartnerAddrIsDocSpecific | ||
| LastChangeDateTime | _SalesOrder | LastChangeDateTime | ||
| _Item | _Item | |||
| _SalesOrder | _SalesOrder | |||
| SalesOrderType | _SalesOrder | SalesOrderType | ||
| OrganizationDivision | _SalesOrder | OrganizationDivision | ||
| SalesOrganization | _SalesOrder | SalesOrganization | ||
| DistributionChannel | _SalesOrder | DistributionChannel |
@VDM: {
lifecycle.contract.type: #PUBLIC_REMOTE_API,
usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE],
viewType: #CONSUMPTION
}
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@EndUserText.label: 'Item Partner Simulation'
@Metadata.ignorePropagatedAnnotations: true
@OData: {
entityType.name: 'SalesOrderItemPartner_Type'
}
@ObjectModel: {
semanticKey: ['SalesOrder','SalesOrderItem','PartnerFunction'],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #L
},
query.implementedBy: 'ABAP:CL_SD_SO_SIMLN_RAP_V4_QRY'
}
define view entity A_SalesOrderItemPartnerSimln_2
as select from R_SalesOrderItemPartnerTP as SalesOrderItemPartner
association to parent A_SalesOrderItemSimulation_2 as _Item on $projection.SalesOrder = _Item.SalesOrder
and $projection.SalesOrderItem = _Item.SalesOrderItem
association [1..1] to A_SalesOrderSimulation_2 as _SalesOrder on $projection.SalesOrder = _SalesOrder.SalesOrder
{
key SalesOrderItemPartner.SalesOrder,
key SalesOrderItemPartner.SalesOrderItem,
@ObjectModel.sapObjectNodeTypeReference: 'PartnerFunction'
key SalesOrderItemPartner.PartnerFunction,
SalesOrderItemPartner.Customer,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'Customer'
cast( '' as rap_null_value_indicator ) as Customer_H,
SalesOrderItemPartner.Supplier,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'Supplier'
cast( '' as rap_null_value_indicator ) as Supplier_H,
SalesOrderItemPartner.Personnel,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'Personnel'
cast( '' as rap_null_value_indicator ) as Personnel_H,
SalesOrderItemPartner.ContactPerson,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'ContactPerson'
cast( '' as rap_null_value_indicator ) as ContactPerson_H,
SalesOrderItemPartner.ReferenceBusinessPartner,
SalesOrderItemPartner.PartnerIsSpecificForSDDocItem,
cast('' as ad_name1) as BusinessPartnerName1,
cast('' as ad_name2) as BusinessPartnerName2,
cast('' as ad_name3) as BusinessPartnerName3,
cast('' as ad_name4) as BusinessPartnerName4,
SalesOrderItemPartner.StreetName,
SalesOrderItemPartner.StreetPrefixName1,
SalesOrderItemPartner.StreetPrefixName2,
SalesOrderItemPartner.StreetSuffixName1,
SalesOrderItemPartner.StreetSuffixName2,
SalesOrderItemPartner.HouseNumber,
SalesOrderItemPartner.PostalCode,
SalesOrderItemPartner.CityName,
SalesOrderItemPartner.DistrictName,
SalesOrderItemPartner.Region,
@ObjectModel.sapObjectNodeTypeReference: 'Country'
SalesOrderItemPartner.Country,
@ObjectModel.sapObjectNodeTypeReference: 'Country'
SalesOrderItemPartner.PhoneNumberCountry,
SalesOrderItemPartner.PhoneNumber,
SalesOrderItemPartner.PhoneNumberExtension,
@ObjectModel.sapObjectNodeTypeReference: 'Country'
SalesOrderItemPartner.MobilePhoneCountry,
SalesOrderItemPartner.MobilePhoneNumber,
@ObjectModel.sapObjectNodeTypeReference: 'Country'
SalesOrderItemPartner.FaxNumberCountry,
SalesOrderItemPartner.FaxNumber,
SalesOrderItemPartner.FaxNumberExtension,
SalesOrderItemPartner.InternationalPhoneNumber,
SalesOrderItemPartner.InternationalMobilePhoneNumber,
SalesOrderItemPartner.InternationalFaxNumber,
SalesOrderItemPartner.POBox,
SalesOrderItemPartner.POBoxPostalCode,
SalesOrderItemPartner.FormOfAddress,
@EndUserText.label: 'Correspondence Language'
cast(SalesOrderItemPartner.CorrespondenceLanguage as bu_langu_corr preserving type) as CorrespondenceLanguage,
@Semantics.eMail.address: true
SalesOrderItemPartner.EmailAddress,
SalesOrderItemPartner.TaxJurisdiction,
SalesOrderItemPartner.TransportZone,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'UnloadingPointName'
cast( '' as rap_null_value_indicator ) as UnloadingPointNameIsNull,
SalesOrderItemPartner.UnloadingPointName,
@Consumption.hidden: true
@Semantics.nullValueIndicatorFor: 'VATRegistration'
cast( '' as rap_null_value_indicator ) as VATRegistrationIsNull,
SalesOrderItemPartner.VATRegistration,
SalesOrderItemPartner.SDDocPartnerAddrIsDocSpecific,
//used for ETAG
@Consumption.hidden: true
_SalesOrder.LastChangeDateTime,
// Associations
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
_Item,
@ObjectModel.filter.enabled: false
@ObjectModel.sort.enabled: false
_SalesOrder,
// For Access control
@Consumption.hidden: true
_SalesOrder.SalesOrderType,
@Consumption.hidden: true
_SalesOrder.OrganizationDivision,
@Consumption.hidden: true
_SalesOrder.SalesOrganization,
@Consumption.hidden: true
_SalesOrder.DistributionChannel
}
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