P_GLACCTLINEITEMSEMTAGREVPROJ
GL Account Line Item with Semantic Tag
P_GLACCTLINEITEMSEMTAGREVPROJ is a CDS View in S/4HANA. GL Account Line Item with Semantic Tag. It contains 124 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ActlSemTagMultiCrcy_F8689 | view_entity | from | COMPOSITE | Actl SemTag Margin with Multi Crcy |
Fields (124)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 1 |
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | FiscalYear | FiscalYear | 1 |
| KEY | GLAccountHierarchy | GLAccountHierarchy | 1 |
| KEY | Ledger | Ledger | 1 |
| KEY | LedgerGLLineItem | LedgerGLLineItem | 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 | |
| _CustomerSupplierCountry | _CustomerSupplierCountry | 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 | |
| _Product | _Product | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProjectBasicData | _ProjectBasicData | 1 | |
| _ProjectManager | _ProjectManager | 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 | |
| AssetClass | AssetClass | 1 | |
| AvailabilityControlIsActive | AvailabilityControlIsActive | 1 | |
| AvailabilityControlProfile | AvailabilityControlProfile | 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 | |
| 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 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| Product | Product | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| Project | Project | 1 | |
| ProjectExternalID | ProjectExternalID | 1 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| ProjectManager | ProjectManager | 1 | |
| ProjectManagerUUID | ProjectManagerUUID | 1 | |
| ProjectNetwork | ProjectNetwork | 1 | |
| ProjectProfileCode | ProjectProfileCode | 1 | |
| ProjectUUID | ProjectUUID | 1 | |
| ProviderContract | ProviderContract | 1 | |
| ProviderContractItem | ProviderContractItem | 1 | |
| PurchasingDocument | PurchasingDocument | 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.
-- GL Account Line Item with Semantic Tag
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GLACCTLINEITEMSEMTAGREVPROJ (
ACCOUNTINGDOCUMENT,
COMPANYCODE,
FISCALYEAR,
GLACCOUNTHIERARCHY,
LEDGER,
LEDGERGLLINEITEM,
SEMANTICTAG,
SOURCELEDGER,
_ACCOUNTINGDOCUMENTTYPE,
_BASEUNIT,
_BILLTOPARTY,
_CHARTOFACCOUNTS,
_COMPANYCODE,
_CONTROLLINGAREA,
_COSTANALYSISRESOURCE,
_COSTSOURCEUNIT,
_CURRENTCOSTCENTER,
_CURRENTPROFITCENTER,
_CUSTOMER,
_CUSTOMERGROUP,
_CUSTOMERSUPPLIERCOUNTRY,
_DISTRIBUTIONCHANNEL,
_FISCALYEAR,
_FISCALYEARVARIANT,
_FUNCTIONALAREA,
_GLACCOUNTINCHARTOFACCOUNTS,
_LEDGER,
_ORDER,
_ORIGINCOSTCTRACTIVITYTYPE,
_ORIGINPROFITCENTER,
_PARTNERCOSTCTRACTIVITYTYPE,
_PLANT,
_PRODUCT,
_PROFITCENTER,
_PROJECTBASICDATA,
_PROJECTMANAGER,
_SALESDISTRICT,
_SALESDOCUMENT,
_SALESORDER,
_SALESORDERITEM,
_SALESORGANIZATION,
_SEGMENT,
_SEMANTICTAG,
_SERVICEDOCUMENT,
_SHIPTOPARTY,
_SOLDPRODUCT,
_SOLDPRODUCTGROUP,
_SOURCELEDGER,
_SUPPLIER,
_WBSELEMENTBASICDATA,
ACCOUNTASSIGNMENTTYPE,
ACCOUNTINGDOCUMENTTYPE,
ASSETCLASS,
AVAILABILITYCONTROLISACTIVE,
AVAILABILITYCONTROLPROFILE,
BASEUNIT,
BILLABLECONTROL,
BILLTOPARTY,
BUSINESSSOLUTIONORDER,
BUSINESSSOLUTIONORDERITEM,
BUSINESSTRANSACTIONTYPE,
CHARTOFACCOUNTS,
CONDITIONCONTRACT,
CONTROLLINGAREA,
CONTROLLINGDEBITCREDITCODE,
COSTANALYSISRESOURCE,
COSTCENTER,
COSTSOURCEUNIT,
CUSTOMER,
CUSTOMERGROUP,
CUSTOMERSUPPLIERCOUNTRY,
CUSTOMERSUPPLIERINDUSTRY,
DISTRIBUTIONCHANNEL,
FINANCIALACCOUNTTYPE,
FISCALPERIOD,
FISCALYEARPERIOD,
FISCALYEARVARIANT,
FUNCTIONALAREA,
GLACCOUNT,
ISCOMMITMENT,
LEDGERFISCALYEAR,
ORDERCATEGORY,
ORDERID,
ORGANIZATIONDIVISION,
ORIGINCOSTCTRACTIVITYTYPE,
ORIGINPROFITCENTER,
PARTNERCOSTCTRACTIVITYTYPE,
PERSONNELNUMBER,
PLANT,
POSTINGDATE,
PRODUCT,
PROFITCENTER,
PROJECT,
PROJECTEXTERNALID,
PROJECTINTERNALID,
PROJECTMANAGER,
PROJECTMANAGERUUID,
PROJECTNETWORK,
PROJECTPROFILECODE,
PROJECTUUID,
PROVIDERCONTRACT,
PROVIDERCONTRACTITEM,
PURCHASINGDOCUMENT,
SALESDISTRICT,
SALESDOCUMENT,
SALESORDER,
SALESORDERITEM,
SALESORGANIZATION,
SEGMENT,
SERVICECONTRACT,
SERVICECONTRACTITEM,
SERVICECONTRACTTYPE,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
SERVICESRENDEREDDATE,
SHIPTOPARTY,
SOLDPRODUCT,
SOLDPRODUCTGROUP,
SUBLEDGERACCTLINEITEMTYPE,
SUPPLIER,
TIMESHEETOVERTIMECATEGORY,
VALUATIONAREA,
WBSELEMENTINTERNALID,
PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, GLACCOUNTHIERARCHY, LEDGER, LEDGERGLLINEITEM, 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