P_INHREPRITMLOGSERRFNDN

CDS View

P_INHREPRITMLOGSERRFNDN is a CDS View in S/4HANA. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_InhRepairItmSrlzdProductSitn view_entity from COMPOSITE Anchr for Chngd Logs Info of Srlzd Prds
P_InhRepairItemTotalProdReq view_entity from COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY InHouseRepair InHouseRepair 1
KEY InHouseRepairItem InHouseRepairItem 1
KEY InhRepairItemSpecialStockType InhRepairItemSpecialStockType 2
KEY InhReprItmInvtryUsabilityCode InhReprItmInvtryUsabilityCode 2
KEY Plant Plant 2
KEY Product Product 1
KEY StorageLocation StorageLocation 2
BaseUnit BaseUnit 1
CreatedByUser CreatedByUser 1
DistributionChannel DistributionChannel 1
Division Division 1
InHouseRepairItemCharUUID InHouseRepairItemCharUUID 1
InHouseRepairItemUUID InHouseRepairItemUUID 1
InhRepairItemAvailyStatus InhRepairItemAvailyStatus 2
InhRepairType InhRepairType 1
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId 1
SalesGroup SalesGroup 1
SalesGroupOrgUnitID SalesGroupOrgUnitID 1
SalesOffice SalesOffice 1
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 1
SalesOrganization SalesOrganization 1
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_INHREPRITMLOGSERRFNDN (
    INHOUSEREPAIR,
    INHOUSEREPAIRITEM,
    INHREPAIRITEMSPECIALSTOCKTYPE,
    INHREPRITMINVTRYUSABILITYCODE,
    PLANT,
    PRODUCT,
    STORAGELOCATION,
    BASEUNIT,
    CREATEDBYUSER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    INHOUSEREPAIRITEMCHARUUID,
    INHOUSEREPAIRITEMUUID,
    INHREPAIRITEMAVAILYSTATUS,
    INHREPAIRTYPE,
    RESPEMPLOYEEBUSINESSPARTNERID,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    PRIMARY KEY (INHOUSEREPAIR, INHOUSEREPAIRITEM, INHREPAIRITEMSPECIALSTOCKTYPE, INHREPRITMINVTRYUSABILITYCODE, PLANT, PRODUCT, STORAGELOCATION)
);