Technische Dokumentation Modul SAP-COPA

Inhaltsverzeichnis

Informationen

Dokumentationstyp: Vollständig (zur Endanwender Dokumentation)
Erstellt am: 07.12.2023
Modulversion: 5
Modultyp: Basismodul
Beschreibung: Modul für SAP Ergebnis- und Marktsegmentrechnung
Benötigt Administrator Rechte: Nein
Ab OCT Version: 5.10.11

Tabellen

integration.tSAPCOPA_Customers

Table to store customer masterdata for module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 CustomerID NVARCHAR(50) highlight_off highlight_off highlight_off
CustomerID.
5 CustomerName NVARCHAR(50) highlight_off highlight_off highlight_off
CustomerName.
6 Street NVARCHAR(255) check_circle highlight_off highlight_off
Street.
7 PostalCode NVARCHAR(255) check_circle highlight_off highlight_off
PostalCode.
8 City NVARCHAR(255) check_circle highlight_off highlight_off
City.
9 CountryIsoCODE NVARCHAR(50) check_circle highlight_off highlight_off
CountryIsoCODE.
10 CustomerClassificationID NVARCHAR(50) check_circle highlight_off highlight_off
CustomerClassificationID.
11 IndustryID NVARCHAR(50) check_circle highlight_off highlight_off
IndustryID.
12 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
JSON Objekt für zusätzliche Informationen abweichend vom Standard.

Referenziert von

integration.tSAPCOPA_MasterdataDescriptions

Table to store masterdata descriptions for module SAPCOPA. The descriptions can be separated by ElementType and LanguageCODE.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 ElementType NVARCHAR(50) highlight_off highlight_off highlight_off
ElementType.
5 ElementID NVARCHAR(50) highlight_off highlight_off highlight_off
ElementID.
6 ElementDesc NVARCHAR(255) highlight_off highlight_off highlight_off
ElementDesc.
7 LanguageCODE NVARCHAR(50) highlight_off highlight_off highlight_off
LanguageCODE.
8 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
JSON Objekt für zusätzliche Informationen abweichend vom Standard.

Referenziert von

integration.tSAPCOPA_Materials

Table to store material masterdata for module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 MaterialID NVARCHAR(50) highlight_off highlight_off highlight_off
MaterialID.
5 MaterialDescDefault NVARCHAR(50) check_circle highlight_off highlight_off
MaterialDescDefault.
6 BaseUnitOfMeasure NVARCHAR(50) check_circle highlight_off highlight_off
BaseUnitOfMeasure.
7 MaterialGroupID NVARCHAR(50) check_circle highlight_off highlight_off
MaterialGroupID.
8 MaterialTypeID NVARCHAR(50) check_circle highlight_off highlight_off
MaterialTypeID.
9 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
JSON Objekt für zusätzliche Informationen abweichend vom Standard.

Referenziert von

integration.tSAPCOPA_SalesOrganizations

Table to store sales organizations masterdata for module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 SalesOrganizationID NVARCHAR(50) highlight_off highlight_off highlight_off
SalesOrganizationID.
5 SalesOrganizationName NVARCHAR(50) highlight_off highlight_off highlight_off
SalesOrganizationName.
6 Street NVARCHAR(255) check_circle highlight_off highlight_off
Street.
7 PostalCode NVARCHAR(255) check_circle highlight_off highlight_off
PostalCode.
8 City NVARCHAR(255) check_circle highlight_off highlight_off
City.
9 CountryIsoCODE NVARCHAR(50) check_circle highlight_off highlight_off
CountryIsoCODE.
10 PlantID NVARCHAR(50) check_circle highlight_off highlight_off
PlantID.
11 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
JSON Objekt für zusätzliche Informationen abweichend vom Standard.

Referenziert von

integration.tSAPCOPA_SalesRepresentatives

Table to store masterdata of sales representatives for module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 SalesRepresentativeID NVARCHAR(50) highlight_off highlight_off highlight_off
SalesRepresentativeID.
5 SalesRepresentativeName NVARCHAR(50) highlight_off highlight_off highlight_off
SalesRepresentativeName.
6 SalesOrganizationID NVARCHAR(50) check_circle highlight_off highlight_off
SalesOrganizationID.
7 DistributionChannelID NVARCHAR(50) check_circle highlight_off highlight_off
DistributionChannelID.
8 DivisionID NVARCHAR(50) check_circle highlight_off highlight_off
DivisionID.
9 PostalCode NVARCHAR(255) check_circle highlight_off highlight_off
PostalCode.
10 City NVARCHAR(255) check_circle highlight_off highlight_off
City.
11 CountryIsoCODE NVARCHAR(50) check_circle highlight_off highlight_off
CountryIsoCODE.
12 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
JSON Objekt für zusätzliche Informationen abweichend vom Standard.

Referenziert von

integration.tSAPCOPA_TransactionData

Table to store transaction data of module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 CustomerID NVARCHAR(50) check_circle highlight_off highlight_off
CustomerID.
5 MaterialID NVARCHAR(50) check_circle highlight_off highlight_off
MaterialID.
6 PlantID NVARCHAR(50) check_circle highlight_off highlight_off
PlantID.
7 BusinessAreaID NVARCHAR(50) check_circle highlight_off highlight_off
BusinessAreaID.
8 SalesOrganizationID NVARCHAR(50) check_circle highlight_off highlight_off
SalesOrganizationID.
9 DistributionChannelID NVARCHAR(50) check_circle highlight_off highlight_off
DistributionChannelID.
10 DivisionID NVARCHAR(50) check_circle highlight_off highlight_off
DivisionID.
11 ProfitCenterID NVARCHAR(50) check_circle highlight_off highlight_off
ProfitCenterID.
12 CostElementID NVARCHAR(50) check_circle highlight_off highlight_off
CostElementID.
13 WbsElementID NVARCHAR(50) check_circle highlight_off highlight_off
WbsElementID.
14 SalesGroupID NVARCHAR(50) check_circle highlight_off highlight_off
SalesGroupID.
15 SalesOfficeID NVARCHAR(50) check_circle highlight_off highlight_off
SalesOfficeID.
16 BillingTypeID NVARCHAR(50) check_circle highlight_off highlight_off
BillingTypeID.
17 SalesOrderNumber NVARCHAR(50) check_circle highlight_off highlight_off
SalesOrderNumber.
18 SalesOrderNumberLine NVARCHAR(50) check_circle highlight_off highlight_off
SalesOrderNumberLine.
19 OrderNumber NVARCHAR(50) check_circle highlight_off highlight_off
OrderNumber.
20 FinancialYear SMALLINT highlight_off highlight_off highlight_off
FinancialYear.
21 FinancialPeriod SMALLINT highlight_off highlight_off highlight_off
FinancialPeriod.
22 DeltaValue BIGINT check_circle highlight_off highlight_off
DeltaValue.
23 DeltaSource NVARCHAR(50) check_circle highlight_off highlight_off
DeltaSource.
24 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
JSON Objekt für zusätzliche Informationen abweichend vom Standard.

Referenziert von

result.tSAPCOPA_MasterdataDescriptions

Table to store masterdata descriptions for module SAPCOPA. The descriptions can be separated by ElementType and LanguageCODE.

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource.
2 ElementType NVARCHAR(50) highlight_off highlight_off highlight_off
ElementType.
3 ElementID NVARCHAR(50) highlight_off highlight_off highlight_off
ElementID.
4 ElementDesc NVARCHAR(255) highlight_off highlight_off highlight_off
ElementDesc.
5 LanguageCODE NVARCHAR(50) highlight_off highlight_off highlight_off
LanguageCODE.

Referenziert von

Sichten

agent.vJSON_integration_tSAPCOPA_Customers

This view resolves the CustomValuesJSON column in table integration.tSAPCOPA_Customers to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tSAPCOPA_MasterdataDescriptions

This view resolves the CustomValuesJSON column in table integration.tSAPCOPA_MasterdataDescriptions to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tSAPCOPA_Materials

This view resolves the CustomValuesJSON column in table integration.tSAPCOPA_Materials to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tSAPCOPA_SalesOrganizations

This view resolves the CustomValuesJSON column in table integration.tSAPCOPA_SalesOrganizations to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tSAPCOPA_SalesRepresentatives

This view resolves the CustomValuesJSON column in table integration.tSAPCOPA_SalesRepresentatives to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tSAPCOPA_TransactionData

This view resolves the CustomValuesJSON column in table integration.tSAPCOPA_TransactionData to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vSAPCOPA_MasterdataDescriptions

Agent view for masterdata descriptions of module SAPCOPA. Descriptions are ordered with language priority (DE, EN, others).

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 ElementType NVARCHAR(50) highlight_off highlight_off highlight_off
3 ElementID NVARCHAR(50) highlight_off highlight_off highlight_off
4 ElementDesc NVARCHAR(255) highlight_off highlight_off highlight_off
5 LanguageCODE NVARCHAR(50) highlight_off highlight_off highlight_off
6 RowKey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vSAPCOPA_Customers

Result view for customer masterdata of module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CustomerID NVARCHAR(50) highlight_off highlight_off highlight_off
3 CustomerName NVARCHAR(50) highlight_off highlight_off highlight_off
4 Street NVARCHAR(255) check_circle highlight_off highlight_off
5 PostalCode NVARCHAR(255) check_circle highlight_off highlight_off
6 City NVARCHAR(255) check_circle highlight_off highlight_off
7 CountryIsoCODE NVARCHAR(50) check_circle highlight_off highlight_off
8 CustomerClassificationID NVARCHAR(50) check_circle highlight_off highlight_off
9 CustomerClassificationDesc NVARCHAR(255) check_circle highlight_off highlight_off
10 IndustryID NVARCHAR(50) check_circle highlight_off highlight_off
11 IndustryDesc NVARCHAR(255) check_circle highlight_off highlight_off
12 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

result.vSAPCOPA_Materials

Result view for material masterdata of module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 MaterialID NVARCHAR(50) highlight_off highlight_off highlight_off
3 MaterialDescDefault NVARCHAR(50) check_circle highlight_off highlight_off
4 BaseUnitOfMeasure NVARCHAR(50) check_circle highlight_off highlight_off
5 MaterialGroupID NVARCHAR(50) check_circle highlight_off highlight_off
6 MaterialGroupDesc NVARCHAR(255) check_circle highlight_off highlight_off
7 MaterialTypeID NVARCHAR(50) check_circle highlight_off highlight_off
8 MaterialTypeDesc NVARCHAR(255) check_circle highlight_off highlight_off
9 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
10 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

result.vSAPCOPA_SalesOrganizations

Result view for sales organization masterdata of module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 SalesOrganizationID NVARCHAR(50) highlight_off highlight_off highlight_off
3 SalesOrganizationName NVARCHAR(50) highlight_off highlight_off highlight_off
4 Street NVARCHAR(255) check_circle highlight_off highlight_off
5 PostalCode NVARCHAR(255) check_circle highlight_off highlight_off
6 City NVARCHAR(255) check_circle highlight_off highlight_off
7 CountryIsoCODE NVARCHAR(50) check_circle highlight_off highlight_off
8 PlantID NVARCHAR(50) check_circle highlight_off highlight_off
9 PlantDesc NVARCHAR(255) check_circle highlight_off highlight_off
10 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

result.vSAPCOPA_SalesRepresentatives

Result view for sales representative masterdata of module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
3 SalesRepresentativeID NVARCHAR(50) highlight_off highlight_off highlight_off
4 SalesRepresentativeName NVARCHAR(50) highlight_off highlight_off highlight_off
5 SalesOrganizationID NVARCHAR(50) check_circle highlight_off highlight_off
6 DistributionChannelID NVARCHAR(50) check_circle highlight_off highlight_off
7 DistributionChannelDesc NVARCHAR(255) check_circle highlight_off highlight_off
8 DivisionID NVARCHAR(50) check_circle highlight_off highlight_off
9 DivisionDesc NVARCHAR(255) check_circle highlight_off highlight_off
10 PostalCode NVARCHAR(255) check_circle highlight_off highlight_off
11 City NVARCHAR(255) check_circle highlight_off highlight_off
12 CountryIsoCODE NVARCHAR(50) check_circle highlight_off highlight_off
13 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
14 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

result.vSAPCOPA_TransactionData

Result view for tansaction data of module SAPCOPA.

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
3 CustomerID NVARCHAR(50) check_circle highlight_off highlight_off
4 CustomerName NVARCHAR(50) check_circle highlight_off highlight_off
5 MaterialID NVARCHAR(50) check_circle highlight_off highlight_off
6 MaterialDescDefault NVARCHAR(50) check_circle highlight_off highlight_off
7 PlantID NVARCHAR(50) check_circle highlight_off highlight_off
8 PlantDesc NVARCHAR(255) check_circle highlight_off highlight_off
9 BusinessAreaID NVARCHAR(50) check_circle highlight_off highlight_off
10 BusinessAreaDesc NVARCHAR(255) check_circle highlight_off highlight_off
11 SalesOrganizationID NVARCHAR(50) check_circle highlight_off highlight_off
12 SalesOrganizationDesc NVARCHAR(50) check_circle highlight_off highlight_off
13 DistributionChannelID NVARCHAR(50) check_circle highlight_off highlight_off
14 DistributionChannelDesc NVARCHAR(255) check_circle highlight_off highlight_off
15 DivisionID NVARCHAR(50) check_circle highlight_off highlight_off
16 DivisionDesc NVARCHAR(255) check_circle highlight_off highlight_off
17 ProfitCenterID NVARCHAR(50) check_circle highlight_off highlight_off
18 CostElementID NVARCHAR(50) check_circle highlight_off highlight_off
19 WbsElementID NVARCHAR(50) check_circle highlight_off highlight_off
20 SalesGroupID NVARCHAR(50) check_circle highlight_off highlight_off
21 SalesGroupDesc NVARCHAR(255) check_circle highlight_off highlight_off
22 SalesOfficeID NVARCHAR(50) check_circle highlight_off highlight_off
23 SalesOfficeDesc NVARCHAR(255) check_circle highlight_off highlight_off
24 BillingTypeID NVARCHAR(50) check_circle highlight_off highlight_off
25 BillingTypeDesc NVARCHAR(255) check_circle highlight_off highlight_off
26 SalesOrderNumber NVARCHAR(50) check_circle highlight_off highlight_off
27 SalesOrderNumberLine NVARCHAR(50) check_circle highlight_off highlight_off
28 OrderNumber NVARCHAR(50) check_circle highlight_off highlight_off
29 FinancialYear SMALLINT highlight_off highlight_off highlight_off
30 FinancialPeriod SMALLINT highlight_off highlight_off highlight_off
31 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

Prozeduren

agent.pPostBulkloadSAPCOPA

This the post bulkload procedure of module "SAPCOPA". The procedure triggers the sync of master data from integration to global schema including foster parent handling.

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username
2 @CompanyKeys NVARCHAR(MAX)
List of CompanyKeys, semicolon separated.

Referenzierte Objekte

agent.pSyncSAPCOPA

Procedure to transfer data of module SAPCOPA to result schema.

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username
2 @CompanyKeys NVARCHAR(MAX)
CompanyKeys
3 @FullRebuild BIT
Force full rebuild of fact tables.

Referenzierte Objekte

integration.pGetDeltaValuesSAPCOPA

Procedure to get DeltaValues from module SAPCOPA.

# Parameter Datentyp
1 @DataSourceKey INT
DataSourceKey
2 @CompanyID NVARCHAR(50)
CompanyID
3 @Username NVARCHAR(255)
Username

Referenzierte Objekte