R_SlsOrdWthoutChrgItmPartnerTP

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 R_SlsOrdWthoutChrgItmPartnerTP.
-- 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 R_SlsOrdWthoutChrgItmPartnerTP AS
SELECT
  cast(SlsOrdWithoutChargeItemPartner.SalesDocument as sales_order_without_charge preserving type) AS SalesOrderWithoutCharge,
  cast(SlsOrdWithoutChargeItemPartner.SalesDocumentItem as sales_order_without_charge_itm preserving type) AS SalesOrderWithoutChargeItem,
  cast(SlsOrdWithoutChargeItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  cast(SlsOrdWithoutChargeItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  SlsOrdWithoutChargeItemPartner.Customer AS Customer,
  SlsOrdWithoutChargeItemPartner.Supplier AS Supplier,
  SlsOrdWithoutChargeItemPartner.Personnel AS Personnel,
  SlsOrdWithoutChargeItemPartner.ContactPerson AS ContactPerson,
  SlsOrdWithoutChargeItemPartner.Partner AS Partner,
  cast('' as ad_name1) AS BusinessPartnerName1,
  cast('' as ad_name2) AS BusinessPartnerName2,
  cast('' as ad_name3) AS BusinessPartnerName3,
  cast('' as ad_name4) AS BusinessPartnerName4,
  SlsOrdWithoutChargeItemPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  SlsOrdWithoutChargeItemPartner.FormOfAddress AS FormOfAddress,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.StreetName AS StreetName,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.StreetPrefixName1 AS StreetPrefixName1,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.StreetPrefixName2 AS StreetPrefixName2,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.StreetSuffixName1 AS StreetSuffixName1,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.StreetSuffixName2 AS StreetSuffixName2,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.Country AS Country,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.Region AS Region,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.CityName AS CityName,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.POBox AS POBox,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  cast(SlsOrdWithoutChargeItemPartner.CorrespondenceLanguage as vdm_sd_sls_langu_corr preserving type ) AS CorrespondenceLanguage,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  SlsOrdWithoutChargeItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  SlsOrdWithoutChargeItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SlsOrdWithoutChargeItemPartner.AddressID AS AddressID,
  SlsOrdWithoutChargeItemPartner.AddressPersonID AS AddressPersonID,
  SlsOrdWithoutChargeItemPartner.AddressObjectType AS AddressObjectType,
  SlsOrdWithoutChargeItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  SlsOrdWithoutChargeItemPartner.VATRegistration AS VATRegistration,
  SlsOrdWithoutChargeItemPartner.UnloadingPointName AS UnloadingPointName,
  SlsOrdWithoutChargeItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  SlsOrdWithoutChargeItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  SlsOrdWithoutChargeItemPartner.InternationalFaxNumber AS InternationalFaxNumber,
  SlsOrdWithoutChargeItemPartner.EmailAddress AS EmailAddress,
  SlsOrdWithoutChargeItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  SlsOrdWithoutChargeItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  SlsOrdWithoutChargeItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  SlsOrdWithoutChargeItemPartner.PartnerIsOneTimeAccount AS PartnerIsOneTimeAccount,
  _SalesOrderWithoutCharge.SalesOrderWithoutChargeType AS SalesOrderWithoutChargeType,
  _SalesOrderWithoutCharge.SalesOrganization AS SalesOrganization,
  _SalesOrderWithoutCharge.DistributionChannel AS DistributionChannel,
  _SalesOrderWithoutCharge.OrganizationDivision AS OrganizationDivision,
  SlsOrdWithoutChargeItemPartner._ContactPerson AS _ContactPerson,
  SlsOrdWithoutChargeItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  SlsOrdWithoutChargeItemPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  SlsOrdWithoutChargeItemPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress._Country AS _Country,
  SlsOrdWithoutChargeItemPartner._OrgNamePostalAddress._Region AS _Region
FROM I_SalesDocItemCompletePartner AS SlsOrdWithoutChargeItemPartner
INNER JOIN I_SalesDocumentBasic AS SalesOrderWithoutCharge ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SalesOrderWithoutChargeTP AS _SalesOrderWithoutCharge ON SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_Language AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON transportzone = _TransportationZone.TransportZone AND country = _TransportationZone.CountryCode  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr ON AddressID = _CurrentDfltLandlinePhoneNmbr.AddressID AND AddressPersonID = _CurrentDfltLandlinePhoneNmbr.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber ON AddressID = _CurrentDfltMobilePhoneNumber.AddressID AND AddressPersonID = _CurrentDfltMobilePhoneNumber.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _CurrentDfltFaxNumber ON AddressID = _CurrentDfltFaxNumber.AddressID AND AddressPersonID = _CurrentDfltFaxNumber.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_WorkplaceAddress AS _WorkPlaceAddress ON ReferenceBusinessPartner = _WorkPlaceAddress.BusinessPartner  -- association [1]
;