P_BUSSOLNORDITEMRELATIONSHIPS

CDS View
29 Fields 1 CDS Views

Solution Order Item Relationships

P_BUSSOLNORDITEMRELATIONSHIPS is a CDS View in S/4HANA. Solution Order Item Relationships. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BusSolnOrdItemRelationships view from CONSUMPTION Solution Order Item Relationship

Fields (29)

KeyField CDS FieldsUsed in Views
KEY BusinessSolutionOrder BusinessSolutionOrder 1
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem 1
KEY BusSolnOrdItemIsTargetItem BusSolnOrdItemIsTargetItem 1
KEY BusSolnOrdRelatedItem BusSolnOrdRelatedItem 1
_DistributionChannel _DistributionChannel 1
_Division _Division 1
_RespEmployee _RespEmployee 1
_SalesGroup _SalesGroup 1
_SalesGroupOrgUnit _SalesGroupOrgUnit 1
_SalesOffice _SalesOffice 1
_SalesOfficeOrgUnit _SalesOfficeOrgUnit 1
_SalesOrganization _SalesOrganization 1
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit 1
_ServiceDocumentType _ServiceDocumentType 1
_ServiceObjType _ServiceObjType 1
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit 1
DistributionChannel DistributionChannel 1
Division Division 1
ResponsibleEmployee ResponsibleEmployee 1
SalesGroup SalesGroup 1
SalesGroupOrgUnitID SalesGroupOrgUnitID 1
SalesOffice SalesOffice 1
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 1
SalesOrganization SalesOrganization 1
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 1
ServiceDocumentType ServiceDocumentType 1
ServiceObjectType ServiceObjectType 1
ServiceOrganization ServiceOrganization 1
SrvcItemRelshpType SrvcItemRelshpType 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.

-- Solution Order Item Relationships
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BUSSOLNORDITEMRELATIONSHIPS (
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    BUSSOLNORDITEMISTARGETITEM,
    BUSSOLNORDRELATEDITEM,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _RESPEMPLOYEE,
    _SALESGROUP,
    _SALESGROUPORGUNIT,
    _SALESOFFICE,
    _SALESOFFICEORGUNIT,
    _SALESORGANIZATION,
    _SALESORGANIZATIONORGUNIT,
    _SERVICEDOCUMENTTYPE,
    _SERVICEOBJTYPE,
    _SERVICEORGANIZATIONORGUNIT,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    RESPONSIBLEEMPLOYEE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERVICEDOCUMENTTYPE,
    SERVICEOBJECTTYPE,
    SERVICEORGANIZATION,
    SRVCITEMRELSHPTYPE,
    PRIMARY KEY (BUSINESSSOLUTIONORDER, BUSINESSSOLUTIONORDERITEM, BUSSOLNORDITEMISTARGETITEM, BUSSOLNORDRELATEDITEM)
);

Learn More