C_PBDItemPartnerTP_F6990

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 C_PBDItemPartnerTP_F6990.
-- 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 C_PBDItemPartnerTP_F6990 AS
SELECT
  PrelimBillingDocument,
  PrelimBillingDocumentItem,
  PartnerFunction,
  Customer,
  virtual CustomerIsHidden : boole_d AS virtualCustomerIsHiddenboole_d,
  Supplier,
  virtual SupplierIsHidden : boole_d AS virtualSupplierIsHiddenboole_d,
  Personnel,
  virtual PersonnelNumberIsHidden : boole_d AS virtualPersonnelNumberIsHiddenboole_d,
  ContactPerson,
  virtual ContactPersonIsHidden : boole_d AS virtualContactPersonIsHiddenboole_d,
  virtual FullName : ad_namtext AS virtualFullNamead_namtext,
  ReferenceBusinessPartner,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddrIsDocSpecific,
  PartnerIsSpecificForSDDocItem,
  SDDocumentPartnerType,
  VATRegistration,
  UnloadingPointName,
  virtual PostalCode : ad_pstcd1 AS virtualPostalCodead_pstcd1,
  virtual CityName : ad_city1 AS virtualCityNamead_city1,
  virtual DistrictName : ad_city2 AS virtualDistrictNamead_city2,
  virtual StreetName : ad_street AS virtualStreetNamead_street,
  virtual HouseNumber : ad_hsnm1 AS virtualHouseNumberad_hsnm1,
  virtual POBox : ad_pobx AS virtualPOBoxad_pobx,
  virtual POBoxPostalCode : ad_pstcd2 AS virtualPOBoxPostalCodead_pstcd2,
  virtual TaxJurisdiction : ad_txjcd AS virtualTaxJurisdictionad_txjcd,
  virtual EmailAddress : vdm_sd_ad_smtpadr AS virtualEmailAddressvdm_sd_ad_smtpadr,
  virtual Country : land1 AS virtualCountryland1,
  virtual CountryName : landx50 AS virtualCountryNamelandx50,
  virtual Region : regio AS virtualRegionregio,
  virtual RegionName : bezei20 AS virtualRegionNamebezei20,
  virtual TransportZone : lzone AS virtualTransportZonelzone,
  virtual TransportZoneDescription : bezei20 AS virtualTransportZoneDescriptionbezei20,
  virtual FormOfAddress : ad_title AS virtualFormOfAddressad_title,
  virtual FormOfAddressName : ad_titletx AS virtualFormOfAddressNamead_titletx,
  virtual CorrespondenceLanguage : spras AS virtualCorrespondenceLanguagespras,
  virtual CorrespondenceLanguageName : sptxt AS virtualCorrespondenceLanguageNamesptxt,
  virtual PersonExternalID : bu_id_number AS virtualPersonExternalIDbu_id_number
FROM R_PrelimBillgDocItemPartnerTP
;