P_RAPostponedItmWthOrderHdr

DDL: P_RAPOSTPONEDITMWTHORDERHDR Type: view_entity COMPOSITE
197 Fields 2 Data Sources 2 Associations

RA Postponed Item with Order Header

P_RAPostponedItmWthOrderHdr is a Composite CDS View that provides data about "RA Postponed Item with Order Header" in SAP S/4HANA. It reads from 2 data sources (I_RAPostponedItem, I_RAPostponedItem) and exposes 197 fields with key fields RASndgCompLogicalSystem, RevnAcctgSenderComponent, RASndgCompDocumentItemType, RASndgCompDocumentItem, RAItemType. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_RAPostponedItem I_RAPostponedItem from
I_RAPostponedItem I_RAPostponedItem union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_RAOrderHeader _PostponedOrderItem $projection.RAOriginalDocItemSenderComp = _PostponedOrderItem.RevnAcctgSenderComponent and $projection.RAOriginalDocItemLogicalSystem = _PostponedOrderItem.RASndgCompLogicalSystem and $projection.RAOriginalDocItemType = _PostponedOrderItem.RASndgCompDocumentItemType and $projection.RAOriginalDocItemID = _PostponedOrderItem.RASndgCompDocumentItem
[1..1] I_RAProcdRevnAcctItem _ProcessedOrderItem $projection.RAOriginalDocItemSenderComp = _ProcessedOrderItem.RevnAcctgSenderComponent and $projection.RAOriginalDocItemLogicalSystem = _ProcessedOrderItem.RASndgCompLogicalSystem and $projection.RAOriginalDocItemType = _ProcessedOrderItem.RASndgCompDocumentItemType and $projection.RAOriginalDocItemID = _ProcessedOrderItem.RASndgCompDocumentItem

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label RA Postponed Item with Order Header view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (197)

KeyFieldSource TableSource FieldDescription
KEY RASndgCompLogicalSystem RASndgCompLogicalSystem Source System
KEY RevnAcctgSenderComponent RevnAcctgSenderComponent Sender Component
KEY RASndgCompDocumentItemType RASndgCompDocumentItemType
KEY RASndgCompDocumentItem RASndgCompDocumentItem
KEY RAItemType RAItemType
KEY RAItemLastChangeDateTimeValue RAItemLastChangeDateTimeValue
RAItemLastChangeDateTime RAItemLastChangeDateTime
RAItemCreationDateTime RAItemCreationDateTime Timestamp
RevnAcctgItemCreatedByUser RevnAcctgItemCreatedByUser User
RevnAcctgOperationalDocument RevnAcctgOperationalDocument Stress Test: GUID
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
CompanyCodeCurrency CompanyCodeCurrency Local Currency
RAOperationalDocumentItem RAOperationalDocumentItem Simulation Item ID
Quantity Quantity Value
RAItemDifferenceToDeliveredQty RAItemDifferenceToDeliveredQty Difference to Delivered Quantity
QuantityUnit QuantityUnit Unit of measure
SalesDocumentCurrency SalesDocumentCurrency Currency
DocumentDate DocumentDate Journal Entry Date
RAItemTranslationDate RAItemTranslationDate Translatn Date
Customer Customer Sold-to Party
RAOriginalDocItemSenderComp RevnAcctgSenderComponent
RAOriginalDocItemType RASndgCompDocumentItemType OrigItemType
RAOriginalDocItemID RASndgCompDocumentItem OriginalItemID
RAOriginalDocItemLogicalSystem RASndgCompLogicalSystem
BusinessPartner BusinessPartner Issuing Authority
PerfOblgnHasAssetImpairment PerfOblgnHasAssetImpairment
RevnAcctgAssetImpairment RevnAcctgAssetImpairment Reduct.in Val.
OrderID OrderID Order ID
RABillingPlanType RABillingPlanType BillPlanTyp
RAItemIsBillingRelevant RAItemIsBillingRelevant Billing Relevant
PerfObligationChangeReason PerfObligationChangeReason Bus Chg Reason
PerfObligationInceptionDate PerfObligationInceptionDate Inception Date
PerfObligationIsToBeDeleted PerfObligationIsToBeDeleted
RAItemIsDeliveryRelevant RAItemIsDeliveryRelevant Delivery-Relevant
RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate Validity Date
PerformanceObligationStartDate PerformanceObligationStartDate Start Date
PerformanceObligationEndDate PerformanceObligationEndDate End Date
CostCenter CostCenter Cost Center
RAPredecessorDocItemSenderComp RAPredecessorDocItemSenderComp
RAPredecessorDocItemLgclSystem RAPredecessorDocItemLgclSystem
RAPredecessorDocItemType RAPredecessorDocItemType
RAPredecessorDocItemID RAPredecessorDocItemID Pred. Item ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
RevnAcctgReceivablesAccount RevnAcctgReceivablesAccount ReceivAccount
RevenueAccountingReference RevenueAccountingReference Reference No.
RevenueAccountingRefType RevenueAccountingRefType Sttl. Ref. Type
RevnAcctgSalesOrganization RevnAcctgSalesOrganization Sales Org.
RAInvoiceAmountIsRelevant RAInvoiceAmountIsRelevant Value-Relevant
AccountAssignmentIsDtmndByRA AccountAssignmentIsDtmndByRA
PerfObligationIsNegative PerfObligationIsNegative Negative Amount
ReceivableAccountIsDtmndByRA ReceivableAccountIsDtmndByRA
CAProduct CAProduct Product ID
CARevenueAccountingServiceType CARevenueAccountingServiceType Service Type
SalesDocumentType SalesDocumentType Sales Doc. Type
StorageLocation StorageLocation StorageLocation
Material Material Vehicle Model
OriginSDDocumentItem OriginSDDocumentItem Origin. Item
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
OriginSDDocument OriginSDDocument Originating Doc
SDDocumentCategory SDDocumentCategory Document Cat.
RAFulfillmentEventDate RAFulfillmentEventDate Fulfillment Date
RAFulfillmentEventTime RAFulfillmentEventTime Time Stamp
PerfOblgnEventType PerfOblgnEventType Event Type
RAInvoiceDueDate RAInvoiceDueDate Net Due Date
ExchangeRate ExchangeRate Exchange rate
AdditionalCrcy1ExchangeRate AdditionalCrcy1ExchangeRate
AdditionalCrcy2ExchangeRate AdditionalCrcy2ExchangeRate
PerfOblgnIsFinallyInvoiced PerfOblgnIsFinallyInvoiced Final Invoice
RAInvoiceCategory RAInvoiceCategory
RAInvoiceType RAInvoiceType SAF-T Document Type
PostingDate PostingDate Posting Date for GR
CompanyCode CompanyCode Receiver Company Code
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
CustomerGroup CustomerGroup Customer Group
MaterialGroup MaterialGroup Product Group
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
Division Division Internal Division ID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Plant Plant Valuation Area
RAPerfOblgnFinalizationDate RAPerfOblgnFinalizationDate Finalizat. Date
RevenueAccountingItemHasError RevenueAccountingItemHasError Item Error Type
RAItemPostponementReason RAItemPostponementReason Postponement Reason
RAItemExemptionReason RAItemExemptionReason Tax Exemp.Reason
RAPerfOblgnCategory RAPerfOblgnCategory Performance Obligation Category
RAItemQuantityIsRelevant RAItemQuantityIsRelevant Quantity Relevant
QuantityAndPriceIsDtmndByRA QuantityAndPriceIsDtmndByRA Estim. Quantity
RACostBasedProfAnlysIsIgnored RACostBasedProfAnlysIsIgnored Ignore Cost-based CO-PA
FulfilledAmountInSlsDocCrcy FulfilledAmountInSlsDocCrcy Value Amount
ApplicationLogHandle ApplicationLogHandle Log Handle
RevnAcctgOrderHeader Stress Test: GUID
RAItemStatus RAItemStatus
RAItemLastSaveDateTime RAItemLastSaveDateTime Timestamp
RAItemIsManuallyChanged RAItemIsManuallyChanged Manual Changed
ResultAnalysisInternalID ResultAnalysisInternalID Results Analysis Key
_CompanyCode _CompanyCode
_BusinessPartner _BusinessPartner
KEY RevnAcctgSenderComponent RevnAcctgSenderComponent Sender Component
KEY RASndgCompDocumentItemType RASndgCompDocumentItemType
KEY RASndgCompDocumentItem RASndgCompDocumentItem
KEY RAItemType RAItemType
KEY RAItemLastChangeDateTimeValue RAItemLastChangeDateTimeValue
RAItemLastChangeDateTime RAItemLastChangeDateTime
RAItemCreationDateTime RAItemCreationDateTime Timestamp
RevnAcctgItemCreatedByUser RevnAcctgItemCreatedByUser User
RevnAcctgOperationalDocument RevnAcctgOperationalDocument Stress Test: GUID
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
CompanyCodeCurrency CompanyCodeCurrency Local Currency
RAOperationalDocumentItem RAOperationalDocumentItem Simulation Item ID
Quantity Quantity Value
RAItemDifferenceToDeliveredQty RAItemDifferenceToDeliveredQty Difference to Delivered Quantity
QuantityUnit QuantityUnit Unit of measure
SalesDocumentCurrency SalesDocumentCurrency Currency
DocumentDate DocumentDate Journal Entry Date
RAItemTranslationDate RAItemTranslationDate Translatn Date
Customer Customer Sold-to Party
RAOriginalDocItemSenderComp RAOriginalDocItemSenderComp
RAOriginalDocItemType RAOriginalDocItemType OrigItemType
RAOriginalDocItemID RAOriginalDocItemID OriginalItemID
RAOriginalDocItemLogicalSystem RAOriginalDocItemLogicalSystem
BusinessPartner BusinessPartner Issuing Authority
PerfOblgnHasAssetImpairment PerfOblgnHasAssetImpairment
RevnAcctgAssetImpairment RevnAcctgAssetImpairment Reduct.in Val.
OrderID OrderID Order ID
RABillingPlanType RABillingPlanType BillPlanTyp
RAItemIsBillingRelevant RAItemIsBillingRelevant Billing Relevant
PerfObligationChangeReason PerfObligationChangeReason Bus Chg Reason
PerfObligationInceptionDate PerfObligationInceptionDate Inception Date
PerfObligationIsToBeDeleted PerfObligationIsToBeDeleted
RAItemIsDeliveryRelevant RAItemIsDeliveryRelevant Delivery-Relevant
RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate Validity Date
PerformanceObligationStartDate PerformanceObligationStartDate Start Date
PerformanceObligationEndDate PerformanceObligationEndDate End Date
CostCenter CostCenter Cost Center
RAPredecessorDocItemSenderComp RAPredecessorDocItemSenderComp
RAPredecessorDocItemLgclSystem RAPredecessorDocItemLgclSystem
RAPredecessorDocItemType RAPredecessorDocItemType
RAPredecessorDocItemID RAPredecessorDocItemID Pred. Item ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
RevnAcctgReceivablesAccount RevnAcctgReceivablesAccount ReceivAccount
RevenueAccountingReference RevenueAccountingReference Reference No.
RevenueAccountingRefType RevenueAccountingRefType Sttl. Ref. Type
RevnAcctgSalesOrganization RevnAcctgSalesOrganization Sales Org.
RAInvoiceAmountIsRelevant RAInvoiceAmountIsRelevant Value-Relevant
AccountAssignmentIsDtmndByRA AccountAssignmentIsDtmndByRA
PerfObligationIsNegative PerfObligationIsNegative Negative Amount
ReceivableAccountIsDtmndByRA ReceivableAccountIsDtmndByRA
CAProduct CAProduct Product ID
CARevenueAccountingServiceType CARevenueAccountingServiceType Service Type
SalesDocumentType SalesDocumentType Sales Doc. Type
StorageLocation StorageLocation StorageLocation
Material Material Vehicle Model
OriginSDDocumentItem OriginSDDocumentItem Origin. Item
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
OriginSDDocument OriginSDDocument Originating Doc
SDDocumentCategory SDDocumentCategory Document Cat.
RAFulfillmentEventDate RAFulfillmentEventDate Fulfillment Date
RAFulfillmentEventTime RAFulfillmentEventTime Time Stamp
PerfOblgnEventType PerfOblgnEventType Event Type
RAInvoiceDueDate RAInvoiceDueDate Net Due Date
ExchangeRate ExchangeRate Exchange rate
AdditionalCrcy1ExchangeRate AdditionalCrcy1ExchangeRate
AdditionalCrcy2ExchangeRate AdditionalCrcy2ExchangeRate
PerfOblgnIsFinallyInvoiced PerfOblgnIsFinallyInvoiced Final Invoice
RAInvoiceCategory RAInvoiceCategory
RAInvoiceType RAInvoiceType SAF-T Document Type
PostingDate PostingDate Posting Date for GR
CompanyCode CompanyCode Receiver Company Code
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
CustomerGroup CustomerGroup Customer Group
MaterialGroup MaterialGroup Product Group
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
Division Division Internal Division ID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Plant Plant Valuation Area
RAPerfOblgnFinalizationDate RAPerfOblgnFinalizationDate Finalizat. Date
RevenueAccountingItemHasError RevenueAccountingItemHasError Item Error Type
RAItemPostponementReason RAItemPostponementReason Postponement Reason
RAItemExemptionReason RAItemExemptionReason Tax Exemp.Reason
RAPerfOblgnCategory RAPerfOblgnCategory Performance Obligation Category
RAItemQuantityIsRelevant RAItemQuantityIsRelevant Quantity Relevant
QuantityAndPriceIsDtmndByRA QuantityAndPriceIsDtmndByRA Estim. Quantity
RACostBasedProfAnlysIsIgnored RACostBasedProfAnlysIsIgnored Ignore Cost-based CO-PA
FulfilledAmountInSlsDocCrcy FulfilledAmountInSlsDocCrcy Value Amount
ApplicationLogHandle ApplicationLogHandle Log Handle
RAItemStatus RAItemStatus
RAItemLastSaveDateTime RAItemLastSaveDateTime Timestamp
RAItemIsManuallyChanged RAItemIsManuallyChanged Manual Changed
ResultAnalysisInternalID ResultAnalysisInternalID Results Analysis Key
_CompanyCode _CompanyCode
_BusinessPartner _BusinessPartner
_Customer _Customer

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_RAPostponedItmWthOrderHdr.
-- 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_RAPostponedItmWthOrderHdr AS
SELECT
  RASndgCompLogicalSystem,
  RevnAcctgSenderComponent,
  RASndgCompDocumentItemType,
  RASndgCompDocumentItem,
  RAItemType,
  RAItemLastChangeDateTimeValue,
  RAItemLastChangeDateTime,
  RAItemCreationDateTime,
  RevnAcctgItemCreatedByUser,
  RevnAcctgOperationalDocument,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CompanyCodeCurrency,
  RAOperationalDocumentItem,
  Quantity,
  RAItemDifferenceToDeliveredQty,
  QuantityUnit,
  SalesDocumentCurrency,
  DocumentDate,
  RAItemTranslationDate,
  Customer,
  RevnAcctgSenderComponent AS RAOriginalDocItemSenderComp,
  RASndgCompDocumentItemType AS RAOriginalDocItemType,
  RASndgCompDocumentItem AS RAOriginalDocItemID,
  RASndgCompLogicalSystem AS RAOriginalDocItemLogicalSystem,
  BusinessPartner,
  PerfOblgnHasAssetImpairment,
  RevnAcctgAssetImpairment,
  OrderID,
  RABillingPlanType,
  RAItemIsBillingRelevant,
  PerfObligationChangeReason,
  PerfObligationInceptionDate,
  PerfObligationIsToBeDeleted,
  RAItemIsDeliveryRelevant,
  RevnAcctgContrChangeEffctvDate,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  CostCenter,
  RAPredecessorDocItemSenderComp,
  RAPredecessorDocItemLgclSystem,
  RAPredecessorDocItemType,
  RAPredecessorDocItemID,
  WBSElementExternalID,
  RevnAcctgReceivablesAccount,
  RevenueAccountingReference,
  RevenueAccountingRefType,
  RevnAcctgSalesOrganization,
  RAInvoiceAmountIsRelevant,
  AccountAssignmentIsDtmndByRA,
  PerfObligationIsNegative,
  ReceivableAccountIsDtmndByRA,
  CAProduct,
  CARevenueAccountingServiceType,
  SalesDocumentType,
  StorageLocation,
  Material,
  OriginSDDocumentItem,
  SalesDocumentItemCategory,
  OriginSDDocument,
  SDDocumentCategory,
  RAFulfillmentEventDate,
  RAFulfillmentEventTime,
  PerfOblgnEventType,
  RAInvoiceDueDate,
  ExchangeRate,
  AdditionalCrcy1ExchangeRate,
  AdditionalCrcy2ExchangeRate,
  PerfOblgnIsFinallyInvoiced,
  RAInvoiceCategory,
  RAInvoiceType,
  PostingDate,
  CompanyCode,
  FunctionalArea,
  BusinessArea,
  CustomerGroup,
  MaterialGroup,
  ProfitCenter,
  Segment,
  Division,
  DistributionChannel,
  Plant,
  RAPerfOblgnFinalizationDate,
  RevenueAccountingItemHasError,
  RAItemPostponementReason,
  RAItemExemptionReason,
  RAPerfOblgnCategory,
  RAItemQuantityIsRelevant,
  QuantityAndPriceIsDtmndByRA,
  RACostBasedProfAnlysIsIgnored,
  FulfilledAmountInSlsDocCrcy,
  ApplicationLogHandle,
  cast (RevnAcctgOperationalDocument as farr_cds_rai_order_header_id preserving type ) AS RevnAcctgOrderHeader,
  RAItemStatus,
  RAItemLastSaveDateTime,
  RAItemIsManuallyChanged,
  ResultAnalysisInternalID
FROM I_RAPostponedItem
LEFT OUTER JOIN I_RAOrderHeader AS _PostponedOrderItem ON RAOriginalDocItemSenderComp = _PostponedOrderItem.RevnAcctgSenderComponent AND RAOriginalDocItemLogicalSystem = _PostponedOrderItem.RASndgCompLogicalSystem AND RAOriginalDocItemType = _PostponedOrderItem.RASndgCompDocumentItemType AND RAOriginalDocItemID = _PostponedOrderItem.RASndgCompDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_RAProcdRevnAcctItem AS _ProcessedOrderItem ON RAOriginalDocItemSenderComp = _ProcessedOrderItem.RevnAcctgSenderComponent AND RAOriginalDocItemLogicalSystem = _ProcessedOrderItem.RASndgCompLogicalSystem AND RAOriginalDocItemType = _ProcessedOrderItem.RASndgCompDocumentItemType AND RAOriginalDocItemID = _ProcessedOrderItem.RASndgCompDocumentItem  -- association [1..1]
-- UNION ALL with additional select branch(es): I_RAPostponedItem
;

Learn More