A_BillingDocumentPartner_2

DDL: A_BILLINGDOCUMENTPARTNER_2 Type: view_entity CONSUMPTION Package: ODATA_SD_BIL_BD_API
34 Fields 1 Data Sources 1 OData Services

Header Partners

A_BillingDocumentPartner_2 is a Consumption CDS View that provides data about "Header Partners" in SAP S/4HANA. It reads from 1 data source (R_BillingDocumentPartnerTP) and exposes 34 fields with key fields BillingDocument, PartnerFunction. It is exposed through 1 OData service (API_BILLINGDOCUMENT). Part of development package ODATA_SD_BIL_BD_API.

Data Sources (1)

SourceAliasJoin Type
R_BillingDocumentPartnerTP R_BillingDocumentPartnerTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Header Partners view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
OData.entityType.name BillingDocumentPartner_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_BILLINGDOCUMENT API_BILLINGDOCUMENT V4 C2 C1

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument Partner BillingDocument SD Document
KEY PartnerFunction Partner PartnerFunction Partner Functn
Customer Partner Customer Sold-to Party
Supplier Partner Supplier Supplier
Personnel Partner Personnel Personnel No.
ContactPerson Partner ContactPerson Contact Person Key
ReferenceBusinessPartner Partner ReferenceBusinessPartner Busn. Partner
BusinessPartnerAddressUUID Partner BusinessPartnerAddressUUID UUID
virtualFullNamead_namtext
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
AddressObjectType AddressObjectType Address Type
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific
virtualFormOfAddressad_title
virtualCorrespondenceLanguagespras
virtualStreetPrefixName1ad_strspp1
virtualStreetPrefixName2ad_strspp2
virtualStreetNamead_street
virtualStreetSuffixName1ad_strspp3
virtualStreetSuffixName2ad_lctn
virtualHouseNumberad_hsnm1
virtualPostalCodead_pstcd1
virtualCityNamead_city1
virtualDistrictNamead_city2
virtualRegionregio
virtualCountryland1
virtualInternationalFaxNumberad_fxnrlng
virtualEmailAddressvdm_sd_ad_smtpadr
virtualPOBoxad_pobx
virtualPOBoxPostalCodead_pstcd2
virtualTaxJurisdictionad_txjcd
virtualTransportZonelzone
VATRegistration VATRegistration VAT Registration No.
UnloadingPointName UnloadingPointName Unloading Point Name

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 A_BillingDocumentPartner_2.
-- 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 A_BillingDocumentPartner_2 AS
SELECT
  Partner.BillingDocument AS BillingDocument,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.Customer AS Customer,
  Partner.Supplier AS Supplier,
  Partner.Personnel AS Personnel,
  Partner.ContactPerson AS ContactPerson,
  Partner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  Partner.BusinessPartnerAddressUUID AS BusinessPartnerAddressUUID,
  virtual FullName : ad_namtext AS virtualFullNamead_namtext,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddrIsDocSpecific,
  virtual FormOfAddress : ad_title AS virtualFormOfAddressad_title,
  virtual CorrespondenceLanguage : spras AS virtualCorrespondenceLanguagespras,
  virtual StreetPrefixName1 : ad_strspp1 AS virtualStreetPrefixName1ad_strspp1,
  virtual StreetPrefixName2 : ad_strspp2 AS virtualStreetPrefixName2ad_strspp2,
  virtual StreetName : ad_street AS virtualStreetNamead_street,
  virtual StreetSuffixName1 : ad_strspp3 AS virtualStreetSuffixName1ad_strspp3,
  virtual StreetSuffixName2 : ad_lctn AS virtualStreetSuffixName2ad_lctn,
  virtual HouseNumber : ad_hsnm1 AS virtualHouseNumberad_hsnm1,
  virtual PostalCode : ad_pstcd1 AS virtualPostalCodead_pstcd1,
  virtual CityName : ad_city1 AS virtualCityNamead_city1,
  virtual DistrictName : ad_city2 AS virtualDistrictNamead_city2,
  virtual Region : regio AS virtualRegionregio,
  virtual Country : land1 AS virtualCountryland1,
  virtual InternationalFaxNumber :ad_fxnrlng AS virtualInternationalFaxNumberad_fxnrlng,
  virtual EmailAddress : vdm_sd_ad_smtpadr AS virtualEmailAddressvdm_sd_ad_smtpadr,
  virtual POBox :ad_pobx AS virtualPOBoxad_pobx,
  virtual POBoxPostalCode : ad_pstcd2 AS virtualPOBoxPostalCodead_pstcd2,
  virtual TaxJurisdiction : ad_txjcd AS virtualTaxJurisdictionad_txjcd,
  virtual TransportZone : lzone AS virtualTransportZonelzone,
  VATRegistration,
  UnloadingPointName
FROM R_BillingDocumentPartnerTP
;

Learn More