C_ESJIBillingDocumentItemQuery

DDL: C_ESJIBILLINGDOCUMENTITEMQUERY SQL: CESJIBILGDOCITMQ Type: view CONSUMPTION

Billing Document Item

C_ESJIBillingDocumentItemQuery is a Consumption CDS View that provides data about "Billing Document Item" in SAP S/4HANA.

47 fields

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CESJIBILGDOCITMQ view
EndUserText.label Billing Document Item view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument
KEY BillingDocumentItem BillingDocumentItem
ObjectType
CreatedByUser CreatedByUser
SalesOrganization _BillingDocument SalesOrganization
OrganizationDivision OrganizationDivision
Division Division
Material Material
BillingDocumentType _BillingDocument BillingDocumentType
BillingDocumentItemText
BillingQuantity BillingQuantity
BillingQuantityUnit BillingQuantityUnit
BaseUnit BaseUnit
ItemNetWeight ItemNetWeight
ItemWeightUnit ItemWeightUnit
ItemVolumeUnit ItemVolumeUnit
BillToPartyCountry BillToPartyCountry
BillToPartyRegion BillToPartyRegion
ItemNetAmountOfBillingDoc NetAmount
TransactionCurrency TransactionCurrency
PurchaseOrderByCustomer _BillingDocument PurchaseOrderByCustomer
AccountingTransferStatus _BillingDocument AccountingTransferStatus
ReferenceSDDocument ReferenceSDDocument
ReferenceSDDocumentItem ReferenceSDDocumentItem
ReferenceSDDocumentCategory ReferenceSDDocumentCategory
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
SalesSDDocumentCategory SalesSDDocumentCategory
SDDocumentReason SDDocumentReason
AccountingTransferStatusDesc
_BillingDocument _BillingDocument
_CreatedByUser _CreatedByUser
_OrganizationDivision _OrganizationDivision
_Division _Division
_Material _Material
_BillingQuantityUnit _BillingQuantityUnit
_BaseUnit _BaseUnit
_ItemWeightUnit _ItemWeightUnit
_ItemVolumeUnit _ItemVolumeUnit
_BillToPartyCountry _BillToPartyCountry
_BillToPartyRegion _BillToPartyRegion
_TransactionCurrency _TransactionCurrency
_ReferenceSalesDocumentItem _ReferenceSalesDocumentItem
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory
_SalesDocumentItem _SalesDocumentItem
_SalesSDDocumentCategory _SalesSDDocumentCategory
_SDDocumentReason _SDDocumentReason 
@AbapCatalog.sqlViewName: 'CESJIBILGDOCITMQ'
@EndUserText.label: 'Billing Document Item'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
define view C_ESJIBillingDocumentItemQuery
with parameters
    P_Language : sylangu
as select distinct from I_BillingDocumentItem
{ 
  //Key

  key BillingDocument,
  key BillingDocumentItem,
  'BUS2037' as ObjectType,
  //Category

//  VBTYP as SDDocumentCategory,

//  pstyv as SalesDocumentItemCategory,

//  posar as SalesDocumentItemType,

//

  //Admin

  CreatedByUser,
//  @Semantics.date.creationDate

//  vbrp.erdat as CreationDate,

//  @Semantics.date.creationDate

//  vbrp.erzet as CreationTime,

//

//  //Organization

  _BillingDocument.SalesOrganization,
  OrganizationDivision,
  Division,
//  vkbur as SalesOffice,

//

  //Product

  Material,
//  werks as Plant,

//  lgort as StorageLocation,

//

  //Billing

  _BillingDocument.BillingDocumentType,
  _Material._Text[1: Language=$parameters.P_Language].MaterialName as BillingDocumentItemText,
//  vbrp.fbuda as ServicesRenderedDate,

  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
  BillingQuantity,
  @Semantics.unitOfMeasure: true
  BillingQuantityUnit,
  @Semantics.unitOfMeasure: true
  BaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
  ItemNetWeight,
  @Semantics.unitOfMeasure: true
  ItemWeightUnit,
//  @DefaultAggregation: #SUM

//  @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'

//  volum as ItemVolume,

  @Semantics.unitOfMeasure: true
  ItemVolumeUnit,
  BillToPartyCountry,
  BillToPartyRegion,
//

  //Pricing

  @DefaultAggregation: #SUM
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  NetAmount as ItemNetAmountOfBillingDoc,
  @Semantics.currencyCode: true
  TransactionCurrency,

  //PurchaseOrderByCustomer

  _BillingDocument.PurchaseOrderByCustomer,

  //PostingStatusID

  _BillingDocument.AccountingTransferStatus,


  //Reference

  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  SalesDocument,
  SalesDocumentItem,
  SalesSDDocumentCategory,
//  vkgrp as SalesGroup,

  SDDocumentReason,
//  vstel as ShippingPoint,


 // PostingStatusText

  coalesce(_BillingDocument._AccountingTransferStatus._Text[1: Language=$parameters.P_Language].AccountingTransferStatusDesc, _BillingDocument.AccountingTransferStatus) as AccountingTransferStatusDesc,
  //association

  _BillingDocument,
  //_Partner,

  _CreatedByUser,
  _OrganizationDivision,
  _Division,
  _Material,
  _BillingQuantityUnit,
  _BaseUnit,
  _ItemWeightUnit,
  _ItemVolumeUnit,
  _BillToPartyCountry,
  _BillToPartyRegion,
  _TransactionCurrency,
//  Filtered Association for ReferenceSDDocumentItem

  _ReferenceSalesDocumentItem,
  _ReferenceSDDocumentCategory,
  _SalesDocumentItem,
  _SalesSDDocumentCategory,
  _SDDocumentReason
}

Learn More