P_SrvcContrLinItmFinConvData

DDL: P_SRVCCONTRLINITMFINCONVDATA Type: view COMPOSITE
107 Fields 1 Data Sources 3 Associations

P_SrvcContrLinItmFinConvData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_SrvcContrItmWithCloudCheck) and exposes 107 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SrvcContrItmWithCloudCheck _ServiceContractItem from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (3)

CardinalityTargetAliasCondition
[1] P_ServiceDocLinItmFinData _GLAcctData _GLAcctData.ServiceContract = _ServiceContractItem.ServiceDocument and _GLAcctData.ServiceContractItem = _ServiceContractItem.ServiceDocumentItem and _GLAcctData.SalesOrganization = _ServiceContractItem.SalesOrganization and _GLAcctData.ServiceContract is not initial and _GLAcctData.ServiceContractType = _ServiceContractItem.ServiceDocumentType
[0..1] I_BusinessPartner _RespEmployeeID $projection.RespEmployeeBusinessPartnerId = _RespEmployeeID.BusinessPartner
[0..1] I_BusSolnOrdBasicFinancial _SolutionOrderVH $projection.RefBusinessSolutionOrder = _SolutionOrderVH.BusinessSolutionOrder

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSRVCONTCONVITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (107)

KeyFieldSource TableSource FieldDescription
KEY Ledger _GLAcctData Ledger Ledger
KEY SourceLedger _GLAcctData SourceLedger Source Ledger
KEY CompanyCode _GLAcctData CompanyCode Receiver Company Code
KEY FiscalYear _GLAcctData FiscalYear G/L Fiscal Year
KEY AccountingDocument _GLAcctData AccountingDocument Journal Entry
KEY LedgerGLLineItem _GLAcctData LedgerGLLineItem Journal Entry Item
KEY GLAccountHierarchy _GLAcctData GLAccountHierarchy
KEY SemanticTag _GLAcctData SemanticTag Semantic Tag
KEY ValidityStartDate _GLAcctData ValidityStartDate Validity Start Date
KEY ValidityEndDate _GLAcctData ValidityEndDate ValidTo
KEY ServiceContract P_SrvcContrItmWithCloudCheck ServiceDocument Transaction ID
KEY ServiceContractItem P_SrvcContrItmWithCloudCheck ServiceDocumentItem Service Document
KEY ServiceDocument _GLAcctData ServiceDocument Transaction ID
KEY ServiceDocumentItem _GLAcctData ServiceDocumentItem Service Document
ServiceDocumentType _GLAcctData ServiceDocumentType Transaction Type
ServiceContractType P_SrvcContrItmWithCloudCheck ServiceDocumentType Transaction Type
ServiceObjectType
RefBusinessSolutionOrder P_SrvcContrItmWithCloudCheck RefBusinessSolutionOrder
RefBusinessSolutionOrderItem P_SrvcContrItmWithCloudCheck RefBusinessSolutionOrderItem
SoldToPartyCountry P_SrvcContrItmWithCloudCheck SoldToPartyCountry
SoldToPartyRegion P_SrvcContrItmWithCloudCheck SoldToPartyRegion
SoldToParty P_SrvcContrItmWithCloudCheck SoldToParty Sold-to Party
SoldToPartyFullName
ShipToParty P_SrvcContrItmWithCloudCheck ShipToParty Ship-To Party (obsolete)
ResponsibleEmployee P_SrvcContrItmWithCloudCheck ResponsibleEmployee Employee Resp.
RespEmployeeBusinessPartnerId P_SrvcContrItmWithCloudCheck ResponsibleEmployee Employee Resp.
ContactPerson P_SrvcContrItmWithCloudCheck ContactPerson Contact Person Key
DisplayCurrency
TransactionCurrency P_SrvcContrItmWithCloudCheck TransactionCurrency Transaction Currency
_TransactionCurrency P_SrvcContrItmWithCloudCheck _TransactionCurrency
CompanyCodeCurrency _GLAcctData CompanyCodeCurrency Local Currency
RecognizedMarginAmtInCCCrcy _GLAcctData RecognizedMarginAmtInCCCrcy
RevenueAmountInCompanyCodeCrcy _GLAcctData RevenueAmountInCompanyCodeCrcy
CostAmountInCompanyCodeCrcy _GLAcctData CostAmountInCompanyCodeCrcy
TotalSrvcContrValueInDC
ServiceDocumentItemNetAmount P_SrvcContrItmWithCloudCheck ServiceDocumentItemNetAmount
RevenueAmountInDisplayCrcy _GLAcctData RevenueAmountInCompanyCodeCrcy
CostAmountInDisplayCurrency _GLAcctData CostAmountInCompanyCodeCrcy
SrvcContrProfitabilityInDC _GLAcctData RecognizedMarginAmtInCCCrcy
YTDSrvcContrRevnAmtInDC _GLAcctData YTDSrvcContrRevnAmtInDC
YTDSrvcContrCostInDC _GLAcctData YTDSrvcContrCostInDC
YTDSrvcContrPrftMarginAmtInDC _GLAcctData YTDSrvcContrPrftMarginAmtInDC
CreationDate _GLAcctData CreationDate Time Stamp
PostingDate _GLAcctData PostingDate Posting Date for GR
DocumentDate _GLAcctData DocumentDate Journal Entry Date
FiscalYearVariant _GLAcctData FiscalYearVariant FY Variant
FiscalPeriod _GLAcctData FiscalPeriod Tax period
FiscalQuarter _GLAcctData FiscalQuarter
CalendarQuarter _CalendarPeriod CalendarQuarter Calendar Quarter
CalendarYear _CalendarPeriod CalendarYear Year
CalendarMonth _CalendarPeriod CalendarMonth Calendar Month
CalendarWeek _CalendarPeriod CalendarWeek Calendar Week
ServiceContractDescription P_SrvcContrItmWithCloudCheck ServiceDocumentDescription
SalesOrganization P_SrvcContrItmWithCloudCheck SalesOrganization Sales Organization
DistributionChannel P_SrvcContrItmWithCloudCheck DistributionChannel RefDistCh-Cust/Mat.
Division P_SrvcContrItmWithCloudCheck Division Internal Division ID
SalesOffice P_SrvcContrItmWithCloudCheck SalesOffice Sales Office
SalesGroup P_SrvcContrItmWithCloudCheck SalesGroup Sales Group
SalesOrganizationOrgUnitID P_SrvcContrItmWithCloudCheck SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID P_SrvcContrItmWithCloudCheck SalesOfficeOrgUnitID
SalesGroupOrgUnitID P_SrvcContrItmWithCloudCheck SalesGroupOrgUnitID
ServiceOrganization P_SrvcContrItmWithCloudCheck ServiceOrganization
ServiceContractStartDate ServiceContractStartDate
ServiceContractEndDate ServiceContractEndDate
NumberOfDays
ServiceContractItemStatus P_SrvcContrItmWithCloudCheck ServiceDocumentItemStatus
ServiceDocumentIsOpen
ServiceDocumentItemCanclnParty P_SrvcContrItmWithCloudCheck ServiceDocumentItemCanclnParty
ServiceDocumentItmCanclnReason P_SrvcContrItmWithCloudCheck ServiceDocumentItmCanclnReason
_Ledger _GLAcctData _Ledger
_SourceLedger _GLAcctData _SourceLedger
_CompanyCode _GLAcctData _CompanyCode
_FiscalYear _GLAcctData _FiscalYear
_JournalEntry _GLAcctData _JournalEntry
_Hierarchy _GLAcctData _Hierarchy
_SemanticTag _GLAcctData _SemanticTag
_CompanyCodeCurrency _GLAcctData _CompanyCodeCurrency
_FiscalYearVariant _GLAcctData _FiscalYearVariant
_CalendarMonth _CalendarPeriod _CalendarMonth
_CalendarYear _CalendarPeriod _CalendarYear
_CalendarQuarter _CalendarPeriod _CalendarQuarter
_SoldToPartyRegion _SoldToPartyRegion
_ServiceDocument _GLAcctData _ServiceDocument
_ServiceDocumentType _GLAcctData _ServiceDocumentType
_ServiceDocumentItem _GLAcctData _ServiceDocumentItem
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_RespEmployee _RespEmployee
_ContactPerson P_SrvcContrItmWithCloudCheck _ContactPerson
_ServiceObjectType
_ServiceContractItemType P_SrvcContrItmWithCloudCheck _ServiceDocumentType
_SalesOrganization P_SrvcContrItmWithCloudCheck _SalesOrganization
_DistributionChannel P_SrvcContrItmWithCloudCheck _DistributionChannel
_Division P_SrvcContrItmWithCloudCheck _Division
_SalesOffice P_SrvcContrItmWithCloudCheck _SalesOffice
_SalesGroup P_SrvcContrItmWithCloudCheck _SalesGroup
_SalesOrganizationOrgUnit P_SrvcContrItmWithCloudCheck _SalesOrganizationOrgUnit
_SalesOfficeOrgUnit P_SrvcContrItmWithCloudCheck _SalesOfficeOrgUnit
_SalesGroupOrgUnit P_SrvcContrItmWithCloudCheck _SalesGroupOrgUnit
_SalesOrganizationOrgUnit_2 P_SrvcContrItmWithCloudCheck _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 P_SrvcContrItmWithCloudCheck _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 P_SrvcContrItmWithCloudCheck _SalesGroupOrgUnit_2
_SoldToPartyCountry P_SrvcContrItmWithCloudCheck _SoldToPartyCountry
_SoldToParty P_SrvcContrItmWithCloudCheck _SoldToParty
_ShipToParty P_SrvcContrItmWithCloudCheck _ShipToParty
_RespEmployeeID _RespEmployeeID
_SolutionOrderVH _SolutionOrderVH

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_SrvcContrLinItmFinConvData.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW P_SrvcContrLinItmFinConvData AS
SELECT
  _GLAcctData.Ledger AS Ledger,
  _GLAcctData.SourceLedger AS SourceLedger,
  _GLAcctData.CompanyCode AS CompanyCode,
  _GLAcctData.FiscalYear AS FiscalYear,
  _GLAcctData.AccountingDocument AS AccountingDocument,
  _GLAcctData.LedgerGLLineItem AS LedgerGLLineItem,
  _GLAcctData.GLAccountHierarchy AS GLAccountHierarchy,
  _GLAcctData.SemanticTag AS SemanticTag,
  _GLAcctData.ValidityStartDate AS ValidityStartDate,
  _GLAcctData.ValidityEndDate AS ValidityEndDate,
  _ServiceContractItem.ServiceDocument AS ServiceContract,
  _ServiceContractItem.ServiceDocumentItem AS ServiceContractItem,
  _GLAcctData.ServiceDocument AS ServiceDocument,
  _GLAcctData.ServiceDocumentItem AS ServiceDocumentItem,
  _GLAcctData.ServiceDocumentType AS ServiceDocumentType,
  _ServiceContractItem.ServiceDocumentType AS ServiceContractType,
  _ServiceContractItem._ServiceDocument.ServiceObjectType AS ServiceObjectType,
  _ServiceContractItem.RefBusinessSolutionOrder AS RefBusinessSolutionOrder,
  _ServiceContractItem.RefBusinessSolutionOrderItem AS RefBusinessSolutionOrderItem,
  _ServiceContractItem.SoldToPartyCountry AS SoldToPartyCountry,
  _ServiceContractItem.SoldToPartyRegion AS SoldToPartyRegion,
  _ServiceContractItem.SoldToParty AS SoldToParty,
  cast( _ServiceContractItem._SoldToParty.BusinessPartnerFullName as crms4_sold_to_party_name) AS SoldToPartyFullName,
  _ServiceContractItem.ShipToParty AS ShipToParty,
  _ServiceContractItem.ResponsibleEmployee AS ResponsibleEmployee,
  _ServiceContractItem.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  _ServiceContractItem.ContactPerson AS ContactPerson,
  cast(:P_DisplayCurrency as currency) AS DisplayCurrency,
  _ServiceContractItem.TransactionCurrency AS TransactionCurrency,
  _ServiceContractItem._TransactionCurrency AS _TransactionCurrency,
  _GLAcctData.CompanyCodeCurrency AS CompanyCodeCurrency,
  _GLAcctData.RecognizedMarginAmtInCCCrcy AS RecognizedMarginAmtInCCCrcy,
  _GLAcctData.RevenueAmountInCompanyCodeCrcy AS RevenueAmountInCompanyCodeCrcy,
  _GLAcctData.CostAmountInCompanyCodeCrcy AS CostAmountInCompanyCodeCrcy,
  _ServiceContractItem._ServiceDocument.ServiceDocNetAmount AS TotalSrvcContrValueInDC,
  _ServiceContractItem.ServiceDocumentItemNetAmount AS ServiceDocumentItemNetAmount,
  _GLAcctData.RevenueAmountInCompanyCodeCrcy AS RevenueAmountInDisplayCrcy,
  _GLAcctData.CostAmountInCompanyCodeCrcy AS CostAmountInDisplayCurrency,
  _GLAcctData.RecognizedMarginAmtInCCCrcy AS SrvcContrProfitabilityInDC,
  _GLAcctData.YTDSrvcContrRevnAmtInDC AS YTDSrvcContrRevnAmtInDC,
  _GLAcctData.YTDSrvcContrCostInDC AS YTDSrvcContrCostInDC,
  _GLAcctData.YTDSrvcContrPrftMarginAmtInDC AS YTDSrvcContrPrftMarginAmtInDC,
  _GLAcctData.CreationDate AS CreationDate,
  _GLAcctData.PostingDate AS PostingDate,
  _GLAcctData.DocumentDate AS DocumentDate,
  _GLAcctData.FiscalYearVariant AS FiscalYearVariant,
  _GLAcctData.FiscalPeriod AS FiscalPeriod,
  _GLAcctData.FiscalQuarter AS FiscalQuarter,
  _CalendarPeriod.CalendarQuarter AS CalendarQuarter,
  _CalendarPeriod.CalendarYear AS CalendarYear,
  _CalendarPeriod.CalendarMonth AS CalendarMonth,
  _CalendarPeriod.CalendarWeek AS CalendarWeek,
  _ServiceContractItem.ServiceDocumentDescription AS ServiceContractDescription,
  _ServiceContractItem.SalesOrganization AS SalesOrganization,
  _ServiceContractItem.DistributionChannel AS DistributionChannel,
  _ServiceContractItem.Division AS Division,
  _ServiceContractItem.SalesOffice AS SalesOffice,
  _ServiceContractItem.SalesGroup AS SalesGroup,
  _ServiceContractItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _ServiceContractItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _ServiceContractItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  _ServiceContractItem.ServiceOrganization AS ServiceOrganization,
  ServiceContractStartDate,
  ServiceContractEndDate,
  dats_days_between(ServiceContractStartDate, ServiceContractEndDate) AS NumberOfDays,
  _ServiceContractItem.ServiceDocumentItemStatus AS ServiceContractItemStatus,
  _ServiceContractItem._ServiceDocument.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
  _ServiceContractItem.ServiceDocumentItemCanclnParty AS ServiceDocumentItemCanclnParty,
  _ServiceContractItem.ServiceDocumentItmCanclnReason AS ServiceDocumentItmCanclnReason,
  _GLAcctData._Ledger AS _Ledger,
  _GLAcctData._SourceLedger AS _SourceLedger,
  _GLAcctData._CompanyCode AS _CompanyCode,
  _GLAcctData._FiscalYear AS _FiscalYear,
  _GLAcctData._JournalEntry AS _JournalEntry,
  _GLAcctData._Hierarchy AS _Hierarchy,
  _GLAcctData._SemanticTag AS _SemanticTag,
  _GLAcctData._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _GLAcctData._FiscalYearVariant AS _FiscalYearVariant,
  _CalendarPeriod._CalendarMonth AS _CalendarMonth,
  _CalendarPeriod._CalendarYear AS _CalendarYear,
  _CalendarPeriod._CalendarQuarter AS _CalendarQuarter,
  _GLAcctData._ServiceDocument AS _ServiceDocument,
  _GLAcctData._ServiceDocumentType AS _ServiceDocumentType,
  _GLAcctData._ServiceDocumentItem AS _ServiceDocumentItem,
  _ServiceContractItem._ContactPerson AS _ContactPerson,
  _ServiceContractItem._ServiceDocument._ServiceObjType AS _ServiceObjectType,
  _ServiceContractItem._ServiceDocumentType AS _ServiceContractItemType,
  _ServiceContractItem._SalesOrganization AS _SalesOrganization,
  _ServiceContractItem._DistributionChannel AS _DistributionChannel,
  _ServiceContractItem._Division AS _Division,
  _ServiceContractItem._SalesOffice AS _SalesOffice,
  _ServiceContractItem._SalesGroup AS _SalesGroup,
  _ServiceContractItem._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  _ServiceContractItem._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  _ServiceContractItem._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  _ServiceContractItem._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  _ServiceContractItem._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  _ServiceContractItem._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
  _ServiceContractItem._SoldToPartyCountry AS _SoldToPartyCountry,
  _ServiceContractItem._SoldToParty AS _SoldToParty,
  _ServiceContractItem._ShipToParty AS _ShipToParty
FROM P_SrvcContrItmWithCloudCheck AS _ServiceContractItem
LEFT OUTER JOIN P_ServiceDocLinItmFinData AS _GLAcctData ON _GLAcctData.ServiceContract = _ServiceContractItem.ServiceDocument AND _GLAcctData.ServiceContractItem = _ServiceContractItem.ServiceDocumentItem AND _GLAcctData.SalesOrganization = _ServiceContractItem.SalesOrganization AND _GLAcctData.ServiceContract is not initial AND _GLAcctData.ServiceContractType = _ServiceContractItem.ServiceDocumentType  -- association [1]
LEFT OUTER JOIN I_BusinessPartner AS _RespEmployeeID ON RespEmployeeBusinessPartnerId = _RespEmployeeID.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusSolnOrdBasicFinancial AS _SolutionOrderVH ON RefBusinessSolutionOrder = _SolutionOrderVH.BusinessSolutionOrder  -- association [0..1]
;

Learn More