P_JOURNALENTRYORDERS

CDS View
102 Fields 1 CDS Views

P view Assigned Orders

P_JOURNALENTRYORDERS is a CDS View in S/4HANA. P view Assigned Orders. It contains 102 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ETOProjectActItem view_entity from COMPOSITE Actual Item view for ETO

Fields (102)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SourceLedger SourceLedger 1
_AccountingDocumentType _AccountingDocumentType 1
_BaseUnit _BaseUnit 1
_BillToParty _BillToParty 1
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCode _CompanyCode 1
_ControllingArea _ControllingArea 1
_CostSourceUnit _CostSourceUnit 1
_CurrentCostCenter _CurrentCostCenter 1
_CurrentProfitCenter _CurrentProfitCenter 1
_Customer _Customer 1
_CustomerGroup _CustomerGroup 1
_CustomerSupplierCountry _CustomerSupplierCountry 1
_DebitCreditCode _DebitCreditCode 1
_DistributionChannel _DistributionChannel 1
_FiscalYear _FiscalYear 1
_FiscalYearVariant _FiscalYearVariant 1
_FunctionalArea _FunctionalArea 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant 1
_Order _Order 1
_OriginProfitCenter _OriginProfitCenter 1
_Plant _Plant 1
_Product _Product 1
_ProfitCenter _ProfitCenter 1
_ProjectBasicData _ProjectBasicData 1
_SalesDistrict _SalesDistrict 1
_SalesDocument _SalesDocument 1
_SalesOrder _SalesOrder 1
_SalesOrderItem _SalesOrderItem 1
_SalesOrganization _SalesOrganization 1
_ServiceDocument _ServiceDocument 1
_ShipToParty _ShipToParty 1
_SoldProduct _SoldProduct 1
_SoldProductGroup _SoldProductGroup 1
_SourceLedger _SourceLedger 1
_Supplier _Supplier 1
AccountAssignmentType AccountAssignmentType 1
AccountingDocumentType AccountingDocumentType 1
AssetClass AssetClass 1
BaseUnit BaseUnit 1
BillToParty BillToParty 1
BusinessSolutionOrder BusinessSolutionOrder 1
BusinessSolutionOrderItem BusinessSolutionOrderItem 1
ChartOfAccounts ChartOfAccounts 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CostSourceUnit CostSourceUnit 1
Customer Customer 1
CustomerGroup CustomerGroup 1
CustomerSupplierCountry CustomerSupplierCountry 1
CustomerSupplierIndustry CustomerSupplierIndustry 1
DebitCreditCode DebitCreditCode 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
OrderType OrderType 1
OrganizationDivision OrganizationDivision 1
OriginProfitCenter OriginProfitCenter 1
Plant Plant 1
PostingDate PostingDate 1
Product Product 1
ProfitCenter ProfitCenter 1
ProjectInternalID ProjectInternalID 1
ProviderContract ProviderContract 1
ProviderContractItem ProviderContractItem 1
PurchasingDocument PurchasingDocument 1
Quantity Quantity 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
ShipToParty ShipToParty 1
SoldProduct SoldProduct 1
SoldProductGroup SoldProductGroup 1
Supplier Supplier 1
ValuationArea ValuationArea 1
ValuationQuantity ValuationQuantity 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.

-- P view Assigned Orders
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_JOURNALENTRYORDERS (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    _ACCOUNTINGDOCUMENTTYPE,
    _BASEUNIT,
    _BILLTOPARTY,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTSOURCEUNIT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _CUSTOMERGROUP,
    _CUSTOMERSUPPLIERCOUNTRY,
    _DEBITCREDITCODE,
    _DISTRIBUTIONCHANNEL,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    _FUNCTIONALAREA,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEARFORVARIANT,
    _ORDER,
    _ORIGINPROFITCENTER,
    _PLANT,
    _PRODUCT,
    _PROFITCENTER,
    _PROJECTBASICDATA,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESORDER,
    _SALESORDERITEM,
    _SALESORGANIZATION,
    _SERVICEDOCUMENT,
    _SHIPTOPARTY,
    _SOLDPRODUCT,
    _SOLDPRODUCTGROUP,
    _SOURCELEDGER,
    _SUPPLIER,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ASSETCLASS,
    BASEUNIT,
    BILLTOPARTY,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTSOURCEUNIT,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DEBITCREDITCODE,
    DISTRIBUTIONCHANNEL,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    GLACCOUNT,
    ISCOMMITMENT,
    LEDGERFISCALYEAR,
    ORDERCATEGORY,
    ORDERID,
    ORDERTYPE,
    ORGANIZATIONDIVISION,
    ORIGINPROFITCENTER,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    PROJECTINTERNALID,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    PURCHASINGDOCUMENT,
    QUANTITY,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESORDER,
    SALESORDERITEM,
    SALESORGANIZATION,
    SEGMENT,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICECONTRACTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUPPLIER,
    VALUATIONAREA,
    VALUATIONQUANTITY,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER)
);

Learn More