I_PrelimBillingDocumentItem

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_PrelimBillingDocumentItem.
-- 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_PrelimBillingDocumentItem AS
SELECT
  cast( BillingDocument as prelim_billing_document preserving type ) AS PrelimBillingDocument,
  cast( BillingDocumentItem as prelim_billing_document_item preserving type ) AS PrelimBillingDocumentItem,
  SalesDocumentItemCategory,
  cast( SalesDocumentItemType as sales_document_item_type preserving type ) AS SalesDocumentItemType,
  ReturnItemProcessingType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  ReferenceLogicalSystem,
  OrganizationDivision,
  Division,
  SalesOffice,
  Material,
  Product,
  OriginallyRequestedMaterial,
  InternationalArticleNumber,
  PricingReferenceMaterial,
  Batch,
  ProductHierarchyNode,
  MaterialGroup,
  ProductGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  ProductConfiguration,
  MaterialCommissionGroup,
  Plant,
  StorageLocation,
  ReplacementPartType,
  MaterialGroupHierarchy1,
  MaterialGroupHierarchy2,
  PlantRegion,
  PlantCounty,
  PlantCity,
  BOMExplosion,
  MaterialDeterminationType,
  cast( BillingDocumentItemText as billing_document_item_desc preserving type ) AS BillingDocumentItemText,
  ServicesRenderedDate,
  cast( BillingQuantity as billing_quantity preserving type ) AS BillingQuantity,
  cast( BillingQuantityUnit as billing_quantity_unit preserving type ) AS BillingQuantityUnit,
  BillingQuantityInBaseUnit,
  BaseUnit,
  MRPRequiredQuantityInBaseUnit,
  cast( BillingToBaseQuantityDnmntr as billing_to_base_qty_dnmntr preserving type ) AS BillingToBaseQuantityDnmntr,
  cast( BillingToBaseQuantityNmrtr as billing_to_base_qty_nmrtr preserving type ) AS BillingToBaseQuantityNmrtr,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  BillToPartyCountry,
  BillToPartyRegion,
  BillingPlanRule,
  BillingPlan,
  BillingPlanItem,
  NetAmount,
  TransactionCurrency,
  GrossAmount,
  PricingDate,
  PriceDetnExchangeRate,
  PricingScaleQuantityInBaseUnit,
  TaxAmount,
  CostAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  StatisticalValueControl,
  CashDiscountIsDeductible,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  ManualPriceChangeType,
  MaterialPricingGroup,
  StatisticsExchangeRate,
  MainItemPricingRefMaterial,
  MainItemMaterialPricingGroup,
  TimeSheetOvertimeCategory,
  PricingRelevance,
  DepartureCountry,
  TaxJurisdiction,
  ProductTaxClassification1,
  ProductTaxClassification2,
  ProductTaxClassification3,
  ProductTaxClassification4,
  ProductTaxClassification5,
  ProductTaxClassification6,
  ProductTaxClassification7,
  ProductTaxClassification8,
  ProductTaxClassification9,
  ZeroVATRsn,
  CountryOfOrigin,
  RegionOfOrigin,
  CommodityCode,
  EligibleAmountForCashDiscount,
  BusinessArea,
  ProfitCenter,
  OrderID,
  WBSElementInternalID,
  ProviderContract,
  ProviderContractItem,
  ControllingArea,
  cast ( case when ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
  ProfitabilitySegment_2,
  CostCenter,
  OriginSDDocument,
  OriginSDDocumentItem,
  PriceDetnExchangeRateDate,
  MatlAccountAssignmentGroup,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  SalesDocument,
  SalesDocumentItem,
  SalesSDDocumentCategory,
  HigherLevelItem,
  HigherLvlItmOfBatSpltItm,
  BillingDocumentItemInPartSgmt,
  ExternalReferenceDocument,
  ExternalReferenceDocumentItem,
  BillingDocExtReferenceDocItem,
  SalesGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SDDocumentReason,
  RetailPromotion,
  RebateBasisAmount,
  VolumeRebateGroup,
  ItemIsRelevantForCredit,
  CreditRelatedPrice,
  SalesDeal,
  SalesPromotion,
  SalesOrderSalesDistrict,
  SalesOrderCustomerGroup,
  SalesOrderCustomerPriceGroup,
  SalesOrderPriceListType,
  SalesOrderSalesOrganization,
  SalesOrderDistributionChannel,
  SalesDocIsCreatedFromReference,
  ShippingPoint,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  SDDocumentCategory,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  CustomerPriceGroup,
  CustomerGroup,
  Country,
  Region,
  CityCode,
  SalesDistrict,
  OverallSDProcessStatus,
  SoldToParty,
  PayerParty,
  BillingDocumentDate,
  CompanyCode,
  County,
  CustomerRebateAgreement,
  BillingDocumentCategory,
  ShipToParty,
  BillToParty,
  SalesEmployee,
  ResponsibleEmployee
FROM I_BillingDocumentItemBasic AS Item
LEFT OUTER JOIN I_PrelimBillingDocument AS _PrelimBillingDocument ON PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument  -- association [1..1]
LEFT OUTER JOIN I_PrelimBillingDocItemPartner AS _Partner ON PrelimBillingDocument = _Partner.PrelimBillingDocument AND PrelimBillingDocumentItem = _Partner.PrelimBillingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_PrelimBillgDocItemPrcgElmnt AS _PricingElement ON PrelimBillingDocument = _PricingElement.PrelimBillingDocument AND PrelimBillingDocumentItem = _PricingElement.PrelimBillingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_PrelimBillingDocumentItem AS _HigherLevelItem ON PrelimBillingDocument = _HigherLevelItem.PrelimBillingDocument AND HigherLevelItem = _HigherLevelItem.PrelimBillingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_PrelimBillingDocumentItem AS _HigherLvlItmOfBatSpltItm ON PrelimBillingDocument = _HigherLvlItmOfBatSpltItm.PrelimBillingDocument AND HigherLvlItmOfBatSpltItm = _HigherLvlItmOfBatSpltItm.PrelimBillingDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_BillingDocumentItem AS _Extension ON PrelimBillingDocument = _Extension.BillingDocument AND PrelimBillingDocumentItem = _Extension.BillingDocumentItem  -- association [1]
;