Technische Dokumentation Modul SAP-COPA
Inhaltsverzeichnis
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