C_ESJIBillingDocumentItemQuery

DDL: C_ESJIBILLINGDOCUMENTITEMQUERY SQL: CESJIBILGDOCITMQ Type: view CONSUMPTION Package: ESJI_SD_JAM_INTEG_CDS_CONT
47 Fields

Billing Document Item

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

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 SD Document
KEY BillingDocumentItem BillingDocumentItem Item
ObjectType
CreatedByUser CreatedByUser User Name
SalesOrganization _BillingDocument SalesOrganization Sales Organization
OrganizationDivision OrganizationDivision Org. Division
Division Division Internal Division ID
Material Material Vehicle Model
BillingDocumentType _BillingDocument BillingDocumentType Billing Type
BillingDocumentItemText
BillingQuantity BillingQuantity Invoiced Qty
BillingQuantityUnit BillingQuantityUnit Sales Unit
BaseUnit BaseUnit Unit of Measure
ItemNetWeight ItemNetWeight Net Weight
ItemWeightUnit ItemWeightUnit Unit of Weight
ItemVolumeUnit ItemVolumeUnit Volume Unit
BillToPartyCountry BillToPartyCountry Dst.CtryRg.Ord.
BillToPartyRegion BillToPartyRegion Region Order
ItemNetAmountOfBillingDoc NetAmount Stated Amount
TransactionCurrency TransactionCurrency Transaction Currency
PurchaseOrderByCustomer _BillingDocument PurchaseOrderByCustomer Purchase Order Number
AccountingTransferStatus _BillingDocument AccountingTransferStatus
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem ReferenceSDDocumentItem Reference Item
ReferenceSDDocumentCategory ReferenceSDDocumentCategory Prec.Doc.Categ.
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
SalesSDDocumentCategory SalesSDDocumentCategory Document Cat.
SDDocumentReason SDDocumentReason Order Reason
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

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 C_ESJIBillingDocumentItemQuery.
-- 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: CESJIBILGDOCITMQ
-- Parameters: P_Language : sylangu

CREATE VIEW C_ESJIBillingDocumentItemQuery AS
SELECT
  BillingDocument,
  BillingDocumentItem,
  'BUS2037' AS ObjectType,
  CreatedByUser,
  _BillingDocument.SalesOrganization AS SalesOrganization,
  OrganizationDivision,
  Division,
  Material,
  _BillingDocument.BillingDocumentType AS BillingDocumentType,
  _Material._Text[1: Language=$parameters.P_Language].MaterialName AS BillingDocumentItemText,
  BillingQuantity,
  BillingQuantityUnit,
  BaseUnit,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolumeUnit,
  BillToPartyCountry,
  BillToPartyRegion,
  NetAmount AS ItemNetAmountOfBillingDoc,
  TransactionCurrency,
  _BillingDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _BillingDocument.AccountingTransferStatus AS AccountingTransferStatus,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  SalesDocument,
  SalesDocumentItem,
  SalesSDDocumentCategory,
  SDDocumentReason,
  coalesce(_BillingDocument._AccountingTransferStatus._Text[1: Language=$parameters.P_Language].AccountingTransferStatusDesc, _BillingDocument.AccountingTransferStatus) AS AccountingTransferStatusDesc
;

Learn More