I_PROFITCENTERTOSALESORDERITEM

CDS View
20 Fields 13 CDS Views

Assgmt of PrftCtr to SlsOrd Item

I_PROFITCENTERTOSALESORDERITEM is a CDS View in S/4HANA. Assgmt of PrftCtr to SlsOrd Item. It contains 20 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_ProfitCenterToSalesOrderItem view_entity from CONSUMPTION Assgmt of PrftCtr to Sales Order Item
finoc_hard_dependency_soi view_entity left_outer Orgl Change: SOI Hard Dependencies
FINOC_RT_RAR_FROM_SOI_OR_SRV view_entity from Orgl Change: RAR from SOI or SRV
FINOC_RULE_POI_BASE view union_all Orgl Change-Rule: Purch. Order Item Base
P_NmbrOfOrglChgObjectsByType view_entity union_all CONSUMPTION Orgl Change Master Data Report List
P_OrglChangeReportRootSOI view_entity from CONSUMPTION Orgl Change Report Root Sales Doc Item
P_OrglChangeReportSOItoCCR view_entity from CONSUMPTION Sales Order Item to Root CostCenter
P_OrglChangeReportSOItoORD view_entity from CONSUMPTION Sales Order Item to Root Order
P_OrglChangeReportSOItoPC view_entity from CONSUMPTION
P_OrglChangeReportSOIToPROD view_entity from CONSUMPTION Dependent Sales Document to Root Product/Plant
P_OrglChangeReportSOItoPROJ view_entity from CONSUMPTION Dependent SalesOrderItem to Root Project
P_OrglChangeReportSOItoSRV view_entity from CONSUMPTION
P_OrglChangeReportSOItoWBS view_entity from CONSUMPTION Sales Document Item to Root WBSElement

Fields (20)

KeyField CDS FieldsUsed in Views
KEY OrganizationalChange OrganizationalChange,orgl_change 2
CompanyCode bukrs,CompanyCode 2
ControllingArea ControllingArea,kokrs 2
OrglChangeEffectiveDate OrglChangeEffectiveDate 6
OrglChgLastDateBeforeEffDate OrglChgLastDateBeforeEffDate 6
ProfitCenter prctr,ProfitCenterByOrglChange 2
ProfitCenterBeforeOrglChange ProfitCenterBeforeOrglChange 1
SalesDocument SourceSalesDocument,srce_kdauf 2
SalesDocumentItem SourceSalesDocumentItem,srce_kdpos 2
SegmentBeforeOrglChange SegmentBeforeOrglChange 8
SegmentByOrglChange Segment 8
SourceCostCenter SourceCostCenter 1
SourceOrder SourceOrder,srce_aufnr 2
SourcePlant SourcePlant,srce_werks 2
SourceProduct SourceProduct,srce_matnr 2
SourceProjectInternalID SourceProjectInternalID,srce_ps_prj_pnr 2
SourceServiceDocument SourceServiceDocument,srce_service_doc_id 3
SourceServiceDocumentItem SourceServiceDocumentItem,srce_service_doc_item_id 3
SourceServiceDocumentType SourceServiceDocumentType,srce_service_doc_type 3
SourceWBSElementInternalID SourceWBSElementInternalID,srce_ps_psp_pnr 2

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.

-- Assgmt of PrftCtr to SlsOrd Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROFITCENTERTOSALESORDERITEM (
    ORGANIZATIONALCHANGE,
    COMPANYCODE,
    CONTROLLINGAREA,
    ORGLCHANGEEFFECTIVEDATE,
    ORGLCHGLASTDATEBEFOREEFFDATE,
    PROFITCENTER,
    PROFITCENTERBEFOREORGLCHANGE,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SEGMENTBEFOREORGLCHANGE,
    SEGMENTBYORGLCHANGE,
    SOURCECOSTCENTER,
    SOURCEORDER,
    SOURCEPLANT,
    SOURCEPRODUCT,
    SOURCEPROJECTINTERNALID,
    SOURCESERVICEDOCUMENT,
    SOURCESERVICEDOCUMENTITEM,
    SOURCESERVICEDOCUMENTTYPE,
    SOURCEWBSELEMENTINTERNALID,
    PRIMARY KEY (ORGANIZATIONALCHANGE)
);

Learn More