FAC_AUDIT_Z3_BILLHDRITEM

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 FAC_AUDIT_Z3_BILLHDRITEM.
-- 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: FACZ3BLHDRITM
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_AUDIT_Z3_BILLHDRITEM AS
SELECT
  BillingDocument,
  cast('000000' as posnr_vf ) AS BillingDocumentItem,
  $session.client AS SystemClient,
  BillingDoc.CompanyCode AS CompanyCode,
  AccountingDocument,
  FiscalYear,
  _AccountingDocument.FiscalPeriod AS FiscalPeriod,
  DocumentReferenceID,
  TransactionCurrency,
  PartnerCompany,
  BillingDocumentType,
  _BillingDocumentType._Text[1: Language = $parameters.P_Language].BillingDocumentTypeName AS BillingDocumentTypeName,
  BillingDocumentDate,
  BillingDocumentIsCancelled,
  SDDocumentCategory,
  _SDDocumentCategory._Text[1: Language = $parameters.P_Language].SDDocumentCategoryName AS SDDocumentCategoryName,
  BillingDocumentCategory,
  IncotermsClassification,
  _IncotermsClassification._Text[1: Language = $parameters.P_Language].IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsTransferLocation,
  SDPricingProcedure,
  _SDPricingProcedure._Text[1: Language = $parameters.P_Language].PricingProcedureName AS PricingProcedureName,
  SoldToParty,
  PayerParty,
  CancelledBillingDocument,
  TotalNetAmount,
  _AccountingDocument.ReferenceDocumentType AS ReferenceDocumentType,
  _AccountingDocument.OriginalReferenceDocument AS OriginalReferenceDocument,
  PurchaseOrderByCustomer,
  PricingDocument,
  SalesOrganization,
  _SalesOrganization._Text[1: Language = $parameters.P_Language].SalesOrganizationName AS SalesOrganizationName,
  CustomerPaymentTerms,
  Country,
  TaxDepartureCountry,
  LogicalSystem,
  VATRegistration,
  VATRegistrationOrigin,
  VATRegistrationCountry,
  IsEUTriangularDeal,
  CreatedByUser,
  CreationDate,
  AccountingExchangeRate,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  cast( '' as pstyv ) AS SalesDocumentItemCategory,
  cast( '' as bezei20 ) AS SalesDocumentItemCategoryName,
  cast( '' as vgbel ) AS ReferenceSDDocument,
  cast( '' as vgpos ) AS ReferenceSDDocumentItem,
  cast( '' as vbeln_va ) AS SalesDocument,
  cast( '' as posnr_va ) AS SalesDocumentItem,
  cast( '' as vbtypl ) AS SalesSDDocumentCategory,
  cast( '' as sddocumentcategoryname ) AS SalesSDDocumentCategoryName,
  cast( '' as gsber ) AS BusinessArea,
  cast( '' as farp_gtext) AS BusinessAreaName,
  cast( '' as kokrs ) AS ControllingArea,
  cast( '' as fis_kokrs_name) AS ControllingAreaName,
  cast( '' as arktx ) AS BillingDocumentItemText,
  cast( '00000000' as fbuda ) AS ServicesRenderedDate,
  cast( '' as shkzg_vf ) AS ReturnItemProcessingType,
  cast( 0 as fkimg ) AS BillingQuantity,
  cast( '' as kowrr ) AS StatisticalValueControl,
  cast( 0 as lmeng ) AS MRPRequiredQuantityInBaseUnit,
  cast( '' as matkl ) AS MaterialGroup,
  cast( '' as matnr ) AS Material,
  cast( '' as meins ) AS BaseUnit,
  cast( 0 as mwsbp ) AS TaxAmount,
  cast( 0 as netwr_fp ) AS NetAmount,
  cast( '' as prctr ) AS ProfitCenter,
  cast( '00000000' as prsdt ) AS PricingDate,
  cast( '' as txjcd ) AS TaxJurisdiction,
  cast( '' as vrkme ) AS BillingQuantityUnit,
  cast( '' as werks_d ) AS Plant,
  cast( '' as werks_name) AS PlantName,
  cast( '' as charg_d ) AS Batch,
  cast( 0 as kzwi1 ) AS Subtotal1Amount,
  cast( 0 as kzwi2 ) AS Subtotal2Amount,
  cast( 0 as kzwi3 ) AS Subtotal3Amount,
  cast( 0 as kzwi4 ) AS Subtotal4Amount,
  cast( 0 as kzwi5 ) AS Subtotal5Amount,
  cast( 0 as kzwi6 ) AS Subtotal6Amount,
  cast( '' as prodh_d ) AS ProductHierarchyNode,
  cast( '' as taxm1 ) AS ProductTaxClassification1,
  cast( '' as taxm2 ) AS ProductTaxClassification2,
  cast( '' as taxm3 ) AS ProductTaxClassification3,
  cast( '' as taxm4 ) AS ProductTaxClassification4,
  cast( '' as taxm5 ) AS ProductTaxClassification5,
  cast( '' as taxm6 ) AS ProductTaxClassification6,
  cast( '' as taxm7 ) AS ProductTaxClassification7,
  cast( '' as taxm8 ) AS ProductTaxClassification8,
  cast( '' as taxm9 ) AS ProductTaxClassification9,
  cast( '' as lgort_d ) AS StorageLocation,
  cast( '' as mwskz ) AS TaxCode,
  cast( '' as fot_txdat_from ) AS TaxRateValidityStartDate,
  cast(''as vbtypl_v ) AS ReferenceSDDocumentCategory,
  cast(''as sddocumentcategoryname ) AS ReferenceSDDocCategoryName,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant
FROM I_BillingDocument AS BillingDoc
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocument AS _BillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
-- UNION ALL with additional select branch(es): I_BillingDocumentItem
;