C_CO_DIANStRpEmployeeOpenItemC

DDL: C_CO_DIANSTRPEMPLOYEEOPENITEMC Type: view CONSUMPTION
30 Fields 1 Data Sources

Empl. Pyrl Open Items Cube for CO DIAN

C_CO_DIANStRpEmployeeOpenItemC (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Contract Accounting Promise To Pay · Country or Region-Specific Functions for Finance

C_CO_DIANStRpEmployeeOpenItemC is a Consumption CDS View (Cube) that provides data about "Empl. Pyrl Open Items Cube for CO DIAN" in SAP S/4HANA. It reads from 1 data source (I_CO_DIANStRpEmplAggrgdPyrl) and exposes 30 fields with key fields CompanyCode, PayrollYear, CO_DIANReportFormat, CO_DIANReportItemType, CO_DIANTaxNumberType.

SAP Help Documentation

CategoryFinance
Data CategoryCube
StatusReleased
Data Extraction TypeFull
Corresponding DataSourceCCODIANSTRPEOIC
Purpose
This CDS view retrieves employee payroll open items that can be reported in the 1009 Report Format for Magnetic Media reporting in Colombia. This CDS view provides the prerequisites for answering the following business questions: What are my employee payroll open items? How many employee payroll open items are there in the system?

Structure
This view relates to the following SAP object types: Employee payroll data Main parameters and filters of the CDS view The main parameters are as follows: CompanyCode : Use this parameter to specify a company code. PayrollYear : Use this parameter to specify a year from which you would like to extract payroll data. TaxNumber1 : Use this parameter to specify the identification of the employee. Example: NIT number.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-FI-CO
CapabilitiesData Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageCountry or Region-Specific Functions for Finance for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view retrieves employee payroll open items that can be reported in the 1009 Report Format for Magnetic Media reporting in Colombia.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What are my employee payroll open items?</p></li> <li><p>How many employee payroll open items are there in the system?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_CO_DIANStRpEmplAggrgdPyrl I_CO_DIANStRpEmplAggrgdPyrl from

Annotations (17)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CCODIANSTRPEOIC view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Empl. Pyrl Open Items Cube for CO DIAN view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PayrollYear PayrollYear Fiscal Year
KEY CO_DIANReportFormat CO_DIANReportFormat DIAN Report Format
KEY CO_DIANReportItemType CO_DIANReportItemType Report Format Item Type
KEY CO_DIANTaxNumberType CO_DIANTaxNumberType DIAN Type of Document
KEY TaxNumber1 TaxNumber1 VAT Reg. No.
KEY CreationUTCDateTime CreationUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report Category ID
KEY StatryRptRunID StatryRptRunID Report Run ID
FirstName FirstName First Name
MiddleName MiddleName Middle Name
LastName LastName Last Name
AdditionalLastName AdditionalLastName Other Last Name
Country Country Country/Region Key
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
CO_DIANCountry _CO_DIANCountryMapping CO_DIANCountry DIAN Country/Region Code
StreetName StreetName Street
CityCode CityCode City code for city/street file
RegionCityRegion
CO_DIANPyrlItemTypeBaseAmt CO_DIANPyrlItemTypeBaseAmt Amount for DIAN
CO_DIANPyrlItemTypeBaseAmtCrcy CO_DIANPyrlItemTypeBaseAmtCrcy Currency for DIAN
CO_DIANPyrlItmTypeCalcdAmt CO_DIANPyrlItmTypeCalcdAmt Amount for DIAN
CO_DIANPyrlItmTypeCalcdAmtCrcy CO_DIANPyrlItmTypeCalcdAmtCrcy Currency for DIAN
CreatedByUser CreatedByUser ABAP System Field: Name of Current User
_EmplPyrlLg _EmplPyrlLg
_CO_DIANCountryMapping _CO_DIANCountryMapping
_CompanyCodeCountryMapping _CompanyCodeCountryMapping
_CompanyCode _CompanyCode
_BaseAmountCurrency _BaseAmountCurrency

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 C_CO_DIANStRpEmployeeOpenItemC.
-- 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 C_CO_DIANStRpEmployeeOpenItemC AS
SELECT
  CompanyCode,
  PayrollYear,
  CO_DIANReportFormat,
  CO_DIANReportItemType,
  CO_DIANTaxNumberType,
  TaxNumber1,
  CreationUTCDateTime,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  FirstName,
  MiddleName,
  LastName,
  AdditionalLastName,
  Country,
  CompanyCodeCountry,
  _CO_DIANCountryMapping.CO_DIANCountry AS CO_DIANCountry,
  StreetName,
  CityCode,
  CO_DIANPyrlItemTypeBaseAmt,
  CO_DIANPyrlItemTypeBaseAmtCrcy,
  CO_DIANPyrlItmTypeCalcdAmt,
  CO_DIANPyrlItmTypeCalcdAmtCrcy,
  CreatedByUser
FROM I_CO_DIANStRpEmplAggrgdPyrl
;

Learn More