P_CanclnBillingDocProcFlowN0

DDL: P_CANCLNBILLINGDOCPROCFLOWN0 SQL: PCBILLDOCPROCFN0 Type: view CONSUMPTION Package: ODATA_SD_BIL_PROCESSFLOW
10 Fields 1 Data Sources

Cancellation Billing Doc Process Flow: Level <> 0

P_CanclnBillingDocProcFlowN0 is a Consumption CDS View that provides data about "Cancellation Billing Doc Process Flow: Level <> 0" in SAP S/4HANA. It reads from 1 data source (I_BillingDocument) and exposes 10 fields with key fields PrecedingDocument, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentCategory, BillingDocument. Part of development package ODATA_SD_BIL_PROCESSFLOW.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocument CancellationDoc from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PCBILLDOCPROCFN0 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument ProcFlow PrecedingDocument SD Document
KEY PrecedingDocumentCategory ProcFlow PrecedingDocumentCategory
KEY SubsequentDocument ProcFlow SubsequentDocument
KEY SubsequentDocumentCategory ProcFlow SubsequentDocumentCategory
KEY BillingDocument I_BillingDocument BillingDocument SD Document
SDDocumentCategory I_BillingDocument SDDocumentCategory Document Cat.
BillingDocumentType I_BillingDocument BillingDocumentType Billing Type
SalesOrganization I_BillingDocument SalesOrganization Sales Organization
CompanyCode ProcFlow CompanyCode Receiver Company Code
FiscalYear ProcFlow FiscalYear G/L Fiscal Year

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 P_CanclnBillingDocProcFlowN0.
-- 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: PCBILLDOCPROCFN0

CREATE VIEW P_CanclnBillingDocProcFlowN0 AS
SELECT
  ProcFlow.PrecedingDocument AS PrecedingDocument,
  ProcFlow.PrecedingDocumentCategory AS PrecedingDocumentCategory,
  ProcFlow.SubsequentDocument AS SubsequentDocument,
  ProcFlow.SubsequentDocumentCategory AS SubsequentDocumentCategory,
  CancellationDoc.BillingDocument AS BillingDocument,
  CancellationDoc.SDDocumentCategory AS SDDocumentCategory,
  CancellationDoc.BillingDocumentType AS BillingDocumentType,
  CancellationDoc.SalesOrganization AS SalesOrganization,
  ProcFlow.CompanyCode AS CompanyCode,
  ProcFlow.FiscalYear AS FiscalYear
FROM I_BillingDocument AS CancellationDoc
;

Learn More