_PROJCSTLINEITM

131 Fields

_PROJCSTLINEITM is an SAP database table in S/4HANA. It contains 131 fields.

Fields (131)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY ActualPlanJournalEntryItem ActualPlanJournalEntryItem 1
KEY CompanyCode CompanyCode 5
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 2
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 2
KEY FiscalYear FiscalYear 5
KEY Ledger Ledger 2
KEY SourceLedger SourceLedger 4
AccountingDocCreatedByUser AccountingDocCreatedByUser 4
ActlCostInProjCrcy ActlCostInProjCrcy 1
ActualAmountInFreeDfndCrcy1 ActualAmountInFreeDfndCrcy1 1
ActualAmountInFreeDfndCrcy2 ActualAmountInFreeDfndCrcy2 1
ActualAmountInFreeDfndCrcy3 ActualAmountInFreeDfndCrcy3 1
ActualAmountInFreeDfndCrcy4 ActualAmountInFreeDfndCrcy4 1
ActualAmountInFreeDfndCrcy5 ActualAmountInFreeDfndCrcy5 1
ActualAmountInFreeDfndCrcy6 ActualAmountInFreeDfndCrcy6 1
ActualAmountInFreeDfndCrcy7 ActualAmountInFreeDfndCrcy7 1
ActualAmountInFreeDfndCrcy8 ActualAmountInFreeDfndCrcy8 1
ActualAmountInFunctionalCrcy ActualAmountInFunctionalCrcy 1
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 4
AmountInFreeDefinedCurrency1 ActualAmountInFreeDfndCrcy1,AmountInFreeDefinedCurrency1,CmtmtCostInFreeDefinedCrcy1,PlanAmountInFreeDefinedCrcy1 4
AmountInFreeDefinedCurrency2 ActualAmountInFreeDfndCrcy2,AmountInFreeDefinedCurrency2,CmtmtCostInFreeDefinedCrcy2,PlanAmountInFreeDefinedCrcy2 4
AmountInFreeDefinedCurrency3 ActualAmountInFreeDfndCrcy3,AmountInFreeDefinedCurrency3,CmtmtCostInFreeDefinedCrcy3,PlanAmountInFreeDefinedCrcy3 4
AmountInFreeDefinedCurrency4 ActualAmountInFreeDfndCrcy4,AmountInFreeDefinedCurrency4,CmtmtCostInFreeDefinedCrcy4,PlanAmountInFreeDefinedCrcy4 4
AmountInFreeDefinedCurrency5 ActualAmountInFreeDfndCrcy5,AmountInFreeDefinedCurrency5,CmtmtCostInFreeDefinedCrcy5,PlanAmountInFreeDefinedCrcy5 4
AmountInFreeDefinedCurrency6 ActualAmountInFreeDfndCrcy6,AmountInFreeDefinedCurrency6,CmtmtCostInFreeDefinedCrcy6,PlanAmountInFreeDefinedCrcy6 4
AmountInFreeDefinedCurrency7 ActualAmountInFreeDfndCrcy7,AmountInFreeDefinedCurrency7,CmtmtCostInFreeDefinedCrcy7,PlanAmountInFreeDefinedCrcy7 4
AmountInFreeDefinedCurrency8 ActualAmountInFreeDfndCrcy8,AmountInFreeDefinedCurrency8,CmtmtCostInFreeDefinedCrcy8,PlanAmountInFreeDefinedCrcy8 4
AmountInFunctionalCurrency ActualAmountInFunctionalCrcy,CmtmtAmountInFunctionalCrcy,PlanAmountInFunctionalCurrency 3
AmountInGlobalCurrency ActualAmountInGlobalCurrency,AmountInGlobalCurrency,CmtmtCostInGlobalCurrency,PlanAmountInGlobalCurrency,PrjStockAmountInGlobalCurrency 5
AmountInObjectCurrency ActlCostInProjCrcy,AmountInObjectCurrency,CmtmtCostInProjCrcy,PlndCostAmtInProjCrcy 4
AmountInTransactionCurrency AmountInTransactionCurrency 4
BusinessArea BusinessArea 5
BusinessTransactionType BusinessTransactionType 5
ChartOfAccounts ChartOfAccounts 5
CompanyCodeCurrency CompanyCodeCurrency 5
ControllingArea ControllingArea 5
ControllingDebitCreditCode ControllingDebitCreditCode 5
ControllingObjectCurrency ControllingObjectCurrency 5
CostCenter CostCenter 5
CostCtrActivityType CostCtrActivityType 5
CreationDate CreationDate 4
DebitCreditCode DebitCreditCode 4
DocumentDate DocumentDate 4
FinancialPlanningEntryItem FinancialPlanningEntryItem 2
FinPlngEntryItemCreatedByUser AccountingDocCreatedByUser 1
FiscalPeriod FiscalPeriod 5
FiscalYearPeriod FiscalYearPeriod 5
FiscalYearVariant FiscalYearVariant 5
FreeDefinedCurrency1 FreeDefinedCurrency1 4
FreeDefinedCurrency2 FreeDefinedCurrency2 4
FreeDefinedCurrency3 FreeDefinedCurrency3 4
FreeDefinedCurrency4 FreeDefinedCurrency4 4
FreeDefinedCurrency5 FreeDefinedCurrency5 4
FreeDefinedCurrency6 FreeDefinedCurrency6 4
FreeDefinedCurrency7 FreeDefinedCurrency7 4
FreeDefinedCurrency8 FreeDefinedCurrency8 4
FunctionalArea FunctionalArea 5
FunctionalCurrency FunctionalCurrency 5
GLAccount GLAccount 5
GlobalCurrency GlobalCurrency 5
InternalOrder InternalOrder 1
IsCommitment IsCommitment 4
IsSettled IsSettled 1
LedgerFiscalYear LedgerFiscalYear 5
LedgerGLLineItem LedgerGLLineItem 4
MaintenanceOrderIsSelected MaintenanceOrderIsSelected 1
NetworkActivity NetworkActivity 1
NetworkActivityElement NetworkActivityElement 1
ObjectInternalID ObjectInternalID 1
OrderID OrderID,ProjectObjectNode 4
OrderOperation OrderOperation 3
OrderType OrderType 1
OrderTypeAppendedCode OrderTypeAppendedCode 1
OriginCostCenter OriginCostCenter 1
OriginCostCtrActivityType OriginCostCtrActivityType 1
PartnerAccountAssignmentType PartnerAccountAssignmentType 3
PartnerCompanyCode PartnerCompanyCode 1
PartnerOrder PartnerOrder 4
PartnerOrder_2 PartnerOrder 1
PartnerOrderCategory PartnerOrderCategory 4
PartnerProfitCenter PartnerProfitCenter 1
PartnerProject PartnerProject 2
PartnerProjectInternalID ProjectInternalID 1
PartnerWBSElement PartnerWBSElement 1
PartnerWBSElementInternalID WBSElementInternalID 1
PlanAmountInFreeDefinedCrcy1 PlanAmountInFreeDefinedCrcy1 1
PlanAmountInFreeDefinedCrcy2 PlanAmountInFreeDefinedCrcy2 1
PlanAmountInFreeDefinedCrcy3 PlanAmountInFreeDefinedCrcy3 1
PlanAmountInFreeDefinedCrcy4 PlanAmountInFreeDefinedCrcy4 1
PlanAmountInFreeDefinedCrcy5 PlanAmountInFreeDefinedCrcy5 1
PlanAmountInFreeDefinedCrcy6 PlanAmountInFreeDefinedCrcy6 1
PlanAmountInFreeDefinedCrcy7 PlanAmountInFreeDefinedCrcy7 1
PlanAmountInFreeDefinedCrcy8 PlanAmountInFreeDefinedCrcy8 1
PlanAmountInFunctionalCurrency PlanAmountInFunctionalCurrency 1
PlanAmountInGlobalCurrency BaselineAmtInGlobalCrcy,PlanAmountInGlobalCurrency 1
PlanningCategory PlanningCategory,SourcePlanningCategory 2
PlanningCategory1 PlanningCategory1 1
PlanningCategory2 PlanningCategory2 1
PlndCostAmtInProjCrcy PlndCostAmtInProjCrcy 1
PostingDate PostingDate 5
Product Product 1
ProductionOrder ProductionOrder 1
ProfitCenter ProfitCenter 5
Project Project 1
ProjectInternalID ProjectInternalID 2
ProjectNetwork ProjectNetwork 1
ProjectObjectDescription ProjectObjectDescription 1
ProjectObjectExternalID ProjectObjectExternalID 1
ProjectObjectNode ProjectObjectNode 1
ProjectObjectProfitCenter ProjectObjectProfitCenter 1
ProjectObjectRootNode ProjectObjectRootNode 1
ProjectObjectType ProjectObjectType 1
ProjectPartnerObject ProjectPartnerObject 1
ProjectSelectedObject ProjectSelectedObject 1
ProjectType ProjectType 1
ResponsibleCostCenter ResponsibleCostCenter 1
ServiceContract ServiceContract 1
ServiceContractItem ServiceContractItem 1
ServiceOrder ServiceOrder 1
ServiceOrderItem ServiceOrderItem 1
SourceLogicalSystem SourceLogicalSystem 4
SourceReferenceDocSubitem SourceReferenceDocSubitem 4
SourceReferenceDocument SourceReferenceDocument 4
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt 4
SourceReferenceDocumentItem SourceReferenceDocumentItem 4
SourceReferenceDocumentType SourceReferenceDocumentType 4
TransactionCurrency TransactionCurrency 5
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 4

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PROJCSTLINEITM (
    ACCOUNTINGDOCUMENT,
    ACTUALPLANJOURNALENTRYITEM,
    COMPANYCODE,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    LEDGER,
    SOURCELEDGER,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACTLCOSTINPROJCRCY,
    ACTUALAMOUNTINFREEDFNDCRCY1,
    ACTUALAMOUNTINFREEDFNDCRCY2,
    ACTUALAMOUNTINFREEDFNDCRCY3,
    ACTUALAMOUNTINFREEDFNDCRCY4,
    ACTUALAMOUNTINFREEDFNDCRCY5,
    ACTUALAMOUNTINFREEDFNDCRCY6,
    ACTUALAMOUNTINFREEDFNDCRCY7,
    ACTUALAMOUNTINFREEDFNDCRCY8,
    ACTUALAMOUNTINFUNCTIONALCRCY,
    ACTUALAMOUNTINGLOBALCURRENCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGOBJECTCURRENCY,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    CREATIONDATE,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FINANCIALPLANNINGENTRYITEM,
    FINPLNGENTRYITEMCREATEDBYUSER,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    GLACCOUNT,
    GLOBALCURRENCY,
    INTERNALORDER,
    ISCOMMITMENT,
    ISSETTLED,
    LEDGERFISCALYEAR,
    LEDGERGLLINEITEM,
    MAINTENANCEORDERISSELECTED,
    NETWORKACTIVITY,
    NETWORKACTIVITYELEMENT,
    OBJECTINTERNALID,
    ORDERID,
    ORDEROPERATION,
    ORDERTYPE,
    ORDERTYPEAPPENDEDCODE,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERCOMPANYCODE,
    PARTNERORDER,
    PARTNERORDER_2,
    PARTNERORDERCATEGORY,
    PARTNERPROFITCENTER,
    PARTNERPROJECT,
    PARTNERPROJECTINTERNALID,
    PARTNERWBSELEMENT,
    PARTNERWBSELEMENTINTERNALID,
    PLANAMOUNTINFREEDEFINEDCRCY1,
    PLANAMOUNTINFREEDEFINEDCRCY2,
    PLANAMOUNTINFREEDEFINEDCRCY3,
    PLANAMOUNTINFREEDEFINEDCRCY4,
    PLANAMOUNTINFREEDEFINEDCRCY5,
    PLANAMOUNTINFREEDEFINEDCRCY6,
    PLANAMOUNTINFREEDEFINEDCRCY7,
    PLANAMOUNTINFREEDEFINEDCRCY8,
    PLANAMOUNTINFUNCTIONALCURRENCY,
    PLANAMOUNTINGLOBALCURRENCY,
    PLANNINGCATEGORY,
    PLANNINGCATEGORY1,
    PLANNINGCATEGORY2,
    PLNDCOSTAMTINPROJCRCY,
    POSTINGDATE,
    PRODUCT,
    PRODUCTIONORDER,
    PROFITCENTER,
    PROJECT,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    PROJECTOBJECTDESCRIPTION,
    PROJECTOBJECTEXTERNALID,
    PROJECTOBJECTNODE,
    PROJECTOBJECTPROFITCENTER,
    PROJECTOBJECTROOTNODE,
    PROJECTOBJECTTYPE,
    PROJECTPARTNEROBJECT,
    PROJECTSELECTEDOBJECT,
    PROJECTTYPE,
    RESPONSIBLECOSTCENTER,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICEORDER,
    SERVICEORDERITEM,
    SOURCELOGICALSYSTEM,
    SOURCEREFERENCEDOCSUBITEM,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTCNTXT,
    SOURCEREFERENCEDOCUMENTITEM,
    SOURCEREFERENCEDOCUMENTTYPE,
    TRANSACTIONCURRENCY,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACTUALPLANJOURNALENTRYITEM, COMPANYCODE, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, LEDGER, SOURCELEDGER)
);

Learn More