C_BillingDocument_F0797

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_BillingDocument_F0797.
-- 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.
-- SQL view name: CBDOCF0797

CREATE VIEW C_BillingDocument_F0797 AS
SELECT
  BillingDocument.BillingDocument AS BillingDocument,
  BillingDocument.BillingDocumentType AS BillingDocumentType,
  BillingDocument._BillingDocumentType._Text[1: Language = $session.system_language ].BillingDocumentTypeName AS BillingDocumentTypeName,
  BillingDocument.PayerParty AS PayerParty,
  BillingDocument._SoldToParty[1: Language = $session.system_language ].CustomerName AS HeaderPayerPartyName,
  cast(BillingDocument.OverallBillingStatus as billing_document_status preserving type) AS OverallBillingStatus,
  BillingDocument.SoldToParty AS SoldToParty,
  BillingDocument._SoldToParty.CustomerName AS SoldToPartyFullName,
  BillingDocument.BillingIssueType AS BillingIssueType,
  BillingDocument.TransactionCurrency AS TransactionCurrency,
  BillingDocument._CompanyCode.Currency AS Currency,
  BillingDocument.BillingDocumentIsCancelled AS BillingDocumentIsCancelled,
  BillingDocument.CancelledBillingDocument AS CancelledBillingDocument,
  BillingDocument.SDDocumentCategory AS SDDocumentCategory,
  BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  BillingDocument.CompanyCode AS CompanyCode,
  BillingDocument._CompanyCode.CompanyCodeName AS CompanyCodeName,
  BillingDocument.FiscalYear AS FiscalYear,
  cast(AccountingDocument as accounting_document_number) AS AccountingDocument,
  cast(BillingDocument.DocumentReferenceID as xblnr_v1_case_sensitive) AS DocumentReferenceID,
  BillingDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  BillingDocument.SalesOrganization AS SalesOrganization,
  BillingDocument.DistributionChannel AS DistributionChannel,
  BillingDocument.Division AS Division,
  BillingDocument.SalesDistrict AS SalesDistrict,
  BillingDocument.TotalNetAmount AS TotalNetAmount,
  BillingDocument.TotalTaxAmount AS TaxAmount,
  cast( (BillingDocument.TotalTaxAmount + BillingDocument.TotalNetAmount) as sdci_odata_total_amount) AS TotalGrossAmount,
  BillingDocument.AccountingTransferStatus AS AccountingTransferStatus,
  BillingDocument.IncotermsVersion AS IncotermsVersion,
  BillingDocument.IncotermsClassification AS IncotermsClassification,
  BillingDocument.IncotermsLocation1 AS IncotermsLocation1,
  BillingDocument.IncotermsLocation2 AS IncotermsLocation2,
  BillingDocument.IsRelevantForAccrual AS IsRelevantForAccrual,
  BillingDocument.PaymentMethod AS PaymentMethod,
  BillingDocument.CustomerPaymentTerms AS CustomerPaymentTerms,
  BillingDocument.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  BillingDocument.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  cast(case when _SitnInstceIndicator.SitnNumberOfInstances > 0 then 'X' else ' ' end as billingdocumenthassituations) AS BillingDocumentHasSituations,
  BillingDocument.InvoiceListType AS InvoiceListType,
  BillingDocument.ShippingCondition AS ShippingCondition,
  BillingDocument.ManualInvoiceMaintIsRelevant AS ManualInvoiceMaintIsRelevant,
  BillingDocument.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  BillingDocument.FixedValueDate AS FixedValueDate,
  AdditionalValueDays,
  AssignmentReference,
  AccountingExchangeRateIsSet,
  cast(abs( AccountingExchangeRate ) as kurrf_not_converted) AS AbsltAccountingExchangeRate,
  cast(case when AccountingExchangeRate < 0 then 'X' else ' ' end as kurrf_quotatn_is_indirect) AS AcctgExchangeRateIsIndrctQtan,
  BillingDocument.DunningArea AS DunningArea,
  BillingDocument.DunningBlockingReason AS DunningBlockingReason,
  BillingDocument.DunningKey AS DunningKey,
  BillingDocument.PricingDocument AS PricingDocument,
  BillingDocument.SDPricingProcedure AS SDPricingProcedure,
  BillingDocument._SDPricingProcedure._Text[1: Language = $session.system_language ].PricingProcedureName AS PricingProcedureName,
  BillingDocument.CustomerGroup AS CustomerGroup,
  BillingDocument.CustomerRebateAgreement AS CustomerRebateAgreement,
  BillingDocument.CustomerPriceGroup AS CustomerPriceGroup,
  BillingDocument.PriceListType AS PriceListType,
  BillingDocument._PriceListType._Text[1: Language = $session.system_language ].PriceListTypeName AS PriceListTypeName,
  BillingDocument.Country AS Country,
  BillingDocument.TaxDepartureCountry AS TaxDepartureCountry,
  BillingDocument.CustomerTaxClassification1 AS CustomerTaxClassification1,
  BillingDocument.CustomerTaxClassification2 AS CustomerTaxClassification2,
  BillingDocument.CustomerTaxClassification3 AS CustomerTaxClassification3,
  BillingDocument.CustomerTaxClassification4 AS CustomerTaxClassification4,
  BillingDocument.CustomerTaxClassification5 AS CustomerTaxClassification5,
  BillingDocument.CustomerTaxClassification6 AS CustomerTaxClassification6,
  BillingDocument.CustomerTaxClassification7 AS CustomerTaxClassification7,
  BillingDocument.CustomerTaxClassification8 AS CustomerTaxClassification8,
  BillingDocument.CustomerTaxClassification9 AS CustomerTaxClassification9,
  BillingDocument.VATRegistration AS VATRegistration,
  BillingDocument.CityCode AS CityCode,
  BillingDocument.County AS County,
  BillingDocument.Region AS Region,
  BillingDocument.VATRegistrationCountry AS VATRegistrationCountry,
  BillingDocument.VATRegistrationOrigin AS VATRegistrationOrigin,
  BillingDocument.IsEUTriangularDeal AS IsEUTriangularDeal,
  cast('1' as sdci_odata_ux_fc) AS UxFcTexts,
  cast('1' as sdci_odata_ux_fc) AS UxAcPost,
  cast('1' as sdci_odata_ux_fc) AS UxAcCancel,
  _SoldToParty.OrganizationBPName1 AS SoldToPartyName,
  _SoldToParty.OrganizationBPName2 AS SoldToPartyAdditionalName,
  _PayerParty.OrganizationBPName1 AS PayerPartyName,
  _PayerParty.OrganizationBPName2 AS PayerPartyAdditionalName,
  BillingDocument.CreationDate AS CreationDate,
  BillingDocument.CreationTime AS CreationTime,
  BillingDocument.CreatedByUser AS CreatedByUser,
  cast(case when BillingDocumentIsTemporary = 'S' then 'X' else BillingDocumentIsTemporary end as vf_draft_indicator) AS BillingDocumentIsTemporary,
  BillingDocument.InvoiceClearingStatus AS InvoiceClearingStatus,
  BillingDocument._CompanyCode AS _CompanyCode,
  BillingDocument._FiscalYear AS _FiscalYear,
  BillingDocument._CustomerPaymentTerms AS _CustomerPaymentTerms,
  BillingDocument._IncotermsClassification AS _IncotermsClassification,
  BillingDocument._IncotermsVersion AS _IncotermsVersion,
  BillingDocument._BillingDocumentType AS _BillingDocumentType,
  BillingDocument._BillingIssueType AS _BillingIssueType,
  BillingDocument._OverallBillingStatus AS _OverallBillingStatus,
  BillingDocument._CustomerGroup AS _CustomerGroup,
  BillingDocument._CustomerPriceGroup AS _CustomerPriceGroup,
  BillingDocument._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
  BillingDocument._DunningBlockingReason AS _DunningBlockingReason,
  BillingDocument._DunningKey AS _DunningKey,
  BillingDocument._Country AS _Country,
  BillingDocument._TaxDepartureCountry AS _TaxDepartureCountry,
  BillingDocument._TransactionCurrency AS _TransactionCurrency,
  BillingDocument._AccountingTransferStatus AS _AccountingTransferStatus,
  BillingDocument._CityCode AS _CityCode,
  BillingDocument._County_2 AS _County_2,
  BillingDocument._Region AS _Region,
  BillingDocument._VATRegistrationCountry AS _VATRegistrationCountry,
  BillingDocument._VATRegistrationOrigin AS _VATRegistrationOrigin,
  BillingDocument._SDPricingProcedure AS _SDPricingProcedure,
  _ErrorLog.SystemMessageIdentification AS SystemMessageIdentification,
  _ErrorLog.SystemMessageNumber AS SystemMessageNumber,
  _ErrorLog.SystemMessageType AS SystemMessageType,
  _ErrorLog.SystemMessageVariable1 AS SystemMessageVariable1,
  _ErrorLog.SystemMessageVariable2 AS SystemMessageVariable2,
  _ErrorLog.SystemMessageVariable3 AS SystemMessageVariable3,
  _ErrorLog.SystemMessageVariable4 AS SystemMessageVariable4,
  cast('' as sdci_odata_issue_text) AS SystemMessageText,
  BillingDocument._InvoiceClearingStatus AS _InvoiceClearingStatus,
  BillingDocument._DunningAreaText AS _DunningAreaText,
  cast('' as xfeld) AS HasMsgsFromLegacyOutputControl
FROM I_BillingDocument AS BillingDocument
LEFT OUTER JOIN C_BillingRunErrorLog AS _FirstErrorMessage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_BillingDocumentItem_F0797 AS _Item ON BillingDocument = _Item.BillingDocument  -- association [0..*]
LEFT OUTER JOIN C_PricingElement AS _PricingElement ON PricingDocument = _PricingElement.PricingDocument  -- association [0..*]
LEFT OUTER JOIN C_SoldToValueHelp AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_SoldToValueHelp AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannel ON SalesOrganization = _DistributionChannel.SalesOrganization AND DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _Division ON SalesOrganization = _Division.SalesOrganization AND DistributionChannel = _Division.DistributionChannel AND Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesDocPaymentMethodVH AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND CompanyCode = _PaymentMethod.BillingCompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CollectiveProcessingErrorLog AS _ErrorLog ON _ErrorLog.CollectiveProcessing = '' AND BillingDocument = _ErrorLog.SDDocument AND _ErrorLog.CollectiveProcessingMsgCounter = _FirstErrorMessage.CollectiveProcessingMsgCounter AND _ErrorLog.ScheduleLine = _FirstErrorMessage.ScheduleLine AND _ErrorLog.SystemMessageType = 'E'  -- association [0..1]
LEFT OUTER JOIN C_BillingDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocument = _Extension.BillingDocument  -- association [1]
LEFT OUTER JOIN C_BillgSalesDocCatVH AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SitnInstceIndicator AS _SitnInstceIndicator ON _SitnInstceIndicator.SitnInstceAnchorObjectKey = BillingDocument AND _SitnInstceIndicator.SitnDefAnchorObject = 'BillingDocument'  -- association [0..1]
;