C_BillingDocumentOMParamDet

DDL: C_BILLINGDOCUMENTOMPARAMDET SQL: CSDBILDOCOMPRM Type: view CONSUMPTION

Billing Document Output Management: Parameter Determination

C_BillingDocumentOMParamDet is a Consumption CDS View that provides data about "Billing Document Output Management: Parameter Determination" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentBasic) and exposes 26 fields with key field BillingDocument.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentBasic BillingDocument from

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CSDBILDOCOMPRM view
EndUserText.label Billing Document Output Management: Parameter Determination view
AbapCatalog.preserveKey true view
ObjectModel.compositionRoot false view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument SD Document
SDDocumentCategory SDDocumentCategory Document Cat.
BillingDocumentType BillingDocumentType Billing Type
IsRelevantForAccrual IsRelevantForAccrual Accruals
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CustomerGroup CustomerGroup Customer Group
Country Country Venue: Ctry/Reg
CompanyCode CompanyCode Receiver Company Code
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
BillingDocumentDate BillingDocumentDate Billing Date
TaxDepartureCountry TaxDepartureCountry Tx Dep Ctry/Reg
AccountingTransferStatus AccountingTransferStatus Posting Status
_SDDocumentCategory _SDDocumentCategory
_BillingDocumentType _BillingDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_CustomerGroup _CustomerGroup
_Country _Country
_CompanyCode _CompanyCode
_TransactionCurrency _TransactionCurrency
_TaxDepartureCountry _TaxDepartureCountry
_AccountingTransferStatus _AccountingTransferStatus

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_BillingDocumentOMParamDet.
-- 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: CSDBILDOCOMPRM

CREATE VIEW C_BillingDocumentOMParamDet AS
SELECT
  BillingDocument,
  SDDocumentCategory,
  BillingDocumentType,
  IsRelevantForAccrual,
  SalesOrganization,
  DistributionChannel,
  Division,
  CustomerGroup,
  Country,
  CompanyCode,
  TotalNetAmount,
  TransactionCurrency,
  BillingDocumentDate,
  TaxDepartureCountry,
  AccountingTransferStatus
FROM I_BillingDocumentBasic AS BillingDocument
;