P_ServiceOrderFulfillment
P_ServiceOrderFulfillment is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 57 fields with key fields ServiceObjectType, ServiceDocument.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ServiceDocument | ServiceDoc | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PSRVORDFU | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view |
Fields (57)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ServiceObjectType | I_ServiceDocument | ServiceObjectType | Object Type |
| KEY | ServiceDocument | I_ServiceDocument | ServiceDocument | Transaction ID |
| ServiceDocumentDescription | I_ServiceDocument | ServiceDocumentDescription | Description | |
| ServiceDocumentUUID | I_ServiceDocument | ServiceDocumentUUID | Object GUID | |
| ServiceDocumentType | I_ServiceDocument | ServiceDocumentType | Transaction Type | |
| NrItemSitnendasSitnNumberOfInstances | ||||
| SoldToParty | I_ServiceDocument | SoldToParty | Sold-to Party | |
| SoldToPartyCountry | I_ServiceDocument | SoldToPartyCountry | Country/Region | |
| SoldToPartyRegion | I_ServiceDocument | SoldToPartyRegion | Region | |
| SalesOrganization | I_ServiceDocument | SalesOrganization | Sales Organization | |
| SalesGroup | I_ServiceDocument | SalesGroup | Sales Group | |
| SalesOffice | I_ServiceDocument | SalesOffice | Sales Office | |
| DistributionChannel | I_ServiceDocument | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | I_ServiceDocument | Division | Internal Division ID | |
| ResponsibleEmployee | I_ServiceDocument | ResponsibleEmployee | Employee Resp. | |
| ServiceDocNetAmount | I_ServiceDocument | ServiceDocNetAmount | Net Value | |
| TotalNetAmount | ||||
| ServiceDocumentStatus | I_ServiceDocument | ServiceDocumentStatus | Unique Custom Status | |
| ServiceDocumentHasError | I_ServiceDocument | ServiceDocumentHasError | Error Status | |
| ServiceDocumentIsReleased | I_ServiceDocument | ServiceDocumentIsReleased | Release Status | |
| ServiceDocBillingStatus | I_ServiceDocument | ServiceDocBillingStatus | Billing Status | |
| ServiceDocIsReleasedForBilling | I_ServiceDocument | ServiceDocIsReleasedForBilling | Rlsd f Bllg | |
| ServiceDocumentIsRejected | I_ServiceDocument | ServiceDocumentIsRejected | Cancellation Status | |
| ServiceDocumentIsOpen | I_ServiceDocument | ServiceDocumentIsOpen | Open | |
| ServiceDocumentIsQuotation | I_ServiceDocument | ServiceDocumentIsQuotation | Quotation Status | |
| TransactionCurrency | I_ServiceDocument | TransactionCurrency | Transaction Currency | |
| SalesGroupOrgUnitID | I_ServiceDocument | SalesGroupOrgUnitID | Sales Group | |
| SalesOfficeOrgUnitID | I_ServiceDocument | SalesOfficeOrgUnitID | Sales Office | |
| SalesOrganizationOrgUnitID | I_ServiceDocument | SalesOrganizationOrgUnitID | Sales Organization | |
| ServiceOrganization | I_ServiceDocument | ServiceOrganization | Service Organization | |
| BillingDocumentType | billingDoc | BillingDocumentType | Billing Type | |
| _SoldToParty | I_ServiceDocument | _SoldToParty | ||
| _SoldToPartyCountry | I_ServiceDocument | _SoldToPartyCountry | ||
| _SoldToPartyRegion | I_ServiceDocument | _SoldToPartyRegion | ||
| _SalesOrganization | I_ServiceDocument | _SalesOrganization | ||
| _SalesGroup | I_ServiceDocument | _SalesGroup | ||
| _SalesOffice | I_ServiceDocument | _SalesOffice | ||
| _DistributionChannel | I_ServiceDocument | _DistributionChannel | ||
| _Division | I_ServiceDocument | _Division | ||
| _RespEmployee | I_ServiceDocument | _RespEmployee | ||
| _ServiceDocumentStatus | I_ServiceDocument | _ServiceDocumentStatus | ||
| _SrvcDocLifecycleStatus | I_ServiceDocument | _SrvcDocLifecycleStatus | ||
| _ServiceDocHasError | I_ServiceDocument | _ServiceDocHasError | ||
| _ServiceDocBillingStatus | I_ServiceDocument | _ServiceDocBillingStatus | ||
| _ServiceDocumentType | I_ServiceDocument | _ServiceDocumentType | ||
| _ServiceObjType | I_ServiceDocument | _ServiceObjType | ||
| _ServiceDocumentIsOpen | I_ServiceDocument | _ServiceDocumentIsOpen | ||
| _SrvcDocIsRelForBillgSts | I_ServiceDocument | _SrvcDocIsRelForBillgSts | ||
| _SalesGroupOrgUnit | I_ServiceDocument | _SalesGroupOrgUnit | ||
| _SalesOfficeOrgUnit | I_ServiceDocument | _SalesOfficeOrgUnit | ||
| _SalesOrganizationOrgUnit | I_ServiceDocument | _SalesOrganizationOrgUnit | ||
| _ServiceOrganizationOrgUnit | I_ServiceDocument | _ServiceOrganizationOrgUnit | ||
| _SalesGroupOrgUnit_2 | I_ServiceDocument | _SalesGroupOrgUnit_2 | ||
| _SalesOfficeOrgUnit_2 | I_ServiceDocument | _SalesOfficeOrgUnit_2 | ||
| _SalesOrganizationOrgUnit_2 | I_ServiceDocument | _SalesOrganizationOrgUnit_2 | ||
| _ServiceOrganizationOrgUnit_2 | I_ServiceDocument | _ServiceOrganizationOrgUnit_2 | ||
| _BillingDocumentType | billingDoc | _BillingDocumentType |
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_ServiceOrderFulfillment.
-- 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 P_ServiceOrderFulfillment AS
SELECT
ServiceDoc.ServiceObjectType AS ServiceObjectType,
ServiceDoc.ServiceDocument AS ServiceDocument,
ServiceDoc.ServiceDocumentDescription AS ServiceDocumentDescription,
ServiceDoc.ServiceDocumentUUID AS ServiceDocumentUUID,
ServiceDoc.ServiceDocumentType AS ServiceDocumentType,
case when srvcSit.NrHeaderSitn is not null then srvcSit.NrItemSitn + srvcSit.NrHeaderSitn else srvcSit.NrItemSitn end as SitnNumberOfInstances AS NrItemSitnendasSitnNumberOfInstances,
ServiceDoc.SoldToParty AS SoldToParty,
ServiceDoc.SoldToPartyCountry AS SoldToPartyCountry,
ServiceDoc.SoldToPartyRegion AS SoldToPartyRegion,
ServiceDoc.SalesOrganization AS SalesOrganization,
ServiceDoc.SalesGroup AS SalesGroup,
ServiceDoc.SalesOffice AS SalesOffice,
ServiceDoc.DistributionChannel AS DistributionChannel,
ServiceDoc.Division AS Division,
ServiceDoc.ResponsibleEmployee AS ResponsibleEmployee,
ServiceDoc.ServiceDocNetAmount AS ServiceDocNetAmount,
sum(billingDoc.TotalNetAmount) AS TotalNetAmount,
ServiceDoc.ServiceDocumentStatus AS ServiceDocumentStatus,
ServiceDoc.ServiceDocumentHasError AS ServiceDocumentHasError,
ServiceDoc.ServiceDocumentIsReleased AS ServiceDocumentIsReleased,
ServiceDoc.ServiceDocBillingStatus AS ServiceDocBillingStatus,
ServiceDoc.ServiceDocIsReleasedForBilling AS ServiceDocIsReleasedForBilling,
ServiceDoc.ServiceDocumentIsRejected AS ServiceDocumentIsRejected,
ServiceDoc.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
ServiceDoc.ServiceDocumentIsQuotation AS ServiceDocumentIsQuotation,
ServiceDoc.TransactionCurrency AS TransactionCurrency,
ServiceDoc.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
ServiceDoc.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
ServiceDoc.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
ServiceDoc.ServiceOrganization AS ServiceOrganization,
billingDoc.BillingDocumentType AS BillingDocumentType,
ServiceDoc._SoldToParty AS _SoldToParty,
ServiceDoc._SoldToPartyCountry AS _SoldToPartyCountry,
ServiceDoc._SoldToPartyRegion AS _SoldToPartyRegion,
ServiceDoc._SalesOrganization AS _SalesOrganization,
ServiceDoc._SalesGroup AS _SalesGroup,
ServiceDoc._SalesOffice AS _SalesOffice,
ServiceDoc._DistributionChannel AS _DistributionChannel,
ServiceDoc._Division AS _Division,
ServiceDoc._RespEmployee AS _RespEmployee,
ServiceDoc._ServiceDocumentStatus AS _ServiceDocumentStatus,
ServiceDoc._SrvcDocLifecycleStatus AS _SrvcDocLifecycleStatus,
ServiceDoc._ServiceDocHasError AS _ServiceDocHasError,
ServiceDoc._ServiceDocBillingStatus AS _ServiceDocBillingStatus,
ServiceDoc._ServiceDocumentType AS _ServiceDocumentType,
ServiceDoc._ServiceObjType AS _ServiceObjType,
ServiceDoc._ServiceDocumentIsOpen AS _ServiceDocumentIsOpen,
ServiceDoc._SrvcDocIsRelForBillgSts AS _SrvcDocIsRelForBillgSts,
ServiceDoc._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
ServiceDoc._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
ServiceDoc._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
ServiceDoc._ServiceOrganizationOrgUnit AS _ServiceOrganizationOrgUnit,
ServiceDoc._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
ServiceDoc._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
ServiceDoc._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
ServiceDoc._ServiceOrganizationOrgUnit_2 AS _ServiceOrganizationOrgUnit_2,
billingDoc._BillingDocumentType AS _BillingDocumentType
FROM I_ServiceDocument AS ServiceDoc
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA