I_BillingDocumentRequest

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_BillingDocumentRequest.
-- 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_BillingDocumentRequest AS
SELECT
  cast (BillingDocument as vbeln_bdr preserving type) AS BillingDocumentRequest,
  SDDocumentCategory,
  cast (BillingDocumentType as sdbil_odata_bdr_type preserving type ) AS BillingDocumentRequestType,
  cast (ProposedBillingDocumentType as proposed_billing_document_type preserving type ) AS ProposedBillingDocumentType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  LogicalSystem,
  SalesOrganization,
  DistributionChannel,
  Division,
  BillingDocumentDate,
  cast (BillingDocCombinationCriteria as billg_doc_req_combn_criteria preserving type ) AS BillgDocReqCombinationCriteria,
  TotalNetAmount,
  TransactionCurrency,
  TotalTaxAmount,
  CustomerPriceGroup,
  PriceListType,
  TaxDepartureCountry,
  VATRegistration,
  VATRegistrationOrigin,
  VATRegistrationCountry,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  SDPricingProcedure,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  PayerParty,
  ContractAccount,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  AdditionalValueDays,
  SEPAMandate,
  CompanyCode,
  CustomerAccountAssignmentGroup,
  ExchangeRateDate,
  ExchangeRateType,
  DocumentReferenceID,
  DunningArea,
  DunningBlockingReason,
  DunningKey,
  cast ( BillingDocRequestReference as sdbil_odata_source_document preserving type ) AS ReferenceDocument,
  cast ( BillgDocReqRefLgclSyst as sdbil_odata_source_system preserving type ) AS ReferenceDocumentLogicalSystem,
  cast ( BillgDocReqRefSDDocCategory as sdbil_odata_src_doc_cat preserving type ) AS ReferenceDocSDDocCategory,
  SoldToParty,
  PurchaseOrderByCustomer,
  CustomerGroup,
  Country,
  CityCode,
  SalesDistrict,
  Region,
  County,
  CreditControlArea,
  PricingDocument,
  OverallBillingDocReqStatus,
  BillingIssueType,
  OverallPricingIncompletionSts
FROM I_BillingDocumentBasic
LEFT OUTER JOIN I_BillingDocumentRequestItem AS _Item ON BillingDocumentRequest = _Item.BillingDocumentRequest  -- association [0..*]
LEFT OUTER JOIN I_BillingDocReqPartner AS _Partner ON BillingDocumentRequest = _Partner.BillingDocumentRequest  -- association [1..*]
LEFT OUTER JOIN I_BillingDocReqPrcgElmnt AS _PricingElement ON BillingDocumentRequest = _PricingElement.BillingDocumentRequest  -- association [0..*]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocumentRequest = _Extension.BillingDocument  -- association [0..1]
;