A_BillingDocument

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_BillingDocument.
-- 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_BillingDocument AS
SELECT
  BillingDocument,
  SDDocumentCategory,
  BillingDocumentCategory,
  BillingDocumentType,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LogicalSystem,
  SalesOrganization,
  DistributionChannel,
  Division,
  BillingDocumentDate,
  BillingDocumentIsCancelled,
  CancelledBillingDocument,
  cast('' as exnum) AS ForeignTrade,
  cast('' as expkz) AS IsExportDelivery,
  BillingDocCombinationCriteria,
  ManualInvoiceMaintIsRelevant,
  IsIntrastatReportingRelevant,
  IsIntrastatReportingExcluded,
  TotalNetAmount,
  TransactionCurrency,
  StatisticsCurrency,
  ForeignTradeStstclCurrency,
  TotalTaxAmount AS TaxAmount,
  (TotalTaxAmount + TotalNetAmount) AS TotalGrossAmount,
  CustomerPriceGroup,
  PriceListType,
  TaxDepartureCountry,
  VATRegistration,
  VATRegistrationOrigin,
  VATRegistrationCountry,
  HierarchyTypePricing,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  IsEUTriangularDeal,
  SDPricingProcedure,
  ShippingCondition,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  PayerParty,
  ContractAccount,
  CustomerPaymentTerms,
  PaymentMethod,
  PaymentReference,
  FixedValueDate,
  AdditionalValueDays,
  SEPAMandate,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  CustomerAccountAssignmentGroup,
  AccountingExchangeRateIsSet,
  cast(abs( AccountingExchangeRate ) as kurrf_abs) AS AbsltAccountingExchangeRate,
  cast(case when AccountingExchangeRate < 0 then 'X' else ' ' end as kurrf_quotatn_is_indirect) AS AcctgExchangeRateIsIndrctQtan,
  ExchangeRateDate,
  ExchangeRateType,
  DocumentReferenceID,
  AssignmentReference,
  DunningArea,
  DunningBlockingReason,
  DunningKey,
  InternalFinancialDocument,
  IsRelevantForAccrual,
  SoldToParty,
  PartnerCompany,
  PurchaseOrderByCustomer,
  CustomerGroup,
  Country,
  CityCode,
  SalesDistrict,
  Region,
  County,
  CreditControlArea,
  CustomerRebateAgreement,
  PricingDocument AS SalesDocumentCondition,
  OverallSDProcessStatus,
  OverallBillingStatus,
  AccountingPostingStatus,
  AccountingTransferStatus,
  BillingIssueType,
  InvoiceListStatus,
  OvrlItmGeneralIncompletionSts,
  OverallPricingIncompletionSts,
  InvoiceClearingStatus,
  InvoiceListType AS BillingDocumentListType,
  InvoiceListBillingDate AS BillingDocumentListDate
FROM I_BillingDocument
LEFT OUTER JOIN A_BillingDocumentItem AS _Item ON BillingDocument = _Item.BillingDocument  -- association [0..*]
LEFT OUTER JOIN A_BillingDocumentPartner AS _Partner ON BillingDocument = _Partner.BillingDocument  -- association [0..*]
LEFT OUTER JOIN A_BillingDocumentPrcgElmnt AS _PricingElement ON BillingDocument = _PricingElement.BillingDocument  -- association [0..*]
LEFT OUTER JOIN A_BillingDocumentText AS _Text ON BillingDocument = _Text.BillingDocument  -- association [0..*]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocument = _Extension.BillingDocument  -- association [0..1]
;