P_PLNSEMTAGMARGINMULTICRCY
Plan SemTag Margin with Multi Crcy
P_PLNSEMTAGMARGINMULTICRCY is a CDS View in S/4HANA. Plan SemTag Margin with Multi Crcy. It contains 119 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ActPlnSemTagMarginUnion | view_entity | union_all | COMPOSITE | Actl Pln SemTag Margin |
| P_ActPlnSemTagMultiCrcy | view_entity | union_all | COMPOSITE | Actual G/L Account Item SemTag union with Plan |
Fields (119)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | CurrencyField | CurrencyField | 1 |
| KEY | FinancialPlanningDataPacket | FinancialPlanningDataPacket | 1 |
| KEY | FinancialPlanningEntryItem | FinancialPlanningEntryItem | 1 |
| KEY | FinancialPlanningReqTransSqnc | FinancialPlanningReqTransSqnc | 1 |
| KEY | FiscalYear | FiscalYear | 1 |
| KEY | SemanticTag | SemanticTag | 1 |
| KEY | SourceLedger | SourceLedger | 1 |
| _AccountingDocumentType | _AccountingDocumentType | 1 | |
| _BaseUnit | _BaseUnit | 1 | |
| _BillToParty | _BillToParty | 1 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _CostAnalysisResource | _CostAnalysisResource | 1 | |
| _CostSourceUnit | _CostSourceUnit | 1 | |
| _CurrentCostCenter | _CurrentCostCenter | 1 | |
| _CurrentProfitCenter | _CurrentProfitCenter | 1 | |
| _Customer | _Customer | 1 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _FiscalYear | _FiscalYear | 1 | |
| _FiscalYearVariant | _FiscalYearVariant | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | 1 | |
| _Ledger | _Ledger | 1 | |
| _Order | _Order | 1 | |
| _OriginCostCtrActivityType | _OriginCostCtrActivityType | 1 | |
| _OriginProfitCenter | _OriginProfitCenter | 1 | |
| _PartnerCostCtrActivityType | _PartnerCostCtrActivityType | 1 | |
| _Plant | _Plant | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProjectBasicData | _ProjectBasicData | 1 | |
| _SalesDistrict | _SalesDistrict | 1 | |
| _SalesDocument | _SalesDocument | 1 | |
| _SalesOrder | _SalesOrder | 1 | |
| _SalesOrderItem | _SalesOrderItem | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _Segment | _Segment | 1 | |
| _SemanticTag | _SemanticTag | 1 | |
| _ServiceDocument | _ServiceDocument | 1 | |
| _ShipToParty | _ShipToParty | 1 | |
| _SoldProduct | _SoldProduct | 1 | |
| _SoldProductGroup | _SoldProductGroup | 1 | |
| _SourceLedger | _SourceLedger | 1 | |
| _Supplier | _Supplier | 1 | |
| _WBSElementBasicData | _WBSElementBasicData | 1 | |
| AccountAssignmentType | AccountAssignmentType | 1 | |
| AccountingDocumentType | AccountingDocumentType | 1 | |
| AmountInDisplayCurrency | AmountInDisplayCurrency | 1 | |
| AssetClass | AssetClass | 1 | |
| BaseUnit | BaseUnit | 1 | |
| BdgtCtrldBdgtCostInDspCrcy | BdgtCtrldBdgtCostInDspCrcy | 1 | |
| BillableControl | BillableControl | 1 | |
| BillToParty | BillToParty | 1 | |
| BudgetPlanSemTotalAmount_H | BudgetPlanSemTotalAmount_H | 1 | |
| BudgetProjStockAmtInDspCrcy_H | BudgetProjStockAmtInDspCrcy_H | 1 | |
| BusinessSolutionOrder | BusinessSolutionOrder | 1 | |
| BusinessSolutionOrderItem | BusinessSolutionOrderItem | 1 | |
| BusinessTransactionType | BusinessTransactionType | 1 | |
| ChartOfAccounts | ChartOfAccounts | 1 | |
| ConditionContract | ConditionContract | 1 | |
| ControllingArea | ControllingArea | 1 | |
| ControllingDebitCreditCode | ControllingDebitCreditCode | 1 | |
| CostAnalysisResource | CostAnalysisResource | 1 | |
| CostCenter | CostCenter | 1 | |
| CostSourceUnit | CostSourceUnit | 1 | |
| Currency | Currency | 1 | |
| Customer | Customer | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerSupplierCountry | CustomerSupplierCountry | 1 | |
| CustomerSupplierIndustry | CustomerSupplierIndustry | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| FinancialAccountType | FinancialAccountType | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FiscalYearPeriod | FiscalYearPeriod | 1 | |
| FiscalYearVariant | FiscalYearVariant | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| GLAccount | GLAccount | 1 | |
| IsCommitment | IsCommitment | 1 | |
| LedgerFiscalYear | LedgerFiscalYear | 1 | |
| OrderCategory | OrderCategory | 1 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| OriginCostCtrActivityType | OriginCostCtrActivityType | 1 | |
| OriginProfitCenter | OriginProfitCenter | 1 | |
| PartnerCostCtrActivityType | PartnerCostCtrActivityType | 1 | |
| PersonnelNumber | PersonnelNumber | 1 | |
| PlanningCategory | PlanningCategory | 1 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| Project | Project | 1 | |
| ProjectExternalID | ProjectExternalID | 1 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| ProjectNetwork | ProjectNetwork | 1 | |
| ProviderContract | ProviderContract | 1 | |
| ProviderContractItem | ProviderContractItem | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| Segment | Segment | 1 | |
| ServiceContract | ServiceContract | 1 | |
| ServiceContractItem | ServiceContractItem | 1 | |
| ServiceContractType | ServiceContractType | 1 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ShipToParty | ShipToParty | 1 | |
| SoldProduct | SoldProduct | 1 | |
| SoldProductGroup | SoldProductGroup | 1 | |
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | 1 | |
| Supplier | Supplier | 1 | |
| TimeSheetOvertimeCategory | TimeSheetOvertimeCategory | 1 | |
| ValuationArea | ValuationArea | 1 | |
| WBSElementInternalID | WBSElementInternalID | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Plan SemTag Margin with Multi Crcy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PLNSEMTAGMARGINMULTICRCY (
COMPANYCODE,
CURRENCYFIELD,
FINANCIALPLANNINGDATAPACKET,
FINANCIALPLANNINGENTRYITEM,
FINANCIALPLANNINGREQTRANSSQNC,
FISCALYEAR,
SEMANTICTAG,
SOURCELEDGER,
_ACCOUNTINGDOCUMENTTYPE,
_BASEUNIT,
_BILLTOPARTY,
_CHARTOFACCOUNTS,
_COMPANYCODE,
_CONTROLLINGAREA,
_COSTANALYSISRESOURCE,
_COSTSOURCEUNIT,
_CURRENTCOSTCENTER,
_CURRENTPROFITCENTER,
_CUSTOMER,
_CUSTOMERGROUP,
_DISTRIBUTIONCHANNEL,
_FISCALYEAR,
_FISCALYEARVARIANT,
_FUNCTIONALAREA,
_GLACCOUNTINCHARTOFACCOUNTS,
_LEDGER,
_ORDER,
_ORIGINCOSTCTRACTIVITYTYPE,
_ORIGINPROFITCENTER,
_PARTNERCOSTCTRACTIVITYTYPE,
_PLANT,
_PROFITCENTER,
_PROJECTBASICDATA,
_SALESDISTRICT,
_SALESDOCUMENT,
_SALESORDER,
_SALESORDERITEM,
_SALESORGANIZATION,
_SEGMENT,
_SEMANTICTAG,
_SERVICEDOCUMENT,
_SHIPTOPARTY,
_SOLDPRODUCT,
_SOLDPRODUCTGROUP,
_SOURCELEDGER,
_SUPPLIER,
_WBSELEMENTBASICDATA,
ACCOUNTASSIGNMENTTYPE,
ACCOUNTINGDOCUMENTTYPE,
AMOUNTINDISPLAYCURRENCY,
ASSETCLASS,
BASEUNIT,
BDGTCTRLDBDGTCOSTINDSPCRCY,
BILLABLECONTROL,
BILLTOPARTY,
BUDGETPLANSEMTOTALAMOUNT_H,
BUDGETPROJSTOCKAMTINDSPCRCY_H,
BUSINESSSOLUTIONORDER,
BUSINESSSOLUTIONORDERITEM,
BUSINESSTRANSACTIONTYPE,
CHARTOFACCOUNTS,
CONDITIONCONTRACT,
CONTROLLINGAREA,
CONTROLLINGDEBITCREDITCODE,
COSTANALYSISRESOURCE,
COSTCENTER,
COSTSOURCEUNIT,
CURRENCY,
CUSTOMER,
CUSTOMERGROUP,
CUSTOMERSUPPLIERCOUNTRY,
CUSTOMERSUPPLIERINDUSTRY,
DISTRIBUTIONCHANNEL,
FINANCIALACCOUNTTYPE,
FISCALPERIOD,
FISCALYEARPERIOD,
FISCALYEARVARIANT,
FUNCTIONALAREA,
GLACCOUNT,
ISCOMMITMENT,
LEDGERFISCALYEAR,
ORDERCATEGORY,
ORDERID,
ORGANIZATIONDIVISION,
ORIGINCOSTCTRACTIVITYTYPE,
ORIGINPROFITCENTER,
PARTNERCOSTCTRACTIVITYTYPE,
PERSONNELNUMBER,
PLANNINGCATEGORY,
PLANT,
POSTINGDATE,
PROFITCENTER,
PROJECT,
PROJECTEXTERNALID,
PROJECTINTERNALID,
PROJECTNETWORK,
PROVIDERCONTRACT,
PROVIDERCONTRACTITEM,
SALESDISTRICT,
SALESDOCUMENT,
SALESORDER,
SALESORDERITEM,
SALESORGANIZATION,
SEGMENT,
SERVICECONTRACT,
SERVICECONTRACTITEM,
SERVICECONTRACTTYPE,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
SERVICESRENDEREDDATE,
SHIPTOPARTY,
SOLDPRODUCT,
SOLDPRODUCTGROUP,
SUBLEDGERACCTLINEITEMTYPE,
SUPPLIER,
TIMESHEETOVERTIMECATEGORY,
VALUATIONAREA,
WBSELEMENTINTERNALID,
PRIMARY KEY (COMPANYCODE, CURRENCYFIELD, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, SEMANTICTAG, SOURCELEDGER)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA