C_ARProcessFlowBillingDoc

DDL: C_ARPROCESSFLOWBILLINGDOC Type: view_entity CONSUMPTION
32 Fields 1 Data Sources

Billing Documen for AR process flow

C_ARProcessFlowBillingDoc is a Consumption CDS View that provides data about "Billing Documen for AR process flow" in SAP S/4HANA. It reads from 1 data source (P_ARProcessFlowBillingDoc) and exposes 32 fields with key field BillingDocument.

Data Sources (1)

SourceAliasJoin Type
P_ARProcessFlowBillingDoc P_ARProcessFlowBillingDoc from

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Billing Documen for AR process flow view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
DataAging.noAgingRestriction true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument SD Document
BillingDocumentType BillingDocumentType Billing Type
BillingDocumentTypeName BillingDocumentTypeName
SoldToParty SoldToParty Sold-to Party
CustomerName CustomerName Name of Customer
ShipToParty ShipToParty Ship-To Party (obsolete)
ShipToPartyName ShipToPartyName Ship-To Party Name
PayerParty PayerParty Payer
PayerPartyName PayerPartyName
BillToParty BillToParty Inv. Recipient
BillToPartyName BillToPartyName Name of Customer
SalesOrganization SalesOrganization Sales Organization
SalesArea SalesArea
SalesAreaDesc SalesAreaDesc
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TotalGrossAmount TotalGrossAmount Total Gross Amount
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
BillingDocumentDate BillingDocumentDate Billing Date
OverallSDProcessStatus OverallSDProcessStatus
OverallSDProcessStatusDesc OverallSDProcessStatusDesc
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
CustomerPaymentTermsName CustomerPaymentTermsName
CreatedByUser CreatedByUser User Name
FullName FullName Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
_SoldToParty _SoldToParty
_PayerParty _PayerParty
_ShipToParty _ShipToParty
_BillToParty _BillToParty
NumberOfBillingDocumentItems

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_ARProcessFlowBillingDoc.
-- 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_ARProcessFlowBillingDoc AS
SELECT
  BillingDocument,
  BillingDocumentType,
  BillingDocumentTypeName,
  SoldToParty,
  CustomerName,
  ShipToParty,
  ShipToPartyName,
  PayerParty,
  PayerPartyName,
  BillToParty,
  BillToPartyName,
  SalesOrganization,
  SalesArea,
  SalesAreaDesc,
  TaxAmount,
  TotalGrossAmount,
  TotalNetAmount,
  TransactionCurrency,
  BillingDocumentDate,
  OverallSDProcessStatus,
  OverallSDProcessStatusDesc,
  CustomerPaymentTerms,
  CustomerPaymentTermsName,
  CreatedByUser,
  FullName,
  CreationDate,
  CreationTime,
  count( distinct _Item.BillingDocumentItem ) AS NumberOfBillingDocumentItems
FROM P_ARProcessFlowBillingDoc
;

Learn More