I_SlsOrdWthoutChrgItmPartner

DDL: I_SLSORDWTHOUTCHRGITMPARTNER Type: view COMPOSITE Package: VDM_SD_SLS_SO

Item Partner for Sales Order Without Charge

I_SlsOrdWthoutChrgItmPartner (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

I_SlsOrdWthoutChrgItmPartner is a Composite CDS View that provides data about "Item Partner for Sales Order Without Charge" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItemPartner) and exposes 26 fields with key fields SalesOrderWithoutCharge, SalesOrderWithoutChargeItem, PartnerFunction. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F6382). Part of development package VDM_SD_SLS_SO.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSales
Application ComponentSD-SLS-SO-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering questions about sales order without charge partners at item level.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItemPartner Partner from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SalesOrderWithoutCharge _SalesOrderWithoutCharge $projection.SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge
[1..1] I_SalesOrderWithoutChargeItem _SalesOrderWithoutChargeItem $projection.SalesOrderWithoutCharge = _SalesOrderWithoutChargeItem.SalesOrderWithoutCharge and $projection.SalesOrderWithoutChargeItem = _SalesOrderWithoutChargeItem.SalesOrderWithoutChargeItem

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Item Partner for Sales Order Without Charge view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDSOWTCHRGITPT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F6382 ASQL_F6382 C2 NOT_RELEASED

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderWithoutCharge Sales Order Without Charge
KEY SalesOrderWithoutChargeItem Sales Order Without Charge Item
KEY PartnerFunction PartnerFunction Partner Function
Customer Customer Customer Number
Supplier Supplier Account Number of Supplier
Personnel Personnel Personnel Number
ContactPerson ContactPerson Number of Contact Person
Partner Partner Customer Number
FullName FullName Full Name of Person
ReferenceBusinessPartner ReferenceBusinessPartner Reference Business Partner
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
AddressObjectType AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person)
SDDocPartnerAddressRefType SDDocPartnerAddressRefType Address indicator
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Determination in Document
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
InternationalPhoneNumber InternationalPhoneNumber Landline Phone
InternationalMobilePhoneNumber InternationalMobilePhoneNumber Cell Phone
EmailAddress EmailAddress E-Mail Address
_SalesOrderWithoutCharge _SalesOrderWithoutCharge
_SalesOrderWithoutChargeItem _SalesOrderWithoutChargeItem
_PartnerFunction _PartnerFunction
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr

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 I_SlsOrdWthoutChrgItmPartner.
-- 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.

CREATE VIEW I_SlsOrdWthoutChrgItmPartner AS
SELECT
  cast(Partner.SalesDocument as sales_order_without_charge preserving type) AS SalesOrderWithoutCharge,
  cast(Partner.SalesDocumentItem as sales_order_without_charge_itm preserving type) AS SalesOrderWithoutChargeItem,
  PartnerFunction,
  Customer,
  Supplier,
  Personnel,
  ContactPerson,
  Partner,
  FullName,
  ReferenceBusinessPartner,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddressRefType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  InternationalPhoneNumber,
  InternationalMobilePhoneNumber,
  EmailAddress
FROM I_SalesDocumentItemPartner AS Partner
LEFT OUTER JOIN I_SalesOrderWithoutCharge AS _SalesOrderWithoutCharge ON SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderWithoutChargeItem AS _SalesOrderWithoutChargeItem ON SalesOrderWithoutCharge = _SalesOrderWithoutChargeItem.SalesOrderWithoutCharge AND SalesOrderWithoutChargeItem = _SalesOrderWithoutChargeItem.SalesOrderWithoutChargeItem  -- association [1..1]
;