P_BillingDocumentItemBasic_2

DDL: P_BILLINGDOCUMENTITEMBASIC_2 Type: view_entity BASIC

P_BillingDocumentItemBasic_2 is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (vbrk, vbrp) and exposes 186 fields with key fields BillingDocument, BillingDocumentItem.

Data Sources (2)

SourceAliasJoin Type
vbrk vbrk inner
vbrp vbrp from

Annotations (3)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (186)

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

{
      //Key

  key vbrp.vbeln                                                             as BillingDocument,
  key vbrp.posnr                                                             as BillingDocumentItem,

      cast(vbrp.pstyv as sales_doc_item_category preserving type)            as SalesDocumentItemCategory,

      vbrp.posar                                                             as SalesDocumentItemType,
      vbrp.shkzg                                                             as ReturnItemProcessingType,
      //Admin

      @Semantics.user.createdBy: true
      vbrp.ernam                                                             as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      vbrp.erdat                                                             as CreationDate,
      @Semantics.systemTime.createdAt
      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,
      //Billing

      @Semantics.text: true
      vbrp.arktx                                                             as BillingDocumentItemText,
      vbrp.fbuda                                                             as ServicesRenderedDate,
      @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
      vbrp.fkimg                                                             as BillingQuantity,

      vbrp.vrkme                                                             as BillingQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      vbrp.fklmg                                                             as BillingQuantityInBaseUnit,

      vbrp.meins                                                             as BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      vbrp.lmeng                                                             as MRPRequiredQuantityInBaseUnit,
      vbrp.umvkn                                                             as BillingToBaseQuantityDnmntr,
      vbrp.umvkz                                                             as BillingToBaseQuantityNmrtr,
      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      vbrp.brgew                                                             as ItemGrossWeight,
      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      vbrp.ntgew                                                             as ItemNetWeight,

      vbrp.gewei                                                             as ItemWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
      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,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.netwr                                                             as NetAmount,

      vbrp.waerk                                                             as TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.brtwr                                                             as GrossAmount,
      vbrp.prsdt                                                             as PricingDate,
      cast( vbrp.kursk as kursk_not_converted preserving type )              as PriceDetnExchangeRate,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      vbrp.smeng                                                             as PricingScaleQuantityInBaseUnit,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.mwsbp                                                             as TaxAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.wavwr                                                             as CostAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.kzwi1                                                             as Subtotal1Amount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.kzwi2                                                             as Subtotal2Amount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.kzwi3                                                             as Subtotal3Amount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.kzwi4                                                             as Subtotal4Amount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.kzwi5                                                             as Subtotal5Amount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      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,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      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,

      //Reference

      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,

      //Sales

      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,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      vbrp.bonba                                                             as RebateBasisAmount,
      vbrp.bonus                                                             as VolumeRebateGroup,
      vbrp.cmpnt                                                             as ItemIsRelevantForCredit,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      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,

      //Other fields

      vbrp.uepvw                                                             as HigherLevelItemUsage,
      cast (vbrp.draft as vf_draft_indicator preserving type )               as BillingDocumentIsTemporary,

      //Added Analytics fields

      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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VBRK",
"VBRP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/