I_SlsOrdWthoutChrgPartner

DDL: I_SLSORDWTHOUTCHRGPARTNER Type: view COMPOSITE
32 Fields 1 Data Sources 1 Associations

Partner for Sales Order Without Charge

I_SlsOrdWthoutChrgPartner is a Composite CDS View that provides data about "Partner for Sales Order Without Charge" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentPartner) and exposes 32 fields with key fields SalesOrderWithoutCharge, PartnerFunction. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentPartner Partner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesOrderWithoutCharge _SalesOrderWithoutCharge $projection.SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label 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 ISDSOWTCHRGPT 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

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderWithoutCharge
KEY PartnerFunction PartnerFunction Partner Functn
Customer Customer Sold-to Party
Supplier Supplier Supplier
Personnel Personnel Personnel No.
ContactPerson ContactPerson Contact Person Key
Partner Partner With Partner
FullName FullName Name
ReferenceBusinessPartner ReferenceBusinessPartner Busn. Partner
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
AddressObjectType AddressObjectType Address Type
SDDocPartnerAddressRefType SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific
VATRegistration VATRegistration VAT Registration No.
UnloadingPointName UnloadingPointName Unloading Point Name
CorrespondenceLanguage CorrespondenceLanguage Language
FormOfAddress FormOfAddress Title Key
InternationalPhoneNumber InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber InternationalMobilePhoneNumber
InternationalFaxNumber InternationalFaxNumber Fax Number
EmailAddress EmailAddress E-Mail Address
_SalesOrderWithoutCharge _SalesOrderWithoutCharge
_PartnerFunction _PartnerFunction
_ContactPerson _ContactPerson
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr
_OrgNamePostalAddress _OrgNamePostalAddress

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_SlsOrdWthoutChrgPartner.
-- 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_SlsOrdWthoutChrgPartner AS
SELECT
  cast(Partner.SalesDocument as sales_order_without_charge preserving type) AS SalesOrderWithoutCharge,
  PartnerFunction,
  Customer,
  Supplier,
  Personnel,
  ContactPerson,
  Partner,
  FullName,
  ReferenceBusinessPartner,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddressRefType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  SDDocPartnerAddrIsDocSpecific,
  VATRegistration,
  UnloadingPointName,
  CorrespondenceLanguage,
  FormOfAddress,
  InternationalPhoneNumber,
  InternationalMobilePhoneNumber,
  InternationalFaxNumber,
  EmailAddress
FROM I_SalesDocumentPartner AS Partner
LEFT OUTER JOIN I_SalesOrderWithoutCharge AS _SalesOrderWithoutCharge ON SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge  -- association [1..1]
;

Learn More