P_JP_TaxReallocationPlnItm_2

DDL: P_JP_TAXREALLOCATIONPLNITM_2 SQL: PJPTAXPLNITM2 Type: view COMPOSITE
40 Fields 1 Data Sources 2 Associations

P_JP_TaxReallocationPlnItm_2 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CustProjSlsOrdItmBillgPlnItm) and exposes 40 fields with key fields CustomerProject, SalesOrder, SalesOrderItem, BillingPlan, BillingPlanItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustProjSlsOrdItmBillgPlnItm _CustProSlsOrdItmBilPlnItm from

Parameters (1)

NameTypeDefault
P_DATE abap.dats(8)

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_JP_TaxConfiguration _JP_TaxConfig $projection.billingcompanycode = _JP_TaxConfig.CompanyCode
[1] I_EngagementProject _EngagementProject _CustProSlsOrdItmBilPlnItm.CustomerProject = _EngagementProject.EngagementProject

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PJPTAXPLNITM2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY CustomerProject I_CustProjSlsOrdItmBillgPlnItm CustomerProject Engmnt Project ID
KEY SalesOrder I_CustProjSlsOrdItmBillgPlnItm SalesOrder SD Document
KEY SalesOrderItem I_CustProjSlsOrdItmBillgPlnItm SalesOrderItem Sales Order Item
KEY BillingPlan I_CustProjSlsOrdItmBillgPlnItm BillingPlan Bill. Plan No.
KEY BillingPlanItem I_CustProjSlsOrdItmBillgPlnItm BillingPlanItem Item
KEY BillingDocumentendasBillingDocument
BillingCompanyCode
ItemNetAmountendasItemNetAmount
BillDocItemTaxAmtendasBillDocItemTaxAmt
TotalNetAmountendasTotalNetAmount
TotalTaxAmountendasTotalTaxAmount
AccountingDocument _BillingInfo AccountingDocument Journal Entry
CompanyCode _BillingInfo CompanyCode Receiver Company Code
FiscalYear _BillingInfo FiscalYear G/L Fiscal Year
BillingPlanUsageCategory I_CustProjSlsOrdItmBillgPlnItm BillingPlanUsageCategory
BillingPlanBillingDate I_CustProjSlsOrdItmBillgPlnItm BillingPlanBillingDate
BillingPlanRelatedBillgStatus I_CustProjSlsOrdItmBillgPlnItm BillingPlanRelatedBillgStatus
BillingPlanAmount I_CustProjSlsOrdItmBillgPlnItm BillingPlanAmount
OptBillingAmount
TransactionCurrency I_CustProjSlsOrdItmBillgPlnItm TransactionCurrency Transaction Currency
BillingPlanItemDescription I_CustProjSlsOrdItmBillgPlnItm BillingPlanItemDescription
BillingPlanServiceStartDate I_CustProjSlsOrdItmBillgPlnItm BillingPlanServiceStartDate
BillingPlanServiceEndDate I_CustProjSlsOrdItmBillgPlnItm BillingPlanServiceEndDate
SalesOrganization I_CustProjSlsOrdItmBillgPlnItm SalesOrganization Sales Organization
StartYearMonth
EndYearMonth
CurrentDate
DebitMemoRequest
DebitMemoRequestItem
BillingDocumentRequest _BillingDocRequestItem BillingDocumentRequest
_AccountingDocument _BillingInfo _AccountingDocument
_CompanyCode _BillingInfo _CompanyCode
_FiscalYear _BillingInfo _FiscalYear
_BillingPlanRelatedBillgStatus I_CustProjSlsOrdItmBillgPlnItm _BillingPlanRelatedBillgStatus
_CustomerProject I_CustProjSlsOrdItmBillgPlnItm _CustomerProject
_SalesOrder I_CustProjSlsOrdItmBillgPlnItm _SalesOrder
_TransactionCurrency I_CustProjSlsOrdItmBillgPlnItm _TransactionCurrency
ProjectBillingIsUsed _EngagementProject ProjectBillingIsUsed
ProjectStartDate _EngagementProject ProjectStartDate Latest Planned Start
_JP_TaxConfig _JP_TaxConfig

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_JP_TaxReallocationPlnItm_2.
-- 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: PJPTAXPLNITM2
-- Parameters: P_DATE : abap.dats(8)

CREATE VIEW P_JP_TaxReallocationPlnItm_2 AS
SELECT
  _CustProSlsOrdItmBilPlnItm.CustomerProject AS CustomerProject,
  _CustProSlsOrdItmBilPlnItm.SalesOrder AS SalesOrder,
  _CustProSlsOrdItmBilPlnItm.SalesOrderItem AS SalesOrderItem,
  _CustProSlsOrdItmBilPlnItm.BillingPlan AS BillingPlan,
  _CustProSlsOrdItmBilPlnItm.BillingPlanItem AS BillingPlanItem,
  case when _BillingInfo.BillingDocument is null then '' else _BillingInfo.BillingDocument end as BillingDocument AS BillingDocumentendasBillingDocument,
  _CustProSlsOrdItmBilPlnItm._SalesOrder.BillingCompanyCode AS BillingCompanyCode,
  case when _BillingInfo.BillingDocument is null then 0 else _BillingInfo.ItemNetAmount end as ItemNetAmount AS ItemNetAmountendasItemNetAmount,
  case when _BillingInfo.BillingDocument is null then 0 else _BillingInfo.BillDocItemTaxAmt end as BillDocItemTaxAmt AS BillDocItemTaxAmtendasBillDocItemTaxAmt,
  case when _BillingInfo.BillingDocument is null then 0 else _BillingInfo.TotalNetAmount end as TotalNetAmount AS TotalNetAmountendasTotalNetAmount,
  case when _BillingInfo.BillingDocument is null then 0 else _BillingInfo.TotalTaxAmount end as TotalTaxAmount AS TotalTaxAmountendasTotalTaxAmount,
  _BillingInfo.AccountingDocument AS AccountingDocument,
  _BillingInfo.CompanyCode AS CompanyCode,
  _BillingInfo.FiscalYear AS FiscalYear,
  _CustProSlsOrdItmBilPlnItm.BillingPlanUsageCategory AS BillingPlanUsageCategory,
  _CustProSlsOrdItmBilPlnItm.BillingPlanBillingDate AS BillingPlanBillingDate,
  _CustProSlsOrdItmBilPlnItm.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  _CustProSlsOrdItmBilPlnItm.BillingPlanAmount AS BillingPlanAmount,
  coalesce(_BillingInfo.ItemNetAmount, _CustProSlsOrdItmBilPlnItm.BillingPlanAmount) AS OptBillingAmount,
  _CustProSlsOrdItmBilPlnItm.TransactionCurrency AS TransactionCurrency,
  _CustProSlsOrdItmBilPlnItm.BillingPlanItemDescription AS BillingPlanItemDescription,
  _CustProSlsOrdItmBilPlnItm.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  _CustProSlsOrdItmBilPlnItm.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  _CustProSlsOrdItmBilPlnItm.SalesOrganization AS SalesOrganization,
  substring(_CustProSlsOrdItmBilPlnItm.BillingPlanServiceStartDate,1,6) AS StartYearMonth,
  substring(_CustProSlsOrdItmBilPlnItm.BillingPlanServiceEndDate,1,6) AS EndYearMonth,
  :P_DATE AS CurrentDate,
  cast('' as debit_memo_request ) AS DebitMemoRequest,
  cast('' as debit_memo_request_item ) AS DebitMemoRequestItem,
  _BillingDocRequestItem.BillingDocumentRequest AS BillingDocumentRequest,
  _BillingInfo._AccountingDocument AS _AccountingDocument,
  _BillingInfo._CompanyCode AS _CompanyCode,
  _BillingInfo._FiscalYear AS _FiscalYear,
  _CustProSlsOrdItmBilPlnItm._BillingPlanRelatedBillgStatus AS _BillingPlanRelatedBillgStatus,
  _CustProSlsOrdItmBilPlnItm._CustomerProject AS _CustomerProject,
  _CustProSlsOrdItmBilPlnItm._SalesOrder AS _SalesOrder,
  _CustProSlsOrdItmBilPlnItm._TransactionCurrency AS _TransactionCurrency,
  _EngagementProject.ProjectBillingIsUsed AS ProjectBillingIsUsed,
  _EngagementProject.ProjectStartDate AS ProjectStartDate
FROM I_CustProjSlsOrdItmBillgPlnItm AS _CustProSlsOrdItmBilPlnItm
LEFT OUTER JOIN I_JP_TaxConfiguration AS _JP_TaxConfig ON billingcompanycode = _JP_TaxConfig.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON _CustProSlsOrdItmBilPlnItm.CustomerProject = _EngagementProject.EngagementProject  -- association [1]
;

Learn More