Deprecated
This CDS view is deprecated in S/4HANA. Use C_CO_DIANStRpFrmt1001Vers10Q instead. View all deprecated CDS views →

C_CO_DIANStRpFormat1001Query

DDL: C_CO_DIANSTRPFORMAT1001QUERY Type: view CONSUMPTION Package: GLO_FIN_IS_CO_FORMAT_1001
58 Fields 1 Data Sources

Format 1001 - Journal Entry Item Query

C_CO_DIANStRpFormat1001Query is a Consumption CDS View that provides data about "Format 1001 - Journal Entry Item Query" in SAP S/4HANA. It reads from 1 data source (C_CO_DIANStRpFormat1001Cube) and exposes 58 fields with key fields CompanyCode, FiscalYear, StatryRptgEntity, StatryRptCategory, StatryRptRunID. Part of development package GLO_FIN_IS_CO_FORMAT_1001.

Data Sources (1)

SourceAliasJoin Type
C_CO_DIANStRpFormat1001Cube C_CO_DIANStRpFormat1001Cube from

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to

Annotations (15)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CSRCOFRMT1001Q view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
Analytics.settings.zeroValues.handling #HIDE view
Analytics.settings.zeroValues.hideOnAxis #ROWS view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Format 1001 - Journal Entry Item Query view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_CO_DIANStRpFrmt1001Vers10Q view
VDM.viewType #CONSUMPTION view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY CO_DIANReportFormat CO_DIANReportFormat Report Format
KEY CO_DIANReportItemType CO_DIANReportItemType Item Type
KEY AccountingDocument Journal Entry
KEY ReportedTaxNumber ReportedTaxNumber
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3
TaxNumber4 TaxNumber4
TaxNumber5 TaxNumber5
TaxNumberType TaxNumberType Tax number type
Customer Customer Sold-to Party
Supplier Supplier Supplier
PurchasingDocument PurchasingDocument Purchasing Document
BusinessPlace BusinessPlace Business place
AccountingDocumentType AccountingDocumentType Journal Entry Type
CO_DIANTaxNumberType CO_DIANTaxNumberType DIAN Doc. Type
BusinessPartnerCategory BusinessPartnerCategory Partner Cat.
FirstName FirstName First Name
MiddleName MiddleName Middle Name
LastName LastName Last Name
AdditionalLastName AdditionalLastName Other Last Name
OrganizationBPName1 OrganizationBPName1 Name 1
OrganizationBPName2 OrganizationBPName2 Name 2
OrganizationBPName3 OrganizationBPName3 Name 3
OrganizationBPName4 OrganizationBPName4 Name 4
BusinessPartner BusinessPartner Issuing Authority
IsNaturalPerson IsNaturalPerson Natural person
IsBelowMinimumAmountThreshold IsBelowMinimumAmountThreshold
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
CO_DIANCountry CO_DIANCountry
Region Region Venue Region
CityCode CityCode IATA: City
CityName CityName Name
StreetName StreetName Text
PostingDate PostingDate Posting Date for GR
CreationUTCDateTime CreationUTCDateTime Time Stamp
GLAccount GLAccount General Ledger
GLAccountName GLAccountName Short Text
AlternativeGLAccount AlternativeGLAccount Group Account
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
ReportingCurrency ReportingCurrency Currency
DcblGLAcctPaytsAmtInRptgCrcy DcblGLAcctPaytsAmtInRptgCrcy
NonDcblGLAcctPaytAmtInRptgCrcy NonDcblGLAcctPaytAmtInRptgCrcy
DcblVATIncrdCostInRptgCrcy DcblVATIncrdCostInRptgCrcy
NonDcblVATIncrdCostInRptgCrcy NonDcblVATIncrdCostInRptgCrcy
WhldgTxIncAmtInRptgCurrency WhldgTxIncAmtInRptgCurrency
TakenWhldgTaxIncAmtInRptgCrcy TakenWhldgTaxIncAmtInRptgCrcy
WhldgTaxCommonVATAmtInRptgCrcy WhldgTaxCommonVATAmtInRptgCrcy
TknWhldgSimpfdVATAmtInRptgCrcy TknWhldgSimpfdVATAmtInRptgCrcy
WhldgTxForeignVATAmtInRptgCrcy WhldgTxForeignVATAmtInRptgCrcy
CO_WhldgCREEAmtInRptgCurrency CO_WhldgCREEAmtInRptgCurrency
CO_TknWhldgCREEAmtInRptgCrcy CO_TknWhldgCREEAmtInRptgCrcy

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_DIANStRpFormat1001Query.
-- 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_Ledger : fins_ledger, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW C_CO_DIANStRpFormat1001Query AS
SELECT
  CompanyCode,
  FiscalYear,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CO_DIANReportFormat,
  CO_DIANReportItemType,
  cast( AccountingDocument as fis_belnr preserving type ) AS AccountingDocument,
  ReportedTaxNumber,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  TaxNumberType,
  Customer,
  Supplier,
  PurchasingDocument,
  BusinessPlace,
  AccountingDocumentType,
  CO_DIANTaxNumberType,
  BusinessPartnerCategory,
  FirstName,
  MiddleName,
  LastName,
  AdditionalLastName,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  BusinessPartner,
  IsNaturalPerson,
  IsBelowMinimumAmountThreshold,
  BusinessPartnerCountry,
  CO_DIANCountry,
  Region,
  CityCode,
  CityName,
  StreetName,
  PostingDate,
  CreationUTCDateTime,
  GLAccount,
  GLAccountName,
  AlternativeGLAccount,
  Reference1IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  ReportingCurrency,
  DcblGLAcctPaytsAmtInRptgCrcy,
  NonDcblGLAcctPaytAmtInRptgCrcy,
  DcblVATIncrdCostInRptgCrcy,
  NonDcblVATIncrdCostInRptgCrcy,
  WhldgTxIncAmtInRptgCurrency,
  TakenWhldgTaxIncAmtInRptgCrcy,
  WhldgTaxCommonVATAmtInRptgCrcy,
  TknWhldgSimpfdVATAmtInRptgCrcy,
  WhldgTxForeignVATAmtInRptgCrcy,
  CO_WhldgCREEAmtInRptgCurrency,
  CO_TknWhldgCREEAmtInRptgCrcy
FROM C_CO_DIANStRpFormat1001Cube
;

Learn More