P_BillingDocumentItemBasic_2

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 P_BillingDocumentItemBasic_2.
-- 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 P_BillingDocumentItemBasic_2 AS
SELECT
  vbrp.vbeln AS BillingDocument,
  vbrp.posnr AS BillingDocumentItem,
  cast(vbrp.pstyv as sales_doc_item_category preserving type) AS SalesDocumentItemCategory,
  vbrp.posar AS SalesDocumentItemType,
  vbrp.shkzg AS ReturnItemProcessingType,
  vbrp.ernam AS CreatedByUser,
  vbrp.erdat AS CreationDate,
  vbrp.erzet AS CreationTime,
  vbrp.logsys AS ReferenceLogicalSystem,
  cast(vbrp.spara as sales_order_divison preserving type) AS OrganizationDivision,
  vbrp. spart AS Division,
  vbrp.vkbur AS SalesOffice,
  cast (vbrp.matnr as productnumber preserving type) AS Product,
  vbrp.matwa AS OriginallyRequestedMaterial,
  vbrp.ean11 AS InternationalArticleNumber,
  vbrp.pmatn AS PricingReferenceMaterial,
  vbrp.charg AS Batch,
  vbrp.prodh AS ProductHierarchyNode,
  cast (vbrp.matkl as productgroup preserving type ) AS ProductGroup,
  vbrp.mvgr1 AS AdditionalMaterialGroup1,
  vbrp.mvgr2 AS AdditionalMaterialGroup2,
  vbrp.mvgr3 AS AdditionalMaterialGroup3,
  vbrp.mvgr4 AS AdditionalMaterialGroup4,
  vbrp.mvgr5 AS AdditionalMaterialGroup5,
  vbrp.cuobj AS ProductConfiguration,
  vbrp.provg AS MaterialCommissionGroup,
  vbrp.werks AS Plant,
  vbrp.lgort AS StorageLocation,
  vbrp.atpkz AS ReplacementPartType,
  vbrp.wgru1 AS MaterialGroupHierarchy1,
  vbrp.wgru2 AS MaterialGroupHierarchy2,
  vbrp.wkreg AS PlantRegion,
  vbrp.wkcou AS PlantCounty,
  vbrp.wkcty AS PlantCity,
  vbrp.transit_plant AS TransitPlant,
  vbrp.vcm_chain_category AS ValueChainCategory,
  vbrp.sernr AS BOMExplosion,
  vbrp.prosa AS MaterialDeterminationType,
  vbrp.arktx AS BillingDocumentItemText,
  vbrp.fbuda AS ServicesRenderedDate,
  vbrp.fkimg AS BillingQuantity,
  vbrp.vrkme AS BillingQuantityUnit,
  vbrp.fklmg AS BillingQuantityInBaseUnit,
  vbrp.meins AS BaseUnit,
  vbrp.lmeng AS MRPRequiredQuantityInBaseUnit,
  vbrp.umvkn AS BillingToBaseQuantityDnmntr,
  vbrp.umvkz AS BillingToBaseQuantityNmrtr,
  vbrp.brgew AS ItemGrossWeight,
  vbrp.ntgew AS ItemNetWeight,
  vbrp.gewei AS ItemWeightUnit,
  vbrp.volum AS ItemVolume,
  vbrp.voleh AS ItemVolumeUnit,
  vbrp.lland_auft AS BillToPartyCountry,
  vbrp.regio_auft AS BillToPartyRegion,
  vbrp.fareg AS BillingPlanRule,
  vbrp.fplnr AS BillingPlan,
  vbrp.fpltr AS BillingPlanItem,
  vbrp.fksaa AS DocumentBillingStatus,
  vbrp.netwr AS NetAmount,
  vbrp.waerk AS TransactionCurrency,
  vbrp.brtwr AS GrossAmount,
  vbrp.prsdt AS PricingDate,
  cast( vbrp.kursk as kursk_not_converted preserving type ) AS PriceDetnExchangeRate,
  vbrp.smeng AS PricingScaleQuantityInBaseUnit,
  vbrp.mwsbp AS TaxAmount,
  vbrp.wavwr AS CostAmount,
  vbrp.kzwi1 AS Subtotal1Amount,
  vbrp.kzwi2 AS Subtotal2Amount,
  vbrp.kzwi3 AS Subtotal3Amount,
  vbrp.kzwi4 AS Subtotal4Amount,
  vbrp.kzwi5 AS Subtotal5Amount,
  vbrp.kzwi6 AS Subtotal6Amount,
  vbrp.kowrr AS StatisticalValueControl,
  vbrp.sktof AS CashDiscountIsDeductible,
  vbrp.kdkg1 AS CustomerConditionGroup1,
  vbrp.kdkg2 AS CustomerConditionGroup2,
  vbrp.kdkg3 AS CustomerConditionGroup3,
  vbrp.kdkg4 AS CustomerConditionGroup4,
  vbrp.kdkg5 AS CustomerConditionGroup5,
  vbrp.mprok AS ManualPriceChangeType,
  vbrp.kondm AS MaterialPricingGroup,
  cast(vbrp.stcur as stcur_ap_not_converted preserving type ) AS StatisticsExchangeRate,
  vbrp.upmat AS MainItemPricingRefMaterial,
  vbrp.ukonm AS MainItemMaterialPricingGroup,
  vbrp.cats_overtime_category AS TimeSheetOvertimeCategory,
  vbrp.prsfd AS PricingRelevance,
  vbrp.aland AS DepartureCountry,
  vbrp.txjcd AS TaxJurisdiction,
  vbrp.taxm1 AS ProductTaxClassification1,
  vbrp.taxm2 AS ProductTaxClassification2,
  vbrp.taxm3 AS ProductTaxClassification3,
  vbrp.taxm4 AS ProductTaxClassification4,
  vbrp.taxm5 AS ProductTaxClassification5,
  vbrp.taxm6 AS ProductTaxClassification6,
  vbrp.taxm7 AS ProductTaxClassification7,
  vbrp.taxm8 AS ProductTaxClassification8,
  vbrp.taxm9 AS ProductTaxClassification9,
  vbrp.j_1arfz AS ZeroVATRsn,
  vbrp.mwsk1 AS TaxCode,
  vbrp.txdat_from AS TaxRateValidityStartDate,
  vbrp.spe_herkl AS CountryOfOrigin,
  vbrp.spe_herkr AS RegionOfOrigin,
  vbrp.itm_comco AS CommodityCode,
  vbrp.skfbp AS EligibleAmountForCashDiscount,
  vbrp.gsber AS BusinessArea,
  vbrp.prctr AS ProfitCenter,
  cast( vbrp.ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  vbrp.vtkey AS ProviderContract,
  cast( vbrp.vtpos as provider_contract_item preserving type ) AS ProviderContractItem,
  vbrp.perop_beg AS BillingPerformancePeriodStrDte,
  vbrp.perop_end AS BillingPerformancePeriodEndDte,
  vbrp.kokrs AS ControllingArea,
  cast( vbrp.paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  vbrp.aufnr AS OrderID,
  vbrp.kostl AS CostCenter,
  vbrp.vbelv AS OriginSDDocument,
  vbrp.posnv AS OriginSDDocumentItem,
  vbrp.kursk_dat AS PriceDetnExchangeRateDate,
  vbrp.ktgrm AS MatlAccountAssignmentGroup,
  vbrp.vgbel AS ReferenceSDDocument,
  vbrp.vgpos AS ReferenceSDDocumentItem,
  cast( vbrp.vgtyp as reference_doc_category preserving type ) AS ReferenceSDDocumentCategory,
  vbrp.aubel AS SalesDocument,
  vbrp.aupos AS SalesDocumentItem,
  cast( vbrp.autyp as sales_document_category preserving type ) AS SalesSDDocumentCategory,
  vbrp.uepos AS HigherLevelItem,
  vbrp.uecha AS HigherLvlItmOfBatSpltItm,
  vbrp.pospa AS BillingDocumentItemInPartSgmt,
  cast( vbrp.vgbel_ex as ext_reference_document preserving type ) AS ExternalReferenceDocument,
  cast( vbrp.vgpos_ex as billingdocextreferencedocitem preserving type ) AS BillingDocExtReferenceDocItem,
  vbrp.pbd_id AS PrelimBillingDocument,
  vbrp.pbd_item_id AS PrelimBillingDocumentItem,
  vbrp.vkgrp AS SalesGroup,
  vbrp.kvgr1 AS AdditionalCustomerGroup1,
  vbrp.kvgr2 AS AdditionalCustomerGroup2,
  vbrp.kvgr3 AS AdditionalCustomerGroup3,
  vbrp.kvgr4 AS AdditionalCustomerGroup4,
  vbrp.kvgr5 AS AdditionalCustomerGroup5,
  vbrp.augru_auft AS SDDocumentReason,
  vbrp.aktnr AS RetailPromotion,
  vbrp.bonba AS RebateBasisAmount,
  vbrp.bonus AS VolumeRebateGroup,
  vbrp.cmpnt AS ItemIsRelevantForCredit,
  vbrp.cmpre AS CreditRelatedPrice,
  vbrp.knuma_ag AS SalesDeal,
  vbrp.knuma_pi AS SalesPromotion,
  vbrp.bzirk_auft AS SalesOrderSalesDistrict,
  vbrp.kdgrp_auft AS SalesOrderCustomerGroup,
  vbrp.konda_auft AS SalesOrderCustomerPriceGroup,
  vbrp.pltyp_auft AS SalesOrderPriceListType,
  vbrp.vkorg_auft AS SalesOrderSalesOrganization,
  vbrp.vtweg_auft AS SalesOrderDistributionChannel,
  vbrp.auref AS SalesDocIsCreatedFromReference,
  vbrp.vstel AS ShippingPoint,
  vbrp.service_doc_type AS ServiceDocumentType,
  vbrp.service_doc_id AS ServiceDocument,
  vbrp.service_doc_item_id AS ServiceDocumentItem,
  vbrp.solution_order_id AS BusinessSolutionOrder,
  vbrp.solution_order_item_id AS BusinessSolutionOrderItem,
  vbrp.uepvw AS HigherLevelItemUsage,
  cast (vbrp.draft as vf_draft_indicator preserving type ) AS BillingDocumentIsTemporary,
  vbrp.vbtyp_ana AS SDDocumentCategory,
  vbrp.fkart_ana AS BillingDocumentType,
  vbrp.vkorg_ana AS SalesOrganization,
  vbrp.vtweg_ana AS DistributionChannel,
  vbrp.konda_ana AS CustomerPriceGroup,
  vbrp.kdgrp_ana AS CustomerGroup,
  vbrp.land1_ana AS Country,
  vbrp.regio_ana AS Region,
  vbrp.cityc_ana AS CityCode,
  vbrp.bzirk_ana AS SalesDistrict,
  vbrp.gbstk_ana AS OverallSDProcessStatus,
  vbrp.vf_status_ana AS OverallBillingStatus,
  vbrp.kunag_ana AS SoldToParty,
  vbrp.kunrg_ana AS PayerParty,
  vbrp.fkdat_ana AS BillingDocumentDate,
  vbrp.bukrs_ana AS CompanyCode,
  vbrp.counc_ana AS County,
  vbrp.knuma_ana AS CustomerRebateAgreement,
  vbrp.fktyp_ana AS BillingDocumentCategory,
  vbrp.kunwe_ana AS ShipToParty,
  vbrp.kunre_ana AS BillToParty,
  vbrp.perve_ana AS SalesEmployee,
  vbrp.perzm_ana AS ResponsibleEmployee,
  vbrk.knumv AS PricingDocument,
  vbrk.sfakn AS CancelledBillingDocument
FROM vbrp
INNER JOIN vbrk ON /* join condition not captured in parsed metadata */
;