C_ARProcessFlowBillgDocRequest

DDL: C_ARPROCESSFLOWBILLGDOCREQUEST Type: view_entity CONSUMPTION
37 Fields 1 Data Sources

Billing Document Request Attributes

C_ARProcessFlowBillgDocRequest is a Consumption CDS View that provides data about "Billing Document Request Attributes" in SAP S/4HANA. It reads from 1 data source (P_ARProcessFlowBillgDocRequest) and exposes 37 fields with key field BillingDocumentRequest.

Data Sources (1)

SourceAliasJoin Type
P_ARProcessFlowBillgDocRequest P_ARProcessFlowBillgDocRequest from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label Billing Document Request Attributes view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentRequest BillingDocumentRequest
OverallBillingDocReqStatus OverallBillingDocReqStatus
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
BillingDocumentDate BillingDocumentDate Billing Date
SoldToParty SoldToParty Sold-to Party
PayerParty PayerParty Payer
DocumentReferenceID DocumentReferenceID Reference
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationName SalesOrganizationName Sales Organization Description
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelName DistributionChannelName
Division Division Internal Division ID
DivisionName DivisionName Division Description
SalesAreaSemanticKey SalesArea
SalesAreaDesc SalesAreaDesc
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
CompanyCode CompanyCode Receiver Company Code
NumberOfBillingDocumentItems
OverallBillingStatusDesc OverallBillingStatusDesc
CustomerName CustomerName Name of Customer
PayerPartyName PayerPartyName
FullName FullName Name
PaymentTermsName PaymentTermsName Description
_BDR _BDR
_CompanyCode _CompanyCode
_CustomerPaymentTerms _CustomerPaymentTerms
_Item _Item
_OvrlBillingDocReqStatus _OvrlBillingDocReqStatus
_PayerParty _PayerParty
_SoldToParty _SoldToParty
_TransactionCurrency _TransactionCurrency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division

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_ARProcessFlowBillgDocRequest.
-- 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 C_ARProcessFlowBillgDocRequest AS
SELECT
  BillingDocumentRequest,
  OverallBillingDocReqStatus,
  TotalNetAmount,
  TransactionCurrency,
  BillingDocumentDate,
  SoldToParty,
  PayerParty,
  DocumentReferenceID,
  SalesOrganization,
  SalesOrganizationName,
  DistributionChannel,
  DistributionChannelName,
  Division,
  DivisionName,
  SalesArea AS SalesAreaSemanticKey,
  SalesAreaDesc,
  CreatedByUser,
  CreationDateTime,
  CustomerPaymentTerms,
  CompanyCode,
  count( distinct _Item.BillingDocumentRequestItem ) AS NumberOfBillingDocumentItems,
  OverallBillingStatusDesc,
  CustomerName,
  PayerPartyName,
  FullName,
  PaymentTermsName
FROM P_ARProcessFlowBillgDocRequest
;

Learn More