I_PrcgCndnMnlAllocTermsSD

DDL: I_PRCGCNDNMNLALLOCTERMSSD Type: view_entity COMPOSITE
5 Fields 4 Data Sources

CPE Terms with manual alloc for SD docs

I_PrcgCndnMnlAllocTermsSD is a Composite CDS View that provides data about "CPE Terms with manual alloc for SD docs" in SAP S/4HANA. It reads from 4 data sources (I_CommodityAllocationItem, I_CmmdtyPricingConditionTerm, I_CmmdtyPrcgDocCndnFmlaLinkage, I_SalesDocumentBasic) and exposes 5 fields with key fields SalesDocument, SalesDocumentCondition, DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm.

Data Sources (4)

SourceAliasJoin Type
I_CommodityAllocationItem _CommodityAllocationItem inner
I_CmmdtyPricingConditionTerm _CpeTerm inner
I_CmmdtyPrcgDocCndnFmlaLinkage _Linkage inner
I_SalesDocumentBasic _SalesDocument from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CPE Terms with manual alloc for SD docs view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentBasic SalesDocument SD Document
KEY SalesDocumentCondition I_SalesDocumentBasic SalesDocumentCondition Doc. Condition
KEY DocItmCmmdtyPrcgCndnUUID I_CmmdtyPrcgDocCndnFmlaLinkage DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
KEY PricingConditionTerm I_CommodityAllocationItem PricingConditionTerm Term Number
AllocationSourceDocumentNumber I_CommodityAllocationItem AllocationSourceDocumentNumber Log Doc No.

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 I_PrcgCndnMnlAllocTermsSD.
-- 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 I_PrcgCndnMnlAllocTermsSD AS
SELECT
  _SalesDocument.SalesDocument AS SalesDocument,
  _SalesDocument.SalesDocumentCondition AS SalesDocumentCondition,
  _Linkage.DocItmCmmdtyPrcgCndnUUID AS DocItmCmmdtyPrcgCndnUUID,
  _CommodityAllocationItem.PricingConditionTerm AS PricingConditionTerm,
  _CommodityAllocationItem.AllocationSourceDocumentNumber AS AllocationSourceDocumentNumber
FROM I_SalesDocumentBasic AS _SalesDocument
INNER JOIN I_CommodityAllocationItem AS _CommodityAllocationItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyPrcgDocCndnFmlaLinkage AS _Linkage ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyPricingConditionTerm AS _CpeTerm ON /* join condition not captured in parsed metadata */
;

Learn More