P_ACTLSEMTAGMARGINMULTICRCY

CDS View
87 Fields 2 CDS Views

Actl SemTag Margin with Multi Crcy

P_ACTLSEMTAGMARGINMULTICRCY is a CDS View in S/4HANA. Actl SemTag Margin with Multi Crcy. It contains 87 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ActPlnSemTagAndSubldgrItm view_entity union_all COMPOSITE Plan&Actual G/L Account Item Union by SemTag and SLALITTYPE
P_ActPlnSemTagMarginUnion view_entity from COMPOSITE Actl Pln SemTag Margin

Fields (87)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY CurrencyField CurrencyField 1
KEY FiscalYear FiscalYear 1
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY SemanticTag SemanticTag 1
KEY SourceLedger SourceLedger 1
_AccountingDocumentType _AccountingDocumentType 1
_CurrentCostCenter _CurrentCostCenter 1
_CurrentProfitCenter _CurrentProfitCenter 1
_PartnerCostCtrActivityType _PartnerCostCtrActivityType 1
_ServiceDocument _ServiceDocument 1
_Supplier _Supplier 1
AccountAssignmentType AccountAssignmentType 1
AccountingDocumentType AccountingDocumentType 1
AssetClass AssetClass 1
BaseUnit BaseUnit 1
BillableControl BillableControl 1
BillToParty BillToParty 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
Customer Customer 1
CustomerGroup CustomerGroup 1
CustomerSupplierCountry CustomerSupplierCountry 1
CustomerSupplierIndustry CustomerSupplierIndustry 1
DistributionChannel DistributionChannel 1
DocumentItemText DocumentItemText 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
Material Material 1
OrderCategory OrderCategory 1
OrderID OrderID 1
OrderType OrderType 1
OrganizationDivision OrganizationDivision 1
OriginCostCtrActivityType OriginCostCtrActivityType 1
OriginProfitCenter OriginProfitCenter 1
PartnerCostCtrActivityType PartnerCostCtrActivityType 1
PersonnelNumber PersonnelNumber 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
PurchasingDocument PurchasingDocument 1
SalesDistrict SalesDistrict 1
SalesDocument SalesDocument 1
SalesDocumentItem SalesDocumentItem 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
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 1
WorkItem WorkItem 1
WorkPackage WorkPackage 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.

-- Actl SemTag Margin with Multi Crcy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ACTLSEMTAGMARGINMULTICRCY (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    CURRENCYFIELD,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    SEMANTICTAG,
    SOURCELEDGER,
    _ACCOUNTINGDOCUMENTTYPE,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _PARTNERCOSTCTRACTIVITYTYPE,
    _SERVICEDOCUMENT,
    _SUPPLIER,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ASSETCLASS,
    BASEUNIT,
    BILLABLECONTROL,
    BILLTOPARTY,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    CONDITIONCONTRACT,
    CONTROLLINGAREA,
    CONTROLLINGDEBITCREDITCODE,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTSOURCEUNIT,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNEL,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    GLACCOUNT,
    ISCOMMITMENT,
    LEDGERFISCALYEAR,
    MATERIAL,
    ORDERCATEGORY,
    ORDERID,
    ORDERTYPE,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINPROFITCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PERSONNELNUMBER,
    PLANT,
    POSTINGDATE,
    PROFITCENTER,
    PROJECT,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    PURCHASINGDOCUMENT,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESORGANIZATION,
    SEGMENT,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICECONTRACTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SERVICESRENDEREDDATE,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    TIMESHEETOVERTIMECATEGORY,
    VALUATIONAREA,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WORKITEM,
    WORKPACKAGE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, CURRENCYFIELD, FISCALYEAR, LEDGERGLLINEITEM, SEMANTICTAG, SOURCELEDGER)
);

Learn More