I_BUSSOLNORDITEMRELATIONSHIPS

CDS View
40 Fields 5 CDS Views

Solution Order Item Relationships

I_BUSSOLNORDITEMRELATIONSHIPS is a CDS View in S/4HANA. Solution Order Item Relationships. It contains 40 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_BusSolnOrdDelivDteSitn1 view from CONSUMPTION Trigger CDS view deliv date change
C_BusSolnOrdDelivDteSitn2 view from CONSUMPTION Trigger CDS for Del. related items
C_BusSolnOrdPlndDteSitn2 view from CONSUMPTION Trigger CDS view planned date reached
I_BusSolnOrderSrvcItmSitn view from COMPOSITE Solution Order Service Item Situation
P_BusSolnOrderEntProjItmSitn view from COMPOSITE Solution Order Enterprise Project Item Situation

Fields (40)

KeyField CDS FieldsUsed in Views
KEY BusinessSolutionOrder BusinessSolutionOrder 2
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem,ServiceDocumentItem 3
KEY BusSolnOrdRelatedItem BusSolnOrdRelatedItem 3
KEY ServiceObjectType ServiceObjectType 5
_DistributionChannel _DistributionChannel 4
_Division _Division 4
_RespEmployee _RespEmployee 3
_SalesGroup _SalesGroup 4
_SalesGroupOrgUnit _SalesGroupOrgUnit 4
_SalesOffice _SalesOffice 4
_SalesOfficeOrgUnit _SalesOfficeOrgUnit 4
_SalesOrganization _SalesOrganization 4
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit 4
_ServiceDocumentType _ServiceDocumentType 3
_ServiceObjType _ServiceObjType 2
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit 4
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus 1
_SrvcDocSystemStatus _SrvcDocSystemStatus 2
BusSolnOrdItemIsTargetItem BusSolnOrdItemIsTargetItem 2
DistributionChannel DistributionChannel 5
Division Division 5
PlannedServiceEndDateTime PlannedServiceEndDateTime 1
PlannedServiceStartDateTime PlannedServiceStartDateTime 1
RequestedServiceEndDateTime RequestedServiceEndDateTime 1
RequestedServiceStartDateTime RequestedServiceStartDateTime 1
ResponsibleEmployee ResponsibleEmployee 5
SalesGroup SalesGroup 5
SalesGroupOrgUnitID SalesGroupOrgUnitID 5
SalesOffice SalesOffice 5
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 5
SalesOrganization SalesOrganization 5
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 5
ServiceDocumentItemCharUUID ServiceDocumentItemCharUUID 5
ServiceDocumentItemObjectType ServiceDocumentItemObjectType 4
ServiceDocumentItemStatus ServiceDocumentItemStatus 4
ServiceDocumentItemUUID ServiceDocumentItemUUID 3
ServiceDocumentType ServiceDocumentType 5
ServiceEmployee ServiceEmployee 1
ServiceOrganization ServiceOrganization 5
SrvcDocItmDeliveryStatus SrvcDocItmDeliveryStatus 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.

-- Solution Order Item Relationships
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSSOLNORDITEMRELATIONSHIPS (
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    BUSSOLNORDRELATEDITEM,
    SERVICEOBJECTTYPE,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _RESPEMPLOYEE,
    _SALESGROUP,
    _SALESGROUPORGUNIT,
    _SALESOFFICE,
    _SALESOFFICEORGUNIT,
    _SALESORGANIZATION,
    _SALESORGANIZATIONORGUNIT,
    _SERVICEDOCUMENTTYPE,
    _SERVICEOBJTYPE,
    _SERVICEORGANIZATIONORGUNIT,
    _SRVCDOCITMLIFECYCLESTATUS,
    _SRVCDOCSYSTEMSTATUS,
    BUSSOLNORDITEMISTARGETITEM,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    PLANNEDSERVICEENDDATETIME,
    PLANNEDSERVICESTARTDATETIME,
    REQUESTEDSERVICEENDDATETIME,
    REQUESTEDSERVICESTARTDATETIME,
    RESPONSIBLEEMPLOYEE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERVICEDOCUMENTITEMCHARUUID,
    SERVICEDOCUMENTITEMOBJECTTYPE,
    SERVICEDOCUMENTITEMSTATUS,
    SERVICEDOCUMENTITEMUUID,
    SERVICEDOCUMENTTYPE,
    SERVICEEMPLOYEE,
    SERVICEORGANIZATION,
    SRVCDOCITMDELIVERYSTATUS,
    PRIMARY KEY (BUSINESSSOLUTIONORDER, BUSINESSSOLUTIONORDERITEM, BUSSOLNORDRELATEDITEM, SERVICEOBJECTTYPE)
);

Learn More